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 Property Plant and Equipment Schedule Template
(0)
16,053
1397
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 Capital Expenditure (CapEx) Excel Calculator
(0)
14,354
1360
Capital expenditure (CapEx) is the amount of money invested by a business in the acquisition, maintenance, and improvement of fixed…
Loan Repayment scheduler Loan Repayment scheduler
(0)
8,453
638
This template help you plan your repayment of loan or debt.  
Amortization Schedule (Automatic) Amortization Schedule (Automatic)
(0)
7,862
454
An amortization calculator is used to determine the periodic payment amount due on a loan (typically a mortgage), based on the amortization process. The amortization repayment…
Dynamic Amortization Schedule Dynamic Amortization Schedule
(0)
6,866
291
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
Static Amortization Schedule Static Amortization Schedule
(0)
5,408
225
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
Loan Amortization Schedule in Microsoft Excel Loan Amortization Schedule in Microsoft Excel
(0)
6,185
58
 Loan Amortization Schedule in Microsoft Excel
Daily Raw Material Consumption Report Daily Raw Material Consumption Report
(0)
1,632
50
 This template can track the daily consumption of the raw materials on two plants. The template shows the opening stock, raw…
Gantt Scheduling: Man Hours Budgeting Included Gantt Scheduling: Man Hours Budgeting Included
(0)
3,302
1
This purchase comes with two separate and unique gantt schedules. Both are built in Google Sheets and the file you…
Project Timeplan - Excel Gantt Chart Project Timeplan - Excel Gantt Chart
(0)
4,040
1
- This sheet can create Gantt Chart time schedule easily.- This sheet is very good for small kinds of projects.-…
Excel Calendar Template Excel Calendar Template
(0)
547
0
An easy way to view the Calender in Months or in Years. You can also add the Holidays to be…
Scheduler Scheduler
(0)
1,497
0
 The XLDB Scheduler is just that. An easy to use but robust and comprehensive schedule manager all in Excel. You…
Routing Manager Routing Manager
(0)
1,345
0
The XLDB Routing Manager is an Excel Application designed to create work orders and optimise routing through to customer locations…
Dynamic Gantt Chart Excel Dynamic Gantt Chart Excel
(0)
1,294
0
  Data Sheet 1 There is First Column in "Data Sheet" name "Options" by selecting any cell you can add…
Excel Gantt Chart Excel Gantt Chart
(0)
2,205
0
This template contains the core functionality needed to create a simple Gantt chart easily. Each row of the worksheet represents…

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