show full calculations in excel

Question 27 (2.5 points) Given the following information regarding an income producing property, determine the internal rate of return (IRR) using after tax cash flows. Expected Holding Period: 5 years; Years 1-5 the Expected ATCF: $90,000; Current Market Value: $897,000; Required equity investment: $250,000; Gross Sales Price at end of year 5: $950,000 with Closing Expenses of $12,000 and Disposition Fee (Brokerage Commission) of 3% of Gross Sales Price.; Remaining Mortgage Balance at end of year 5: $425,000. Taxes due on sale is $55,000. Levered discount rate is 15%. Investor's ordinary tax rate is 35%. 46% 44% 42% O 45%