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.
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.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.