John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned 7. Johns share of the familys 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 Johns appropriate amount of life insurance coverage.

Please show up calculate in Excel, Thank you!