Hi, I need some help with this, please. Thanks!

Wisconsin Corporation has the following information pertaining to the purchase of a new piece of equipment: Cash revenues less cash expenses: $55,000 per year

Cost of equipment: $150,000 Salvage value at the end of the 9th year: $15,000 Increase in working capital requirements: $45,000

Tax rate: 40 % Life: 9 years

Cost of capital is 14 percent.

Required (use excel):

a. Calculate the following assuming straight-line depreciation:

1. Calculate the after-tax net income for each of the nine years.

2. Calculate the after-tax cash flows for each of the nine years.

3. Calculate the after-tax payback period.

4. Calculate the accrual accounting rate ofreturn on original investment for each of the nine years.

5. Calculate the net present value (NPV).

6. Calculate the internal rate of return (IRR).

b. Calculate the following assuming that depreciation expense is $27,000, $24,000, $21,000, $18,000, $15,000, $12,000, $9,000, $6,000 and $3,000 for years 1 through 9, respectively:

1. Calculate the after-tax cash flows for each of the nine years.

2. Calculate the after-tax payback period.

3. Calculate the net present value (NPV).

4. Calculate the internal rate of return (IRR).