Depreciation & Loan Amortization Schedules
Originally published: 26/02/2021 09:31
Last version published: 25/02/2022 09:32
Publication number: ELQ-65875-2
View all versions & Certificate

Depreciation & Loan Amortization Schedules

User friendly calculation tool for Depreciation & Loan Amortization Schedules

Professional Template for Depreciation & Amortization Calculations.

General Overview

Calculation of Fixed Assets depreciation using the 3 main depreciation Methods


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 it's 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)


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)

Template is easy customizable and suitable for any type of business / industry.

For any inquiry/modification, please contact me via private message.

This Best Practice includes
1 Excel Model

Acquire business license for $49.00

Add to cart

Add to bookmarks


Further information

Useful tool to assist users in calculating depreciation & amortization amounts, which are used on company's financial statements

Suitable for any kind of business

0.0 / 5 (0 votes)

please wait...