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, Paym 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 DocumentRight 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 DocumentRight 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%
Background image of page 5

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

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

This note was uploaded on 06/22/2009 for the course ACCOUNTING 3 taught by Professor Kaas during the Spring '09 term at CUNY Brooklyn.

Page1 / 28

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

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

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