Let's invest money...

Description
This template will help you to calculate the information about the interest and time you will pay when you withdraw money from the bank in the month and year according to the time you will specify.

You write down the amount of credit you want to receive in the Loan Investment table.

Then you should enter the interest rate applied by the bank, option either you pay interest at the beginning or end of each month, the loan period as a year, the number of payments per year and the date you will pay the first.

The table automatically calculates the monthly interest amount in the Install Amount line with the help of Excel PMT Function which you'll required to pay.

You can know the total interest amount you will pay in the Total Interest Paid line.

In the next table, the total number of payments is automatically and dynamically calculated with the Sequence function in accordance with the number of credit years you will show in the previous table.

In the first row of the date column, the payment date shown in the previous table is copied by reference. In the next rows of the date column, the first days of the next payment months are written with the EDate function.

Then, the total payment, interest and principal payments are written in order.

You may see interest payment amounts on monthly and yearly basis in next tables.

I have also written all the formulas with the help of Formulatext Function in the last column.

Good Luck!