Loan, Interest, EMI etc. Calculation
General Names Formula Names
Interest Rate 10% Rate
Loan Amount 10,00,000 P.V (Principal Value)
Duration In Months 'N' (no. of periods)
=PMT() (payment terms)
This function calculate the EMI value per month.
Syntax: =PMT(rate, nper, pv, [fv], [type])
Ex:
=IPMT() (interest in payment terms)
This function calculate only the interest part of one month.
Syntax: =IPMT(rate, per, nper, pv, [fv], [type])
=PPMT() (interest in payment terms)
This function calculate only the principal value of one month.
Syntax: =IPMT(rate, per, nper, pv, [fv], [type])
Fomula:
=IPMT() >> =IPMT(10%/12,A2,10,-100000)
=PPMT() >> =PPMT(10%/12,A2,10,-100000)
=PV()
This function calculate the loan amount from the EMI value.
Syntax: =PV(rate, nper, pmt, [fv], [type])
Ex: If a person capable to pay Rs. 10500 monthly with 10% int. rate so, what is his loan amount for 5 years.
=FV()
This function calculate the future value of the amount saving.
Syntax: =FV(rate, nper, pmt, [fv], [type])
Ex: If you save money Rs. 500 every month and receive int. 8% for 2 years so after 2 years value = ?
Depreciation