Question

Calculate the MIRR for a project where the WACC is 7%: Invest: $96 today plus $27...

Calculate the MIRR for a project where the WACC is 7%: Invest: $96 today plus $27 at the end of year 2. Returns: $32, $36, $40, and $45 to be received at the end of years 1, 2, 3, and 4

Please show all calculations no excel

Homework Answers

Answer #1

r = WACC = 7%

n = 4 years

Present Value of Cash Outflows = [$96 /(1+7%)^0] + [$27 / (1+7%)^2]

= $96 + ($27 / 1.1449)

= $96 + $23.5828457

= $119.582846

Future Value of Cash Inflows = [$32 / (1+7%)^1] + [$36 / (1+7%)^2] + [$40 / (1+7%)^3] + [$45 / (1+7%)^4]

= [$32 / 1.07] + [$36 / 1.1449] + [$40 / 1.225043] + [$45 / 1.31079601]

= $29.9065421 + $31.4437942 + $32.6519151 + $34.3302845

= $128.332536

MIRR = nth root of [(Future value of +ve cash flows / Present value of -ve cash flows)] - 1

= 4th root of [$128.332536 / $119.582846] - 1

= 4th root of (1.07316844) - 1

= 1.01781061 - 1

= 0.01781061

Therefore, MIRR of the Project is 1.78%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
There are two projects that the company is considering: Project A costs -10,000 to implement today,...
There are two projects that the company is considering: Project A costs -10,000 to implement today, and it brings subsequent cash flows of 5,000 at the end of year 1; 1,500 at the end of year 2; 2,100 at the end of year 3; and 3,400 at the end of year 4. Project B's initial cost is -10,000, and subsequent cash flows are 2,500 per year for five (5) years. WACC is 6% for both projects. a. Calculate NPV and...
There are 2 projects that the company is considering: Project A costs 10,000 to implement today,...
There are 2 projects that the company is considering: Project A costs 10,000 to implement today, and it brings subsequent cash flows of 5,000 at the end of year 1; 4,000 at the end of year 2; 6,000 at the end of year 3 Project B’s initial cost is 12,000, and subsequent cash flows are 6,000 per year for 3 years. WACC is 8% for both projects. a. calculate NPV and IRR for each project and decide which one to...
A project requires a start up cost of $105000 today and 10 annual cost of $3500...
A project requires a start up cost of $105000 today and 10 annual cost of $3500 starting in one year. Starting at the end of the 11th year, the project returns 20 annual payments of $X. Determine X so that the project yields an annual effective rate of 6% over the 30 years. PLEASE show by hand and NOT excel!!!
The cash flows for a project are: $100 today, $100 in 1 year, $100 in 2...
The cash flows for a project are: $100 today, $100 in 1 year, $100 in 2 years, and -$400 in 3 years. (7 points) a. Calculate the IRR for the project. b. If the cost of capital is 10%, will you accept this project? Explain concisely. Please show all work
An investor has $25,000 that he can invest today. In addition to this amount, he can...
An investor has $25,000 that he can invest today. In addition to this amount, he can also invest $12,000 per year for 30 years (beginning one year from now) at which time he will retire. He plans on living for 25 years after he retires. If interest rates are 8 percent, what size annual annuity payment can he obtain for his retirement years? (All annuity payments are at year-end. Round your answer to the nearest dollar.) PLEASE show in excel
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $134 $134 $134 $134 $134 $134 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
A rm is considering an investment project with the following information: Initial capital expenditure $36 million...
A rm is considering an investment project with the following information: Initial capital expenditure $36 million Annual sales (in units) 2 million units Selling price per unit $20 Cost per unit $10 Project life 3 years Depreciation Straight line, over the life of the project Working capital Initially (Year 0) the project requires an increase in net working capital of $6 million, but it will be recovered after the project's life (Year 3). Tax rate 20% WACC 15% (a) What...
The YayForWinterBreak Company wants to calculate the NPV and IRR on the following project: Cost is...
The YayForWinterBreak Company wants to calculate the NPV and IRR on the following project: Cost is $22,000 today, with end-of-year cash flows of $10,000, $10,000, and $6,500, Years 1 through 3 respectively for three years. Assume the cost of capital is 8%. SHOW ALL WORK on the TI BAII Plus Calculator FOR FULL CREDIT. a) (8 pts) NPV? b) (5 pts) IRR? c) (2 pts) Do you accept or reject the project, and why?
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $135 $135 $135 $135 $135 $135 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...
A company has an 11% WACC and is considering two mutually exclusive investments (that cannot be...
A company has an 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $133 $133 $133 $133 $133 $133 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...