D20 2 fx B C D E F G 3 This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest 4 portion of a loan payment at any given point in time. Be sure to use cell references. 5 6 Initial Balance 7 Annual Interest Rate 8 Years 9 Annual Payemnt 10 11 Summary loan data for year 12 13 Balance at start of year 14 Balance at end of year 15 Interest paid during the year 16 Principle paid during the year 17 18 19 20 $ 10,000.00 10% $1,627.45 10 Insert a spinner to change the year. 4 Creating spinners is discussed in the first Excel exercise for chapter 6. A B 1 Amortization Table - Breaking Do 2