Glenn Apartments can be purchased for $650,000 with initial annual NOI of $ 60,900 that is projected to grow 2.25% annually. Evaluation of the project must be completed using a discount rate of 10%. The loan used in the purchase shall be at 75% LTV, a 5.50% APR and a 15 year term. Closing costs shall be 4.0% and cost of sale 7.0%. Project the cash flows for a 5 year hold and determine the NPV, IRR and first year ROI of the project.

please show work in excel by each step