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 106 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


jomama

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

For a complete list of videos, visit our video library