Investment required in equipment - $630,000

Working capital requirement - $40,000

Net annual operating cash inflow - $300,000

One-time renovation expense in year 2. $80,000

The expected life of the project and the equipment is 3 years and the equipment has zero salvage value. The working capital would be required immediately and would be released for use elsewhere at the end of the project. The company uses straight-line depreciation on all equipment and the depreciation expense on the equipment would be $210,000 per year. Assume cash flows occur at the end of the year except for the initial investments. The company takes income taxes into account in its capital budgeting. The income tax rate is 35%. The after-tax discount rate is 15%. The net annual operating cash inflow is the difference between the incremental sales revenue and incremental cash operating expenses.

Required: Determine the net present value of the project. Prepare an excel worksheet and paste it into the problem as your answer.

Motn Corporation has provided the following information concerning a capital budgeting project The expected life of the project end the equipment a 3 years and the equipment has zero salvage value. The working capital would be required immediately and would br released for use elsewhere at the end of the project. The company uses straight-line depreciation or all equipment end the depreciation expense on the equipment would be $210,000 per year. Assume cash flows occur at the end of the year except for the initial investments. The company takes income taxes into account in it capital budgeting. The income tax rate is 35%. The after-tax discount rate is 15%. The net annual operating cash inflow is the difference between the incremental sales revenue and incremental cash operating expenses. Required. Determine the net present value of the project. Prepare an excel worksheet and paste it into the problem as your