Solve using excel please! For the cash flows shown below, determine the present worth in year...

Question

Question

For the cash flows shown below, determine the present worth in year 0 at an interest rate of 6% per year compounded monthly C

Solve using excel please!

Answer 1

Answer #1

D12 - 1 =C12*B12 ДА В 10 Year Cash flow 11 0 $ 300,000 12 1 $ 275,000 2 $ 250,000 14 3 $ 225,000 15 4 $ 200,000 16 5 $ 175,00

*Please rate Thumbs up

Answer 2

Similar Homework Help Questions

For the cash flows shown below, determine the present worth & the equivalent uniform worth in...

For the cash flows shown below, determine the present worth & the equivalent uniform worth in years 1 through 5 at an interest rate of 18% per year compounded monthly. Draw the cash flow diagram as well. (6+ 2 + 2 pts) Year 0 1 2 3 4 5 Cash Flows, S 0 200,000 0 350,000 0 400,000
Find the present worth in year 0 for the cash flows shown using an interest rate of 5% per year. *solve it in Excel, sh...

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
please help me draw the labelled cash flow For the cash flows shown below, determine the...

please help me draw the labelled cash flow For the cash flows shown below, determine the present worth & the equivalent uniform worth in years 1 through 5 at an interest rate of 18% per year compounded monthly. Draw the cash flow diagram as well. (6+ 2 + 2 pts) Year 0 1 2 3 4 5 Cash Flows, s 0 200,000 0 350,000 0 400,000

2. For the cash flows shown below, determine the total equivalent present worth & the equivalent...

2. For the cash flows shown below, determine the total equivalent present worth & the equivalent annual worth in years 1 through 5. The interest rates specified are 10% for the years 1-3 and 12% for years 4 & 5. Draw the cash flow diagram as well. (Hint: Please note the different interest rates specified for different years] (4 + 2 + 2 pts) Year 0 1 2 3 4 5 Cash Flows, S 0 2000 2000 2000 4000 4000
1a) (13pts) For the cash flows below, determine the amount in year I, if the funure...

1a) (13pts) For the cash flows below, determine the amount in year I, if the funure worth interest rate is 7.770618763% per year compounded quarterly in year 9 is $6.000 and the Year Cost,S1000 A 4 : A-75 7 8 |A-1951A-225 A-15 45 . A-105 A-1351 A-165 Ib) (12pts) Compute the equivalent uniform A value for years 1 through 8. given varying interest rates as shown in the cash flow diagram. i = 14% +--i = 10%- 6 Year 100...
For the cash flows shown, calculate the future worth in year 14 using i = 14%...

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

For the cash flows shown, find the future worth in year 7 at į = 3%...

For the cash flows shown, find the future worth in year 7 at į = 3% per year? (G is decreasing and equal to $200) Solve it in Excel, upload your excel files and formula AF = ? i = 3% 4 0 1 2 3 5 6 7 17000
Problem 04.062 Varying Interest Rates For the cash flows shown, determine the future worth in year...

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...

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 Ⓡ.

6. For the cash flows described, determine the value of G that makes the present worth...

6. For the cash flows described, determine the value of G that makes the present worth in year o equal to $14,000. Use the proper cash-flow series in your calculations (i.e., do not translate the dollar amounts one-by-one). The interest rate is 10%. Cash flows: nothing in year 0; $8000 in year 1; $8000-G in year 2; $8000-2G in year 3; $8000-3G in year 4.