Question

Home & More is considering a project with cash flows of -$375,000, $133,500, -$35,600, $244,700, and...

Home & More is considering a project with cash flows of -$375,000, $133,500, -$35,600, $244,700, and $271,000 for years 0 to 4. Should this project be accepted based on the combination approach to the modified internal rate of return if both the discount rate and the reinvestment rate are 16 percent? Why or why not?

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

The formulas and the inputs used in MS-EXCEL is as follows:
Cash flows 1 Year -375000 133500 35600 244700 271000 7 Discount rate 0.16 Modified internal MIRR(B2:B6,B7,B7) 8 rate of retur

The result is as follows:

1 Year Cash flows -$375,000 $133,500 -$35,600 0 4 $244,700 $271,000 4 6 7 Discount rate 16.00% Modified internal rate 8 of re

The MIRR is 17.42%, which is higher than the discount rate of 16%.

Conclusion: As the MIRR is higher than the discount rate, the project should be accepted.

Add a comment
Know the answer?
Add Answer to:
Home & More is considering a project with cash flows of -$375,000, $133,500, -$35,600, $244,700, and...
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
  • A project has projected cash flows of -$112,365, $32,800, $52,400, -$112,000 and $171,500 for years 0...

    A project has projected cash flows of -$112,365, $32,800, $52,400, -$112,000 and $171,500 for years 0 to 4, respectively. Should this project be accepted based on the combination approach to the modified internal rate of return if both the discount rate and the reinvestment rate are 11.8 percent? Group of answer choices No; The MIRR is 8.02 percent. No; The MIRR is 10.09 percent. Yes; The MIRR is 12 percent. Yes; The MIRR is 11.80 percent. Yes; The MIRR is...

  • Blue Water Systems is analyzing a project with the following cash flows. Should this project be...

    Blue Water Systems is analyzing a project with the following cash flows. Should this project be accepted based on the modified internal rate of return if the discount rate is 12 percent? Why or why not? Year   Cash flow 1    -260,000 2 85,000 3 128,600 4    96,780

  • Crystal industries is considering an expansion project with cash flows of -$287,500, $107,500, $196,100, $104,500, and...

    Crystal industries is considering an expansion project with cash flows of -$287,500, $107,500, $196,100, $104,500, and -$92,700 for Years 0 through 4. should the firm proceed with expansion based on the discountkng approach to the modified internal rate of return if the discoint rate is 13.4 percent?

  • 1. Allen Inc., is considering a project with the following cash flows.   Year Cash Flows 0...

    1. Allen Inc., is considering a project with the following cash flows.   Year Cash Flows 0 -$32,374 1 $6,334 2 $13,790 3 $12,995 4 $20,673 5 $29,260 The company uses a discount rate of 7 percent on all of its projects. Calculate the profitability index of the project? 2. Elway Corp. is considering a project with the following cash flows.   Year Cash Flows 0 -$45,331 1 $15,903 2 $24,490 3 $34,625 4 -$11,486 5 $40,937 The company uses a discount...

  • Question 10 7.5 pts You are considering a project with conventional cash flows. The IRR is...

    Question 10 7.5 pts You are considering a project with conventional cash flows. The IRR is 15.7 percent, NPV is -$198, and the payback period is 3.92 years. Which one of the following statements is correct given this information? This project should be accepted based on the internal rate of return. The discount rate used in computing the net present value was less than 15.7 percent. The required rate of return must be greater than 15.7 percent. The discounted payback...

  • Bogart Reclamation is considering a project that has project cash flows of $-48,000, $48,000, $48,000, and...

    Bogart Reclamation is considering a project that has project cash flows of $-48,000, $48,000, $48,000, and $ 48,000. If the required return is 9.5%, what is the project MIRR using the Discount Approach? What is the MIRR using the Reinvestment Approach? Discount MIRR 8.8%. Reinvestment MIRR 8.9% Discount MIRR 996: Reinvestment MIRR 996 Discount MIRR 10.05%; Reinvestment MIRR 11.2196 The IRR cannot be calculated Discount MIRR 8.89%; Reinvestment MIRR 8.97%

  • 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

  • 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...

  • Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow $29,500 11,700...

    Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow $29,500 11,700 14,400 16,300 13,400 6.66 2 points 4 9,900 eBook Print References The company uses a discount rate of 13 percent and a reinvestment rate of 6 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate...

  • You are considering an investment project with the cash flows of -400 (the initial cash flow),...

    You are considering an investment project with the cash flows of -400 (the initial cash flow), 700 (cash flow at year 1), -200 (cash flow at year 2). Given the discount rate of 12%, compute the Modified Internal Rate of Return (MIRR) using the discountingapproach. 31.91% 25.13% 27.55% 29.71%

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