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



Leave a Reply

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

WordPress spam blocked by CleanTalk.