7. Emilio Corporation has the following information about the purchase of a new piece of equipment: Cash revenues less cash expenses $300,000 per year Cost of equipment Salvage value at the end of the 10th year Increase in working capital requirements $1,100,000 $100,000 $140,000 Tax rate 30 percent 10 years Life The cost of capital is 15 percent. Required (use excel): a. Calculate the following assuming straight-line depreciation: i. Calculate the after-tax net income for each of the ten years. ii. Calculate the after-tax cash flows for each of the ten years. iii. Calculate the after-tax payback period. iv. Calculate the accrual accounting rate of return on original investment for each of the ten 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 $200,000, $180,000, $160,000, $140,000, $120,000, $100,000, $80,000, $60,000, $40,000 and $20,000 for years 1 through 10, respectively: i. Calculate the after-tax cash flows for each of the ten years. ii. Calculate the after-tax payback period. iii. Calculate the net present value (NPV). iv. Calculate the internal rate of return (IRR)