✅ Calculate the simple interest and know the main concepts, as well as an automatic amortization table for different periods 6,12,18 and 24 months.
Today we are going to make a simple interest amortization table, I will explain step by step the creation of the table, as well as functionality and main concepts, we will start from an unpaid balance, periods, capital and everything that includes interest, this will help us to have an automatic calculation and determine the total interest to pay.
#Excel #LoganExcel #Finance #Interest
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ I calculate interest Credit Card • Como calcular el inter...
✅ Compare Rates • Tabla de amortización ...
⏱️ Timestamps ⏱️
00:34 Amortization table with simple interest
01:30 Structure of the amortization table
02:09 Concepts and simple interest formula
02:55 Calculate simple interest in Excel
06:44 Automate the calculation of interest by periods
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.wordpress.com/
🔹Instagram instagram.com/loganexcel/...
Негізгі бет How to make a simple interest amortization table in Excel, calculate simple interest in Excel
Пікірлер: 19