Promotion for September Only: Our most popular Stream, the Digital Transformation Stream, is discounted by $100.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


BENEFITS OF DOCUMENT

  1. Assist users in calculating depreciation & amortization amounts, which are used on company's financial statements
  2. Template is suitable for any kind of business

DOCUMENT DESCRIPTION

Professional Template for Depreciation & Amortization Calculations.

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.

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Depreciation & Loan Amortization Schedules Excel document

 

Depreciation & Loan Amortization Schedules

Sold by GL Consulting (this author has 49 documents)

$49.00

ALL FEES INCLUDED
Add to Cart
  

This business document is categorized under the function(s):

It applies to All Industries

File Type: Excel (xlsx)

File Size: 3 MB

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): May 2, 2021
Most recent version published: May 3, 2021

Ask the Author a Question

Must be logged in Click here to log in



This document is available as part of the following discounted bundle(s):


All-in-One General Financial Models

$350.00

This bundle contains 8 additional documents.

View Full Details

Excel workbook
$69.00
Author:
Excel workbook
$59.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$69.00
Author:
Excel workbook
$59.00
Author:
Excel workbook
$69.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$39.00
Author:




CUSTOMER TESTIMONIALS




SELECT CUSTOMERS

Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.



Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.



CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

Excel workbook
$109.00
5-page Word document and supporting Word
$29.00
133-slide PowerPoint deck
$179.99
63-slide PowerPoint deck
$49.00
Author: LearnPPT
Excel workbook
$40.00
Author: giovanni
89-slide PowerPoint deck
$49.00
Author: STRATICX
28-slide PowerPoint deck
$29.00
Author: STRATICX
Excel workbook
$109.99
104-slide PowerPoint deck and supporting Excel workbook
$69.00
56-slide PowerPoint deck
$49.00
Author: STRATICX
Excel workbook
$20.00
Author: officehelp

 
RELATED TOPICS

TOP 10 TOPICS

Become your organization's resident expert on...

Digital Transformation
 
Strategy Development
 
Organizational Design (OD)
 
Performance Management
 
Post-merger Integration (PMI)
 
Business Transformation
 
Customer-centric Design (CCD)
 
Organizational Culture (OC)
Interested in something else? Browse our 350+ Business Toolkits of best practices, each focused on a specific management topic.