In: Accounting
A property owner has provided you with the following information. Assume the owner has no other assets or liabilities. The annual gross revenue is $3,275,000. The debt service payment on the loan is $147,000 per month. The capitalization rate is 8%. Assets: Cash $ 1,000,000 Land 1,500,000 Building 29,500,000 Total Assets $ 32,000,000 Liabilities & Equity: Nonrecourse Liabilities $ 25,000,000 Partner’s Capital 7,000,000 Total Liabilities & Capital $ 32,000,000
14. What is the property’s NOI?
Calculate the Debt Service Coverage Ratio?
What is the Debt to Asset Ratio?
Last year’s Debt Ratio for the property was 74%. The industry average Debt to Asset ratio is 82%. Based on the available information would you consider this to be a low, normal or high risk investment and why?
What is the Effective Gross Income Multiplier?
Debt Service Payment per Month | $ 1,47,000.00 | |
Yearly Payment | $ 17,64,000.00 | |
Gross Revenue (EBITDA) | $ 32,75,000.00 | |
Debt Service Coverage Ratio | =EBITDA/Debt Service Payment | |
Debt Service Coverage Ratio | 1.857 | |
Let take Capitalization Rate as Loan Interest | ||
Liabilities | $ 25,00,000.00 | |
Yearly Debt Service Payment | $ 17,64,000.00 | |
Total (Including Interest) | $ 42,64,000.00 | |
Principle | $ 39,48,148.15 | +4264000/1.08 |
Interest | $ 3,15,851.85 | |
Gross Revenue (EBITDA) | $ 32,75,000.00 | |
Less: Interest | $ 3,15,851.85 | |
Net Operating Income | $ 29,59,148.15 | |
Debt to Asset Ratio | ||
Debt | 2500000 | |
Total Assets | 3200000 | |
Debt to Total Assets | 78.13% | |
Last Year | 74% | |
Industry Average Debt Asset Ratio | 84% | |
Company Debt to Asset Ratio is less than Industry Average so it is Low risky | ||
Effective Gross Income Multiplier | Total Assets/Gross Income | |
0.977099 |