Depreciation and Loan Amortization Schedules

Professional calculation tool for 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 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]

You must log in to submit a review.