In: Accounting
Legend Service Center just purchased an automobile hoist for $31,200. The hoist has an 8-year life and an estimated salvage value of $3,330. Installation costs and freight charges were $3,830 and $890, respectively. Legend uses straight-line depreciation. The new hoist will be used to replace mufflers and tires on automobiles. Legend estimates that the new hoist will enable his mechanics to replace 6 extra mufflers per week. Each muffler sells for $72 installed.
The cost of a muffler is $38, and the labor cost to install a muffler is $14.
(a) Compute the cash payback period for the new hoist. (Round answer to 2 decimal places, e.g. 10.50.) Cash payback period Entry field with correct answer 5.76 years
(b) Compute the annual rate of return for the new hoist. (Round answer to 1 decimal place, e.g. 10.5.) Annual rate of return Entry field with incorrect answer 6 %
i have also tried 7.7, 17.4 and all are incorrect for B, can you explain in detail B I only have 1 more chance at getting it correct,
| Calculate cost of Automobile Hoist | |
| Initial Investment/ Cash Flow (Cf0) | |
| Amount $ | |
| Purchase value of automobile hoist | 31,200.00 | 
| Installation Costs | 3,830.00 | 
| Freight charges | 890.00 | 
| Total cost of Automobile Hoist(1+2+3) | 35,920.00 | 
| Incremental Cash flows from purchase of Automobile Hoist | |
| No. of Mufflers per week replaced | 6 | 
| Selling price of each muffler replace/installed | 72 | 
| Cost of each muffler | 38 | 
| Labor cost to install each Muffler | 14 | 
| Salvage value at the end of 8 years | 3,330 | 
| No. of weeks per year | 52 | 
| Depreciation ( Initial Cost - Salvage Value)/ Useful Life in years | 4,073.75 | 
| Step 3 | Map the Cash Flows | |||||||||
| Cf0 | Cf1 | Cf2 | Cf3 | Cf4 | Cf5 | Cf6 | Cf7 | Cf8 | ||
| 1 | Initial Investment | (35,920.00) | ||||||||
| 2 | Incremental Sales Income | 22,464.00 | 22,464.00 | 22,464.00 | 22,464.00 | 22,464.00 | 22,464.00 | 22,464.00 | 22,464.00 | |
| Less | ||||||||||
| 3 | Incremental cost of Mufflers | 11,856.00 | 11,856.00 | 11,856.00 | 11,856.00 | 11,856.00 | 11,856.00 | 11,856.00 | 11,856.00 | |
| 4 | Labor cost for installing Mufflers | 4,368.00 | 4,368.00 | 4,368.00 | 4,368.00 | 4,368.00 | 4,368.00 | 4,368.00 | 4,368.00 | |
| 5 | Depreciation | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | |
| 6 | Salvage Value | (3,330) | ||||||||
| 7 | Incremental Income (2-(3+4+5+6)) | 2,166.25 | 2,166.25 | 2,166.25 | 2,166.25 | 2,166.25 | 2,166.25 | 2,166.25 | 5,496.25 | |
| 8 | Add : Depreciation | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | 4,073.75 | |
| 9 | Cash Flow (7+8) | 6,240.00 | 6,240.00 | 6,240.00 | 6,240.00 | 6,240.00 | 6,240.00 | 6,240.00 | 9,570.00 | 
| Q (a). | Payback period | |
| Formula = Initial Cash Outflow / Annual Cash Outflow | 35920/6240 | |
| Answer | Payback period | 5.76 years | 
| Q (b) | Annual Rate of Return | |
| Step 4 | Compute total return | |
| Total Return = Total cash flows from 1 to 7+ (Cash Flow for year 8+ salvage value) | ||
| => | 6240*7 + (6240+3330) | |
| => | Cash flow * 8 ( Step 3 - Row 9 : Total Cash Flows year 1 to 8) | |
| => | 53,250.00 | |
| Step 5 | Use formula for Annual Rate of Return | |
| => | (Annual Net Income / Average Investment)*100 | |
| i | Annual Net Income | 2,166.25 | 
| ii | Average Investment (Initial Cost + Salvage Value)/2 | |
| => | (35920+3330) | 19,625 | 
| iii | Answer : Annual Rate of Return (i/ii)*100 | 11.04% |