Use Scroll bar to choose a particular period below: 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 Use Scroll bar to choose a particular period below: 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