Question

In: Finance

The Lopez family has come to you for advice on life insurance cover to protect their...

The Lopez family has come to you for advice on life insurance cover to protect their family. Sanjay Lopez, aged 40, is a plumber and his wife, Sarah, aged 35, is a hairdresser. Both work full-time. They have two children: Linda, aged two (2), and Jasper, aged four (4).

Sanjay earns $45,000 and Sarah earn $20,000 and they currently only save $100 per month.

  1. If Sanjay was to die, Sarah wants to provide monthly income of $4,500 to their family during the dependency period of their children until the youngest reaches age 18. However, when the youngest child has reached age 18, Sarah would then like to cover $3,250 per month for her life expectancy (age 85) to supplement her income.

Assuming an interest rate of 7% (compounded monthly), inflation at 1.5% (adjusted monthly), what is the total capital requirement needed for income for Sarah in the event of Sanjay’s death?

ALSO, assume Sarah would like this payment to begin at the start of each month from month 1.

Solutions

Expert Solution

Assumming that if Sanjay dies, savings of $100 per month will not be needed or practicable, we are focussing on 4500 per month savings only.

We must divide the entire period into two parts -

a) 16 years until Linda turns 18

b) 34 years when Sarah turns 85.

All the payments are assumed to bade made at the beginning of each month from the beginning of month 1 means at t= 0.

We must discount the cash flows needs on a monthly basis to construct a portflio today which can satisfy our requirements for next 50 years. Discount rate to be sued will be monthly rate after accounting for inflation. Since discount rate and inflation both ate given in monthly compounded format, we can easily calculate monthly rate to be used in calculation =

It comes to be 0.71% approx = 8.5/12.

Now we must pull the cash flows sequentially to arrive at capital sum required to made today or insurance sum assured to be purchased today.

Part 1 - Calculate present value of 3250 for 408 months using 0.71% in BGM mode in BA II plus calculator. It comes to be 435288.

Part 2 - Calculate present value of 4500 for 192 months using 0.71%. Also calculate the PV of 435288 above along with.

Final answer comes to be 586113. If Sarah invets this sum today, it will fulfill her desires of montly cash flows of 4500 for 16 years and 3250 for 34 years therafter assumming cash flows are received at beginning of each period.

She need to buy an annuity due plan with initial investment of 586113 today which will fetch her 4500 for 16 years and 3250 for next 34 years.


Related Solutions

Life Insurance Need Analysis Case Your friend John asks you for advice concerning life insurance. John,...
Life Insurance Need Analysis Case Your friend John asks you for advice concerning life insurance. John, an auto mechanic, is 38 years old and currently earns $76,000 per year. John is married and has three children, Billy, age 5. Cindy, age 9, and Sally, age 13. John’s wife, Mary, is currently a stay at home mom. When Billy is old enough to attend school, Mary hopes to get a job as an administrative assistant in the children’s school. That position...
The investment committee of your church has come to you for advice one of the stocks...
The investment committee of your church has come to you for advice one of the stocks held by the church has paid cash dividends for years. This year the company issues a stock dividend so that the church received additional shares rather than cash. The committee is concerned about whether this stock dividend is really worth anything. One committee member argues the stock dividend is as good as cash; another argues that the dividend is worthless. Write a brief report...
Consider the following scenario: Your boss has come to you for advice on the current finances...
Consider the following scenario: Your boss has come to you for advice on the current finances of the company and needs you to create an extended DuPont analysis, common size analysis, and percentage change analysis. Your boss wants you to fill out the attached Excel file because he/she has no idea what she is talking about and is going to use your report as her work. Remember to answer all the questions in the attached document. Has J&W's liquidity position...
Your younger brother has come to you for advice. He is about to enter college and...
Your younger brother has come to you for advice. He is about to enter college and has two options open to him. His first option is to study engineering. If he does this, his undergraduate degree would cost him $30,000 a year for four years. Having obtained this, he would need to gain two years of practical experience: in the first year he would earn $35,000, in the second year he would earn $40,000. He would then need to obtain...
For this Assignment, consider that your patient has come to you with concerns of a family...
For this Assignment, consider that your patient has come to you with concerns of a family history of a genetic disorder. They would like information of the likelihood of conceiving a child with the disorder. The mother’s grandmother had the disease and the father’s brother has the disease. For this Assignment, select one of the following diseases as the focus of your investigation: Huntington’s Disease, Sickle Cell Anemia, or Cystic Fibrosis. Apply the concepts of epigenetics and testing to help...
Your friend John asks you for advice concerning life insurance. John is 26 years old and...
Your friend John asks you for advice concerning life insurance. John is 26 years old and graduated from law school last year. He currently earns $40,000 per year. John’s wife, Mary, is a graphics designer who currently earns $50,000 per year. Mary is 28 years old. The couple have three children: Billy, age1, Cindy, age 3, and Sally, age 5. John and Mary pay $1,000 per month for their home mortgage, which will be paid off in 25 years. The...
3. A pregnant woman has come to you for advice. By mistake she took thalidomide prescribed...
3. A pregnant woman has come to you for advice. By mistake she took thalidomide prescribed for her husband. She is certain that she took the drug during the third week of pregnancy, she is now near the end of the second trimester. She has come to you to determine whether her child will be born with malformed limbs. a. Explain what test or tests you would suggest that could answer her question. b. Explain why you choose that test....
Assume that you provide financial advice to Minelli Enterprises Limited. The company’s management has come to...
Assume that you provide financial advice to Minelli Enterprises Limited. The company’s management has come to you for guidance over a foreign exchange transaction. The company, based in New Zealand, has sold GBP$ 4,500,000 worth of equipment to a customer in Great Britain. The payment has been deferred for six (06) months. The following information has been provided: Spot exchange rate = NZD 1.9639/GBP Six-month forward rate = NZD 1.9613/GBP New Zealand lending rate = 3.12% p.a. New Zealand deposit...
45. Your younger brother has come to you for advice. He is about to enter college...
45. Your younger brother has come to you for advice. He is about to enter college and has two options open to him. His first option is to study engineering. If he does this, his undergraduate degree would cost him $30,000 a year for four years. Having obtained this, he would need to gain two years of practical experience: in the first year he would earn $35,000, in the second year he would earn $40,000. He would then need to...
Fund Life & Health insurance How does the law of insurable interest protect human life? (identifying...
Fund Life & Health insurance How does the law of insurable interest protect human life? (identifying the requirement of the law and insurance company and analyzing how it protects general public.) What factors make joint life an effective tool in the case of a buy-sell agreement? ( Explain how JL matches the need for buy-sell agreement timing and analyzing what riders in JL benefits in the situation of buy-sell agreement.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT