Schedules Templates

Take advantage and use our library of pre-built finance schedules templates to simplify your financing modeling process and produce a detailed supporting schedule!
Property Plant and Equipment Schedule Template
(0)
1,299
285
This Property Plant and Equipment Schedule Template is a simple and easy to use, one-sheet worksheet that will allow you…
Capital Expenditure (CapEx) Excel Calculator
(0)
881
271
Capital expenditure (CapEx) is the amount of money invested by a business in the acquisition, maintenance, and improvement of fixed…

Schedules Templates in Excel

Types of Schedules

Supporting schedules is a section in a financial model used to break down the more complex calculations such as the monthly or yearly interest and depreciation expenses. Below are some of the common types of schedules financial analysts would build to produce more accurate figures:

Debt schedule

A debt schedule lists all of the debt a business currently has and they are usually ordered according to maturity. The main purpose of a debt schedule is to determine:

  • Interest expenses which flow into the income statement
  • Closing debt balances which are shown on the balance sheet
  • Principal repayments which flow into the cash flow statement in the financing activities section

Property plant and equipment schedule or depreciation schedule

A PP&E schedule, sometimes referred to as depreciation schedule, allows financial analysts to track and forecast the value of a company’s fixed assets, capital expenditures, and depreciation expenses. The formula for calculating net PP&E is:

Net PP&E = Gross PP&E + Capital Expenditure – Accumulated Depreciation