Page 56 - COMPUTER
P. 56
FINANCIAL FUNCTIONS
=PMT:IT`S CALLCULATE EMI(INSTALLMENT).
=IPMT: IT’S CALLCULATE INTEREST.
=PPMT: IT`S CALLCULATE PRINCIPAL .
A B C
1 RATE : PERSENTTAGE 2%
OF INTEREST
2 NPER:NUMBER OF 2 YEARS
PEROID
3 PV :PRESENT VALUE 100000 /=
4 FV (FUTURE VALUE )
=PMT(RATE/12,NPER*12,PV)
=PMT(B1/12,B2/12,B3)
=IPMT(RATE/12, JIS MONTH KI NIKALNI HAI,NPER*12,PV)
=IPMT(B1/12,1,B2*12,B3)
=PPMT(RATE/12,JIS MONTH KI NIKALNI HAI,NPER*12,PV)
=PPMT(B1/12,1,B2*12,B3)
FOR FUTURE VALUE
=FV(RATE/12,NPER*12,-PV)
=FV(B1/12,B2*12,-B3)
55
