Excel payment 
Total interest 6 years 

NUMBER  
Excel formula 
month #  end of month payment  interest paid that month  principal paid that month  loan balance  
Show byhand work 
1  already in #4  
Show byhand work 
2  already in #4  