need as an excel sheet asap. thank you :)

please let me know if this is any better visibly. needed as an excel sheet

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 2.5% 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 quiz questions in canvas. My Per umber of Gwth EARLY Vacan Meuse Month 150 3. $75.00 SVEDO 1 son San. 51.250.000.00 Op Growth YEARLY Per VARI Sale taling pene haud Unredare Tas ved at levereretus Med Laverdar Tas AART Te Dua TR2 YR YRG VRS WC Terme Cuk Operating income Det Before Tas Cash Alleres Cash Earn per Cash from Sale Of A Property Prede More talesuly Bry Tartu htuar RO Cash Flowers R1 TR2 TRU VRS Unilevard Delare Ter Lower Detare Tas LAT Valuation PV IRR Under Betres wered before Tae Led At Tas D E Amortization Table E F Assumptions Loan Amount Loan Expenses Loan Term Amortization Term Rate Month Beginning Balance Amortization Table Monthly Payment Principal Interest Ending Balance Tbiliser 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 2.5% 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 quiz questions in canvas, A Mehr Number of its and Gowth CARLY Vacances Musim Per Moth 150 . 50 San S. 1 som San 0.00 51125.000 Op Growth YEARLY Per PEAR Sale Sing pen heredem Und Belarus Repedett leveres Laverdar Tas Manual Teuta Y Preleme 2 YR YEG VRS C hem Net Operating income Det Before Toscach Alleres Cash intime 0 R -40 Cash From Sale Of A Property Sales de More fare to Fauty Beverin Bay Barson hafuatay Cash Flowers YE TR2 VRO YRA VRS Unilever Before Tor Low Before Tas Las Arenas Valuation FV Undervered Bettas wered for Laverda Tas D E Amortization Table E F Assumptions Loan Amount Loan Expenses Loan Term Amortization Term Rate Month Beginning Balance Amortization Table Monthly Payment Principal Interest Ending Balance Tibaner 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 2.5% 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 quiz questions in canvas. My Per umber of Gwth EARLY Vacan Meuse Month 150 3. $75.00 SVEDO 1 son San. 51.250.000.00 Op Growth YEARLY Per VARI Sale taling pene haud Unredare Tas ved at levereretus Med Laverdar Tas AART Te Dua TR2 YR YRG VRS WC Terme Cuk Operating income Det Before Tas Cash Alleres Cash Earn per Cash from Sale Of A Property Prede More talesuly Bry Tartu htuar RO Cash Flowers R1 TR2 TRU VRS Unilevard Delare Ter Lower Detare Tas LAT Valuation PV IRR Under Betres wered before Tae Led At Tas D E Amortization Table E F Assumptions Loan Amount Loan Expenses Loan Term Amortization Term Rate Month Beginning Balance Amortization Table Monthly Payment Principal Interest Ending Balance Tbiliser 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 2.5% 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 quiz questions in canvas, A Mehr Number of its and Gowth CARLY Vacances Musim Per Moth 150 . 50 San S. 1 som San 0.00 51125.000 Op Growth YEARLY Per PEAR Sale Sing pen heredem Und Belarus Repedett leveres Laverdar Tas Manual Teuta Y Preleme 2 YR YEG VRS C hem Net Operating income Det Before Toscach Alleres Cash intime 0 R -40 Cash From Sale Of A Property Sales de More fare to Fauty Beverin Bay Barson hafuatay Cash Flowers YE TR2 VRO YRA VRS Unilever Before Tor Low Before Tas Las Arenas Valuation FV Undervered Bettas wered for Laverda Tas D E Amortization Table E F Assumptions Loan Amount Loan Expenses Loan Term Amortization Term Rate Month Beginning Balance Amortization Table Monthly Payment Principal Interest Ending Balance Tibaner