plese plese try to answer those questions my assingment will be due soon and provide the answer in excel word

2. Current Ratio Liquid Assets Current Liabilities Current Ratio Times 3. Debt Ratio Liabilities Assets Debt Ratio 4. Liquidity Ratio Liquid Assets Monthly Living Expenses Liquidity Ratio Times Question 2. The current ratio is a measure of short-term debt burden. A current ratio of 2 indicates that for every $2 of liquid assets there is $1 of current liabilities (a current ratio =2 ). A high current ratio indicates the ability to meet short-term obligations. What is the current ratio on December 31 "for the Douglas family? Question 3 . Debt burden is something that every family should monitor: One ratio is a debt ratio (litabilities/assets). In recent years, the Douglas family's debt ratio was running around 40%. What is their current debt ratio? Question 4. The liquidity ratio indicates the number of months that living expenses can be paid from liquid assets if an emergency arises (such as any ewent that would result in a serious decrease in income) If the family's monthly living expenses are about $6,000. what is their liquidity ratio? Current Financial Intormation 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 certified 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 neighborhoods 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, bank statements, 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 $60 purchased six months ago for $14,500 is worth about $15,000 (Kelly Blue book). with a bank Ioan balance of $10,000 - An insurance policy on Jeff's life with a tace value of $100,000 with a cash surrender value of $2,500 and no policy loan balance. Mary is the beneficiary listed on Jeff's policy. - An insurance policy on Mary's life with a face value of $10,000 and no cash sumender value felf is the beneficiary listed on Mary's policy. - Credit card balances that total $3,500 - A savings account with a $1,000 balance. - Two mutual funds earmarked for the children's college education. The account foc Paut hasa balance of $10,000 and Marcy's has $11,000 as a current balance. The fund has averabed an ax annual rate of return over its life. - 100 shares of Apple inc: (NASDAO stock symbol AAM), formerly Apple Computer, inc. You need to value this stock and all the socks they own based on the Dec. 11, 2022 price per stare You wall need to find that on the internet. The cost basis is $120 per shate. 10 forur - 200 shares of AT\&I. The cost basis is $41 a share. - 50 shares of Microsoft. The cost basis is $158 per share. - 75 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 Alphabet stock.) - A checking 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 loan 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 improvement loan of $2,000 due in 2 years (unsecured - not a home equity loan.) - Jeff wants to finish the basement and he has discussed this at length 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 love 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/softball 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 baseball player and Marcy as a softball player. The membership costs and related costs are as follows: $1,500 per vear (covers both kids). equipment $500 per year, and team revistration 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 priority at this point and wants to exploce this possibility in more detail. Question 1. Mary understands that although the family doesn't maintain a formal accounting system to be able to produce a personal balance sheet, they do have records from which such a statement can be prepared. Mary knows that periodically, it would be wise to have a balance sheet that is up to date as the family may need it for a loan application, possibly for some investment opportunities, and for developing plans such as a personal financial plan, an estate plan or a formal retirement plan. According to AICPA's Statement of Position 82-1 Accounting and Financial Reporting for Personal Financial Statements, personal financial statements should present assets at their estimated current values and liabilities at their estimated current amounts. The estimated current value of an asset in personal financial statements is the amount at which the item could be exchanged between a buyer and seller, each of whom is well informed and willing, and neither of whom is compelled to buy or sell. 3 What is the family's net worth? Pleave prepare a personal balance sheet. The balance sheet "as of date" should be Dec, 11, 2022. PIFASE. NOII: Because the family owns several common stock inwestments, if might be helpful to review question 5 (below) and complete the question 5 workaheet in the Ixcel workbook and then enter the appropiate balance sheet value from that portfolio report besure to use the matket values as of 12/31/22 for the stocks when prepatine the balance sheet