Download rental property profit and loss statement in Excel and Spreadsheet. Compute the overall financial performance of your real estate property and rental property with this free profit and loss statement excel template.
About Rental property Profit and Loss Statement Excel Template
Using this template, you can capture property wise rental revenue and number of months occupied. Total revenue from each property gets computed automatically.
Rental Income = Per month rental price * Number of months occupied
Expenditure in running a rental property can be of many nature. Some of the expenditure pertaining to rental property are highlighted below –
- Property management fees – includes all the services and supplies for management of property or building.
- Advertising cost – cost that is incurred in generating leads for property sales/ rental
- Repair and maintenance – cost that is essential to make the property market relevant
- Accounting and legal fees – cost that is essential to keep all the books of accounts in place and legal filings and returns in compliance.
- Utilities – these are cost pertaining to general recurring items like electricity, lawn management and other items
- Insurance – cost towards insurance of rental property
- Other miscellaneous expenditures
With categorization of rental income from property and expenditure as highlighted above, you can easily prepare rental property profit and loss statement.
Introduction to Profit and Loss statement
An income statement or profit and loss account is one of the financial statements of a company and shows the company’s revenues and expenses during a particular period. It indicates how the revenues are transformed into the net income or net profit. (Source : Wikipedia)
You can easily customize the color scheme of this excel template. Furthermore, adding company or client logo can make this template more visually appealing.
Download and use printable rental property profit and loss statement excel template
Now, To download and use this free printable profit and loss excel template, follow the instructions below –
- Firstly, You should have Microsoft Office/ Microsoft Excel installed in your system.
- After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
- Once extracted, you can open the file using Excel and start entering data or customizing the format.