Time value of money and financial calculator tutorials
Tutorials by Brand:
Time value of money and financial calculator tutorials
In the previous section we looked at using the basic time value of money functions to calculate present and future value of annuities (even cash flows). In this section we will take a look at how to use Excel to calculate the present and future values of uneven cash flow streams. We will also see how to calculate net present…
In the previous section we looked at the basic time value of money functions and how to use them to calculate present and future value of lump sums. In this section we will take a look at how to use Excel to calculate the present and future values of regular annuities and annuities due. A regular annuity is a series…
Excel (and other spreadsheet programs) is the greatest financial calculator ever made. There is more of a learning curve than a regular financial calculator, but it is much more powerful. This tutorial will demonstrate how to use Excel’s financial functions to handle basic time value of money problems using the same examples as in the calculator tutorials. I will keep…