In: Accounting
National Rodeo Association, a not-for-profit organization, is considering purchasing a new enterprise software system for $75,000. This investment is projected to have an seven-year useful life, and a salvage value of $10,000; the investment is projected to save the organization approximately $14,000 each year in operating costs. In addition to the cost of the software system, the association needs an increase of $6,000 in net working capital (other than cash) in the first year, which will not be released (that is, converted back to cash) until the end of seven years.
Required:
1. What is the payback period for this proposed investment? (Assume that the cash flows, other than salvage value, occur evenly throughout the year. Round your answer to 2 decimal places, e.g., 2.452 years = 2.45 years.)
2. If the Association has a required rate of return of 9 percent, what is the net present value (NPV) of the proposed investment? Round your calculation to whole dollars (i.e., zero decimal points).
1) | ||||
Initial Investment | ||||
Cost of new software | $ 75,000 | |||
Working Capital | $ 6,000 | |||
Total | $ 81,000 | |||
Annual cash inflow | $ 14,000.00 | |||
Payback period = Initial Investment / annual cash inflow | ||||
=$81000/14000 | ||||
=5.79 years | ||||
2) | Calculation Of NPV | |||
a | Annual net cash inflow | $ 14,000 | ||
b | PV Annuity Factor (9%,7 years) | 5.0330 | ||
c | PV of annual cash flow (a*b) | $ 70,461.34 | ||
d | Release Of Working Capital | $ 6,000.00 | ||
e | PV Factor for 7th year | 0.5470 | ||
f | PV of working capital | $ 3,282.21 | ||
g | Salvage Value | $ 10,000 | ||
h | PV Factor for 7th year | 0.54703 | ||
i | PV of Salvage Value (g*h) | $ 5,470.34 | ||
j | Initial Investment | $ 81,000 | ||
k | NPV (c+i+f-j) | $ -1,786 |