Prepare an excel worksheet...

Mota Corporation has provided the following information concerning a capital budgeting project: 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.

Mota Corporation has provided the following information concerning a capital budgeting project: $630,000 Investment required in equipment Working capital requirement $40,000 $300,000 Net annual operating cash inflow $80,000 One-time renovation expense in year 2 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