Interest on Credit Sales Calculator
Originally published: 26/10/2020 05:50
Publication number: ELQ-25190-1
View all versions & Certificate
certified

Interest on Credit Sales Calculator

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

Description
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 entering the down payment percent % and interest on credit sales as well as financing period, this model in mainly used by all industries related light and heavy equipment (trading and manufacturing) such as cars, trucks, generators, excavators, rollers, drilling machines, dumpers, and all heavy equipment related to construction and mining industries,

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

Conclusion and customization
This is a highly versatile, very sophisticated financial model template, and is also user-friendly.
If you have any inquiries, modification request or other requests of assistance to customize the model template for your business case please contact us here: https://www.eloquens.com/channel/ecorporatefinance

This Best Practice includes
Excel Template

ECF Consultancy offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Help the user to calculate the interest on credit sales


0.0 / 5 (0 votes)

please wait...