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 […]
Welcome aboard viewers. I’m still tweaking things here and there and I’m trying to decide where I should host my screencasts and in what format(s) they should be available. Then I will begin recording them and uploading them as time goes on. At the moment, Veoh is looking rather appealing. I may go with Revver […]