How to calculate the EMI for Any loan in India│Excel PMT, IPMT, PPMT & PV Function in HINDI

How to calculate the EMI for Any loan in India│Excel PMT, IPMT, PPMT & PV Function in HINDI

A brief introduction of PMT, IPMT and PPMT Excel functions. or How to calculate the EMI on your loan. This below-mentioned Method of EMI Calculation on Excel is very simple and easy. *****Click below Link to Download sheet for Practice**** Link: https://drive.google.com/uc?export=do... *********MS Excel – PMT Function********* • In Excel, the PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule. • The syntax for the PMT function is: • PMT( interest_rate, number_payments, PV, [FV], [Type] ) • interest_rate is the interest rate for the loan. • number_payments is the number of payments for the loan. • PV is the present value or principal of the loan. • FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes an FV value of 0. • Type is optional. It indicates when the payments are due. Type can be one of the following values: • If the Type parameter is omitted, the PMT function assumes a Type value of 0. • Applies To: Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 • Type of Function: Worksheet function (WS) VBA function (VBA) *********MS Excel: IPMT Function********* • In Excel, the IPMT function returns the interest payment for an investment based on an interest rate and a constant payment schedule. • The syntax for the IPMT function is: • IPMT( interest_rate, period, number_payments, PV, [FV], [Type] ) • interest_rate is the interest rate for the investment. • the period is the period to calculate the interest rate. It must be a value between 1 and number_payments. • number_payments is the number of payments for the annuity. • PV is the present value of the payments. • FV is optional. It is the future value that you'd like the investment to be after all payments have been made. If this parameter is omitted, the IPMT function will assume an FV of 0. • Type is optional. It indicates when the payments are due. Type can be one of the following values: • If the Type parameter is omitted, the IPMT function assumes a Type value of 0. • Applies To: • Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 • Type of Function: • Worksheet function (WS) • VBA function (VBA) *********MS Excel: PPMT Function********* • In Excel, the PPMT function returns the payment on the principal for a particular payment based on an interest rate and a constant payment schedule. • The syntax for the PPMT function is: • PPMT( interest_rate, period, number_payments, PV, [FV], [Type] ) • interest_rate is the interest rate for the loan. • a period is a period used to determine how much principal has been repaid. A period must be a value between 1 and number_payments. • number_payments is the number of payments for the loan. • PV is the present value or principal of the loan. • FV is optional. It is the future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PPMT function assumes an FV value of 0. • Type is optional. It indicates when the payments are due. Type can be one of the following values: • If the Type parameter is omitted, the PPMT function assumes a Type value of 0. • Applies To: • Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 • Type of Function: • Worksheet function (WS) • VBA function (VBA) Work EMI calculator excel sheet with prepayment option EMI calculation formula with example loan calculator excel sheet free download EMI calculator in excel with moratorium period EMI principal and interest calculator breakup excel reducing balance loan calculator excel download ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें ! ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है। आप हमारे चैनल को Subscribe करे।    / @comtutor   फेसबुक पर पसंद करने के लिए क्लिक करें   / comtutor4u   ट्विटर पर फॉलो करने के लिए क्लिक करे   / comtutor4u