Year | CF | Compound factor | Compounded CF | ||
2 | $17,000.00 | (1+0.03)^(7-2)= | 1.159274074 | 1.1592740743*17000= | $ 19,707.66 |
3 | $16,800.00 | (1+0.03)^(7-3)= | 1.12550881 | 1.12550881*16800= | $ 18,908.55 |
4 | $ 16,600.00 | (1+0.03)^(7-4)= | 1.092727 | 1.092727*16600= | $ 18,139.27 |
5 | $16,400.00 | (1+0.03)^(7-5)= | 1.0609 | 1.0609*16400= | $ 17,398.76 |
6 | $16,200.00 | (1+0.03)^(7-6)= | 1.03 | 1.03*16200= | $ 16,686.00 |
7 | $16,000.00 | (1+0.03)^(7-7)= | 1 | 1*16000= | $ 16,000.00 |
FV = Sum of all Compounded CF | $ 1,06,840.24 |
For the cash flows shown, find the future worth in year 7 at į = 3%...
Find the present worth in year 0 for the cash flows shown using an interest rate of 5% per year. *solve it in Excel, show formula P = ? i=5% 3 4 5 6 7 8 9 10 11 A=$10,000 $8000+$10,000 $12,000+$10,000
For the cash flows shown, calculate the future worth in year 14 using i = 14% per year. Year 0 1 2 3 4 5 6 Cash flow, $ 200 200 200 200 300 300 300
Solve using excel please! For the cash flows shown below, determine the present worth in year 0 at an interest rate of 6% per year compounded monthly Cost ($1000) Year $300 0 $275 1 $250 2 $225 3 $200 4 $175 5
Problem 04.062 Varying Interest Rates For the cash flows shown, determine the future worth in year 5. Year 0 1-4 Estimated i Per Year 14% Cash Flow($/year) 5000 6000 9000 14% 5 9% The future worth in 5 years is $
Problem 04.062 Varying Interest Rates For the cash flows shown, determine the future worth in year 5. Year Cash Flow($/year) 0 5000 1-4 6000 51 9000 Estimated i Per Year 8% 8% 16% The future worth in 5 years is $ 93765.956 Ⓡ.
For the cash flows shown, determine the future worth in year 5. Year Cash Flow($/year) Estimated i Per Year 0 5000 8% 1–4 6000 8% 5 9000 16% The future worth in 5 years is $
For the cash flows shown, calculate the future worth in year 13 at i = 11% per year. Year01234567Cash flow, $5005005000800800800800 The future worth is calculated to be?
Convert the cash flows shown above (black arrows) into an equivalent annual worth "A" in years 1 through 8 (red arrows) at i = 15% per year. *solve it in Excel, show formula A = ? 9_19 21 31 41 51 of 71 81 i=15% VVVVV A = $9000 $9000 + $7000
*Note: You should form cash flow diagrams and use excel functions to solve following questions. You should upload your excel files on blackboard and attach the hard copy of them to your HW. Q1: The present worth of the cash flow shown below at į= 10% is? 8 show the formula in excel step by step P ? 0 1 2 3 456 7 A $13,000 Q2: An engineering company in Wyoming that owns 50 hectares of valuable land has...
Find Equivalent Annual Worth for the following Cash flow if i=3%: Use excel to solve this question show formula Year Cash flow, $ 0 0 1 2 3 4 5 6 7 own 550 $50 350 Step 1. Finding NPV 5110 $130 Step 2. Finding AT 0 1 2 3 4 5 6 7 1 $50 $50 $50 $70 $90 $110 $130