This preview shows pages 1–7. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: =pv(rate,nper,pmt,[fv],[type]) 11/14/10 4 Third important question If we buy an item today, what stream of payments would return the amount we spent today (Principal) and an acceptable interest rate? =pmt(rate,nper,pv,[fv],[type]) 11/14/10 5 Type? Ordinary annuity (Type = 0) when first payment is received at the end of the period. Annuity due (Type = 1) when first payment is received immediately. 11/14/10 6 Other important notes Rate= annual rate. Quarterly is rate/4 Monthly is rate/12 Daily is rate/365 Nper = number of periods If using quarterly rate take nper * 4 If using monthly rate take nper *12 If using daily rate take nper * 365 PV = current value or present value taking time value of money into consideration FV = future value taking time value of money into consideration 11/14/10 7...
View
Full
Document
This note was uploaded on 11/13/2010 for the course EMS 432 taught by Professor Johnson during the Spring '10 term at NMT.
 Spring '10
 Johnson

Click to edit the document details