Need Help on excel part figuring out how to calculate

Mario (age 24) and Lexi (age 24) are a young couple they have been married a little over 3 years. They have a son Roberto (age 2) and are expecting a baby this spring. Mario and Lexi both have their college degrees. Mario works as an engineer and makes $60,000 per year. Lexi is taking care of Roberto and soon will be taking care of the baby but is also starting a consulting business. She currently makes $10,000 on her business working part-time. She is hopeful that as the kids get in daycare she will have more time to commit to work and will also be making $60,000+ per year with her technical degree.

Mario and Lexi are concerned that if something happened to one of them the other would not make enough money to cover the costs of raising the family. The do not have any life insurance right now. They would like to pay off their mortgage if one of them dies. The would also like to have a 6 month emergency fund based on Mario's salary. They would like to have $175,000 for each child's education. At this point, they are planning on having 2 children. They have not begun saving for education.

Mario thinks that if Lexi dies he will need a live in nanny to help with the children for the next 13 years. They estimate the cost of that at $30,000 per year. He would also like another $6,000 per year that he can contribute to retirement income for the next 18 years.

They will need $50,000 for the adjustment period for costs that will allow them to deal with the death of their spouse.

Lexi thinks that if Mario dies she will need money to replace his $60,000 per year income until the baby is 18 years old. That will allow her to save for retirement and cover her lifestyle costs.

Both of them feel that having 2 children will increase their costs by about $10,000 for child costs for the entire 18 years the children are dependent at home.

They estimate the following costs if something happened to one of them:

Cost	If Mario Died	If Lexi Died
Funeral costs	$15,000	$15,000
End of life medical bills	$5,000	$5,000
Car loans	$7,000	$10,000
Credit cards	$2,000	$3,000
Probate attorney costs	$5,000	$5,000
Mortgage payoff	$180,000	$180,000
Emergency fund	$30,000	$30,000
Roberto's education	$175,000	$175,000
Baby's education	$175,000	$175,000

They have the following assets owned joint tenancy with rights of survivorship

Checking account $20,000

Investment account $100,000

IRA's $20,000 with each other listed as the beneficiary

Pension death benefits $10,000 with Lexi named as beneficiary

They would like you to give them an indication of how much insurance coverage they need and what type of insurance your recommend. Please complete the spreadsheet on excel to determine life insurance needs. For time value of money calculations please assume a 5% return on all investments .Provide the following information to Mario and Lexi;

Need help calculating income needs

Additional Life Insurance Needed Additional Life Insurance Needed