Monthly loan drawdown schedule

[fkhan123]

Hello,

I am struggling to calculate repayment on a loan with a monthly drawdown. For each month the value of the loan changes . Below is an example. Grateful if someone has an idea on how monthly payment on this can be calculated

Term	20​
Interest rate	4.00%​
Payments per year	12​
Debt Drawdown		1/31/2022​	2/28/2022​	3/31/2022​	4/30/2022​	5/31/2022​	6/30/2022​	7/31/2022​
Monthly		10,063,383	11,720,366	13,277,077	14,629,447	15,678,969	16,344,486	16,572,544
Total		10,063,383	21,783,749	35,060,826	49,690,273	65,369,242	81,713,728	98,286,272

 

[BigBeachBananas]

Book1
	A	B
1	Term	20
2	Interest rate	4.00%
3	Payments per year	12
4	Principal	10,063,383
5	Monthly Payments	($60,982)
Sheet2

Cell Formulas
Range	Formula
B5	B5	=PMT(B2/B3,B1*B3,B4,0,0)