FINA4920-TVMSummary

FINA4920-TVMSummary - PVlump sum=FV11 rt FVlump sum=PV1 rt...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
FINA 4920 Time Value of Money Summary Sheet = + PVlump sum FV11 rt = + FVlump sum PV1 rt = - rlump sum FVPV1t 1 = + tlump sum lnFVPVln1 r = - + PVannuity Pmt1 11 rtr = + - FVannuity Pmt1 rt 1r = - + - Pmtannuity PV1 11 rtr 1 = + - - Pmtannuity FV1 rt 1r 1 = - * + tannuity lnPmtPmt r PVln1 r = + * + tannuity lnPmt r FVPmtln1 r = PVperpetuity Pmtr = + - EAR 1 APRmm 1 = + - APR m1 EAR1m 1 = - EARcontinuous compounding eAPR 1 = FVcontinuous compounding PVert = - PVcontinuous compounding FVe rt = tcontinuous compounding lnFVPVr = rcontinuous compounding lnFVPVt = + + + + + + + …+ + = = ( + ) NPV CF0 CF11 r1 CF21 r2 CF31 r3 CFn1 rn t 0nCFt 1 r t = + + + + + + + …+ + = = + IRR CF0 CF11 IRR1 CF21 IRR2 CF31 IRR3 CFn1 IRRn t 0nCFt1 IRRt = = = + PI PV of inflowsPV of outflows t 1nCFt1 rtCF0 PURPOSE FUNCTION CALL NAME, SYNTAX,   ARGUMENTS PRESENT VALUE =PV(RATE, NPER, PMT, FV, type) FUTURE VALUE =FV(RATE, NPER, PMT, PV, type) PAYMENT =PMT(RATE, NPER, PV, FV, type) NUMBER OF PERIODS FOR AN INVESTMENT
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

FINA4920-TVMSummary - PVlump sum=FV11 rt FVlump sum=PV1 rt...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online