Loan schedule

[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

[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

[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

[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