Ch_02_Annuity - Flow Period Discount Rate Per using the...

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

View Full Document Right Arrow Icon
Present Value and System of Four Annuity Variables Inputs Payment $80.00 8 Discount Rate / Period 6.0% 6 Number of Periods 5 5 Present Value $336.99 6 Annuity Present Value using a Time Line 0 Period $0.00 1 2 3 4 5 Cash Flows $0.00 $80.00 $80.00 $80.00 $80.00 $80.00 Present Value of Each Cash Flow $0.00 $75.47 $71.20 $67.17 $63.37 $59.78 Present Value $336.99 Annuity Present Value using the Formula Present Value 336.99 Annuity Present Value using the PV Function Present Value $337 Payment Payment using the Formula $80.00 Payment using the PMT Function $80.00 Discount Rate / Period A NNUITY $0.00 $1.00 $2.00 $3.00 $4.00 $5.00 $0.00 $50.00 $100.00 Annuity Cash Flows Present Value of Each Cash
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
Background image of page 2
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
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Flow Period Discount Rate / Per using the RATE Func 6% Number of Periods Num of Periods using the NPER Function 5 Future Value Inputs Payment $80.00 8 Discount Rate / Period 6.0% 6 Number of Periods 5 5 Annuity Future Value using a Time Line Period 0 1 2 3 4 Cash Flows $0.00 $80.00 $80.00 $80.00 $80.00 Future Value of Each Cash Flow $0.00 $101.00 $95.28 $89.89 $84.80 Future Value Annuity Future Value using the Formula Future Value $450.97 Annuity Future Value using the FV Function Future Value $450.97 A NNUITY 0 1 2 $0.00 $50.00 $100.00 Ann Pe 5 $80.00 $80.00 $450.97 3 4 5 nuity Cash Flows Future Value of Each Cash Flow eriod...
View Full Document

{[ snackBarMessage ]}

Page1 / 4

Ch_02_Annuity - Flow Period Discount Rate Per using the...

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

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