Calculate mirr for project with expected economic life

Assignment Help Financial Management

Reference no: EM131962588

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: EM131962588

Questions Cloud

The cash prices of six-month and one-year treasury bills : The cash prices of six-month and one-year Treasury bills are 94.0 and 89.0. Calculate the six-month, one-year, 1.5-year, and two-year zero rates.

What is the annual earnings growth rate for apple : Apple’s ROE is 39.67%, and its payout ratio is 28.88%. Based on this information, what is the annual earnings growth rate for Apple?

The fixed-floating rate swap : which counterparty would benefit from having entered into the fixed-floating rate swap?

What was your rate of return in percent : Suppose that you buy 100 shares of stock at $57 per share. what was your rate of return in percent?

Calculate mirr for project with expected economic life : Use Excel's syntax (and show the formulas) to calculate the MIRR for a project with an expected economic life six years

About to pay annual dividend : Popovich Corp. is just about to pay an annual dividend of $2.45 per share. What is the price of the stock today?

What is the price of one share of utah mining stock : An investor is considering the purchase of a share of the Utah Mining Company. what is the price of one share of Utah Mining Stock?

What is apple return on equity : What is Apple’s return on equity (ROE)?

Challenges associated with value judgments : What are some of the implications and challenges associated with value judgments?

User Account

All Pages