Compute the future value of the cash flows

Assignment Help Financial Management

Reference no: EM131962448

Given the following data, use Excel's syntax (and show the formulas) to calculate the MIRR for a project with an expected economic life six years and a salvage value of $1,000 (the last data entry). The end-of-period cash flows are expected to increase at 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 the cash flows at the rate of ten per cent and solve for the discount rate that discounts this future value back to the present value of $10,000.

Please explain the process and the results in a written PROFESSIONAL MANNER.

Reference no: EM131962448

Questions Cloud

What is the best estimate of stock current market value : The required return on this stock is 14%. What is the best estimate of the stock’s current market value?

What is the required rate of return on stock : What is the required rate of return on this stock? That is, solve for r.

The dividend is expected to grow at some constant rate : The dividend is expected to grow at some constant rate, g, forever. What is the growth rate (i.e. solve for g)?

What is the stock expected price three years from today : The required rate of return on the stock is 14.4%. What is the stock's expected price 3 years from today (i.e. solve for P3)?

Compute the future value of the cash flows : compute the Future Value of the cash flows at rate of ten per cent and solve for discount rate that discounts future value back to value of $10,000.

Lenders take all the interest rate risk : Which of the following is the same synthetic position as short stock, long call? For CAM loans, lenders take all the interest rate risk.

What is beas unlevered beta : What is BEA's unlevered beta? Use market value D/S (which is the same as wd/ws) when unlevering. What are BEA’s WACC and total value of the firm with 45% debt?

What quarterly payment will the friend make on the loan : The deal calls for a 6.92% APR “loan” rate with quarterly compounding. What quarterly payment will the friend make on the loan?

User Account

All Pages