NAME Due on Ma 14 Before 340,000 51,000 21. Calculate Going in Cop Rat Rob REAL ESTATE PC VC -M -EG O CAPEX NO -OS -DTCH 289,000 115,600 14,450 158,950 125.630 33.320 22. Catrudne the faulty Puddend Runto Con 15 in introve Cateutate the active Grom income Multiplier HW You are considering purchasing a small office building for $1,975,000 Your expectations include: - First-year gross potential income of $340,000; - Vacancy & collection losses equal to 15% of PGI: Operating expenses 40% of EGI - Capital expenditures = 5% of EGI - 51,481,250 mortgage (75% LTV) @ 7% - Mortgage will be amortized over 25 years with a monthly payment of $10,469.17 - Total up-front financing costs - 2% of the loan amount - Required equity Investment is 5523,375 (51.975,000 - ($1.481,250 - $29,625) 04. Calculate the Operating tente allo (OR) Q5. Calculate the Debt Cover Rat OCR NAME Due on Ma 14 Before 340,000 51,000 21. Calculate Going in Cop Rat Rob REAL ESTATE PC VC -M -EG O CAPEX NO -OS -DTCH 289,000 115,600 14,450 158,950 125.630 33.320 22. Catrudne the faulty Puddend Runto Con 15 in introve Cateutate the active Grom income Multiplier HW You are considering purchasing a small office building for $1,975,000 Your expectations include: - First-year gross potential income of $340,000; - Vacancy & collection losses equal to 15% of PGI: Operating expenses 40% of EGI - Capital expenditures = 5% of EGI - 51,481,250 mortgage (75% LTV) @ 7% - Mortgage will be amortized over 25 years with a monthly payment of $10,469.17 - Total up-front financing costs - 2% of the loan amount - Required equity Investment is 5523,375 (51.975,000 - ($1.481,250 - $29,625) 04. Calculate the Operating tente allo (OR) Q5. Calculate the Debt Cover Rat OCR