Question

Doak Corp. is evaluating a project with the following cash flows. The company uses a discount...

Doak Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects.

Year Cash Flow
0 –$ 32,600  
1 11,520  
2 14,670  
3 11,270  
4 10,940  
5 4,230  

Calculate the MIRR of the project using all three methods with these interest rates. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

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

Using excel to calculate MIRR for all three approaches

A B
1 Year Cash Flow
2 0 -32600
3 1 11520
4 2 14670
5 3 11270
6 4 10940
7 5 -4230
Discount Rate 11%
Reinvestment rate 8%
MIRR using discounting approach 12.61%
Excel formula MIRR(B2:B7,11%,11%)
MIRR using reinvesting approach 13.83%
Excel formula MIRR(B2:B7,8%,8%)
MIRR using combination approach 10.98%
Excel formula MIRR(B2:B7,11%,8%)
Add a comment
Know the answer?
Add Answer to:
Doak Corp. is evaluating a project with the following cash flows. The company uses a discount...
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
  • Doak Corp. is evaluating a project with the following cash flows. The company uses a discount...

    Doak Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Year Nmto Cash Flow -$32,600 11,520 14,670 11,270 10,940 - 4,230 Calculate the MIRR of the project using all three methods with these interest rates. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach...

  • Doak Corp. is evaluating a project with the following cash flows. The company uses a discount...

    Doak Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Year Cash Flow 0 –$ 32,600   1 11,520   2 14,670   3 11,270   4 10,940   5 – 4,230   Calculate the MIRR of the project using all three methods with these interest rates. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places,...

  • Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$32,600 11,520...

    Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$32,600 11,520 14,670 11,270 10,940 - 4,230 The company uses an interest rate of 10 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach Combination approach

  • Doak Corp. is evaluating a project with the following cash flows. The company uses a discount...

    Doak Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 12 percent and a reinvestment rate of 9 percent on all of its projects. >WN- Cash Flow $16,600 7.700 8,900 8,500 7.300 4.700 Calculate the MIRR of the project using all three methods with these interest rates. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach Combination approach

  • Mittuch Corp. is evaluating a project with the following cash flows. The company uses a discount...

    Mittuch Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 10 percent and a reinvestment rate of 7 percent on all of its projects. Year Cash Flow 0 –$ 15,900 1 7,000 2 8,200 3 7,800 4 6,600 5 –4,000 Calculate the MIRR of the project using all three methods with these interest rates. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g.,...

  • Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$15,100 6,200...

    Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow -$15,100 6,200 7,400 7,000 5,800 -3,200 1 2 3 5 The company uses an interest rate of 11 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach Combination approach %

  • Chamberlain Corp. is evaluating a project with the following cash flows. The company uses a discount...

    Chamberlain Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Year Cash Flow 0 –$ 19,500 1 7,930 2 9,490 3 8,970 4 7,210 5 – 3,980 Required: Calculate the MIRR of the project using all three methods using these interest rates. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) MIRR   Discounting...

  • Can't figure out the combination approach Doak Corp. is evaluating a project with the following cash...

    Can't figure out the combination approach Doak Corp. is evaluating a project with the following cash flows: Year UWNO Cash Flow -$16,500 7,600 8,800 8,400 7,200 - 4,600 The company uses an interest rate of 10 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Discounting approach Reinvestment approach Combination approach 1 24.00% 17.10%...

  • CHAPTER 8 GRADED HOMEWORK Saved For the given cash flows, suppose the firm uses the NPV...

    CHAPTER 8 GRADED HOMEWORK Saved For the given cash flows, suppose the firm uses the NPV decision rule. 10 points Cash Flow -$ 157,300 74,000 87,000 46,000 ( 8 00:38:53 eBook a. At a required return of 9 percent, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. At a required return of 21 percent, what is the NPV of the project? (A negative answser should...

  • Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...

    Doak Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 16,100 1 7,200 2 8,400 3 8,000 4 6,800 5 – 4,200 The company uses an interest rate of 11 percent on all of its projects. Calculate the MIRR of the project using all three methods.

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