This essаy questiоn is wоrth 40 pоints in totаl. In this question, we hаve a property, 331 79th St, Apt 31, North Bergen, NJ, 07047 for sale as shown in the attached MLS file 331 79th St, North Bergen.pdf. A couple is deciding to rent a similar property or purchase this property with 20% down payment and financed with a constant monthly payment fully amortizing mortgage loan at a fixed interest rate for 30 years. Other costs associated with owning include maintenance, insurances, Home Owner Association (HOA) fee, and property taxes. These expenses would not have to be paid if renting is chosen. All other expenses would have to be paid regardless of whether the property is owned or rented, such as utilities, and so on. Because they offset, they don’t have to be included in the analysis. Other assumptions include The couple is estimating the purchase price as the asking price of $329,000, Based on Zillow.com, the initial rent is $2259 per month, Growth rate in rents, and property value is 2% per year, Insurance for the first year is $1320, The maintenance cost is assumed to be $1200 for the first year. In addition, there is a Home Owner Association (HOA) fee $465 per month, Escalation in expenses at 3% per year for the coming 5 years, A marginal income tax rate of 30%, The property tax rate is calculated as $4152 over the sale price, A 1-5-year period of analysis, at the end of which, the property would be sold if owned. Selling expenses of 7% would have to be paid at that time, and The 30-year fixed mortgage rate is 6.34% per year quoted as an Annual Percentage Rate (APR) for the couple. a). Based on the information, what’s the internal rate of return for the couple if they purchase the house and sell it in 1, 2, 3, 4, and 5 years respectively? (3 points for each answer) b). What’s the dollar amount of Net Present Value (NPV) for the couple if they purchase the house and sell it in 1, 2, 3, 4, and 5 years respectively? (3 points for each answer) c). If the couple is planning to stay in the house for 3 years, should they purchase or rent the house? (5 points) d). If the couple is planning to stay in the house for 5 years, should they purchase or rent the house? (5 points) Extra point Question: If the couple wants to breakeven in buying the house and selling it in three years, what is the maximum offer price of the house? (one extra point) If you have used the Excel Template file (Template_Practice Midterm_Single Family Rent vs Own-1.xlsx), please rename your file as LastName_FirstName_Essay.xlsx and upload your finished Excel file at the end of the exam for this question using the "Insert" button at the top of this question. If you haven't used the Excel file, you can also type your answer for this question in the text field.