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




More Best Practices from CFI

See all

Any questions on Property Plant And Equipment Schedule Template?

The user community and author are here to help. Go ahead!

4.4 / 5 (8 votes)

please wait...