Question

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

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%

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, 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 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 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 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 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
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 $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 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 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:...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 1 minute ago

asked 8 minutes ago

asked 17 minutes ago

asked 28 minutes ago

asked 35 minutes ago

asked 35 minutes ago

asked 49 minutes ago

asked 53 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago