{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of chptr6 - Nbr of years Nbr of periods Interest rate...

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

View Full Document Right Arrow Icon
Nbr of years: 10 Period factor: 4 Nbr of periods: 40 << Result of Nbr of years X Period factor Interest rate: 8.00% =PV(Period Interest, Periods, Payments, Future value, Payme Period interest 2.00% << Result of Nbr of years / Period factor Present value: $100.00 Payments: $25.00 Future value: $1,000.00 Solve for present value of a single sum: =PV(B3/B4,B1*B4,0,B7,0) =PV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($452.89) Solve for present value of an ordinary annuity: =PV(B3/E1,B1*E1,B6,0) =PV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($683.89) Solve for present value of an annuity due: =PV(B3/E1,B1*E1,B6,1) =PV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($697.56) Present value of $1 for 10 periods at 8% =PV(B3,B1,0,1,0) =PV(8% interest, 10 periods, 0 payments, future value = $1, 0=payment at the end of the period) ($0.46)
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
ent at the beginning or the end of the period) pouding,Payments = 0, Future value = $1,000, , 0 - payment at the end of the period) pouding,$25 payments, 0 - payment at the end of the period) pouding,$25 payments, 1 - payment at the beginning of the period)
Background image of page 2
Nbr of years: 10 Period factor: 4 Nbr of periods: 40 << Result of Nbr of years X Period factor Interest rate: 8.00% =FV(Period Interest, Periods, Payments, Future value, Payme Period interest 2.00% << Result of Nbr of years / Period factor Present value: $100.00 Payments: $25.00 Future value: $1,000.00 Solve for Future value of a single sum: =FV(B3/B4,B1*B4,0,B7,0) =FV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($220.80) Solve for Future value of an ordinary annuity: =FV(B3/E1,B1*E1,B6,0) =FV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($1,510.05) Solve for Future value of an annuity due: =FV(B3/E1,B1*E1,B6,1) =FV(2% Period interest = 8% / 4 quarterly compounding events,40 periods = 10 years X quarterly comp ($1,540.25) Future value of $1 for 10 periods at 8% =FV(B3,B1,0,1,0) =FV(8% interest, 10 periods, 0 payments, future value = $1, 0=payment at the end of the period) ($2.16)
Background image of page 3

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

View Full Document Right Arrow Icon
ent at the beginning or the end of the period) pouding,Payments = 0, Future value = $1,000, , 0 - payment at the end of the period) pouding,$25 payments, 0 - payment at the end of the period) pouding,$25 payments, 1 - payment at the beginning of the period)
Background image of page 4
40 << Enter the life of the bond in years. The maximum is 40 years. s << Is the bond a semi-annual payment bond - Enter the letter S, or an annual paym 7.00% << Enter the annual face or stated interest rate of the bond. 6.00% << Enter the annual market, effective, or yield rate of the bond.
Background image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '09
  • KAAS
  • $7,999.49 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72, $10,000,000.00 3.50

{[ snackBarMessage ]}