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

jeff jeffy answered 9 months ago
Next > < Previous

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?
What is the FV at the end of year 3 of the following cash flow stream...
What is the FV at the end of year 3 of the following cash flow stream if the quoted interest rate is 15 percent, compounded quarterly? Year0=$0 Year1=$200 Year2=$200 Year3=$200. (WITH EXPLANATION PLEASE and Manual + Calculator solution)
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT