Question

In: Finance

8. Calculate the Future Value of the following cash flow stream. Assume that 12.50% is the...

8. Calculate the Future Value of the following cash flow stream. Assume that 12.50% is the appropriate rate. Year Cash Flow 1-5 $2,000 6-12 4,000 13 10,000 14-20 13,000 21-25 16,000

Solutions

Expert Solution

$ 708,583.38

Year Cash Flow Future Value of 1 Future Value of cash flow
a b c=1.1250^(25-a) d=b*c
1 $       2,000    16.8912 $     33,782.40
2 $       2,000    15.0144 $     30,028.80
3 $       2,000    13.3461 $     26,692.27
4 $       2,000    11.8632 $     23,726.46
5 $       2,000    10.5451 $     21,090.19
6 $       4,000      9.3734 $     37,493.67
7 $       4,000      8.3319 $     33,327.70
8 $       4,000      7.4062 $     29,624.63
9 $       4,000      6.5833 $     26,333.00
10 $       4,000      5.8518 $     23,407.11
11 $       4,000      5.2016 $     20,806.32
12 $       4,000      4.6236 $     18,494.51
13 $     10,000      4.1099 $     41,098.91
14 $     13,000      3.6532 $     47,492.07
15 $     13,000      3.2473 $     42,215.17
16 $     13,000      2.8865 $     37,524.60
17 $     13,000      2.5658 $     33,355.20
18 $     13,000      2.2807 $     29,649.07
19 $     13,000      2.0273 $     26,354.72
20 $     13,000      1.8020 $     23,426.42
21 $     16,000      1.6018 $     25,628.91
22 $     16,000      1.4238 $     22,781.25
23 $     16,000      1.2656 $     20,250.00
24 $     16,000      1.1250 $     18,000.00
25 $     16,000      1.0000 $     16,000.00
Total $ 7,08,583.38

Related Solutions

What is the present value and future value of the following cash flow stream at a...
What is the present value and future value of the following cash flow stream at a rate of 8.00%? Years: 0 1 2 3 4 CFs: $0 $75 $225 $0 $500
Find the future value of the following cash flow stream at a rate of 5%: Year...
Find the future value of the following cash flow stream at a rate of 5%: Year 0: $0, Year 1: $400, Year 2 $300, Year 3 $250.
Find the present value of the following cash flow stream assuming a discount rate of 8%:...
Find the present value of the following cash flow stream assuming a discount rate of 8%: A payment of $10,000 received at the end of each MONTH over the coming 4 years, followed by a payment of $5000 received at the end of each MONTH over the 6 years after that. a.) $556,975.15 b.) $409,619.13 c.) $285,172.61 d.) $207,297.84 e.) $616,916.97
Assume that 17.00 % is the appropriate rate for the following cash flow stream. Year Cash...
Assume that 17.00 % is the appropriate rate for the following cash flow stream. Year Cash Flow ($) 1 3,000 2-11 4,000 12-25 6,000 26-40 10,000 1. What is the Present Value of the cash flows? 2. What is the Future Value of the cash flows? Round your answer to the nearest dollar and do NOT enter a dollar sign.
What is the Net Present Value of the following cash flow stream? Year Cash Flow 0...
What is the Net Present Value of the following cash flow stream? Year Cash Flow 0 -$489 1 $363 2 $192 3 $161 4 $256 Assume an interest rate of 13% Note: Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. If your answer is negative, enter your answer as a negative number rounded off to two decimal points.
Problem 4-7 Present and Future Value of an Uneven Cash Flow Stream An investment will pay...
Problem 4-7 Present and Future Value of an Uneven Cash Flow Stream An investment will pay $200 at the end of each of the next 3 years, $400 at the end of Year 4, $600 at the end of Year 5, and $800 at the end of Year 6. If other investments of equal risk earn 8% annually, what is its present value? Round your answer to the nearest cent.What is its future value? Round your answer to the nearest...
What is the present value of the following cash flow stream at a rate of 3.0%...
What is the present value of the following cash flow stream at a rate of 3.0% per year? Year 0: $0, Year 1: $75, Year 2: $225, Year 3: $0, Year 4: $300
What is the present value of the following cash flow stream at a rate of 7.0%...
What is the present value of the following cash flow stream at a rate of 7.0% per year? cash flow stream : 0=0$ 1=$75 2=$225 3=$0 4=$300 years and CF'S
PRESENT AND FUTURE VALUES OF A CASH FLOW STREAM An investment will pay $50 at the...
PRESENT AND FUTURE VALUES OF A CASH FLOW STREAM An investment will pay $50 at the end of each of the next 3 years, $200 at the end of Year 4, $300 at the end of Year 5, and $550 at the end of Year 6. If other investments of equal risk earn 11% annually, what is its present value? Round your answer to the nearest cent. $ If other investments of equal risk earn 11% annually, what is its...
PRESENT AND FUTURE VALUES OF A CASH FLOW STREAM An investment will pay $50 at the...
PRESENT AND FUTURE VALUES OF A CASH FLOW STREAM An investment will pay $50 at the end of each of the next 3 years, $250 at the end of Year 4, $350 at the end of Year 5, and $550 at the end of Year 6. If other investments of equal risk earn 4% annually, what is its present value? Round your answer to the nearest cent. $   If other investments of equal risk earn 4% annually, what is its...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT