Best Math Formula website. Search anything about Math Formula in this website.
mathematical formula for pmt function in excel. The formula in C10 will look like PMT C612 C7-C5. SO when I calculate this on excel for monthly Payments the formula goes like PMT6512 512 30000 -9000 459.
The PMT function below calculates the annual deposit. Cell B12 PPMTB1B2B3B4B2B5B6B7 PPMT00712243012165 00000 or Cell B13 B9-B11. And taking same philosophy or re-usability this is even simpler with usage of the PMT and IPMT functions.
You might note that the calculated nper is not exactly 360 in either case B6 and B7.
-PMTC30E31E32C33 and output will be 34674. Rate it the rate of the interest per period. Per - The period for which the interest rate is calculated. Pmt is the payment made each period.