Depreciation & Loan Amortization Schedules
Originally published: 26/02/2021 09:31
Publication number: ELQ-65875-1
View all versions & Certificate
certified

Depreciation & Loan Amortization Schedules

User friendly calculation tool for Depreciation & Loan Amortization Schedules

Description
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.

This Best Practice includes
1 Excel Model

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

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

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from GL Consulting

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Depreciation & Loan Amortization Schedules?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...