Free spreadsheets - Posted by John Behle
Posted by John Behle on December 21, 1999 at 13:32:09:
If you use Quattro Pro or Excel, there are free spreadsheets available on my website.
The one called “easycalc” is laid out just like the yield worksheet that I use. Enter 4 variables and it automatically solves for the 5th. It uses some circular calculations, so “Quattro” will give you a warning notice and post “error” in any cells you haven’t entered numbers into. Enter the numbers and as soon as you have any 4 of 5 variables, it solves for the 5th. “Excel” freaks out and blasts you with error messages unless you turn off the automatic calculation and just manually recalculate by hitting the key when you are ready.
I use the Quattro version of the program daily.
The second spreadsheet is called “unevencf” that handles up to ten uneven cash flows of any length. It automatically calculates at 8 different yields that you can set. This means you can do some very time consuming calculations in seconds.
just go to www.papergame.com and you’ll find them.