Question 12 10 pts Complete this table to prepare a pro-forma financial statement to analyze financing a 50 unit apartment building with the following facts. Show how you answered the question. a) potential rent = $2,000/month; use 5% vacancy loss b) operating expenses=30% of gross potential rent c) property taxes = $750/unit d) replacement reserves= $250/unit c) property valued at $13,000,000 d) loan to value= 75% e) interest rate= 4.25% f) loan amortization=30 years Show how you calculated the answer. # of apartments potential rent vacancy loss EGI operating expenses property taxes replacement reserves property value loan amount debt service breakeven occupancy debt coverage # of apartments = 50 potential rent = 50 x 2,000 = 1,200,000 vacancy lost = 1,200,000 X.05 = 60,000 EGI = 1,200,000 - 60,000 = 1,140,000 Operating Expeneses = 1,200,000 x.30 = 360,000 Property Taxes = 750 x 50 = 37,500 Replacement Reserves = 250 x 50 = 12,500 Property Value = 13,000,000 Loan Amount = 13,000,000 x.75 = 9,750,000 Debt Service = Breakeven occupancy = Debt Coverage = Question 12 10 pts Complete this table to prepare a pro-forma financial statement to analyze financing a 50 unit apartment building with the following facts. Show how you answered the question. a) potential rent = $2,000/month; use 5% vacancy loss b) operating expenses=30% of gross potential rent c) property taxes = $750/unit d) replacement reserves= $250/unit c) property valued at $13,000,000 d) loan to value= 75% e) interest rate= 4.25% f) loan amortization=30 years Show how you calculated the answer. # of apartments potential rent vacancy loss EGI operating expenses property taxes replacement reserves property value loan amount debt service breakeven occupancy debt coverage # of apartments = 50 potential rent = 50 x 2,000 = 1,200,000 vacancy lost = 1,200,000 X.05 = 60,000 EGI = 1,200,000 - 60,000 = 1,140,000 Operating Expeneses = 1,200,000 x.30 = 360,000 Property Taxes = 750 x 50 = 37,500 Replacement Reserves = 250 x 50 = 12,500 Property Value = 13,000,000 Loan Amount = 13,000,000 x.75 = 9,750,000 Debt Service = Breakeven occupancy = Debt Coverage =