Compute the Future Value of the cash flows.

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