Working with Formulas and Functions: Creating a Loan Payment Schedule

Excel techniques used:

• Copy and paste formulas
• Use Auto Fill to insert formulas and complete a series
• Chang the zoom magnification of the workbook window
• Use relative and absolute references
• Use the Sum funciton
  
• Use the PMT function
• Use the PPMT function
• Use the IPMT function

(Zoom in by clicking the pictures)