PLEASE USE EXCEL, WITH STEPS. THANK YOU

A firm has invested $400,000 in car-washing equipment. They will depreciate the equipment by 60% bonus depreciation with the balance using 5-year MACRS, assuming a $50,000 salvage value at the end of the 5-year useful life. The firm is expected to have a before-tax cash flow, after meeting all expenses of operation (except depreciation), of $165,000 per year. The firm's combined corporate tax rate is 28%. (a) If the projected income is correct, and the equipment can be sold for $100,000 at the end of 5 years, what after-tax rate of return would the corporation receive from this venture? 12-25 G