Please show excel sheets and show all work. Answers provided

An investment of $600,000 is made in equipment that qualifies as 3-year equipment for MACRS-GDS depreciation. The before-tax cash flows, measured in constant dollars, for the investment consist of a uniform annual series of $200,000 plus a $200,000 salvage value at the end of the 5-year planning horizon. A 40% tax rate and 3% inflation rate apply. The real ATMARR is 10%.

a.Determine the after-tax cash flows, in constant dollars, for each year.

b.Determine the present worth for the investment.

c.Determine the real internal rate of return for the investment.