In: Accounting
Problem 2 (Ignore taxes for this problem)
Bullock Prosthetics is planning to buy 3-D printing machinery costing $380,000. This machinery’s expected useful life is 5 years. They require a minimum rate of return of 8%, and have calculated the following data pertaining to the purchase and operation of this machinery:
| 
 Year  | 
 Estimated Annual Cash Inflows  | 
 Estimated Annual Cash Outflows  | 
 Depreciation  | 
| 
 1  | 
 $ 90,000  | 
 $15,000  | 
 $60,000  | 
| 
 2  | 
 $150,000  | 
 $45,000  | 
 $60,000  | 
| 
 3  | 
 $230,000  | 
 $95,000  | 
 $60,000  | 
| 
 4  | 
 $270,000  | 
 $110,000  | 
 $60,000  | 
| 
 5  | 
 $300,000  | 
 $125,000  | 
 $60,000  | 
I have seen other examples of this question, but I still don't understand and truly want to comprehend. Id appreciate it if shown exactly how to resolve.
| SOLUTION: A | ||||||
| CACULATION OF PAYBACK PERIOD | ||||||
| Period | Particulars | Inflow (Outflow) | Cumulative Value | |||
| 0 | Outflow | $ -380,000 | $ -380,000 | |||
| 1 | Net Cash Inflow | $ 75,000 | $ -305,000 | |||
| 2 | Net Cash Inflow | $ 105,000 | $ -200,000 | |||
| 3 | Net Cash Inflow | $ 135,000 | $ -65,000 | |||
| 4 | Net Cash Inflow | $ 160,000 | $ 95,000 | |||
| 5 | Net Cash Inflow | $ 175,000 | $ 270,000 | |||
| Total | ||||||
| All the investment is recovered in the year 4 but not all the whole year is required for this | ||||||
| So the we have to calculate the fraction as below, | ||||||
| Payback Period = | 3 Years + | $ 65,000 | "/" By | $ 160,000 | ||
| Payback Period = | 3 Years + | 0.41 | ||||
| Payback Period = | 3.41 Years | |||||
| Answer =Pay back period = 3.41 Years | ||||||
| SOLUTION: B | ||||||
| Total Net Cash Inflow (Total of Yr 1 to Yr 5 of net cash inflow) | = | $ 650,000 | ||||
| Divide By | = | "/" By | ||||
| No. of Years | = | 5 | Years | |||
| Equals to | = | = | ||||
| Average Annual Net cash inflow | = | $ 130,000 | ||||
| CALCULATION OF ACCOUNTING RATE OF RETURN | ||||||
| Average Annual Net Cash inflow | "/" | Initital Investment | "=" | Accounting Rate of Return (ARR) | ||
| $ 130,000 | "/" | $ 380,000 | "=" | 34.21% | ||
| Answer = ARR = 34.21 % | ||||||
| SOLUTION: C | ||||||
| CACULATION OF NET PRESENT VALUE | ||||||
| Years | Inflow (Outflow) | PVF of $ 1 @ 8 % | Present Value | |||
| 0 | $ -380,000 | 1.00000 | $ -380,000 | |||
| 1 | $ 75,000 | 0.92593 | $ 69,444 | |||
| 2 | $ 105,000 | 0.85734 | $ 90,021 | |||
| 3 | $ 135,000 | 0.79383 | $ 107,167 | |||
| 4 | $ 160,000 | 0.73503 | $ 117,605 | |||
| 5 | $ 175,000 | 0.68058 | $ 119,102 | |||
| Total | $ 123,339 | |||||
| Answer = Net Present Value = $ 123,339 | ||||||