Ravi Sir's Cards › Excel
Compare Personal Loan Offers in Excel (card 1 of 2)
Revision card 1 for Compare Personal Loan Offers in Excel: Monthly EMI: =PMT(B6/12,B7*12,-B5) gives ₹10,746.95; Total of all EMIs: =B9*B7*12 gives ₹6,44,817; Total interest: =B10-B5 gives ₹1,44,817.
Read card text
What this card says
1 for Compare Personal Loan Offers in Excel: Monthly EMI: =PMT(B6/12,B7*12,-B5) gives ₹10,746.95
Total of all EMIs: =B9*B7*12 gives ₹6,44,817
Total interest: =B10-B5 gives ₹1,44,817.
Learn this in the lesson: Compare Personal Loan Offers in Excel: EMI, Total Interest, Processing Fee and the Cheapest Loan