In: Finance
KFA is considering investing in a new drone technology costing $12 million. It has a 5 year life (no salvage value) and will save KFA $3.5 million/year in pre-tax operating costs. It will need an up-front working capital investment of $300,000. KFA's cost of capital is 8.0% and its tax rate is 21.0%. Their current technology has a $5 million book value but a $1 million salvage value. What are the NPV and IRR of the decision to replace the old technology?
Output: | Year | |||||
Start | 1 | 2 | 3 | 4 | 5 | |
Cost | ||||||
Operating: | ||||||
Cost savings | ||||||
Book loss: sale of old tech | ||||||
Total operating | ||||||
After-tax operating | ||||||
Working capital | ||||||
Cash flow | ||||||
NPV | ||||||
IRR |
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -