A Model for Analysis of Bond Valuation By Using Microsoft Excel plus VBA

Sunday, October 22, 2017

The Power of Analysis Is Still in Microsoft Hands

In the reference with article of “A case of Accounting Control System Solved by a New Idea” posted on link:  http://www.emfps.org/2015/10/a-case-of-accounting-control-system.html?m=1, there is another option for this model. If you only replace one number in column of Debit instead of 10 numbers and type randomly 10 numbers in column of Credit, you will solve a linear equation with maximum 10 independent variables. Of course, I have developed both columns by 20 numbers in this article.
The purpose of this article is to show a model which solves an equation with 20 independent variables. It is clear, normal people don’t need to solve an equation with 20 independent variables but this is a promotional model in which it will present the power of analysis by Microsoft and it will be a challenge for its competitors.

 According to a report posted on website of Forbes in 2012, Tim Worstall stated that Microsoft's Market Share Drops From 97% to 20% In Just over A Decade. (Below link)



But I can anticipate that Microsoft will come back to market and will gain its previous market share where the share price of Microsoft will significantly surge upward in the near future. But when? The time is, when everybody will be easily able to connect his/her spreadsheets to his/her website. In this case, the people will be able to have the data or system analysis simply on their smart phones.

Model (6): The solve an linear equation with 20 variables by click

Assume we have function of “w” with 20 independent variables as follows:

w = f (x,y,z,s,d,f,g,h,j,k,l,i,u,t,r,e,q,n,m,v) =
 x + y + z+ s+ d + f + g + h + j + k + l + i + u + t + r + e + q + n + m+ v

Now, this model will find many answers for all independent variables for a specific result of “c” just like below equation:


x + y + z+ s+ d + f + g + h + j + k + l + i + u + t + r + e + q + n + m+ v = c

Definitely there are infinity answers for all independent variables for a specific result of “c”.
Blow clip shows you some examples which are generated by click:




As you can see on above clip, all variables are changed by each click while amount of “c” as total sum of variables always stays the constant. When I change “c”, we will have a new equation and definitely new answers for this equation. At the first, "c" is equal to 63031280 then it is equal to 77699560 and finally it is equal to 14667470





This is the reason why I say to you: "Many thanks to Bill Gates and Microsoft who gifted and donated us the great opportunity to discover the ways to reach the gates of new worlds. There will be the big changes in engineering fields and finally big changes in educational systems throughout the world in the near future."