DO LOOP: HOW to create EMI calculator

[MikeZdeb]

Hi, you changed it and that's the incorrect answer, yes/no?  My principle and interest represent the portion of the monthly payemt that goes to paying down thiose two amounts.  If you add up the principle column it sums to $100,000 ... the amount of the loan.

[Reeza]

I only changed the function from ppmt to finance with PPMT option, since the PPMT generated an error for me. Maybe the order of the parameters changed? No other changes. I was expecting the same output you displayed.