Amortization Table - Breaking Down Your Payment- No vided 3 This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the 4 principle/interest portion of a loan payment at any given point in time. Be sure to use cell references 6 Initial Balance $ 10,000.00 7 Annual Interest Rate 8 Years 10% 10 Annual Payemnt Summary loan data for year 13 Balance at start of year 14 Balance at end of year 15 Interest paid during the year 16 Principle paid during the year