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]
Similar Products
Other customers were also interested in...
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
General Financial Models – All-in-One Bundle
A collection of templates suitable for various types of businesses/industries, covering major accoun... Read more
Leveraged Buyout (LBO) Financial Model
Advanced Financial Model presenting a potential acquisition of a public or private company using a s... Read more
Budgeting & Forecasting Model Template
Budgeting & Forecasting Template suitable for either a Trade or Service company in any type of i... Read more
From Trial Balance to Business Valuation – M...
Management Accounts Template, providing full reporting cycle and mapping between accounting and fina... Read more
Annual Operating Plan – Actual vs Budget Tem...
User friendly template enabling user to prepare an operating budget to project company’s performan... Read more
Inventory Management – Control and Tracking ...
This highly-sophisticated and user-friendly Inventory Management & Tracking Template is suitable... Read more
Amortization Schedules Template (Loans, Mortgages,...
User friendly template including Amortization Schedules for Loans, Mortgages, Operating and Finance ... Read more
Cap Tables & Investor Returns Model
User-friendly Cap Table Model for a startup company or early-stage venture including multiple rounds... Read more
You must log in to submit a review.