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.

This note was uploaded on 01/13/2012 for the course MMBIO 361 taught by Professor Bernard during the Fall '11 term at BYU.

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