In: Accounting
Consider the following cash flows of two mutually exclusive projects for A–Z Motorcars. Assume the discount rate for both projects is 8 percent.
| Year | 
AZM Mini-SUV  | 
AZF Full-SUV  | 
||||
| 0 | –$ | 530,000 | –$ | 880,000 | ||
| 1 | 336,000 | 366,000 | ||||
| 2 | 212,000 | 452,000 | ||||
| 3 | 166,000 | 306,000 | ||||
a. What is the payback period for each project?
(Do not round intermediate calculations and round your
answers to 2 decimal places, e.g., 32.16.)
| Payback period | |
| AZM Mini-SUV | years | 
| AZF Full-SUV | years | 
b. What is the NPV for each project? (Do
not round intermediate calculations and round your answers to 2
decimal places, e.g., 32.16.)
| NPV | |
| AZM Mini-SUV | $ | 
| AZF Full-SUV | $ | 
c. What is the IRR for each project? (Do
not round intermediate calculations. Enter your answers as a
percent rounded to 2 decimal places, e.g.,
32.16.)
| IRR | |
| AZM Mini-SUV | % | 
| AZF Full-SUV | % | 
(a)- Payback period for each project
Payback Period - AZM Mini-SUV
| 
 Year  | 
 Cash Flows  | 
 Cumulative net Cash flow  | 
| 
 0  | 
 -5,30,000  | 
 -5,30,000  | 
| 
 1  | 
 3,36,000  | 
 -1,94,000  | 
| 
 2  | 
 2,12,000  | 
 18,000  | 
| 
 3  | 
 1,66,000  | 
 1,84,000  | 
Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)
= 1 Year + ($194,000 / 212,000)
= 1 Year + 0.92 years
= 1.92 Years
Payback Period - AZF Full-SUV
| 
 Year  | 
 Cash Flows  | 
 Cumulative net Cash flow  | 
| 
 0  | 
 -8,80,000  | 
 -8,80,000  | 
| 
 1  | 
 3,66,000  | 
 -5,14,000  | 
| 
 2  | 
 4,52,000  | 
 -62,000  | 
| 
 3  | 
 3,06,000  | 
 2,44,000  | 
Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)
= 2 Year + ($62,000 / 306,000)
= 2 Year + 0.20 years
= 2.20 Years
Payback Period - AZM Mini-SUV = 1.92 years
Payback Period - AZF Full-SUV = 2.20 Years
(b)- NPV for each project
NPV - AZM Mini-SUV
| 
 Year  | 
 Annual Cash Inflow  | 
 Present Value factor at 8%  | 
 Present Value of Cash Flow  | 
| 
 1  | 
 3,36,000  | 
 0.9259  | 
 3,11,111.11  | 
| 
 2  | 
 2,12,000  | 
 0.8573  | 
 1,81,755.83  | 
| 
 3  | 
 1,66,000  | 
 0.7938  | 
 1,31,776.15  | 
| 
 TOTAL  | 
 $ 6,24,643.09  | 
||
Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment
= $ 6,24,643.09 – 530,000
= $ 94,643.09
NPV - AZF Full-SUV
| 
 Year  | 
 Annual Cash Inflow  | 
 Present Value factor at 8%  | 
 Present Value of Cash Flow  | 
| 
 1  | 
 3,66,000  | 
 0.9259  | 
 3,38,888.89  | 
| 
 2  | 
 4,52,000  | 
 0.8573  | 
 3,87,517.15  | 
| 
 3  | 
 3,06,000  | 
 0.7938  | 
 2,42,912.67  | 
| 
 TOTAL  | 
 $ 9,69,318.70  | 
||
Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment
= $ 9,69,318.70 – 880,000
= $ 89,318.70
NPV - AZM Mini-SUV = $ 94,643.09
NPV - AZF Full-SUV = $ 89,318.70
(c)- IRR for each project
IRR for AZM Mini-SUV = 19.08%
IRR for AZF Full-SUV = 13.69%