In: Accounting
Given the following information, calculate the Payback for a capital budget proposal. Show your work. Machine Cost: $6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual savings: $560,000 Annual labor savings: $25,000 Expected useful life in years: 12 Overhaul costs in year 4: $50,000 Annual operating costs: $25,000 Hurdle rate: 8%
Initial Investment | ||
Machine Cost | $6,000,000.00 | |
Setup Cost | $45,000.00 | |
Training Cost | $25,000.00 | |
Initial Investment | $6,070,000.00 | |
Anticipated annual savings | $560,000.00 | |
Annual labor savings | $25,000.00 | |
Less: | ||
Annual maintenance costs | -$45,000.00 | |
Annual operating costs | -$25,000.00 | |
Net Annual Savings | $515,000.00 | |
Year 4 Cash flow = $515000 - 50000 = $465000 | ||
Year 12 Cash flow = $515000 + 50000 = $565000 | ||
Year | Cash Flow | Cumulative Cash Flow |
0 | -$6,070,000.00 | -$6,070,000.00 |
1 | $515,000.00 | -$5,555,000.00 |
2 | $515,000.00 | -$5,040,000.00 |
3 | $515,000.00 | -$4,525,000.00 |
4 | $465,000.00 | -$4,060,000.00 |
5 | $515,000.00 | -$3,545,000.00 |
6 | $515,000.00 | -$3,030,000.00 |
7 | $515,000.00 | -$2,515,000.00 |
8 | $515,000.00 | -$2,000,000.00 |
9 | $515,000.00 | -$1,485,000.00 |
10 | $515,000.00 | -$970,000.00 |
11 | $515,000.00 | -$455,000.00 |
12 | $565,000.00 | |
Payback = 11 years + $455000/565000 | 11.81 | Years |