◆Home Improvement Ideas Journal

Rental Property Depreciation Schedule Example

By

Depreciation is a critical aspect of owning a rental property, as it allows owners to recoup the cost of their asset over time. For those new to rental property investment, understanding how to create a depreciation schedule can seem daunting. However, it's a vital process that can save you thousands on your taxes and help you maintain your property's value.

In this guide, we'll walk you through the process of creating an example of a depreciation schedule for rental property, including the necessary components, common mistakes to avoid, and a step-by-step breakdown. By the end, you'll have a solid understanding of how to calculate and apply depreciation to your rental property, maximizing your return on investment.

Understanding Depreciation for Rental Property

Depreciation for rental property is based on the notion that the value of a property decreases over time due to wear and tear, or obsolescence. The Internal Revenue Service (IRS) allows rental property owners to recuperate this loss in value through annual deductions on their taxes.

How to Create Rental Property Depreciation Calculator in Excel - ExcelDemy
How to Create Rental Property Depreciation Calculator in Excel - ExcelDemy
Rental Property Depreciation: How to Calculate & Examples
Rental Property Depreciation: How to Calculate & Examples
Explore Our Example of Monthly Depreciation Schedule Template
Explore Our Example of Monthly Depreciation Schedule Template

The IRS considers residential rental properties, including single-family homes, apartments, and townhouses, as personal property for tax purposes. This makes it eligible for depreciation. However, only the building structure, not the land, is depreciable.

Identifying Depreciable Assets

Before creating your depreciation schedule, you'll need to identify the depreciable assets in your rental property. Typically, these include:

How Is Rental Property Depreciation Calculated? Free Property Depreciation Calculator
How Is Rental Property Depreciation Calculated? Free Property Depreciation Calculator
Template Depreciation Schedule
Template Depreciation Schedule
Depreciation Schedule Template Excel & Google Sheets
Depreciation Schedule Template Excel & Google Sheets
  • The building structure, including the foundation, walls, roof, and internal structural components.
  • Built-in improvements, such as cabinetry, tile work, and wall treatments.
  • Physical assets that contribute to the value of the property, like heating, plumbing, and electrical systems.
  • Personal property assets that are affixed to the building, like appliances and furniture.

Some assets may not be depreciated as part of the building, such as land improvements like fencing, pavement, and landscaping. These are considered land improvements and are deducted separately.

Determining the Depreciation Method

The method you use to depreciate your rental property depends on when it was placed in service and its useful life. The most common methods for residential rental property are:

  • Modified Accelerated Cost Recovery System (MACRS) with a 27.5-year recovery period, also known as Class Life depreciation.
  • Alternate Depreciation System (ADS) with a half-year convention, available for certain assets placed in service after 1986.

For most residential rental properties, the MACRS method with a 27.5-year recovery period is the most suitable. This method, introduced in the Tax Reform Act of 1986, provides a fixed rate of depreciation based on the class life of the asset.

Depreciation Schedule Template Excel, Download Free Depreciation Schedule
Depreciation Schedule Template Excel, Download Free Depreciation Schedule
Straight Line Depreciation Schedule Calculator | Double Entry Bookkeeping
Straight Line Depreciation Schedule Calculator | Double Entry Bookkeeping
Free Depreciation Schedule Templates | MS Excel & MS Word
Free Depreciation Schedule Templates | MS Excel & MS Word
Free Printable Depreciation Schedule Templates (Excel / PDF)
Free Printable Depreciation Schedule Templates (Excel / PDF)
13+ Depreciation Schedule Templates Free - Word Excel Templates
13+ Depreciation Schedule Templates Free - Word Excel Templates
Free Depreciation Schedule Templates in MS Word and MS Excel
Free Depreciation Schedule Templates in MS Word and MS Excel

Creating an Example Depreciation Schedule

Now that we've covered the basics of depreciation, let's create an example depreciation schedule for a single-family rental home. Suppose we purchased the property for $200,000, and the building's value is $150,000, with the remaining $50,000 allocated to land improvements.

For this example, we'll use the MACRS method with a 27.5-year recovery period, and we'll assume the property was placed in service in 2022.

Calculating Annual Depreciation

To calculate annual depreciation, we'll use the Half-Year Convention rule, which assumes that the property was placed in service and ready for use halfway through the year. The depreciation expense for the first year is calculated as follows:

The 35 rental deductions landlords miss most (free checklist)
The 35 rental deductions landlords miss most (free checklist)
Rent Tracking Spreadsheet: A Comprehensive Guide - Free Sample, Example & Format Templates
Rent Tracking Spreadsheet: A Comprehensive Guide - Free Sample, Example & Format Templates
Rental Property Tax Spreadsheet - Schedule E Landlord Tracker with Depreciation & Mortgage Amortization | XLSX
Rental Property Tax Spreadsheet - Schedule E Landlord Tracker with Depreciation & Mortgage Amortization | XLSX
Rental Property Balance Sheet in Excel - 2 Methods (Free Template) - ExcelDemy
Rental Property Balance Sheet in Excel - 2 Methods (Free Template) - ExcelDemy
Landlord template demo, Track rental property in excel
Landlord template demo, Track rental property in excel
Master Your Rental Property Finances with This Spreadsheet
Master Your Rental Property Finances with This Spreadsheet
Rental Property Tracker Spreadsheet | Landlord Income Expense Excel Template (1-10 Properties)
Rental Property Tracker Spreadsheet | Landlord Income Expense Excel Template (1-10 Properties)
How to Create Monthly Depreciation Schedule in Excel - ExcelDemy
How to Create Monthly Depreciation Schedule in Excel - ExcelDemy
Free Rental Property Management Template (Excel, Word, PDF) - Excel TMP
Free Rental Property Management Template (Excel, Word, PDF) - Excel TMP
Printable Depreciation Schedule Template
Printable Depreciation Schedule Template
MyClearBudget - Etsy
MyClearBudget - Etsy
the graph shows that there are two types of deprection schedules compared to each other
the graph shows that there are two types of deprection schedules compared to each other
a person holding up a business card with the words tax deprection schedules australia
a person holding up a business card with the words tax deprection schedules australia
Cost Basis Recovery Period Depreciation Rate Depreciation Expense
$150,000 27.5 years 3.636% (rounded) $5,454 (rounded)

In this example, the annual depreciation expense for the building structure is $5,454 (($150,000 * 3.636%) / 2).

Note: To maximize your depreciation deduction, consider performing a cost segregation study. This process involves breaking down the building's components and assigning appropriate recovery periods based on their useful life. This can significantly accelerate your depreciation deductions, but it requires professional expertise and often a fee.

Accounting for Land Improvements

Land improvements, such as landscaping, fences, and pavement, are also depreciable but typically have a shorter recovery period. In this example, we'll assume the remaining $50,000 in land improvements has a 15-year recovery period. Using thestraight-line method of depreciation, the annual depreciation expense is calculated as follows:

Annual Depreciation Expense = Cost Basis / Recovery Period

$50,000 / 15 years = $3,333

This results in an annual depreciation expense of $3,333 for land improvements.

publiques, consider seeking help from a tax professional or using specialized tax software. A proper depreciation schedule helps ensure you're compliant with IRS regulations and maximize your tax benefits, ultimately boosting your rental property's ROI.