please make a model in excel

You are an investor looking to acquire a 100 unit apartment in Gainesville, FL. It is a Class A property with no major damages (no capital expenditures needed). You can purchase the property for $8,750,000 today and you charge $1,000 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 3% annually to account for any of the 100 tenants to not pay a portion of their rent. You are assuming all tenants will need parking so you charge $50 a month for their parking spot (miscellaneous income). Every year maintenance and utilities will cost you $200,000 (Operating Expenses) and it will grow at 1.5% yearly. You think that based on your market projections, you can sell your property in 5 years for $10,500,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% Once you complete the model, meinen Directions 1. Fill out assumptions in the designated assumption box 2. Fill out the proforma box by referencing the assumptions (no mare coding 13. Use the year proforma to reference your cash flow from operations 4. Calculate unlevered before tex NPV and RB using the cash row tre operations D Ta LE RE ESTER Discounted Cash Flow Red Cells Greences incorrect Answ Correct An Assumptions Monthly Rent Per Unit Number of Units Rent Growth (YLARLY) Vacancy/Collection Losses Miscellaneous income Per Month OpX YEARLY Opx Growth [YEARLY) CapX Purchase Price (YEAR 0) Sale Price (LAR) Selling tips Require Return BA) Unlevered Before Tax Serraforma YAZ YAD VR Potential Greas income Vacanty and Collection Misteme rective drons income OP CADX set Operating income important continens Letture Net Chew From Operations YRI YRI YR. YAO YRS UV Before Tex Valuations NPV Unlevered Beton TEX