plese plese try to answer the blank parts which i include the image and it will be due tonight. also, i post same question 2 times but no one done it completely whole parts and wrote the each answer in excel

What do you recommend for death benefit amounts for each person (Jeff and Mary)? What is your rationale for the amount of coverage you recommend? Question 10. Jeft and Mary have discussed the need to life insurance and one of theif goals is to have a sufficient amount of coverage in the event of an untimety death. Part of the reason for maintaining tife insurance coverage is the replacement of eamings and to provide funds for funeral and burial. Jeff's salary is $70,000 per yeat and Mary makes about $40,000, funeral and burial expenses average $10,000 a year, according to personal finance articles. The couple also agrees that death benefit proceeds should be sufficient to pay off debts such as the tralances owed for credit cards, vacation loans, and home improvement debt. Easy Method - a quick and easy method that assumes the life insurance will cover 70k of 7 vears of the deceased person's annual income. DINK method - DINK is an acronym for DiNK stands for doubJe income, no kids. Since Jetf and Mary do have two woung children, the DiNK method's results may not be appropeiate however, please calculate the life insurance need under this method as another point of information. DINX assumes that life invurance coverage is adequate if it covers funerat expenses and one half of the family debts upon an untimely death of one of the "bread winners." 6 Family Need Method - a more detailed method that calculates life insurance needs by consideting assets (such as checking and savings accounts and imvestments) and awuming that lifo insurance and liquid assets will cover estimated funeral costs and the future financial nends of dependents. Current Financial Information They own their home which they purchased two years ago for $285,000. Their town (Rumford, Rhode island) tax office has assessed the home value at $200,000. Recently, Mary hired a certiticd real estate. appraiser to prepare a home appraisal and his appraised value was $300,000 (the real estate appraiser based her opinion of value on recent sales of comparable homes in similar ncighborhoods and considered current construction costs and land value.) While surfing the web, Mary noticed that their home is listed on Zillow.com with a "Zestimate" of $350,000. Zestimate's are powered by an algorithm. Mary knows that the variables of the valuation system, including analysis of home exterior and interior and traditional real estate facts and figures images, can be inaccurate and may need updating, however Mary logs into zillow often to see how the system is valuing one of the families largest and most important asset. The mortgage on the home has a balance of $140,000. A review of the Douglas' financial information, bankstatements, and other documents shows the following as of Dec. 31, 2022: - 2015 Camry worth about \$11,000 (Kelly Blue Book), with a bank loan balance of \$3,000 - 2014 Volvo 560 purchased six months ago for $14,500 is worth about $15,000 (Kelly Blue Book). with a bankioan balance of $10,000 - An insurance policy on Jeff's life with a face value of $100,000 with a cash surrender value of $2,500 and no policy loan balance. Mary is the beneficiary listed on Jelf's policy. - An insurance policy on Mary's life with a face value of $10,000 and no cash surrender value. Jefl is the beneficiary listed on Mary's policy. - Credit card balances that total 53,500. - A savings account with a $1,000 balance - Iwo mutual funds earmarked for the children's college education. The account for Paul has a balance of $10,000 and Marcy's bas $11,000 as a current balance. The fund has averaged an 876 annual rate of retun over its life. - 100 shares of Apple inc. (NASDAQ stock symbol AAPL), fommerly Apple Computer, Inc. You need to value this stock and all the stocks they own based on the Dec. 31,2022 price per share. You will need to find that on the internet. The cost basis is $120 per shate. - 200 shates of AI\&T. The cost basis is $41 a share. - 50 shares of Microsoft. The cost basis is $158 per share. - 15 " shares of Alphabet Inc. The cost basis is \$1,600 per share. ("There was a 20:1 stock split after they bought the shares and so they now have 1,500 shares). Use 1,500 shares to determine the market value of the Aphabet stock.) - Achecking account with a balance of $3,000. - Jeff estimates that their furniture, fixtures etc, in the home are worth about $7,000. - Jeff and Mary have retirement accounts that have a current market value of approximately $200,000. - Mary still has an education foan with an outstanding balance of $15,000. It still has seven years left on it. - A vacation loan of $750 due in 6 months and a home improvernent loan of $2,000 duc in 2 years (unsecured - not a horne equity loan.) - Jeff wants to finish the basement and he has discussed this at Iength with Mary. He is getting estimates from contractors based on ideas that both he and Mary have to create a play area for the children and a TV/den for the family. Jeff and Mary love to play ping pong and pool and would fove to introduce the children to both "sports." He believes that the project will cost about $30,000 and he is interested in tapping into the home equity. - Jeff is also an avid baseball fan and is looking at buying a membership to a local baseball/soltball facility for both Paul and Marcy. He figures that since he doesn't have any expensive hobbies, it would be fun to get Paul started as a basehall player and Marcy as a softball player. The membership costs and related costs are as follows: $1,500 per year (covers both kids). equipment $500 per year, and team registration and travel costs will be about another $1,000 to $2,000 a year depending on how serious the kids become. Mary is not sure that this is a prionity at this point and wants to explore this possibitity in more detail