Page 1 of 1
Loan schedule
Posted: Tue Nov 25, 2025 6:15 pm
by sna
Dear all,
I need your input to create loan schedule
Loan amt:120,000$
Interest rate :13% per year
Repayment date
start 01/11/08
Maturity date:30/11/2025
repay monthly and principal add interest as new balance then calculate interest and so on
Note do not need dynamic array formula
Thanks
Re: Loan schedule
Posted: Tue Nov 25, 2025 7:22 pm
by norkaz
Hi guy
To ensure clarity, could you please provide the criteria for the loan schedule formula that needs to be resolved?
Then, the formula will be created according to the specifications provided.
Bigcat9Excel
BKK Thailand
Re: Loan schedule
Posted: Tue Nov 25, 2025 8:47 pm
by sna
Loan compounding it means include principal n interest for base of calculate interest
Mth 1:120,000 *13%÷12=1300 interest
Mth 2:121,300*13%÷12=1,304.08 interest
Mth 3:122,604.08*13%÷12=1,328.21
.....
So format
Date principal interest total
Re: Loan schedule
Posted: Wed Nov 26, 2025 1:35 pm
by norkaz
...
Hi Guy, I’m not completely sure I understood your question, but I’ve tried to solve the problem based on the details you attached.
C2
=B2*$F$1/12
D2
=B2+C2
F1 = interest rate per year
Bigcat9Excel
BKK Thailand
Re: Loan schedule
Posted: Fri Nov 28, 2025 10:05 pm
by sna
Thanks i come up with FV