In: Accounting
Average Rate of Return, Cash Payback Period, Net Present Value Method for a Service Company
Spanish Peaks Railroad Inc. is considering acquiring equipment at a cost of $108,000. The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $54,000. The company's minimum desired rate of return for net present value analysis is 12%.
| 
 Present Value of an Annuity of $1 at Compound Interest  | 
|||||
| 
 Year  | 
 6%  | 
 10%  | 
 12%  | 
 15%  | 
 20%  | 
| 
 1  | 
 0.943  | 
 0.909  | 
 0.893  | 
 0.870  | 
 0.833  | 
| 
 2  | 
 1.833  | 
 1.736  | 
 1.690  | 
 1.626  | 
 1.528  | 
| 
 3  | 
 2.673  | 
 2.487  | 
 2.402  | 
 2.283  | 
 2.106  | 
| 
 4  | 
 3.465  | 
 3.170  | 
 3.037  | 
 2.855  | 
 2.589  | 
| 
 5  | 
 4.212  | 
 3.791  | 
 3.605  | 
 3.353  | 
 2.991  | 
| 
 6  | 
 4.917  | 
 4.355  | 
 4.111  | 
 3.785  | 
 3.326  | 
| 
 7  | 
 5.582  | 
 4.868  | 
 4.564  | 
 4.160  | 
 3.605  | 
| 
 8  | 
 6.210  | 
 5.335  | 
 4.968  | 
 4.487  | 
 3.837  | 
| 
 9  | 
 6.802  | 
 5.759  | 
 5.328  | 
 4.772  | 
 4.031  | 
| 
 10  | 
 7.360  | 
 6.145  | 
 5.650  | 
 5.019  | 
 4.192  | 
Compute the following:
a. The average rate of return, giving effect to
straight-line depreciation on the investment. If required, round
your answer to one decimal place.
%
b. The cash payback period.
2 years  
c. The net present value. Use the above table of the present value of an annuity of $1. Round to the nearest dollar. If required, use a minus sign to indicate negative net present value for current grading purpose.
| 
 Present value of annual net cash flows  | 
 $  | 
| 
 Amount to be invested  | 
 $  | 
| 
 Net present value  | 
 $  | 
Answer :-
a)Average rate of return = [(Annual cash inflows - Annual Depreciation) / Average investment] × 100
Annual cash inflows = $54,000
Annual Depreciation = (Cost of Equipment - Residual value) / Useful life of Asset
Annual Depreciation = ( $108,000 - $0) / 10 years
Annual Depreciation = $10,800
Average Investment = (Cost of Equipment - Residual value) / 2
Average Investment = ($108,000 - $0) / 2
Average Investment = $54,000
Average Rate of Return = [ ($54,000 - $10,800) / $54,000] × 100
Average Rate of Return = 80%
b) Cash payback period = Initial investment / Annual cash inflows
Initial Investment = $108,000
Annual cash inflows = $54,000
Cash payback period = $108,000 / $54,000
Cash payback period = 2 years
c)The net present value are as follows :-
| Particular | Amount | 
| Present value of Annual cash flows (Note 1) | $305,100 | 
| 
 Amount to be invested (Initial Investment)  | 
($108,000) | 
| Net present value | 
 $197,100  | 
Note 1 :-
Present value of Annual cash inflow = Annual cash inflows × Present value of an annuity ( i = 12% , n = 10 years)
Annual Cash inflows = $54,000
Present value of an annuity (i = 12% , n = 10 years) = 5.650
Present value of Annual cash inflows = $54,000 × 5.650
Present value of Annual cash inflows = $305,100