Create a loan table based on the borrowed capital

An Excel file is created to create a table for loans to calculate the interest due and the interest after deducting the total monthly payment required to compensate for the borrowed capital + if any amount is added with the interest payment, it will become clear to you how much you will pay and how much you will save.