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 48 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
Thanks for the timely response, appreciate it


tranoy

  • Member
  • Posts: 344
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

For a complete list of videos, visit our video library