Ravi Sir's Cards › Excel
Home Loan EMI in Excel (card 1 of 2)
Revision card 1 for Home Loan EMI in Excel: Monthly EMI: =PMT(B5/12,B6*12,-B4) gives ₹21,695.58; Total of all EMIs: =B8*B9 gives ₹52,06,939; Total interest: =B10-B4 gives ₹27,06,939.
Read card text
What this card says
1 for Home Loan EMI in Excel: Monthly EMI: =PMT(B5/12,B6*12,-B4) gives ₹21,695.58
Total of all EMIs: =B8*B9 gives ₹52,06,939
Total interest: =B10-B4 gives ₹27,06,939.
Learn this in the lesson: How to Calculate Home Loan EMI in Excel with PMT (and Make a Month-by-Month Repayment Schedule)