Depreciation and Loan Amortization Schedules

All Industries, Financial Model, General Excel Financial Models

Accounting, Amortization, Budget, Debt Amortization, Debt Schedule, Financial Modeling, Financial Planning, Financial Reporting, Financial Statements, Interest Accrual

Professional Template for Depreciation & Amortization Calculations.

General Overview

Depreciation:
Calculation of Fixed Assets depreciation using the 3 main depreciation Methods

Inputs:

Update Gray Fill – Blue Font Cells
Price: Fill in the purchase price of each Asset Category
Purchase Year: Fill in the year the asset was originally purchased
Salvage Value: Fill in the estimated amount of the asset and the end of its useful life.
Useful Life: Fill in the estimated years the asset will remain in service

Select the desired Depreciation Method from the Drop-Down List
SL: Straight-Line Depreciation
SYD: Sum-of-Years’ Digits
DDB: Double Declining Balance

Loan Amortization:
Calculation of Amortization Schedule, using 6 different payment frequency scenarios (Annual, Semi-Annual, Quarterly, Bi-Monthly, Monthly)

Inputs:

Loan Amount: Fill in the total amount of the Loan
Annual Interest Rate: Fill in the Annual Rate (%)
Term of Loan in Years; Fill in the duration of the loan in years
First Payment Date: Fill in the first payment date of the loan
Payment Frequency: Select payment frequency from the drop-down list (Annual, Semi-annual, Quarterly, Bi-monthly, Monthly)

The template is easily customizable and suitable for any type of business/industry.

For any inquiry/modification, please contact me via: [email protected]