24 Time Value of Money Calculations in One Excel Workbook

I thought I would consolidate some of the past posts and spreadsheets into one workbook. It could come in handy when you need some quick answers, or just to check your calculations. I tried to give not only the Excel functions, but the math and alternative calculations. In addition, I included the option to calculate the cash flows when they start at the end of the period (Ordinary Annuity) or at the beginning (Annuity Due). When Excel Functions did not have an option for this, I use workarounds and formulas. This is a what the first column of the contents sheet looks like. All sheets are hyperlinked from the contents sheet and all sheets have a hyperlink back to the contents sheet. Like calculations are grouped and color coded:

Download Workbook



Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.

Leave a Reply

Your email address will not be published. Required fields are marked *