Question

Project A costs $3,000, and its cash flows are the same in Years 1 through 10....

Project A costs $3,000, and its cash flows are the same in Years 1 through 10. Its IRR is 13%, and its WACC is 11%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. %

1 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

Project A costs = $3,000

Its IRR is = 13%

Its cash flows are the same in Years 1 through 10

Since at IRR, NPV = 0, Hence PV of cash flows = Project cost = $3,000

To get annual cash flows we will use PMT function of excel:

PMT (rate, nper, pv, fv, type)

= PMT (13%, 10, -3000, 0, 0)

= $552.87

As such annual cash flows = $552.87

MIRR is calculated as below:

0 2 3 4 5 6 7 9 100 cost($3,000) $552.87 $552.87 $552.87 $552.87 $552.87 $552.87 $552.87 $552.87 $552.87 $552.87 53,000 5287 $5287 552.87 552.87 553287 $5287 $32.87 552.87 53287 553287 Cash flows IRR MIRR 13% 11.91%Using excel formula of MIRR, we get:

MIRR = 11.91%

Add a comment
Know the answer?
Add Answer to:
Project A costs $3,000, and its cash flows are the same in Years 1 through 10....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT