# Time value of money. Interest Rate /Discount Rate / Internal Rate of Return.

It’s time to talk about interest rates, discount rates and time value of money. Three inter related core concepts in Finance that lead to a number of interesting applications.

## Compounding

Let’s go back to a simple investments. We put in a 100 dollars in our friendly neighborhood bank account. As long as the money stays in the account for one full year, it will grow to 110 dollars, for a net return of 10%.

What if the money stays in the account for two years or even more? Let’s assume that the day you invest the money in the bank, a wormhole (space time anomaly, dimensional gateway, a doorway to another universe) opens from nowhere, swallows you and spits you back in your home world after 100 years in hibernation. Amazingly the bank and your account have survived your unplanned absence and the bank has been paying you interest all of these years. Guess what: YOU ARE RICH! You go to the bank and find out that your account contains exactly one million three hundred and seventy eight thousand and sixty one dollars and twenty three cents. In order to make sure that there is no mistake or miscalculations on the bank statement, you decide to run the numbers yourself. Here are the details & the assumptions the bank made in calculating your balance.

- Interest was paid every year on 31
^{st}December on the balance in your account on 1^{st}of January of that year. - Interest was added to your balance on 31
^{st}December.

Year | Balance on 1^{st} Jan | Interest | Balance on 31^{st} December |

1 | 100 | 10 | 110 |

2 | 110 | 11 | 121 |

3 | 121 | 12 | 133 |

4 | 133 | 13 | 146 |

5 | 146 | 15 | 161 |

6 | 161 | 16 | 177 |

7 | 177 | 18 | 195 |

8 | 195 | 19 | 214 |

9 | 214 | 21 | 236 |

10 | 236 | 24 | 259 |

We can carry this on for the next 90 years. Instead of making 90 additional calculations, there is a shortcut which can help us save time and space. Do you see a pattern above? If not, let’s see if we can make it more obvious. Our objective is to avoid the repetitive calculations above and reduce 100 years of number crunching to one simple formula.

We already know the following

Balance at end of 1st year = Principal * (1 + 10%)

Balance at end of 2nd year = Balance at end of 1st year * (1 + 10%)

Balance at end of 3rd year = Balance at end of 2nd year * (1 + 10%)

Balance at end of 4th year = Balance at end of 3rd year * (1 + 10%)

(and so on…..)

To simplify and calculate “Balance at the end of 4th year”, we need to keep on substituting all definitions till we are down to something that just has “original balance” and (1 + 10%). The substitution sequence is as follows

Balance at the end of the 4th year

= Balance at end of 3rd year * (1 + 10%)

= Balance at end of 2nd year * (1 + 10%) * (1 + 10%)

= Balance at end of 1^{st} year * (1 + 10%) * (1 + 10%) * (1 + 10%)

= Principal * (1 + 10%) * (1 + 10%) * (1 + 10%) * (1 + 10%)

= Principal * (1 + 10%) ^ 4

The “^” sign is read as “raised to the power of” or “to the power of”. Even simple calculators and spreadsheet programs have a function that can allow you to calculate “(1 + 10%) raised to the power 4”. When you run the numbers, you will find that the answer is 1.46.

Now you we come to the difficult part. How would you calculate the growth in your account at 10% interest for the next 100 years.

The answer is “Principal * (1 + 10%) ^ 100”. The number, as we already know, is 1.378 Million dollars.

The approach that we have just used is called compounding or compound interest. It’s called compounding because this year’s interest is next year’s principal.

# Time Value of Money

Let’s look at another example that takes a different angle. My friendly bank manager has offered me a guaranteed return of 10% on anything that I put in my account as long as that amount stays in the account for one full year. I know that I would need 11,000 dollars at the end of one year to buy myself something, anything, everything. What do I need to put in today, that the X amount (principal) @ 10% a year will grow to 11,000 at the end of year one?

Interesting question. Let’s take another look at the work we did above.

We already know that at 10%, a dollar today grows to

1 * (1+ 10%) = 1.1

What we need to know is what principal today will grow to 11,000 dollars at 10% a year. So the above equation becomes

Principal * (1 + 10%) = 11,000

Or using basic manipulation

Principal = 11,000 / (1 + 10%) = 10,000

What this says is that to have 11,000 dollars one year from now, we need 10,000 dollars at an interest rate of 10% today.

What about 11,000 dollars two or even three years from now?

Well, we already know that a dollar at 10% in two years will grow to

1 * (1 + 10) ^ 2 = 1.21

Taking the approach used above

Principal * (1 + 10%) ^ 2 = 11,000

Principal = 11,000 / (1 + 10%) ^ 2 = 11,000 / 1.21 = 9,090

So what does this means? The 11,000 dollars we need two years from now are valued 9,090 dollars today.

What we have just done above is called **discounting.** We are adjusting the value of a payment that will be received at a point in future. This adjustment is called discounting. Therefore, we are discounting back a future value to bring it to its present value. The rate used to adjust the future payment is called the discount rate.

The idea behind discounting or compounding is also known as time value of money. Since a dollar at a fixed interest rate will grow in any bank account at that certain rate, if it is invested in an alternate opportunity, it should at least earn that rate from the other alternative to even consider the alternative worth thinking about. Discounting adjusts future payments, investment returns and even return of principal on this basis. The idea is that if you fail to earn the discount rate, you have actually lost money, since any bank, would at least have given you the discount rate as return for depositing your money with them. Anything less than that would mean that you have not put your money to its best use.

When we calculate the value of future payments today, we are doing a **present value **calculation. When we try to value what a stream of future payments is valued at today (the value of receiving 1,000 dollars a month for the next 36 months ), it is also a present value calculation. When we calculate the value of anything in the future we do a **future value** calculation. When we try to determine what a stream of future payments will be worth at some point in the future (the value of paying 1,000 dollars a month for 36 months, 36 months from today), it is also a future value calculation.

The analysis of any investment generally requires discounting (present valuing or pv’ing) two streams of numbers.

The first is the amount invested. If you put in a 1,000 dollars in an investment, every year for the next 5 years, that investment is worth the present value of five payments of 1,000 dollars each, one year apart.

Worth of investment today (Present Value of Investment) =

PV of $1000 (1 year from now) + PV of $1000 (2 years from now + ….+ PV of $1000 (5 years from now)

The second is the promised return. If in return for this investment you would receive 5,000 dollars in each six years and seven years from now, is it a good investment?

The value of these two payments is equal to the present value of two payments of 5,000, spread over two years and starting five years from now (year six and year seven).

Value of stream of return today (Present Value of Return) = PV of $5000 ( 6 years from now) + PV of $5000 ( 7 years from now)

Year | Investment | Return |

1 | 1,000 | |

2 | 1,000 | |

3 | 1,000 | |

4 | 1,000 | |

5 | 1,000 | |

6 | 5,000 | |

7 | 5,000 |

A positive NPV denotes that at a certain cost of capital the returns or inflows from an investment opportunity outweigh the outflows or costs of investment, and vice versa. Obviously, when comparing various alternatives available for investment, the option with the most positive NPV or least negative NPV will be favoured or chosen. The ensuing discussion on “Present Value in Action” will make these concepts clear.The Net Present Value (NPV) of this opportunity is the present value of the return (inflows) less the present value of the investment stream (outflows).

## Examples

**1) **Natasha has a chance to invest in a project, Ventures, Inc. that will pay her $100 in year 1, and $200 in year 2.How much is she willing to pay for this opportunity? Assume an annual discount rate of 10%.

**Solution: **She will be willing to pay an amount that is equal to the present value of this stream of payments. To calculate the present value, you need to divide the payment by its respective discount factor.

Discount factor for year n = (1 + [discount rate])^n

**Discount rate **given*=*10%

Therefore:

Year | 1 | 2 |

Discount Factor | 1.10 | 1.21 |

Payment | $ 100.00 | $ 200.00 |

PV | $ 99.90 | $ 165.30 |

**Total PV*** *= Sum of PVs of payments = $ 256.20

Hence, she would be willing to pay $256.2 for this opportunity.

**2) **Zia wants to lease a car for 3 years. The car dealer has given him two payment options to choose from:

Year | 0 | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 |

Option 1 | $ 3,000.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 |

Option 2 | $ 5,000.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 |

Which payment option should he choose? (Assume an annual discount rate of 10%)

**Solution: **

In order to decide which payment to choose from, he would need to calculate the PV of the payment stream, and look at which costs him the least. Using the following:

Discount rate= 10%

Discount factor for year n = (1 + [discount rate])^n

PV of payment in year n = [payment in year n] / [discount factor for year n]

Total PV = Sum of PVs of payments

## PV of payment stream for option 1

Year | 0 | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 |

Option 1 Payment | $ 3,000.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 | $ 500.00 |

Discount Factor | $ 1.05 | $ 1.10 | $ 1.15 | $ 1.21 | $ 1.27 | $ 1.33 | |

PV of Payment | $ 3,000.00 | $ 476.73 | $ 454.55 | $ 433.39 | $ 413.22 | $ 393.99 | $ 375.66 |

PV of payment stream for option 1 = $ 5,547.5

## PV of payment stream for option 2

Year | 0 | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 |

Option 1 Payment | $ 5,000.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 |

Discount Factor | $ 1.05 | $ 1.10 | $ 1.15 | $ 1.21 | $ 1.27 | $ 1.33 | |

PV of Payment | $ 5,000.00 | $ 333.71 | $ 318.18 | $ 303.37 | $ 289.26 | $ 275.79 | $ 262.96 |

PV of payment stream for option 2*=*$ 6,783.3

**Conclusion: **Hence he should choose option 1 as it costs him less than option 2.

**3) **Zareena’s firm, Tots and Toys, Inc. offers her an investment plan that requires 10 yearly payments of $1000, starting from today. The plan promises an annual return of 8% on her investment. The money will be available to her at the end of 10 years (no withdrawls are allowed before that time.) What amount will she get at the end of 10 years?

**Solution: **The question requires you to find the future value (FV) of the stream of payments. The rate given is 8%.

In order to find the FV, you need to multiply each amount by its respective FV factor, and then sum the results.

Discount rate given* *= 8%

FV factor for year N = (1 + [discount rate])^(10 – N)

Year | Payment | FV Factor | FV |

0 | $ 1,000 | 2.16 | $ 2,158.9 |

1 | $ 1,000 | 2.00 | $ 1,999.0 |

2 | $ 1,000 | 1.85 | $ 1,850.9 |

3 | $ 1,000 | 1.71 | $ 1,713.8 |

4 | $ 1,000 | 1.59 | $ 1,586.9 |

5 | $ 1,000 | 1.47 | $ 1,469.3 |

6 | $ 1,000 | 1.36 | $ 1,360.5 |

7 | $ 1,000 | 1.26 | $ 1,259.7 |

8 | $ 1,000 | 1.17 | $ 1,166.4 |

9 | $ 1,000 | 1.08 | $ 1,080.0 |

**4) **Its Jan 1st, 2000 and WeGotItAll, Inc., your brand-new start-up, is in dire need of cash. You decide to take a loan of $100,000 from the bank. Interest on the loan will accrue at the rate of 10% and the bank requires that you pay back $10,000, on Jan 1st, every year starting 5 years from now, and therest of the amount on Jan 1st, 2010. How much is this final amount?

**Solution: **

In order to calculate the amount, you need to calculate the future value of the stream of cash flow, using 10% as your discount rate.

Using:

Amount borrowed = $ 100,000

Interest rate* = *10%

Annual payback amount $ 10,000

(starting from year 5)s

Interest for year = [Amt at year beginning] * [Interest rate]

Amount at year end = [Amount at year beginning] + [Interest for year]

Year | Amt at prev. yr end | Payback | Amt. at year beg. | Interest for year | Amt. at year end |

0 | $ – | $ – | $ 100,000.0 | $ 10,000.0 | $ 110,000.0 |

1 | $ 110,000.0 | $ – | $ 110,000.0 | $ 11,000.0 | $ 121,000.0 |

2 | $ 121,000.0 | $ – | $ 121,000.0 | $ 12,100.0 | $ 133,100.0 |

3 | $ 133,100.0 | $ – | $ 133,100.0 | $ 13,100.0 | $ 146,410.0 |

4 | $ 146,410.0 | $ – | $ 146,410.0 | $ 14,641.0 | $ 161,051.0 |

5 | $ 161,051.0 | $ 10,000.0 | $ 151,051.0 | $ 15,105.1 | $ 166,156.1 |

6 | $ 166,156.0 | $ 10,000.0 | $ 156,156.0 | $ 15,615.6 | $ 171,771.7 |

7 | $ 171,771.7 | $ 10,000.0 | $ 161,771.7 | $ 16,177.2 | $ 177,948.9 |

8 | $ 177,948.9 | $ 10,000.0 | $ 167,948.9 | $ 16,794.9 | $ 184,743.8 |

9 | $ 184,743.8 | $ 10,000.0 | $ 174,743.8 | $ 17, 474.4 | $ 192,218.1 |

Hence you would need to pay back $192,218.1 on Jan 1st, 2010.

**5) **You have just sold your start-up for a $100 million, and your friend comes up to you asking you to invest in his new start-up. He says he needs $100,000 now, and will require a further $50,000 each in years 1 and 2. For your investment, he is willing to give you 30% of his company which he expects to sell for $80 million in year 5. What is the NPV of this opportunity?

Assume a discount rate of 30% for this risky investment.

The first thing to do is chalk out the cash flows, including both the inflows and the outflows:

Year | 0 | 1 | 2 | 3 | 4 | 5 |

Cash flow | $ (100,000) | $ (50,000) | $ (50,000) | $ 2,400,000 |

Using:

Discount rate = 30%

Discount factor for year n = (1 + [discount rate])^n

PV of cash flow in year n = [payment in year n] / [discount factor for year n]

NPV = Sum of the PV’s of the cash flows

Year | 0 | 1 | 2 | 3 | 4 | 5 |

Cash Flow | $ (100,000) | $ (50,000) | $ (50,000) | $ – | $ – | $ 2,400,000 |

Discount Factor | 1.30 | 1.69 | 2.20 | 2.86 | 3.71 | |

PV | $ (100,000) | $ (38,461.5) | $ (29,585) | $ – | $ – | $ 646,389.8 |

NPV | $ 478,342.4 |

**6) **Gabes is the CFO of eBizz, Inc. His company has a ? of 2, and has no debt on its books. Due to its rapid growth Gabes is in dire need of cash and decides to increase his company’s leverage to 25%. How does that affect his cost of capital? (Assume that taking on debt does not change your ??)

Ignore the tax effects of debt.

*Assume the following: *

Risk free rate= 6%

Market risk premium = 8%

Cost of debt = 10%

## Solution

Cost of equity = [risk free rate] + ? * [market risk premium]

Therefore:

Cost of equity = 6% + 2*(8%) = 22.00%

This is also your initial cost of capital, since you had no debt on your books.

Now, Cost of capital = [% of debt] * [cost of debt] + [% of equity] * [cost of equity]

We know that leverage has been increased to 25%.

This means that:

Debt/Equity = 25% = ¼

This means that now his company is 1/5th debt and 4/5 equity.

Therefore:

Cost of capital = (20% * 10%) + (80% * 22%) = 19.60%

Hence issuing debt has lowered his cost of capital.