In this screencast I talk about stock market indices and methods by which they are calculated on a daily basis in order to display index changes in those fancy stock tickers you see all around the world on television, the web, and Wall Street itself.
Download the Market Indices Excel 2007 document.
How to Calculate Stock Market […]
Learn how to calculate a proper Geometric Mean of stock returns in which negative rates of return can be included. I cover another of the many Excel nuances that Finance and Statistics personnel are presented with. I cover the Geometric Mean formulae, appropriate adjustments, and a way in which you can maniuplate Excel’s GEOMEAN function […]
Learn how to setup a simple yet useful loan amortization schedule. While I cover an automobile loan example in this screencast, you can apply the same practices to mortgages and other loans. It’s simple, it’s intuitive, and it provides you with a lot of useful information. Enjoy!
Download the Loan Amortization Schedule Excel 2007 document.
I cover one of Excel’s many nuances: the incorrect Net Present Value function, courtesy of Microsoft developers. The NPV function in Excel has been incorrect ever since Excel could first calculate Net Present Value. As my example I use a simple corporate project with an initial cash outlay, three cash inflows, and a cost of […]