Property Plant and Equipment Schedule Template
This property plant and equipment schedule template will help you keep track of PP&E balances and depreciation costs.
This is what a property, plant, and equipment schedule looks like:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Property, Plant, and Equipment (PP&E) is a non-current, tangible capital asset on the balance sheetBalance SheetThe balance sheet is one of the three fundamental financial statements. These statements are key to both financial modeling and accounting. The balance sheet displays the company’s total assets, and how these assets are financed, through either debt or equity. Assets = Liabilities + Equity of a business used to generate revenues and profits. PP&E plays a key part in the financial planning and analysis FP&A AnalystBecome an FP&A Analyst at a corporation. We outline the salary, skills, personality, and training you need for FP&A jobs and a successful finance career. FP&A analysts, managers, and directors are responsible for providing executives with the analysis, information they need to make operational, strategic decisionsof a company’s operations and future expenditures, especially with regards to capital expendituresHow to Calculate CapEx - FormulaThis guide shows how to calculate CapEx by deriving the CapEx formula from the income statement and balance sheet for use in financial modeling and analysis. To calculate capital expenditures, use depreciation on the income statement, add current period PP&E and subtract prior period PP&E.
The PP&E account is often denoted as net of accumulated depreciation. This means that, if a company does not purchase new equipment (capital expenditures is zero), Net PP&E should slowly decrease in value every period due to depreciation. This can be better determined by a depreciation schedule.
The formula for calculating net PP&E is:
Net PP&E = Gross PP&E + Capital Expenditures – Accumulated Depreciation
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTransactionsDownload free transaction templates including a Letter of Intent (LOI), Term Sheet, Non-Disclosure Agreement (NDA), Confidential Information Memorandum (CIM), Equity Capital Markets (ECM) memo, Due Diligence checklist, and other types of corporate transactions. Download the Word Document files for your own use
