{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of chptr6

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

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

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)

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

View Full Document
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)
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)

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

View Full Document
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)
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.

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.
• 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 ]}