This template contains 10 common financial calculations. Most are self explanatory. A few need further explanation. Future Value of an Annuity -- the future value of a series of periodic investments of an equal amount. Annuitizing a Future Amount -- the equal periodic payments that you could withdraw from an investment. After Tax Real Rate of Return on Investment -- the annual return on your investment after taxes and inflation have taken their share. Tax Free Equivalent Yield -- converts a taxable return to an after tax return. Taxable Equivalent Rate for Tax Free Yield -- converts a tax free yield, such as that of a municipal bond, to a taxable yield - so that you can comparison shop for yields.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.