Computer_lab_1

# Computer_lab_1 - SINGLE CASH FLOW Present Value Problem...

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

Present Value Inputs Single Cash Flow Discount Rate / Period Number of Periods Present Value using the Formula Present Value Present Value using the PV Function Present Value S INGLE C ASH F LOW Problem: Your company has told you that you if you remain employed with them, you will receive a \$50,000 bonus four years from today. Assume a discount rate of 8%. Fill in this spreadsheet, calculating the present value in two different ways.

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

View Full Document
Present Value Inputs Payment Discount Rate / Period Number of Periods Annuity Present Value using a Time Line Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Cash Flows Present Value of Each Cash Flow Present Value Annuity Present Value using the PV Function Present Value Compare PV to: Lump sum option Dif erence (Annuity PV - Lump sum) A NNUITY Problem: Kenny Dukes, Lot ery Winner. Refer to the 1st newspaper article to answer the questions.
System of Four Annuity Variables Inputs Payment \$576.64 Discount Rate / Month

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.

{[ snackBarMessage ]}

### Page1 / 7

Computer_lab_1 - SINGLE CASH FLOW Present Value Problem...

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

View Full Document
Ask a homework question - tutors are online