Question

In: Finance

ou are given the following stream of cash flows: Year 1 Year 2 Year 3 Year...

ou are given the following stream of cash flows: Year 1 Year 2 Year 3 Year 4 Year 5 $100,000 $110,000 $120,000 $130,000 $140,000 A. If you thought the appropriate discount rate was 10%, what would be the present value of this cash flow stream today at t=0? B. If you thought the appropriate interest/discount rate was 10%, what would be the future value of this cash flow stream in five years at t=5 years?

Solutions

Expert Solution

Present Value calculation

Present Value is calculated using the below formula:

PV = Cn/(1+r)n

where r is the discount rate, Cn is the cash flow at year n

C1 = 100000, C2 = 110000, C3 = 120000, C4 = 130000, C5 = 140000

Present value of C1 = 100000/(1+10%)1 = 100000/(1.1)1 = 90909.0909090909

Present value of C2 = 100000/(1+10%)2 = 100000/(1.1)2 = 90909.0909090909

Present value of C3 = 100000/(1+10%)3 = 100000/(1.1)3 = 90157.7761081893

Present value of C4 = 100000/(1+10%)4 = 100000/(1.1)4​​​​​​​ = 88791.7491974592

Present value of C5 = 100000/(1+10%)5 = 100000/(1.1)5​​​​​​​ = 86928.9852282817

Total Present value = 447696.692352112

Year 1 2 3 4 5
Cash flow 100000 110000 120000 130000 140000
Present value 90909.09 90909.09 90157.78 88791.75 86928.99

Future value calculation

Future value is calculated using the below formula

FV = C*(1+r)n

Year 1 2 3 4 5
Cash flow 100000 110000 120000 130000 140000

Future value of C1 at (t=5) = 100000*(1+10%)4 = 100000*1.14 = 146410

Future value of C2 at (t=5) = 100000*(1+10%)3 = 100000*1.13 = 146410

Future value of C3 at (t=5) = 100000*(1+10%)2 = 100000*1.12 = 145200

Future value of C4 at t=5 = 100000*(1+10%)1 = 100000*1.11 = 143000

Future value of C5 at t=5 = 140000

Total future value at t=5) = 146410+146410+145200+143000+140000 = 721020

Year 1 2 3 4 5
Cash flow 100000 110000 120000 130000 140000
Future value 146410 146410 145200 143000 140000

Related Solutions

Calculate NPV for the following stream of cash flows: Year 1 is an outflow of $200...
Calculate NPV for the following stream of cash flows: Year 1 is an outflow of $200 for research; Years 2, 3 and 4 have a cash inflow each year of $100. The appropriate discount rate for valuation is 10%. NPV is
Calculate the NPV given the following cash​ flows YEAR   CASH FLOWS 0 -60,000 1 25,000 2...
Calculate the NPV given the following cash​ flows YEAR   CASH FLOWS 0 -60,000 1 25,000 2 25,000 3 15,000 4 15,000 5 10,000 6   10,000 if the appropriate required rate of return is 8 percent. Should the project be​ accepted? What is the​ project's NPV​?
You have 3 projects with the following cash​ flows: Year    0       1   2     ...
You have 3 projects with the following cash​ flows: Year    0       1   2      3         4 Project 1   -$149   $19   $42   $61      $79 Project 2   -827      0   0   7,002   -6,508 Project 3   18          39   62   81      -247 a. For which of these projects is the IRR rule​ reliable?_______. b. Estimate the IRR for each project​ (to the nearest 1 %​).________. c. What is the NPV of each project if the cost of capital is 5...
Value of a mixed stream For the mixed stream of cash flows shown in the following​...
Value of a mixed stream For the mixed stream of cash flows shown in the following​ table, LOADING...​, determine the future value at the end of the final year if deposits are made into an account paying annual interest of 13​%, assuming that no withdrawals are made during the period and that the deposits are​ made: 1              30,300 2              25,250 3              20,200 4              10,100 5              5,050 a. At the end of each year. b. At the beginning of each year....
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 -$ 152 $22 $39 $58 $82 Project 2          −826 0 0 7,010 −6,506 Project 3 21 41 61 80   −247 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest1%​). c. What is the NPV of each project if the cost of capital is 5%​?20 %50%​? a. For which of these...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 −$151 $ 21 $ 39 $ 59 $ 80 Project 2                                                −824 00 00 6,999 −6,501 Project 3 2020 40 62 81 −245 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest 1%​). c. What is the NPV of each project if the cost of capital is 5%​? 20%​? 50%​? a....
ou are given three investment alternatives to analyze. The cash flows from these three investments are...
ou are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup​ window:.... Assuming a discount rate of 21 ​percent, find the present value of each investment. a. What is the present value of investment A at 21 percent annual discount​ rate? ​$ nothing  ​(Round to the nearest​ cent.) b. What is the present value of investment B at 21 percent annual discount​ rate? ​$ nothing  ​(Round to the nearest​ cent.) END...
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2...
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2 7,630 3 5,040 4 −1,580 Assuming the appropriate interest rate is 10 percent, what is the MIRR for this project using the discounting approach? 19.21% 15.23% 13.96% 11.63% 17.77%
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2...
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2 7,360 3 4,800 4 −1,640 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach?
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3...
Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3 5,000 4 6,000 5 7,000 a. What is the return expected on this investment measured in dollar terms if the opportunity cost is 6%. b. What is the return on this investment measured in percentage terms? c. Is the investment profitable? Explain your answer.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT