time value of money

# time value of money - =pv(rate,nper,pmt,[fv],[type])...

This preview shows pages 1–7. Sign up to view the full content.

11/14/10 1 A quick tour of the time value of money

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

View Full Document
11/14/10 2 Theory: We would rather have a dollar today than have a promise of a dollar in the future If we have the dollar today, we can invest it and get back more next year. If we wait a year to get the dollar, there is some risk that we won’t receive the dollar. We have some preference for current consumption.
Identifying the correct question 1. Do you want to know what a single amount is worth in the future? =fv(rate, nper,pmt ,[pv ],[type]) 2. Do you want to know what a series of payments (annuities) is worth in the future? =fv(rate, nper, pmt ,[pv],[type]) 11/14/10 3

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

View Full Document
Question often used in accounting What is the current or present value of a single amount (FV) to be received in the future? =pv(rate,nper,pmt,[fv],[type]) What is the current or present value of a series of payments (annuities) to be received in the future?

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

View Full Document
This is the end of the preview. Sign up to access the rest of the 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.

### Page1 / 7

time value of money - =pv(rate,nper,pmt,[fv],[type])...

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

View Full Document
Ask a homework question - tutors are online