Question

An airline is considering a project of replacement and upgrading of machinery that would improve efficiency. The new machinery costs $350 today and is expected to last for 5 years with no salvage value. Straight line depreciation will be used. Project inflows connected with the new machinery will begin in one year and are expected to be $300 each year for 5 years and project outflows will also begin in one year and are expected to be $135 each year for 5 years. The corporate tax rate is 36% and the required rate of return is 8%. Calculate the project's net present value.

Answer 1

Answer:

$172.25

Explanation:

initial outlay for the project = -$350

cash flow years 1-5 = [($300 - $135 - $70) x (1 - 36%)] + $70 (depreciation expense) = $60.80 + $70 = $130.80

using an excel spreadsheet and the NPV function, we can calculate the project's NPV with an 8% discount rate:

=NPV(8%,130.80,130.80,130.80,130.80,130.80) - $350 = $522.25 - $350 = $172.25

we can also do it manually:

NPV = -$350 + $130.80/1.08 + $130.80/1.08² + $130.80/1.08³ + $130.80/1.08⁴ + $130.80/1.08⁵ = $172.25