How To Use PMT IPMT & PPMT Formula in Excel (EMI Calculate Kaise Karen)
HOW TO USE PMT, IPMT & PPMT FORMULA ? LOAN AMOUNT 1000000 YEAR 5.076345471 Month Interest Principal Total MONTH 60.91614565 1 Rs. -10,000.00 Rs. -12,000.00 Rs. -22,000.00 AIR 12% 2 Rs. -9,880.00 Rs. -12,120.00 Rs. -22,000.00 MIR 1% 3 Rs. -9,758.80 Rs. -12,241.20 Rs. -22,000.00 EMI ($22,000.00) 4 Rs. -9,636.39 Rs. -12,363.61 Rs. -22,000.00 5 Rs. -9,512.75 Rs. -12,487.25 Rs. -22,000.00 6 Rs. -9,387.88 Rs. -12,612.12 Rs. -22,000.00 USE GOAL SEAK TO CHANGE THE VALUE AND PERIOD 7 Rs. -9,261.76 Rs. -12,738.24 Rs. -22,000.00 NOTE : GO TO DATA TAB, CLICK ON WHAT IF ANALYSIS 8 Rs. -9,134.38 Rs. -12,865.62 Rs. -22,000.00 AND CHOOSE GOAL SEAK THEN DIALOGUE BOX WILL 9 ...