You are an investor looking to acquire a 150 unit apartment in Gainesville, FL. It is a Class B property with no major damages. You can purchase the property for $10,750,000 today and you charge $850 a month for each unit on a 12 month lease. You also believe that your rent will grow at a constant yearly rate of 1.5% and project that you will have vacancy and collection losses of 5% annually since you account for some tenants not paying their rent on time even though you have 100% occupancy. You assume 60% of your tenants will need parking so you charge $75 a month for their parking spot. Every year maintenance and utilities will cost you $250,000 and it will grow at 25% yearly You think that based on your market projections, you can sell your property in 5 years for $11,250,000 and you expect there to be selling expenses of 6% You will not invest in this property unless you can realize an unlevered before tax return of 10%, a 14% levered return before taxes, and a 9.8% levered return after taxes on the property Furthermore, you successfully acquired the property with 60% financed by ABC Bank with a 15-year fixed interest rate loan at 4.25% per year. You will have to pay 3% in loan expenses and you plan on using an amortization term of 15 years making this a fixed interest rate fully amortized loan. You will have yearly taxes of $115,000 for the next 5 years and you will have taxes due on sale of 4% on the property. Once you complete the model, answer the Assumptions Monthly Rent Per Unit Number of Units Rent Growth (YEARLY) Vacancy/Collection Losses Miscellaneous Income Per Month OpX [YEARLY) OpX Growth (YEARLY) Purchase Price (YEAR O) Sale Price Selling Expense Required Return (RR) Unlevered E Required Return (BR) Levered Be Required Return (RR) Levered Aft Annual Taxes Taxes Due On Sale $850.00 150 1.50% 5.00% $75.00 $250,000.00 2.50% $0.00 $10.750,000.00 $11,250,000.00 6.00% 10.00% 14.00% 9.80 $115,000.00 $430,000.00 Proforma YR 1 YR 2 YR 3 YR 4 YR5 Potential Gross Income Vacancy and Collection Miscellaneous Income Effective Gross Income Opx CapX Net Operating Income Debt Service Before Tax Cash Flow Tax Alter Tax Cash Flow Anh Les Y7 wered ort Tas dtatus Leren Amortization Tatlle Assumptions Loan Amount Loan Expenses Loan Term Amortization Term Rate Amortization Table Monthly Payment Principal 3 Month Beginning Balance Interest Ending Balance 5 5 3 . 2 3 4 5 6