Question

In: Finance

John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a...

John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned 7. John’s share of the family’s consumption is 21%, and he pays an average tax rate of 28%. He plans to work another 30 years and expects salary increases equal to inflation, which he expects to be 3% annually. He expects to earn an 8% nominal rate of return on his investments.

1. Use the Human Life Value (HLV) method to calculate John’s appropriate amount of life insurance coverage.

Please show up calculate in Excel, Thank you!

Solutions

Expert Solution

Working: -


Related Solutions

John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a...
John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned 7. John’s share of the family’s consumption is 21%, and he pays an average tax rate of 28%. He plans to work another 30 years and expects salary increases equal to inflation, which he expects to be 3% annually. He expects to earn an 8% nominal rate of return on his investments. Use the Capitalization of Earning method to determine...
John is a 32 year old IT worker with a wife and a 3 year old...
John is a 32 year old IT worker with a wife and a 3 year old child. During a previous physical, it was noted that John has an ‘obese’ BMI of 33. John attributed his weight problem to a lack of exercise because of his work/family life, and because of his moderate to severe asthma. John mentioned that he regularly The only prescription John was taking at the time of that former visit was prednisolone, an asthma medication he has...
John is 37 years old this year. He and his wife have a daughter, Sara, who...
John is 37 years old this year. He and his wife have a daughter, Sara, who is 12 years old. John wants to provide for the family for the next 10 years until Sara is 22 years old and has completed her university education. He estimates that the income needed for the family is $70,000 and Sara’s university education is $42,000. He also wants to provide a total amount of $180,000 as retirement income for his wife and he estimates...
A 38 year old male complains of fatigue by the end of the day. He has...
A 38 year old male complains of fatigue by the end of the day. He has experienced these symptoms for several months now. Recently he has noticed numbness and tingling in his feet. His labs reveal an RBC (2.9 L), HGB (11.0 L), HCT (32.4 L), MCV (111.2 H), and MCH (37.2 H). Which follow up testing would you recommend to confirm deficiency? What type of anemia does this client have? How do you explain the neurological symptoms? What dietary...
A 38 year old man comes into the ER with several problems. He has had the...
A 38 year old man comes into the ER with several problems. He has had the stomach flu and has been vomiting for a couple days now. He is lethargic. His pulse rate is high, his respiratory rate is 35 and his breath smells of acetone. His glucose was high and his pH was low. What is the problem with this patient? What is your possible diagnosis?
Bill Hughes is a 26 year-old man who lives with his wife. He has a history...
Bill Hughes is a 26 year-old man who lives with his wife. He has a history of type one diabetes and is overweight. He presented to the emergency department, complaining of feeling foggy in the head and sleepy. His wife reports that he became very drowsy and confused after dinner. Bill has high blood sugar levels which were managed in the emergency department and he has been transferred to the medical ward. You are the nurse assigned to care for...
Making financial decision's Jack is a 40-year-old construction worker. He makes $33,500 per year. He only...
Making financial decision's Jack is a 40-year-old construction worker. He makes $33,500 per year. He only saves 5 percent of his salary per year since it is all he feels he can afford. His friend Joe suggests that he invest his money conservatively so that it won’t lose as much value if the market takes a nosedive. His other friend Jim thinks that investing aggressively with high risk is the way to go since Jack has several years to work...
Jeff (age 38) and John (Jeff's 18 year old son) are seeking the advice of a...
Jeff (age 38) and John (Jeff's 18 year old son) are seeking the advice of a genetic counselor after a family member was recently diagnosed with Huntington disease, a progressive and fatal nervous system disorder that manifests itself when individuals are generally between age 30 and age 50. If Jeff has inherited the gene for Huntington disease, then there is a 50% probability that he has passed along the gene to his son John.  Jeff shows no symptoms of the disease...
Communication Mr. Simpson is a 78-year-old patient whose wife died last year. He has been living...
Communication Mr. Simpson is a 78-year-old patient whose wife died last year. He has been living alone. He has limited cooking skills; thus he eats out a lot. Since his wife died, his blood sugar has been poorly controlled. To help Mr. Simpson gain better blood sugar control, the dietitian came to see him. After she left, Mr. Simpson was angry and stated his desire to leave the hospital right now. He stated, “That diet person came to see me,...
Amar patel, aged 35, lives with his wife Mona, their 5 year old son Ankit and...
Amar patel, aged 35, lives with his wife Mona, their 5 year old son Ankit and 10 year old daughter Mita. His parents also live with him in a flat in Puna. He had taking a housing loan on a floating interest rate three years ago to purchase the flat. He is a software engineer and he earns around Rs 18 lakhs per annum. His net worth and cash flows are given below. Net Worth Particulars Amount(Rs) Assets: Savings A/c...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT