5. Fill out EAR and EPR by using EFFECT, NOMINAL

6. Fill out range Payment, Interest Component, Principal component, Outstanding Balance, Total paid over life of loan and Total interest paid over life of loand by using VLOOKUP, PMT, IPMT, PPMT

7. Fill out the amortization table

PLEASE ANSWER WITH EXCEL AND SHOW STEPS

Use Scroll bar to choose a particular period below: Use Scroll bar to choose a particular period below