Investment Decisions – Financial Concepts
1 Interest calculations
In the previous chapter frequent reference was made to interest rates. We now have to look in just a little more detail about how interest is calculated and how the timing of receipts and payments affects their values.
Simple interest
If an interest rate is 5% and an amount of $1,000 is deposited in the bank (known as the principal) then, assuming no withdrawals are made, the amount of cash in the investor's account will be as follows:
Period | Balance |
After 1 year | $1,050 |
After 2 years | $1,100 |
After 3 years | $1,150 |
… | … |
After 10 years | $1,500 |
etc |
The 5% interest rate is always applied to the principal of the loan and not to the whole account balance ie it is not applied to any interest previously earned.
Exactly the same calculation would be applied if we had borrowed $1,000 at 5% simple interest. After 10 years, $1,500 would be owed to the bank.
Compound interest
With compound interest, the interest rate is applied to not only the original principal but also to any interest added. Assuming no withdrawals are made the balances at the end of each year would be:
Period | Balance | Working |
After 1 year | $1,050 | 1,000 × 1.05 |
After 2 years | $1,102.50 | 1,050 × 1.05 or 1,000 × 1.05² |
After 3 years | $1,157.625 | 1,102.50 × 1.05 or 1,000 × 1.05³ |
… | … | |
After 10 years | $1,628.89 | 1,000 × 1.05¹⁰ |
You will see that with compound interest the bank balance rises much more sharply than with simple interest
The formula for the future value of the bank deposit (or loan) is:
S = P(1 + r)n
where
P = the principal
r = the annual interest rate as a decimal ie 15% = 0.15
n = the number of years
When you need the future value of a mixture of cash flows, such as a lump sum now plus a series of equal payments, the safest route is to bring everything to a present value first and then compound the total forward with this formula. The lump sum paid now is already a present value; the series uses the annuity factor for the number of payments actually made, counted as in the rent example later in this chapter. For $10,000 invested now plus nine payments of $1,500 at the ends of years 1 to 9, at 10%: 10,000 + 1,500 × 5.759 = 18,638.5, and 18,638.5 × 1.10 to the power 10 = $48,343 at the end of year 10. Simply adding the payments together ($23,500) ignores interest altogether, and was the most common answer.
A business borrows $50,000 at 12% interest. After 15 years how much is owed
(i) Using simple interest?
(ii) Using compound interest?
Solution
(i) Interest will amount to 12% x 50,000 = $6,000 per year. After 15 years this will have accumulated to $90,000 so the total amount owing is $140,000.
(ii) Using the formula:
S = P(1 + r)n
S = 50,000 x 1.1215 = $273,678
2 Discounting
2.1 Single receipts or payments
Interest calculations project forward to show how much will be in a bank account after a number of years. Discounting does the reverse: it says something like "If I want to end up with $1,000 in a bank account after 3 years and the interest rate is 5%, how much do I have to deposit now?
The compound interest formula can be used:
S = P(1 + r)n
where S is the amount in the account after n years. So:
P = S x 1/(1 + r)n
1,000 = P (1.05)3
So, P = 1,000/(1.05)3 = $863.84
(You can check this by working out the final amount after three years if $863.84 is invested at 5%).
$863.84 is known as the present value of $1,000 received after 3 years at a 5% discount rate.
Similarly, if $1,000 were received after 10 years at a discount rate of 10%, the present value would be:
P = 1,000/(1.10)10 = $385.54
To make the calculation easier, discount tables are used and provided in the exam. Here's an extract:
Present value tables
Periods | Discount rate | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
(n) | 1% | 2% | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% |
1 | 0.990 | 0.980 | 0.971 | 0.962 | 0.952 | 0.943 | 0.935 | 0.926 | 0.917 | 0.909 |
2 | 0.980 | 0.961 | 0.943 | 0.925 | 0.907 | 0.890 | 0.873 | 0.857 | 0.842 | 0.826 |
3 | 0.971 | 0.942 | 0.915 | 0.889 | 0.864 | 0.840 | 0.816 | 0.794 | 0.772 | 0.751 |
4 | 0.961 | 0.924 | 0.888 | 0.855 | 0.823 | 0.792 | 0.763 | 0.735 | 0.708 | 0.683 |
5 | 0.951 | 0.906 | 0.863 | 0.822 | 0.784 | 0.747 | 0.713 | 0.681 | 0.650 | 0.621 |
6 | 0.942 | 0.888 | 0.837 | 0.790 | 0.746 | 0.705 | 0.666 | 0.630 | 0.596 | 0.564 |
7 | 0.933 | 0.871 | 0.813 | 0.760 | 0.711 | 0.665 | 0.623 | 0.583 | 0.547 | 0.513 |
8 | 0.923 | 0.853 | 0.789 | 0.731 | 0.677 | 0.627 | 0.582 | 0.540 | 0.502 | 0.467 |
9 | 0.914 | 0.837 | 0.766 | 0.703 | 0.645 | 0.592 | 0.544 | 0.500 | 0.460 | 0.424 |
10 | 0.905 | 0.820 | 0.744 | 0.676 | 0.614 | 0.558 | 0.508 | 0.463 | 0.422 | 0.386 |
11 | 0.896 | 0.804 | 0.722 | 0.650 | 0.585 | 0.527 | 0.475 | 0.429 | 0.388 | 0.350 |
12 | 0.887 | 0.788 | 0.701 | 0.625 | 0.557 | 0.497 | 0.444 | 0.397 | 0.356 | 0.319 |
13 | 0.879 | 0.773 | 0.681 | 0.601 | 0.530 | 0.469 | 0.415 | 0.368 | 0.326 | 0.290 |
14 | 0.870 | 0.758 | 0.661 | 0.577 | 0.505 | 0.442 | 0.388 | 0.340 | 0.299 | 0.263 |
15 | 0.861 | 0.743 | 0.642 | 0.555 | 0.481 | 0.417 | 0.362 | 0.315 | 0.275 | 0.239 |
For the last example, go down the left hand column until you get to 10, the number of years hence that the flow occurs, then go rightwards until the discount rate is 10%. The table figure is 0.386 (rounded to 3 decimal places) so the present value of any amount received after 10 years at a 10% discount rate is 0.386 times the amount, here $386.
Discounting is required for you to properly evaluate cash flows as not just the raw amount needs to be considered but also when it is received. For example, say you were offered the following choice:
(i) Receive $10,000 now; or
(ii) Receive $10,000 in 4 years time
Interest rate = 7%
We would instinctively choose option (i): if we receive the money now we can invest it now at 7% whereas that possibility is only available after 4 years in option (ii). The present value quantifies the benefit from earlier receipts:
(i) Receiving $10,000 means you have $10,000 now
(ii) Receiving $10,000 in 4 years at 7% interest rate is equivalent to receiving $10,000 x 0.763 = 7,630 now (0.763 is the 4 year 7% table figure).
You might not have needed discounting to make the right decision here, but what about this choice:
(i) Receive $6,000 in 2 years; or
(ii) Receive $7,400 in 5 years
Interest rate = 8%
Both amounts need to be turned into their present values, eliminating timing differences and allowing us to concentrate on the amounts.
(i) PV of receiving $6,000 in 2 years at an interest rate of 8% = 6,000 x 0.857 = $5,142
(ii) PV of receiving $7,400 in 5 years at an interest rate of 8% = 7,400 x 0.681 = $5,039
So option (i) is better.
Discounting takes into account that:
Later receipts suffer greater risk and uncertainty
Later receipts have their values eroded by inflation
Earlier receipts can be reinvested earlier to produce more profits.
2.2 Annuities
An annuity is a constant amount of money paid or received for a number of years. This can be a relatively common pattern of cash flow, for example, annual rents, insurance premiums or pension receipts.
The present value of annuities can be worked out using the method we have seen above, but another set of tables is available that makes the calculation much faster. These tables are known as annuity tables or cumulative discount tables.
Annuity tables
Periods | Discount rate | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
(n) | 1% | 2% | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% |
1 | 0.990 | 0.980 | 0.971 | 0.962 | 0.952 | 0.943 | 0.935 | 0.926 | 0.917 | 0.909 |
2 | 1.970 | 1.942 | 1.913 | 1.886 | 1.859 | 1.833 | 1.808 | 1.783 | 1.759 | 1.736 |
3 | 2.941 | 2.884 | 2.829 | 2.775 | 2.723 | 2.673 | 2.624 | 2.577 | 2.531 | 2.487 |
4 | 3.902 | 3.808 | 3.717 | 3.630 | 3.546 | 3.465 | 3.387 | 3.312 | 3.240 | 3.170 |
5 | 4.853 | 4.713 | 4.580 | 4.452 | 4.329 | 4.212 | 4.100 | 3.993 | 3.890 | 3.791 |
6 | 5.795 | 5.601 | 5.417 | 5.242 | 5.076 | 4.917 | 4.767 | 4.623 | 4.486 | 4.355 |
7 | 6.728 | 6.472 | 6.230 | 6.002 | 5.786 | 5.582 | 5.389 | 5.206 | 5.033 | 4.868 |
8 | 7.652 | 7.325 | 7.020 | 6.733 | 6.463 | 6.210 | 5.971 | 5.747 | 5.535 | 5.335 |
9 | 8.566 | 8.162 | 7.786 | 7.435 | 7.108 | 6.802 | 6.515 | 6.247 | 5.995 | 5.759 |
10 | 9.471 | 8.983 | 8.530 | 8.111 | 7.722 | 7.360 | 7.024 | 6.710 | 6.418 | 6.145 |
11 | 10.368 | 9.787 | 9.253 | 8.760 | 8.306 | 7.887 | 7.499 | 7.139 | 6.805 | 6.495 |
12 | 11.255 | 10.575 | 9.954 | 9.385 | 8.863 | 8.384 | 7.943 | 7.536 | 7.161 | 6.814 |
13 | 12.134 | 11.348 | 10.635 | 9.986 | 9.394 | 8.853 | 8.358 | 7.904 | 7.487 | 7.103 |
14 | 13.004 | 12.106 | 11.296 | 10.563 | 9.899 | 9.295 | 8.745 | 8.244 | 7.786 | 7.367 |
15 | 13.865 | 12.849 | 11.938 | 11.118 | 10.380 | 9.712 | 9.108 | 8.559 | 8.061 | 7.606 |
A business must pay $4,000 every year for 4 years starting at time 1 ie starting one year from now. The discount rate of 6%
What is the present value of these receipts?
Solutions
Method 1 - the long way
Time | Cash flow | Discount factor | Discounted cash flow |
|---|---|---|---|
1 | (4,000) | 0.943 | (3,772) |
2 | (4,000) | 0.890 | (3,560) |
3 | (4,000) | 0.840 | (3,360) |
4 | (4,000) | 0.792 | (3,168) |
Total present value | (13,860) |
Method 2 - the quick way
Time | Cash flow | Annuity (cumulative) discount factor | Discounted cash flow |
|---|---|---|---|
1 - 4 | (4,000) | 3.465 | (13,860) |
The factor of 3.465, above is the 4-year 6% cumulative (annuity) factor and it will allow the calculation of the present value for years 1 - 4 in one line instead of four. Note that the name 'cumulative discount factor is because the cumulative factor is the sum of the four individual factors (3.465 = 0.943 + 0.890 + 0.840 + 0.792)
It is important to be aware that the annuity factor can only be used as it stands for flows starting at time 1 and then occurring every period thereafter. Other patterns of flow need a bit of work on the discount factor.
A business will receive annual rent of $12,000 from a tenant, for 5 years starting at time 3. The discount rate is 4%.
What is the present value of the rental receipts?
Solution
The receipts will be received for times: 3, 4, 5, 6, 7. Here is where the first error is likely to be made as you might think you should be looking at time 8 for the last receipt (as 3 +5 = 8).
The seven year cumulative factor would let us calculate the present value of receipts for times 1 - 7 inclusive. But we want 3 - 7 inclusive so we don't want times 1 - 2.
The required factor is therefore:
Period | Cumulative factor |
1 to 7 | 6.002 |
Less: 1 to 2 | (1.886) |
3 to 7 | 4.116 |
The present value of the five flows is therefore: 12,000 x 4.116 = $49,392
2.3 Perpetuities
A perpetuity is a constant annual amount, starting at time 1 and going on for ever. Once you get up to around an annuity for a period of 50 years, the inflows can effectively be regarded as a perpetuity because flows after 50 years are discounted so heavily that they can usually be ignored.
The cumulative discount factor for a perpetuity = 1/Discount rate as a decimal
A building is leased for 999 years at an annual rent of $120,000. The discount rate is 6%.
What is the present values of the rental flows if:
(i) The first rent is paid at Time 1
(ii) The first rent is paid at Time 0
(iii) The first rent is paid at Time 5
Solutions
(i) 120,000 x 1/0.06 = $2,000,000
(Note: the perpetuity discount factor of 1/Discount rate implies the flows begin at time 1)
Period | Present value |
Times 1 – 999 (in essence for ever) | $2,000,000 |
Time 0 | $120,000 |
Times 0 – 999 | $2,120,000 |
(iii) We want times 1 - 999 except times 1,2 3, and 4
Required discount rate = 1/0.06 - 3.465 [the 1 - 4 cumulative 6% factor] = 13.2
Present value of the rental payments = 120,000 x 13.2 = $1,584,000
3 Chapter 11 questions
Question 1
How much will be in a bank account at the end of the following investments?
(a) $1,000 invested for 5 years at 4% simple interest
(b) $500 invested for 4 years at 6% compound interest
(c) $600 invested for 5 years. For the first two years 3% compound interest was earned and 5% compound interest was then earned for the final three years.
Show answerHide answer
Question 2
What is the present value of $345 received after 4 years if the discount rate to be used is 7%?
Show answerHide answer
Question 3
What is the present value of $250 received every year from time 1 to time 10 if the discount rate is 4%?
Show answerHide answer
Question 4
What is the present value of $1,200 received in perpetuity, starting at time 1, if the discount rate is 5%?
Show answerHide answer
Question 5
What is the present value of receiving $1,000 for years 4 - 8 inclusive if the discount rate is 5%?
Show answerHide answer
Question 6
What is the present value of a perpetuity of $500 pa that starts at time 3 if the discount rate is 7%
Show answerHide answer
Investment Decisions – Financial Concepts
10 questionsAnswer the questions one at a time. Your progress is saved so you can leave and come back.
Open chapter practice