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 $1,250,000. The equipment has an estimated life of eight years and no residual value. It is expected to provide yearly net cash flows of $312,500. 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.
c. The net present value. Use the above table of the present value of an annuity of $1. Round to the nearest dollar.
Present value of annual net cash flows $
Amount to be invested $
Net present value $

Respuesta :

Answer:

12.5%

4 years

NPV = $302,387

PV of cash flows = $1,552,387

Amount invested = $1,250,000

Explanation:

Average rate of return = net income / amount invested

Net income = cash flow - depreciation

Straight line depreciation expense = (Cost of asset - Salvage value) / useful life

1,250,000 / 8 = 156,250

Net income = $312,500 - 156,250 = $156250

(156250 / $1,250,000) x 100 = 12.50%

Payback calculates the amount of time it takes to recover the amount invested in a project from it cumulative cash flows

Payback period = Amount invested / cash flow

$1,250,000 / $312,500 = 4 years

Net present value is the present value of after-tax cash flows from an investment less the amount invested.  

NPV can be calculated using a financial calculator  

Cash flow in year 0 = $-1,250,000

Cash flow each year from year 1 to 8 = $312,500

I = 12%

NPV =  $302,387

To find the NPV using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.