7. Gabe Corporation has the following information about the purchase of a new piece of equipment: Cash revenues less cash expenses $50,000 per year Cost of equipment Salvage value at the end of the 7th year Increase in working capital requirements $100,000 $16,000 $40,000 Tax rate Life 35 percent 7 years The cost of capital is 12 percent. Required (use excel): a. Calculate the following assuming straight-line depreciation: i. Calculate the after-tax net income for each of the seven years. ii. Calculate the after-tax cash flows for each of the seven years. iii. Calculate the after-tax payback period. iv. Calculate the accrual accounting rate of return on original investment for each of the seven years. V. Calculate the net present value (NPV). vi. Calculate the internal rate of return (IRR). b. Calculate the following assuming that depreciation expense is $21,000, $18,000, $15,000, $12,000, $9,000, $6,000 and $3,000 for years 1 through 7, respectively: i. Calculate the after-tax cash flows for each of the seven years. ii. Calculate the after-tax payback period. iii. Calculate the net present value (NPV). iv. Calculate the internal rate of return (IRR)