The Debt Coverage Ratio (DCR) is a benchmark which measures an income producing property's ability to cover the monthly mortgage payments. The DCR is calculated by dividing the net operating income (NOI) by a property's annual debt service.
Annual debt service equals the annual total of all interest and principal paid for all loans on a property.
Debt Coverage Ratio = Net Operating Income/ Annual Debt Service
Many lending institutions require a minimum debt coverage ratio value to procure a loan for income producing properties. The higher the debt coverage ratio value the more available income to cover the debt service, and thus the less the risk.Lenders use the debt coverage ratio to determine if an income producing property has sufficient income to cover the operating expenses and debt service. To acquire a loan for an income producing property, the debt coverage ratio must usually be greater than 1.1. A debt coverage ratio of less than 1 indicates that the income generated by a property is insufficient to cover the mortgage payments and operating expenses.
Member Posts
No topics exist.
Contribute to this page
Determine the Real Estate Financial Statistics for a PropertyBefore you buy an investment property it is critical that you create your own projection of the property's profitability. Real-Estate-Proforma.com has a quick-proforma with which you can calculate real estate financial statistics such as Internal Rate of Return, Capitalization Rate, Cash-on-Cash, Debt Multiplier, Loan-to -Value Ratio, Debt Coverage Ratio, and Mortgage Payments. You can use this JavaScript proforma to project the profitability of a real estate project. By becoming a member you will receive access to a number of Excel real estate proformas. membership | services
If you are analyzing another person's proforma, or you are examining a prospectus for a real estate deal, it is very important that you read the document carefully and determine how the values of the financial statistics above are being calculated. For instance, values such as the Cap Rate may be determined from overly optimistic projections of the future rental income of a property.
You can "reverse engineer" the financial projections you receive from a prospectus and/or request the Excel (or other type of) spreadsheet a developer used to create their proforma. A very useful Excel or Visual Basic macro used to check Excel formulas is available in the spreadsheet below for download. Download Mortgage Formula Excel Spreadsheet
The due-diligence you do on a potential investment may uncover a number of potential problems with a real estate deal and we suggest you research each real estate investment very carefully. There are a variety of real estate financial consultants who can help with this, but if you are like many Real-Estate-Proforma.com members, you can or are learning to do your own due-diligence.
We hope you become a more successful real estate investor by using this site! membership | services







