Snasui Excel Forum

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

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

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