Overview

Hi there,
With this Excel Template, you will be able to easily calculate the interest amounts you will pay or earn when you receive a loan from the Bank or deposit money in return for interest.
You will be able to reach the result by changing the different periods, interest amounts, some factors of payment terms at the beginning or end of the month.
Functions such as Edate, Sequence, PMT, IPMT, PPMT are used in the template.

Good luck...

 

Reviews Add a review
Qafur

I recommend this template to those who wants to invest money or to borrow money as credit. It helps to calculate the revenue. Well-done. Thanks.

More From Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
1,940
224
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
1,777
199
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
1,802
189
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
HR INSIGHTS DASHBOARD
4,700
130
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
4,824
113
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
5,215
181
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
See All