MS-Excel-Financial-Functions

MS-Excel-Financial-Functions - MS-Excel Financial...

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

View Full Document Right Arrow Icon
MS-Excel Financial Functions, Related to Interest Factor Formulas in MSci 261 (D. Fuller, January 2006) From MS-Excel Help, for the functions PV, PMT, FV, RATE, or NPER, the following equation is solved for one of these values, given the other values. pv* (1 + rate ) nper + pmt (1 + rate* type )* 0 1 ) 1 ( = + + fv rate rate nper Translated into the symbols of the textbook, P = pv , A = pmt , F = fv , i = rate , N = nper and with type =0 , the equation is: 0 1 ) 1 ( ) 1 ( = + + + + F i i A i P N N , or, using interest factor symbols P ( F/P,i,N ) + A ( F/A,i,N ) + F = 0. Let’s look at the case when F =0. Suppose we know the values for A, i and N , and we want to find an equivalent value for P , using MS-Excel. Then select the PV function (it will return a value of pv = P ), and supply the known values for A, i and N in the proper positions in the argument list (see MS-Excel help for the order of the arguments). (You can leave out the last two arguments, which are for F and type ; by leaving them out, MS-Excel assumes that these
Background image of page 1

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

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

This note was uploaded on 04/01/2012 for the course MSCI 261 taught by Professor Bonkoo during the Winter '09 term at Waterloo.

Page1 / 2

MS-Excel-Financial-Functions - MS-Excel Financial...

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