In: Finance
Walker & Campsey wants to invest in a new computer system, and management has narrowed the choice to Systems A and B. System A requires an up-front cost of $125,000, after which it generates positive after-tax cash flows of $80,000 at the end of each of the next 2 years. The system could be replaced every 2 years, and the cash inflows and outflows would remain the same. System B also requires an up-front cost of $125,000, after which it would generate positive after-tax cash flows of $60,000 at the end of each of the next 3 years. System B can be replaced every 3 years, but each time the system is replaced, both the cash outflows and cash inflows would increase by 5%. The company needs a computer system for 6 years, after which the current owners plan to retire and liquidate the firm. The company's cost of capital is 12%. What is the NPV (on a 6-year extended basis) of the system that adds the most value? Enter your answer rounded to two decimal places. Do not enter $ or comma in the answer box. For example, if your answer is $12,300.456 then enter as 12300.46 in the answer box.
The NPV (on a 6-year extended basis) of the system that adds the
most value = NPV of system B = $ 33,392.01
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.
Please note that all inflows and outflows go up by 5% as soon as replacement takes place at the end of year 3 in case of system B.