Depreciation & Loan Amortization Schedules

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 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)

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)

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

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