Overview

General overview

 

The template is constructed to calculate the credit sales for all industries but mainly used for cars, light and heavy equipment

 

The template helps the user to calculate the interest on the financing amount (selling price – down payment)

 

This model is very simple to use by simply recording the down payment and interest on credit sales as well as financing period

The template is fully-editable / customizable model

Inputs

 

Update the general info in the Front Page

Enter the selling price

Enter the current year

Select the month

Enter the down payment %

Enter the interest rate per annum

Select the financing period

 

Outcome             

 

Interest amount by month

Total interest

Monthly payment

Loan balance every month

 

If you have any inquiry please contact us

Tags
Reviews Add a review
No reviews yet

More From ECF Consultancy

Browse our top rated business templates. See All
Financial Reporting Checklist Excel Template
136
0
 Looking for a working checklist that you can use as a template when conducting a financial report? If you are,…
Balance Confirmation
191
2
 Download balance confirmation letter 
Executive Financial Summary Excel with Power Point Template
239
0
 Overview The template provides a short financial description of the business that allow the reader to understand the highlights of…
Payback Period
452
20
 What is payback period? The payback period helps to determine the length of time required to recover the initial cash…
Authority Matrix Excel Template
478
0
 Authorities and Responsibilities Matrices   Authorities and Responsibilities Matrices are considered important to organizations due to their role in identifying…
WACC Calculator
1,104
104
The free excel template help the user to calculates the weighted average cost of capital for the long-term funding used…
See All