Site icon UK Essayz

Calculating the annual loan payment

Use Excel –  Must demonstrate your detailed calculations by embedding the formulas/functions in the cells 

 Problems are on pages (CHPT 11) 36&37 & CHPT 15 (21) attached 
 Chapter 11, Problem 2
When calculating the annual loan payment, solve using monthly compounding, then multiply that number by 12 months to get the annual amount for use in the remaining calculations.

Chapter 11, Problem 5
Chapter 15, Problem 1
Chapter 15, Problem 2