Instructions:

You are required to use a financial calculator or spreadsheet (Excel) to solve 10 different parts of a single problem (provided on page 4) related to capital budgeting. You are required to show the following two steps for the problem (a sample problem and solution is provided for guidance).

(i) Develop a timeline (linear representation of the timing of cash flows).

(ii) Calculate the correct solutions to the problem components.

Homework Problem

1) Kingston Corporation is considering a new machine that requires an initial investment of $550,000, including installation costs, and has a useful life of eight years. The expected annual after-tax cash flows for the machine are $89,000 during the first three years, $95,000 during years for through six, and $105,000 during the last two years.

(a) Calculate the internal rate of returnIRR (round your answer to two decimal places).

(b) Calculate the net present valueNPVat the following required rates of return (round your answers to two decimal places):

(1) 3% (2) 4% (3) 8% (4) 9%

(c) Using the IRR and NPV criterion, comment if the projects should be accepted or rejected at the following required rates of return:

(1) 3% (2) 4% (3) 8% (4) 9%

(d) Plot the NPV profile (NPV on the Y-axis and the required rates of return on the X-axis).