A rental property income statement is central to understanding your portfolio and is a key figure for several important real estate metrics.
Written by
Ben Luxon
PUBLISHED ON
24
Feb
2022
A real estate income statement is one of the most important reports for real estate investors. If a property is under or overperforming, a rental property income statement is central to understanding why. Additionally, a real estate income statement will report net operating income (NOI) which is a key figure used in important real estate financial metrics such as cap rate and debt service coverage ratio (DSCR).
Also known as a profit and loss statement (P&L) or income expense statement, a real estate income statement lists all of the income and expenses associated with your property over a specified period of time. The report should beak down your portfolio by property and show total operating expenses and gross income to highlight total profits.
Information on a real estate income statement includes:
Your real estate income statement displays three main pieces of data, the gross monthly income, the total operating expenses, and the net operating income.
Related: Tracking Rental Property Expenses: What Landlords Need To Know
Your monthly income statement allows you to analyze your portfolio performance on a month-to-month basis. This month-to-month report will allow you to easily spot any unexpected overheads, and closely monitor cash flow on an ongoing basis to identify income and expense trends over a longer time period.
Your year-to-date (or YTD) profit and loss statement shows your total income, current accrued expenses, and total net operating income from the beginning of the tax or calendar year to the date the report was run. This is a useful report to analyze your property’s overall performance and to give you an indicator of current taxable income.
A year-end income statement for rental property is a report that shows the total income, expenses, and NOI for the tax year. This is usually generated at the end of the year and used to help compile tax returns and update any important rental property portfolio performance indicators such as cap rate.
When talking about abbreviations, the TTM statement or sometimes T12 statement tends to come up a lot. TTM, or T12, stands for “trailing twelve months” and generally refers to a financial statement that represents the entity’s performance over the past year from the current date.
A trailing 12-month report is used to monitor the change in NOI over the previous 12 months. A property’s T12, along with its rent roll and T3 (trailing 3-month financial statement) are some of the most important forms of documentation that a borrower will need to show a lender.
In order to better understand how a rental property income statement works and can be used, let’s review an example.
For this example, we will look at a T12 real estate income statement for a single-family rental home. The purchase price is $200,000 with a 20% deposit and a monthly income of $2000.
It’s important to correctly classify and itemize all of your income and expenses to ensure you get the most practical use out of your report and use it to accurately and easily file your tax return. However, for the sake of simplicity, we have consolidated some of the example income and expenses.
Rental income = $24,000
Other income = $150 (late fees)
Total income = $24,150
Annual operating expenses
Insurance = $1,200
Landscaping & snow removal = $300
Mortgage interest = $8,100
Property management = $2,400 (averages 8% – 12% of gross rental income)
Property tax = $2,000
Repairs & maintenance = $1,400
Total operating expenses = $15,400
Travel expense = $2,500 (to visit out-of-state property)
Office supplies = $230
Total owner expenses = $2,730
$24,000 Income – $15,400 Operating Expenses – $2,730 Owner Expenses = $5,870 Net Operating Income (NOI)
The capitalization rate is a good way to quickly calculate the potential of a property based on estimated numbers. The cap rate is a measurement of the rate of return on an investment property.
The lower the cap rate of a property, the slower the return will be. It takes into account the total (expected) income and the property’s current market value. The cap rate formula is a good one to take into account when comparing like-for-like investments in a single market.
Cap Rate = NOI / Property Value
The Debt Service Coverage Ratio (DSCR) is used by lenders to determine the ability of a company, or loan applicant, such as a landlord, to repay all of its debt obligations. This includes repayment of the principal and interest on both short and long-term debt.
DSCR = Total Debt Service / Net Operating Income
The IRS allows owners of residential property used for investment purposes to depreciate the property value (excluding the land or lot value) over a period of 27.5 years.
To calculate total taxable income, subtract depreciation expense from your net operating income.
For example, let’s say the property value in the example above, minus the value of the land is $140,000, then the total annual depreciation would be approximately $5090. As the NOI is $5,870, the total taxable net income would be $780.
In order to generate an accurate rental property income statement, whether this is an end-of-year report, a T12 statement, or a monthly statement, you need to keep detailed and careful records of all of your income and expenses throughout the year. Using spreadsheets for your income and expense tracking leaves a lot to be desired. It means you have to do a lot of manual data entry and generating an income expense statement is almost impossible.
Thankfully, there are plenty of software solutions on the market today that are designed to make this easier, less time-consuming, and more accurate.
Landlord Studio is designed by landlords for landlords with a principal aim to make tracking and reporting income and expenses easier. Our new income and expense statement allows you to get a full breakdown of your portfolio income and expenses on a month by month or property basis.
With Landlord Studio, you can track your expenses on any device in real-time. Digitize receipts at the point of sale, connect your bank accounts to reconcile transactions and reduce manual data entry, and easily generate any of over 15 reports including an income/expense statement, profit and loss summary, and our Schedule E report specially designed to help landlords at tax time.
All of our reports are filterable by date range, income and expense categories, and property owner meaning you can easily generate monthly reports, a T12 statement, a year-to-date profit, and loss statement, or an end-of-year income and expense statement.
With this data at hand, quickly identify potential problems and compare actual results to budgets. Regular scrutiny of key income and expense line items often yields insights and opportunities that might otherwise go unnoticed.