need as an excel sheet asap. thanks :)

+ Subject Property 5 This is a Class B duplex in Gainesville that you plan to renovate before leasing out to students in order to command 6 higher rents. You did your research and project the renovations to cost you $6,500 per unit in year 1. You can 7 purchase the property for $175,000 today and you believe that the total combined rent will be $1,745 a month for 8 the entire property with a 12 month lease. You also believe that your rent will grow at a constant yearly rate of 1.5% 9 and project that you will have vacancy and collection losses of 3% annually since you secured creditable tenants, 10 Both tenants will be charged $50 a month for their parking spot, maintenance and utilities will cost you $4,000 11 annually, and the operating expenses will grow at 2% yearly. Based on your assumptions you can sell your property in 12 5 years for $225,000. You expect there to be selling expenses of 6%. You will not invest in this property unless you 13 can realize an unlevered before tax return of 10%, a levered before tax return of 14%, and a levered after tax return 14 of 9.8%. You would like to acquire the property with 60% financed by ABC Bank with a 15-year fixed interest rate 15 loan at 3.5% per year. You also negotiate to only pay interest for the six months. You will have to pay 3% in loan 16 expenses and you plan on using an amortization term of 30 years making this a fixed rate partially amortized loan 17 with an interest only period. Your yearly taxes will be $3,750 and you will have taxes due on sale of 4% on the 18 property. Once you complete the model, answer the quiz questions in canvas. o 19 20 21 22 Discounted Cash Flow Assumptions Monthly Rent Per Unit Number of Units Rent Growth (YEARLY) 8 Vacancy/Collection Losses 9 Miscellaneous Income Per Month 10 OpX (YEARLY) 11 OpX Growth (YEARLY) 12 CapX 13 Purchase Price (YEAR O) 14 Sale Price (YEAR) 15 Selling Expense 16 Required Return (RR) Unlevered Before Tax 17 Required Return (RR) Levered Before Tax 18 Required Return (RR) Levered After Tax 19 Annual Taxes 20 Taxes Due On Sale .0% 21 22 23 24 25 Potential Gross income 26 Vacancy and Collection 27 Miscellaneous Income 28 Effective Gross income 29 Opx 30 Capx 21 Net Operating Income 32 Debt Service 3 Before Tax Cash Flow 34 Tax 35 Alter Tax Cash Flow Proforma YRS YR 4 YR2 YR 3 YR 6 YR 1 30 Amor Lean Espen Buy Investment se price Selling Expert Net Sales Proceeds Cachowane Notes Remaine More Beauty avertin Berat Ah YHD Cash Flow From Opera YR1 VR 2 Ya VE RS univered Before Tax Levered Before Tox Lored Aner Tax Valuations NPV IRR Unlevered Before Tax Levered Before Tax Levered After Tax Going Out (Terminal Cap Rate Amortization Table Assumptions Payments Loan Amount (.0%) Loan Expenses (0%) Loan Term Amortization Term Interest Only Period Rate PMT 1/0 PMT Amortization Table Monthly Payment Principal Interest Ending Balance Month Beginning Balance 6 7 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 - CE Amortization le + Subject Property 5 This is a Class B duplex in Gainesville that you plan to renovate before leasing out to students in order to command 6 higher rents. You did your research and project the renovations to cost you $6,500 per unit in year 1. You can 7 purchase the property for $175,000 today and you believe that the total combined rent will be $1,745 a month for 8 the entire property with a 12 month lease. You also believe that your rent will grow at a constant yearly rate of 1.5% 9 and project that you will have vacancy and collection losses of 3% annually since you secured creditable tenants, 10 Both tenants will be charged $50 a month for their parking spot, maintenance and utilities will cost you $4,000 11 annually, and the operating expenses will grow at 2% yearly. Based on your assumptions you can sell your property in 12 5 years for $225,000. You expect there to be selling expenses of 6%. You will not invest in this property unless you 13 can realize an unlevered before tax return of 10%, a levered before tax return of 14%, and a levered after tax return 14 of 9.8%. You would like to acquire the property with 60% financed by ABC Bank with a 15-year fixed interest rate 15 loan at 3.5% per year. You also negotiate to only pay interest for the six months. You will have to pay 3% in loan 16 expenses and you plan on using an amortization term of 30 years making this a fixed rate partially amortized loan 17 with an interest only period. Your yearly taxes will be $3,750 and you will have taxes due on sale of 4% on the 18 property. Once you complete the model, answer the quiz questions in canvas. o 19 20 21 22 Discounted Cash Flow Assumptions Monthly Rent Per Unit Number of Units Rent Growth (YEARLY) 8 Vacancy/Collection Losses 9 Miscellaneous Income Per Month 10 OpX (YEARLY) 11 OpX Growth (YEARLY) 12 CapX 13 Purchase Price (YEAR O) 14 Sale Price (YEAR) 15 Selling Expense 16 Required Return (RR) Unlevered Before Tax 17 Required Return (RR) Levered Before Tax 18 Required Return (RR) Levered After Tax 19 Annual Taxes 20 Taxes Due On Sale .0% 21 22 23 24 25 Potential Gross income 26 Vacancy and Collection 27 Miscellaneous Income 28 Effective Gross income 29 Opx 30 Capx 21 Net Operating Income 32 Debt Service 3 Before Tax Cash Flow 34 Tax 35 Alter Tax Cash Flow Proforma YRS YR 4 YR2 YR 3 YR 6 YR 1 30 Amor Lean Espen Buy Investment se price Selling Expert Net Sales Proceeds Cachowane Notes Remaine More Beauty avertin Berat Ah YHD Cash Flow From Opera YR1 VR 2 Ya VE RS univered Before Tax Levered Before Tox Lored Aner Tax Valuations NPV IRR Unlevered Before Tax Levered Before Tax Levered After Tax Going Out (Terminal Cap Rate Amortization Table Assumptions Payments Loan Amount (.0%) Loan Expenses (0%) Loan Term Amortization Term Interest Only Period Rate PMT 1/0 PMT Amortization Table Monthly Payment Principal Interest Ending Balance Month Beginning Balance 6 7 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 - CE Amortization le