Question
Please help this is very important. Please do NOT use excel. Do NOT SHOW in excel. Please show ALL FORMULAS. Please show step by step
Please help this is very important. Please do NOT use excel. Do NOT SHOW in excel. Please show ALL FORMULAS. Please show step by step INCLUDING PART A B AND C. Please show and EXPLAIN WHY you choose a RATE OF RETURN PERCENTAGE. Please INCLUDE the DISCOUNT FORMULA for PART C. PLEASE keep the problem neat and organized. If you show by handwriting PLEASE KEEP IT neat and organized. THANK YOU.
Problem 9-12 NPV versus IRR [LO1, 5]
Garage, Inc., has identified the following two mutually exclusive projects: |
Year | Cash Flow (A) |
| Cash Flow (B) | ||||
0 | $ | 28,000 |
|
| $ | 28,000 |
|
1 |
| 13,400 |
|
|
| 3,800 |
|
2 |
| 11,300 |
|
|
| 9,300 |
|
3 |
| 8,700 |
|
|
| 14,200 |
|
4 |
| 4,600 |
|
|
| 15,800 |
|
a-1 | What is the IRR for each of these projects? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
| IRR |
Project A | % |
Project B | % |
a-2 | Using the IRR decision rule, which project should the company accept? |
|
|
| Project A Project B |
a-3 | Is this decision necessarily correct? |
|
|
| Yes No |
b-1 | If the required return is 10 percent, what is the NPV for each of these projects? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) |
| NPV |
Project A | $ |
Project B | $ |
b-2 | Which project will the company choose if it applies the NPV decision rule? |
|
|
| Project A Project B |
c. | At what discount rate would the company be indifferent between these two projects? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
Discount rate | % |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started