Snasui Excel Forum

Hi dear

I got some problem with schedule calculation.
The balance at last period should be zero.
Why in this case it got minus balance?

Best wishes

I also attached a template.the error in sheet 02

Try with these formulas.

1. D7
   =PPMT(D$4,$A7,$E$4,-$C$4)
   Enter > Copy down
2. E7
   =IPMT(D$4,$A7,$E$4,-$C$4)
   Enter > Copy down
3. G7
   =$C$4-SUM(D$7:D7)
   Enter > Copy down