# Explain the process and the results.

Given the following data, use Excel’s syntax (and showthe formulas) to calculate the MIRR for a project with an expectedeconomic life six years and a salvage value of \$1,000 (the lastdata entry). The end-of-period cash flows are expected to increaseat the rate of 10% per annum. Project data: outlay cost: -\$10,000 Estimated end-of-period cash flows: -\$2,000, \$5,000,\$4,000, \$3,000, \$5,000, and \$1,000 To estimate the MIRR, compute the Future Value of thecash flows at the rate of ten per cent and solve for the discountrate that discounts this future value back to the present value of\$10,000. Please explain the process and the results

Don't use plagiarized sources. Get Your Custom Essay on
Explain the process and the results.
Just from \$13/Page
Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Total price:
\$0.00

How it works?