A project has an initial requirement of $310,000 for fixed assets and $62,000 for net working capital. The fixed assets will be depreciated to a zero book value over the 3-year life of the project and have an estimated salvage value of $155,000. All of the net working capital will be recouped at the end of the project. The annual operating cash flow is $345,000 and the discount rate is 18 percent. What is the project's net present value if the tax rate is 34 percent?
This solution is provided in an attached Excel spreadsheet and explains the computation of a project's net present value. By clicking directly onto the cells of the Excel file, the user can see what functions were employed to derive the computed values.