Module 3: Present Value

12 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.28
List Price:  €96.12
You save:  €28.84
£55.93
List Price:  £79.91
You save:  £23.97
CA$98.01
List Price:  CA$140.02
You save:  CA$42.01
A$107.87
List Price:  A$154.11
You save:  A$46.23
S$94.42
List Price:  S$134.90
You save:  S$40.47
HK$544.78
List Price:  HK$778.29
You save:  HK$233.51
CHF 62.22
List Price:  CHF 88.89
You save:  CHF 26.67
NOK kr779.46
List Price:  NOK kr1,113.56
You save:  NOK kr334.10
DKK kr501.79
List Price:  DKK kr716.88
You save:  DKK kr215.08
NZ$119.98
List Price:  NZ$171.41
You save:  NZ$51.43
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.18
৳8,402.58
List Price:  ৳12,004.20
You save:  ৳3,601.62
₹5,911.93
List Price:  ₹8,445.97
You save:  ₹2,534.04
RM312.68
List Price:  RM446.70
You save:  RM134.02
₦118,358.68
List Price:  ₦169,091.08
You save:  ₦50,732.40
₨19,451.98
List Price:  ₨27,789.74
You save:  ₨8,337.75
฿2,421.30
List Price:  ฿3,459.15
You save:  ฿1,037.85
₺2,419.75
List Price:  ₺3,456.94
You save:  ₺1,037.18
B$406.81
List Price:  B$581.19
You save:  B$174.37
R1,266.21
List Price:  R1,808.95
You save:  R542.74
Лв131.43
List Price:  Лв187.77
You save:  Лв56.33
₩98,455.31
List Price:  ₩140,656.47
You save:  ₩42,201.16
₪260.61
List Price:  ₪372.31
You save:  ₪111.70
₱4,125.84
List Price:  ₱5,894.31
You save:  ₱1,768.47
¥10,813.84
List Price:  ¥15,449
You save:  ¥4,635.16
MX$1,432.62
List Price:  MX$2,046.69
You save:  MX$614.07
QR256.35
List Price:  QR366.23
You save:  QR109.88
P959.91
List Price:  P1,371.36
You save:  P411.45
KSh9,063.70
List Price:  KSh12,948.70
You save:  KSh3,885
E£3,476.67
List Price:  E£4,966.88
You save:  E£1,490.21
ብር8,762.26
List Price:  ብር12,518.05
You save:  ብር3,755.79
Kz63,877.12
List Price:  Kz91,256.94
You save:  Kz27,379.82
CLP$68,152.06
List Price:  CLP$97,364.26
You save:  CLP$29,212.20
CN¥507.37
List Price:  CN¥724.85
You save:  CN¥217.47
RD$4,236.71
List Price:  RD$6,052.70
You save:  RD$1,815.99
DA9,355.50
List Price:  DA13,365.57
You save:  DA4,010.07
FJ$159.32
List Price:  FJ$227.62
You save:  FJ$68.29
Q542.77
List Price:  Q775.43
You save:  Q232.65
GY$14,710.67
List Price:  GY$21,016.15
You save:  GY$6,305.47
ISK kr9,775.50
List Price:  ISK kr13,965.60
You save:  ISK kr4,190.10
DH703.21
List Price:  DH1,004.63
You save:  DH301.41
L1,276.61
List Price:  L1,823.81
You save:  L547.19
ден4,112.73
List Price:  ден5,875.58
You save:  ден1,762.85
MOP$563.70
List Price:  MOP$805.33
You save:  MOP$241.62
N$1,272.29
List Price:  N$1,817.64
You save:  N$545.34
C$2,573.53
List Price:  C$3,676.63
You save:  C$1,103.10
रु9,461.06
List Price:  रु13,516.38
You save:  रु4,055.32
S/267.08
List Price:  S/381.56
You save:  S/114.48
K283.05
List Price:  K404.37
You save:  K121.32
SAR262.80
List Price:  SAR375.44
You save:  SAR112.64
ZK1,938.90
List Price:  ZK2,769.98
You save:  ZK831.07
L334.76
List Price:  L478.25
You save:  L143.49
Kč1,707.89
List Price:  Kč2,439.96
You save:  Kč732.06
Ft27,663.65
List Price:  Ft39,521.19
You save:  Ft11,857.54
SEK kr779.03
List Price:  SEK kr1,112.95
You save:  SEK kr333.92
ARS$70,272.32
List Price:  ARS$100,393.34
You save:  ARS$30,121.01
Bs485.83
List Price:  Bs694.07
You save:  Bs208.24
COP$310,661.31
List Price:  COP$443,820.90
You save:  COP$133,159.58
₡35,743.76
List Price:  ₡51,064.70
You save:  ₡15,320.94
L1,776.85
List Price:  L2,538.46
You save:  L761.61
₲551,865.53
List Price:  ₲788,413.13
You save:  ₲236,547.59
$U2,996.30
List Price:  $U4,280.61
You save:  $U1,284.31
zł292.33
List Price:  zł417.63
You save:  zł125.30
Already have an account? Log In

Transcript

In this lesson, we're going to look at the concept of present value. Let us use a simple example in this lesson to illustrate the concepts. Let's say I promised to pay you $10 each year forever, and ask you what you would pay me today. For the right to receive that continuous and endless stream of payments in the future, you would first need to evaluate the risk of the investment opportunity. You need to look at such things as how creditworthy I am by my ability to make good on my promise to pay you $10 forever, but you will also need to consider inflation rates and interest rates and any other types of risks that could impact your rate of return. Let's say after this evaluation, you determine that you need a 10% rate of return to compensate you for the risks of making this investment.

You now have enough information to calculate the value of this opportunity to you using what is called a discounted cash flow analysis. discounting is a method that is often used in finance to determine the value of a future stream of cash flow. The concept of time value of money is at the very heart of discounting, which is to say $1 received today is worth more than $1 received a year from now, which is worth more than $1 received two years from now and so on and so forth. The reason this statement is true is that you can take the $1 received today, invest it and earn a return giving you more than $1 a year from now. The expected rate of return becomes our discount factor. financial analysts have all sorts of ways that They can do a present value calculation.

And it doesn't matter what method is used, the answer will always be the same, you could use a present value table, which tells you the discount factor by lining up your discount rate with a number of periods. You can also use a formula to calculate the discount factor, which is the same as the PV if the present value interest factor, which is calculated as one divided by one plus the discount rate to the exponent of the number of periods that you're investing for. And then finally, you can use Excel and use a function in Excel called present value. Any one of these three approaches will result in the same answer. So let's put this into a spreadsheet so that you can see visually what I'm talking about. Let's put our years across To talk and call them 12345, and so on, this goes on for forever to the right of your screen, by the way, because I made a forever promise.

Next, let's put our $10 of cash flow under each of the years. Next, let's put our 10% discount rate into cell B seven, and calculate our discount factor using the formula on the previous slide. Notice how the discount factor the PV if is getting smaller and smaller, the further to the right we go, which makes sense because $1 12 years from now is not going to be worth a whole lot to me today. In fact, it's worth 32 cents. Next, multiply the cash flow the $10 by the discount factor to come up with or arrive at the discounted cash flow. Finally, add up The discounted cash flows to calculate a present value.

The result when rounded is $100. In fact, if you were to add up all the columns to the right, you would get precisely $100 $100 represents the value of this investment opportunity, and you should be willing to pay me $100 for this promise, you might think all these columns are kind of crazy, and there must be a better way. Well, it's your lucky day, because there is let's take the value of the investment opportunity, the $100 and divide it by the annual cash flow of $10. This two equals 10. Now, finance people call this a multiple and you will see multiples quoted all over the place in finance media, from earnings multiples, to cash flow multiples, to even the book value multiples that we saw in our last lesson, when we were comparing Microsoft ofs market capitalization to its book value of equity. If you know the income, and you know the multiple, you literally multiply the two together to determine value.

But this multiple also ties back to our rate of return. When you have a constant and infinite life cash flow stream, you can take your discount rate and divide it into one to determine your multiple. In other words, one divided by 10% equals the same 10 times multiple $10 of income times the multiple of 10 gives us our very same $100 of value. Let's do this using a different set of assumptions that are a little messier to work with. If I promised you $6 a year forever, and your required rate of return was 15%. How much is this investment opportunity worth?

If you Got $40 you would be correct, calculated as six times one divided by your discount rate of 15%. Or even more simply $6 divided by 15% equals the $40. Got it? Let's change our original scenario ever so slightly, and instead, assume that the cash flows grow at a constant rate. How does that change our analysis? Let's model this out in Excel.

Notice how the cash flow is growing by 2% each year. Once again these cells will reach as far as the eye can see to the right of your screen. The sum of the discounted cash flows is $125 which is to say we get $100 of value from our initial $10 and an incremental $25 of present value from the growth in the cash flow. Now a shortcut method still works. However, we need to adjust that denominator by subtracting the expected growth rate from our discount rate, we change our original formula to read $10 divided by 10% minus 2%. The value of this opportunity is the very same $125, implying a multiple of 12 and a half times.

Always remember that smaller discount rates will increase present value. What if the cash flows were expected to instead decreased by 2% per year, say in the situation of a declining business? Well, instead of subtracting 2% from the discount rate, we add it and as a result, the value is now at $3 and our multiple decreases to 8.3 times. still with me, let's try another variation. What if instead, I promised to pay you $10 for only the next five years and not forever, like I did in the previous example, how much is this worth? We call this an annuity.

When the cash flow forecast only occurs for five years, we need to look up the discount factor in a different table or use a different formula. We call this the discount factor of an annuity or the present value interest factor of an annuity they mean the same thing. Let me just show you something that will help you conceptualize what this formula represents. The present value interest factor table for a lump sum is on the left. The table for the annuity is on the right. You can add up the five separate discount factors from the table on the left hand came up with the same discount factor supplied on the table on the right When you think about what an annuity represents, this makes sense.

So whether you do it the long way by discounting each $10 cash flow for five years, or use the alternative table or a formula to calculate the discount factor, your answer is the same. In this case, we take the 3.791 discount factor from the table and multiply it by the $10 annual cash flow to determine a present value of $37 and 91 cents. That is what you should be willing to pay me for this investment opportunity. Let me see if I can really fool you now by offering you an investment opportunity that has cash flows that are both finite and uneven. What are you going to pay me for this? I promised to pay you $5 in the first year $10 in the second $7 in the third $8 in the fourth and $11 in the fifth year, at which point it's over.

Many business opportunities experience uneven cash flows like this. So how are you going to handle it? When this is the situation, there are no shortcuts, you sit down with a spreadsheet and you input the assumptions. Let's do that now. This screen illustrates the approach and is consistent with what was shown earlier years across the top cash flows on row five. The discount factor has been calculated on row seven and the discounted cash flow on row nine, you can add up the discounted cash flows to determine the present value of this opportunity.

This gives us $30 and 36 cents. This is what those five cash payments over the next five years are worth in today's dollars. The basis of what you've just learned in this lesson are the foundation for so many types of financial analysis. As we illustrated in this lesson, we can determine the value of something, it could be a business and investment or securities like stocks or bonds. All of these types of opportunities come with a stream of cash flow and a discount rate, which you can use to determine value. A more advanced extension of this idea is for capital budgeting, capital budgeting is deciding about whether or not to invest capital in a new long term project, such as opening a new plant or purchasing a competitor's business.

The process you use a similar forecast the future cash flow, determining discount rate, calculate present value and then subtract off the upfront investment. The results give you what is called net present value because present value of cash flow is subtracted from the investment required to obtain them. If the resulting number is positive, the opportunity Create shareholder value, and if it's negative, it dilutes it and the project should not be pursued. So now you have learned a little something about how to calculate present value. In this lesson, we learned three really important things. First of all, present value determines the value today of a future stream of cash flow.

Secondly, to determine value, you need a cash forecast and a discount rate. The discount rate is set based on an expectation of return. And thirdly, we learned about three different approaches to calculating value, depending on the characteristics of the stream of cash flow. In our next lesson, let's flip this around and look at future value.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.