Please see attachment for questions. If you could please show me how you solved the questions. Thanks

Q.1 Adam and Arin Adams have collected their personal asset and liability information and have asked you to put together a balance sheet as of December 31, 2015. The following information is received from the Adams family Cash Checking Savings IBM stock Auto loan Mortgage Medical bills payable Utility bills payable Real estate $ $300 2,910 1,260 2,058 8,020 99,304 241 149 150,404 Retirement funds, IRA 2014 Sebring 2010 Jeep Money market funds Jewelry and artwork Net worth Household furnishings Credit card balance Personal loan $2,017 15,058 7,982 1,227 2,974 77,532 4,146 2,014 3,076 a. Create a personal balance sheet as of December 31, 2015. It should be similar to a corporate balance sheet. b. What must the total assets of the Adams family be equal to by December 31, 2015? c. What was their net working capital (NWC) at the end of the year? (Hint: NWC is the difference between total liquid assets and total current liabilities.) Adam and Arin Adams Balance Sheet 31-Dec-15 Liabilities and Net Worth Assets 0 0 0 0 Total Liquid Assets 0 0 Total Investments 0 0 0 0 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Personal Property Total Real Estate Total Assets Q.2 Liquidity ratioJosh Smith has compiled some of his personal financial data in order to determine his liquidity position. The data are as follows: Account Amount Cash Marketable securities Checking account Credit card payables Shortterm notes payable $3,110 970 780 1,260 990 a. Josh's liquidity ratio is ___. (Round to two decimal places.) Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2016 in order to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outflows. These percentages are based on their takehome pay (that is., monthly utilities normally run 5.2% of monthly takehome pay). The information here Income Monthly takehome pay Expenses Housing Utilities Food Transportation Medical/dental Clothing for October & November Clothing for December Property taxes (November only) Appliances Personal Care Entertainment for October & November Entertainment for December Savings Other Excess in cash $ $4,920 30.3% 5.2% 10.5% 7.4% 0.5% 2.7% $435 11.4% 1.1% 1.9% 5.6% $1,549 7.7% 5.5% 64.6% can be used to create their fourthquarter budget for 2016. a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016? can be used to create their fourthquarter budget for 2016. a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016? a. Complete the October 2016 cash budget below:(Round to the nearest dollar.) Sam and Suzy Sizeman Personal Budget for the Period October-December 2016 October Income Take-home pay Expenses Percent Housing 30.30% Utilities 5.20% Food 10.50% Transportation 7.40% Medical/Dental 0.50% Clothing 2.70% Property taxes 11.40% Appliances 1.10% Personal care 1.90% Entertainment 5.60% Savings 7.70% Other 5.50% Excess cash 4.60% Total expenses Cash surplus or (deficit) Cumulative cash surplus or (deficit) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Q3. Time value Personal Finance Problem You have $1,500 to invest today at 7% interest compounded annually. a. Find how much you will have accumulated in the account at the end of (1) 5 years, (2) 10 years, and (3) 15 years. b. Use your findings in part a to calculate the amount of interest earned in (1) the first 5 years (years 1 to 5), (2) the second 5 years (years 6 to 10), and (3) the third 5 years (years 11 to 15). c. Compare and contrast your findings in part b. Explain how the amount of interest earned changes in each succeeding 5 -year period