I am trying to input the interest cost of a loan in a different chart using 3 different scenarios. Each scenarios has a time frame (years) and an interest rate. By example I have a 13 years project, i owe the bank 100 000$. For the first term I have a 4 years at 3.00% fixed rate. In 4 years i'll have a 5 years 3.75% and nine years later a 4.00% for 4 years.
Years Rate Loan Left Interest Paid during year 1 Interest Paid during year 2 Interest Paid during year 3 Interest Paid during year 4 Interest Paid during year 5
First Term 4 3.00% 91 235$ 2953$ 2890$ 2824$ 2757$ (empty cell)
Second Term 5 3.75% 79 791$ 3359$ 3279$ 3195$ 3109$ 3019$
Third Term 4 4.00% 69 232$ 3120$ 3020$ 2916$ 2807$ (empty cell)
How it should look.
Year Cost of Interest
1 2953$
2 2890$
3 2824$
4 2757$
5 3359$
6 3279$
7 3195$
8 3109$
9 3019$
10 3120$
11 3020$
12 2916$
13 2807$
Bookmarks