Please using Excel to solve this question.

You are looking to purchase a $1,500,000 building with a 75% LTV loan (30 years, monthly payments, 5% rate). You are planning on selling the building after 3 years and believe that it will increase in value by $100,000 over that horizon. The NOI forecast is shown below. What is the pre-tax IRR associated with the equity investment? Year 1 Year 2 NOI $100,000 $110,000 Year 3 $115,000