This topic contains a solution. Click here to go to the answer

Author Question: After winning the lottery, you state that you are indifferent between receiving twenty 500,000 ... (Read 75 times)

luminitza

  • Hero Member
  • *****
  • Posts: 555
After winning the lottery, you state that you are indifferent between receiving twenty 500,000 end-of-the-year payments (first payment one year from today), or a lump sum of 5,734,961 today.
 
  What interest rate are you using in your decision-making process such that you are indifferent between the two choices?
  A) 5.00
  B) 6.00
  C) 7.00
  D) 8.00

Question 2

You have won the lottery and received a check for 1,275,156 today. You invest the lottery check today at an annual interest rate of 8 and allow it to build for a full ten years.
 
  At that point in time, you shift the money to an account paying only 6 per year. You plan to spend 175,000 per year in retirement (assume equal annual end-of-the-year cash flows) for 30 years, and your first retirement cash flow is exactly eleven years from today. Will you have enough money to fully fund your desired retirement? Use a calculator to determine your answer.
  A) Yes, because your investment will allow you to spend up to 225,000 per year in retirement.
  B) No, because your investment will allow you to spend up to only 158,000 per year in retirement.
  C) Yes, because your investment will allow you to spend up to 200,000 per year in retirement.
  D) No, because your investment will allow you to spend up to only 137,000 per year in retirement.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

potomatos

  • Sr. Member
  • ****
  • Posts: 338
Answer to Question 1

Answer: B
Explanation: B) This is an iterative process (trial and error). Solve using the RATE function in Excel.
MODE = END
INPUT 20 ? -5,734,961 500,000 0
KEY N I/Y PV PMT FV
CPT 6.00

Answer to Question 2

Answer: C
Explanation: C) Calculator Solution for money you will have at the end of 10 years:
MODE = END
INPUT 10 8.0 -1,275,156 0 ?
KEY N I/Y PV PMT FV
CPT 2,752,966.16

Calculator solution for the (present value of) the money you need at the end of 10 years:
MODE = END
INPUT 30 6.0 2,752,966.16 ? 0
KEY N I/Y PV PMT FV
CPT 200,000




luminitza

  • Member
  • Posts: 555
Reply 2 on: Jul 10, 2018
Excellent


TheDev123

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

For a complete list of videos, visit our video library