Property Plant and Equipment Schedule Template
Originally published: 12/06/2018 09:28
Last version published: 16/01/2019 09:04
Publication number: ELQ-78165-5
View all versions & Certificate

Property Plant and Equipment Schedule Template

Simple excel template for monitoring, analysing and scheduling the PP&E and depreciation of your business.

This is a simple and easy to use, one-sheet worksheet that will allow you to monitor, analyse and schedule the Property, Plant & Equipment (PP&E) of your business over a 5 year period.

PP&E is made up of tangible capital assets. Examples include: machinery, equipment, vehicles, buildings, land and office space. All of these are used in the business to generate revenue and profits.

PP&E is an extremely important part of business operations as it represents the business' long term assets. Using this model will allow you to create a PP&E schedule for your capital assets. A business' PP&E represents an essential element of their overall balance sheet and general financial considerations. When creating a financial plan for your business, it is essential to consider PP&E depreciation.

This model includes:

- Opening Balance
- Capital Expenditure
- Depreciation Schedule
- Closing Balance

As such, this template gives you the opportunity to conduct a thorough analysis of your PP&E.

By using this model, you will be able to create a detailed depreciation schedule for your capital assets. It uses PP&E formulas in order to calculate the depreciation of your technology, property and equipment, as well as your total depreciation and closing balance.

See the accompanying video for a great demonstration using a realistic example.

This Best Practice includes
1 Excel Spreadsheet, 1 YouTube Video

CFI offers you this Best Practice for free!

download for free

Add to bookmarks


4.4 / 5 (8 votes)

please wait...