Write down the following formula. =F5-D6 Press Enter to apply the formula. Drag the Fill Handle icon down the column. Get the actual values of interest and principal in EMI. The remaining loan amount should be zero, which implies that the calculation is correct. It produces a calculator....
Select cellH11and enter the following formula: =IFERROR(IF(B11="","",E11+F11),"") PressEnterto calculate the total payment of the first transaction. For now, the cell is empty because the cell references that the formula used is empty. Breakdown of the Formula IFERROR(IF(B11=””,...
To calculate the EMI in the first month, select cell C6. To calculate the EMI, enter the formula using the ABS and PMT functions. =ABS(PMT($I$7,$I$6,$F$5,0,0)) Press Enter to apply the formula. You need to have the same EMI for every value. So, if you look at the formul...