Present and Future Values
Written by Janet Swift   
Article Index
Present and Future Values
Interest Rates And Inflation
Net present value - NPV
Net Future Value
Regular cashflows
All The Payments

The principles of present and future value apply even if the cash flow is irregular. The calculations are just a matter of breaking down the cashflow calculations into simple steps.


 Financial Functions


 Buy from Amazon

Spreadsheets take the hard work out of calculations, but you still need to know how to do them. Financial Functions with a spreadsheet is all about understanding and reasoning, using a spreadsheet to do the actual calculation.

  1. Understanding Percentages
    Percentages are something familiar to us all - but they present many pitfalls that need to be avoided.

  2. Interest Simple and Compound
    We explore the idea of borrowing money for a specified rate of interest or earning interest on an investment. The ideas of Present and Future Value PV and FV are introduced. 

  3. Effective Interest Rates
    We explore the idea of the `effective’ annual interest rate and then on to the Effective Interest Rate/Annual Percentage Rate, the much quoted EIR or APR.

  4. Introduction to Cashflow - Savings Plans
    In the first of three chapters covering the way in which interest rate affects cashflow we explore savings - but first we introduce some general ideas that apply equally to annuities and repayment loans.

  5. Cashflow Continued - Annuities
    We move on to annuities in the second of three chapters devoted to exploring the way in which interest rate affects 

  6. Exploring Repayment Loans
    Repayment loans are the subject of the last of three chapters which look at the effects of regular cashflows.

  7. Present and Future Values
    The principles of present and future value apply even if the cash flow is irregular. The calculations are just a matter of breaking down the cash flow calculations into simple steps.

  8. Investment Analysis
    How is it possible to evaluate investments that generate irregular cashflows? We explore how NPV can be used to make investment decisions.

  9. Advanced Investment Analysis IRR and MIRR
    The IRR is perhaps the most complicated of the measures of the value of an investment with an irregular cash flow. Understanding exactly what it means is a good step toward making correct use of it. 



Chapter Seven

In earlier chapters we have examined how money behaves under some particularly simple situations - a single deposit or loan accruing interest and the effect of a regular cashflow on the same.

In real life cashflows are often irregular both in time and in amount. This makes it difficult to evaluate the worth of an investment or the cost of a loan that involves irregular payments. However all is not lost because there are a range of methods that can be used to compare such investments and loans.

In this and the next chapter we examine the ideas of the present and future value of money and see how these ideas can be used to make judgements about the worth of an investment.

The time value of money

The most important thing to realise when evaluating an investment is that money now is worth more than money in the future - even if you ignore the action of inflation.

The reason is that money that you have now can be invested and can earn a safe rate of interest. If you are deprived of a sum of money until a later date then you have to take into account the loss of interest. You can think of this as an opportunity cost of not having the money.

If the prevailing ‘no risk’ interest rate is I% then $PV will grow to $FV given by:

FV = PV*(1+I)^n

in n time periods.

The present value grows into the future value by the action of compound interest. This relationship can be turned the other way about and we can say that the future value can be discounted back to its equivalent present value.

This relationship between Future Value and Present Value is fundamental to the measurement of the time value of money.

If you are to receive a sum of money in the future then what ever it is worth then it is only worth the equivalent present value now.

That is, all Future Values should be reduced to their corresponding Present Values before their worth can be assessed using:


You can think of this as reducing future sums of money by a discount factor of 1/(1+I)^n to allow for the effect of interest.

For example, if you are to receive $100 in 5 years time, i.e. FV=500 and n=5*12, the Present Value is:


So if you were offered $500 in 5 years time or $355.60 now there would be no reason to prefer one or the other on purely financial grounds.

It is in this sense that the present value and the future value represent the same amount of wealth - one will become the other by the action of time and interest.

The safe interest rate

Of course the equivalence of FV and PV does depend on the interest rate that you choose to use in the formula and this adds a degree of arbitrariness into the comparison.

In practice you should use an interest rate that makes the comparison meaningful to you. For example, there is no point in using an interest rate that is not accessible to you or to the sum of money under consideration.

So using a high rate that can only be obtained by large deposits isn’t reasonable in most cases, neither is a high risk rate. You should in general choose an interest rate that is readily obtainable and regarded as a safe investment.

There is another problem in that safe interest rates may vary over the period of the calculation and so alter the present value. However factors that alter the ‘safe’ interest rate also tend to affect the return on every type of investment and so the alter the future value in the same way as the present value!

As a result the present value still provides an excellent way of comparing different investment opportunities.