need as an excel sheet asap. thanks :)

You are investing in a 250 unit student housing complex that you bought for $21,000,000 and plan to sell the property in 12 years. You financed 55% of the property by ABC Bank with a 15 year fixed interest rate loan at 4.75% per year and will have to pay 3.5% in loan expenses. You have a 2 and a half year interest only period and will have an amortization term of 30 years You will have annual taxes of $90,525 for the next 12 years and will have taxes due on sale of 6% on the property. You hope to receive a 10% unlevered return, 14% levered return on the property before taxes, and a 9.8% levered return after taxes. The apartment has 45 units with 1 bed/1 bath, 55 units with 2 beds/1 bath, 70 units with 2 beds/2 baths, and so units with 4 bedt/4 baths. After doing your due diligence, you take a conservative approach and project the 1/1 units to rent for $1,000/room/month, the 2/1 units to rent for $500/room/month, the 2/2 units to rent for $600/room/month, and the 4/4 units to rent for $550/room/month. Each leate will be for 12 months and you project the rent to increase by 2 for the first 4 years of owning the property and then stabilize to 1.5 for the remaining years. You also expect the vacancy and collection losses to be 10% in the first year and then decrease by 2 for each year until stable in year 4 for the remaining years. Your operating expenses include basie maintenance on the property totaling $45,000/month, a property management fee of $65.000/month, and a salary of $14,500/month/employee for the 8 employees on site. Your operating expenses will grow at a rate of 18 yearly. You will also have miscellaneous income of $50/room/month for a pet fee, in which you project 40% of the room total to have pets, and 5100/room/month for parking, in which you project 72% of the room total to need a parking spot. When you had the property inspected prior to ownership, you realized you needed to tepave all the concrete roads and fix pot holes as well as build a pool and outdoor social area for residents within the next 6 years. You have asked multiple companies how much it will cost to fix the roadways, build a pooland an outdoor social area and find out it will cost $8,700 to fix the roadways and $35,000 to install a popl and outdoor social area. You plan to fix the roadways in year 1 and build the pool and outdoor area in year 2. After 12 years when you go to sell the property, you find out that comparable properties are selling at an average cap rate of 6.5% and that you will have 5.5% selling expenses. Amount/Notes Cost Totals (Monthly) Unit Mix Of Apartment Complex lbed/1bath 2bed/1bath 2bed/2bath 4bed/4bath O Miscellaneous Income 1 Pet Fee 2 Parking Spot 3 4 Operating Expenses 5 Maintenance Fee 6 Property Management Fee 7 On-Site Employees 8 9 0 Capital Expenses 1 Repaving Roadways (Plus Labor) 2 Pool & Outdoor Area (Plus Labor) 23 Totals (Yearly) ... . - Assumptions Payments Loan Amount (0%) Loan Expenses (.0%) Loan Term Amortization Term Interest Only Period Rate PMT V/O PMT Amortization Table Monthly Payment Principal Month Beginning Balance Interest Ending Balance You are investing in a 250 unit student housing complex that you bought for $21,000,000 and plan to sell the property in 12 years. You financed 55% of the property by ABC Bank with a 15 year fixed interest rate loan at 4.75% per year and will have to pay 3.5% in loan expenses. You have a 2 and a half year interest only period and will have an amortization term of 30 years You will have annual taxes of $90,525 for the next 12 years and will have taxes due on sale of 6% on the property. You hope to receive a 10% unlevered return, 14% levered return on the property before taxes, and a 9.8% levered return after taxes. The apartment has 45 units with 1 bed/1 bath, 55 units with 2 beds/1 bath, 70 units with 2 beds/2 baths, and so units with 4 bedt/4 baths. After doing your due diligence, you take a conservative approach and project the 1/1 units to rent for $1,000/room/month, the 2/1 units to rent for $500/room/month, the 2/2 units to rent for $600/room/month, and the 4/4 units to rent for $550/room/month. Each leate will be for 12 months and you project the rent to increase by 2 for the first 4 years of owning the property and then stabilize to 1.5 for the remaining years. You also expect the vacancy and collection losses to be 10% in the first year and then decrease by 2 for each year until stable in year 4 for the remaining years. Your operating expenses include basie maintenance on the property totaling $45,000/month, a property management fee of $65.000/month, and a salary of $14,500/month/employee for the 8 employees on site. Your operating expenses will grow at a rate of 18 yearly. You will also have miscellaneous income of $50/room/month for a pet fee, in which you project 40% of the room total to have pets, and 5100/room/month for parking, in which you project 72% of the room total to need a parking spot. When you had the property inspected prior to ownership, you realized you needed to tepave all the concrete roads and fix pot holes as well as build a pool and outdoor social area for residents within the next 6 years. You have asked multiple companies how much it will cost to fix the roadways, build a pooland an outdoor social area and find out it will cost $8,700 to fix the roadways and $35,000 to install a popl and outdoor social area. You plan to fix the roadways in year 1 and build the pool and outdoor area in year 2. After 12 years when you go to sell the property, you find out that comparable properties are selling at an average cap rate of 6.5% and that you will have 5.5% selling expenses. Amount/Notes Cost Totals (Monthly) Unit Mix Of Apartment Complex lbed/1bath 2bed/1bath 2bed/2bath 4bed/4bath O Miscellaneous Income 1 Pet Fee 2 Parking Spot 3 4 Operating Expenses 5 Maintenance Fee 6 Property Management Fee 7 On-Site Employees 8 9 0 Capital Expenses 1 Repaving Roadways (Plus Labor) 2 Pool & Outdoor Area (Plus Labor) 23 Totals (Yearly) ... . - Assumptions Payments Loan Amount (0%) Loan Expenses (.0%) Loan Term Amortization Term Interest Only Period Rate PMT V/O PMT Amortization Table Monthly Payment Principal Month Beginning Balance Interest Ending Balance