In: Finance
XYZ Company is considering purchasing a piece of equipment costing $400,000. It has a useful life of 4years and will be depreciated straight-line to zero, after which it will be scrapped for $30,000. This piece of equipment will save $150,000 per year in pretax operating costs during its useful life but requires an initial investment in NWC of $36,000. XYZ Company has a 21% tax rate and a required rate of return of 12%
What is the annual Operating Cash Flow (OCF) of this piece of equipment in Years 1-4?
What is the Year 4IATCF (Income After-Tax Cash Flow)?
What is the NPV of purchasing this piece of equipment?
Should XYZ Company take on this project?
What is the project's EAC?
As per rules I am answering the first 4 subparts of the question
1:
| The Annual operating cash flows are as below | ||||||
| OCF | SL | |||||
| Year | Cash flows | Depreciation | EBIT | Tax | PAT | OCF | 
| 1-4 | 150000 | 100000 | 50000 | 10500 | 39500 | 139500 | 
2: Year 4 ATCF =199200
3: NPV =
| $25,650.66 | 
4: Yes, since NPV is positive.
WORKINGS
| Salvage | |
| Purchase price | 400000 | 
| Less: Depreciation | 400000 | 
| Closing book value | 0 | 
| Selling price | 30000 | 
| Gain/(loss) | 30000 | 
| Tax/ Saving | 6300 | 
| Net salvage | 23700 | 
| Finally the Net cash flows | |||||
| Year | Initial cash flow | OCF | Working capital | Salvage | Net cash flows | 
| 0 | -400000 | -36000 | -436000 | ||
| 1 | $139,500.00 | 139500 | |||
| 2 | $139,500.00 | 139500 | |||
| 3 | $139,500.00 | 139500 | |||
| 4 | $139,500.00 | 36000 | 23700 | 199200 | |
| NPV | $25,650.66 | 
