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 -
