📊 Excel PMT Function (Loan EMI Calculation)

🔹 PMT Function क्या है?

👉 PMT Function Excel में loan की EMI (monthly payment) निकालने के लिए use होता है।

👉 आसान भाषा में:
“Loan की हर महीने कितनी किस्त (EMI) देनी होगी — यह PMT function बताता है।”

🧾 Syntax (Formula Structure)

=PMT(rate, nper, pv, [fv], [type])

📌 मतलब:

• rate → Interest rate (monthly)
• nper → Total months (loan period)
• pv → Loan amount (present value)
• fv → Future value (optional, usually 0)
• type → 0 = end of month (default), 1 = beginning

📊 Example (Loan EMI Calculation)

👉 मान लो:

• Loan = ₹1,00,000
• Interest Rate = 12% yearly
• Time = 2 साल (24 months)

✅ Formula

=PMT(12%/12, 24, -100000)

👉 Result: ₹4,707 (approx EMI)

💡 Important समझ

✔ Interest rate को monthly (rate/12) करना जरूरी है
✔ Loan amount को negative (-) लिखते हैं
✔ Result EMI (monthly payment) में आता है

🔥 Real Life Use

✔ Bank loan EMI calculation
✔ Home loan / Car loan
✔ Business finance planning
✔ Personal loan analysis

⚠️ Common Mistakes

❌ Rate को yearly ही डाल देना
❌ महीनों की जगह साल डाल देना
❌ Negative sign भूल जाना

📝 Short Exam Line

👉 “PMT function का उपयोग Excel में loan की EMI (monthly payment) निकालने के लिए किया जाता है।”