Computer_lab_1

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

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
System of Four Annuity Variables Inputs Payment $576.64 Discount Rate / Month
Background image of page 3

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

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

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 Right Arrow Icon
Ask a homework question - tutors are online