calculate the current ratio based on the information provided. show all work.

Calculate the Months Living Expenses Covered Ratio. Show all work .

utoSave OH v FinStatements A20 (1) - Excel Search le Home Insert Draw - Page Layout Formulas Data Review View Help AutoSur Calibri 11 29 Wrap Text ILLA General X Cut L Copy * Format Painter AA === a. A aste BIU Insert Delete Format v Es Merge & Center $ %) 4088 Conditional Format as Cell Formatting Table Styles Clear Clipboard Font Alignment Number Styles Cells 16 f B C F G H 1 Financial Dat - Columni 2 Assets - Column2 D E Column 3 Column4 Liabilities Column5 Column 6 Cash $500 1. $350 $1,200 Current Bills (unpaid balance) Visa Master Card Other Credit Cards $8,000 3 4 5 6 $500 $90 J. Credit Card Debt $8,000 7 8 A. 9 $2,290 $5,600 First Mortgage 2nd Home Mortgage Home Equity Loan Other Housing Debt $105,000 $100,000 $9,000 10 11 Checking Savings/CDS S Money Market Funds Other Monetary Assets Monetary Assets Mutual Funds Stocks S Bonds Life Insurance (cash- value) Cash Value of Annuities Investment Real Estate (REITS, partnerships) Other investments Investments 401(k) and 403(b) K. Housing $214,000 12 Automobile 1 $3,000 13 Automobile 2 14 15 16 B 17 $5,600 $2,500 $3,000 $4,000 Other Automobile Loans Automobile Loans College Loans Loans on Life Insurance Policies Bank Loans Installment Loans Company Pension S 18 19 20 Keogh TIRA Balance Sheet $8,000 $1.000 Income Statement + Type here to search O i AutoSave OH H2 FinStatementsFA20 (1) - Excel Search File Home Insert Draw - Page Layout Formulas Data Review View Help X Cut Calibri 11 " K === ab Wrap Text General AT Le Copy y Paste BIU .00 Insert Delete Format Merge & Center $ % 00 Format Painter Clipboard Conditional Format as Cell Formatting Table Styles Styles Font E Alignment Number Cells M16 A B C. D E F G H 1 J Other 21 Other Retirement Plans Retirement Plans Primary Residence M. Other Debts $5,000 22 C. 23 $10,500 $170,000 2nd Home $ N. Total Debt (add lines through M) $230,350 24 Time Shares/Condominium S 25 26 Net Worth $170,000 H Total Assets $207,390 D. 27 28 29 $8,000 N. 0 Less: Total Debt Equals: Net Worth $230,350 ($22,960) 30 $8,000 31 E. 32 33 34 Other Housing Housing (market value) Automobile 1 Automobile 2 $ Other Automobiles Automobiles Collectibles Boats Furniture Other Personal Property Personal Property Money Owed You Market Value of Your Business Other Other Assets $- $11,000 35 36 F 37 $11,000 38 39 40 G 41 H. $207,390 42 Total Assets (add lines A through G) Balance Sheet Income Statement + 1 Type here to search O AutoSave FinStatementsFA20 (4) - Protected View Search File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing E12 X fx A D 1 Column1 Column2 2 3 4 5 $57,500 B Income Wages and salaries Wage Earner 1 Wage Earner 2 Total Wages and salaries + Interest and Dividends Royalties, Commissions and Rents + Other Income 6 7 $57,500 $720 $58,220 Taxes Federal Income and Social Security + State Income $11,830 $1,880 $13,710 $44,510 8 9 A. Total Income 10 11 12 13 14 B. Total Income Taxes 15 16 C. After-Tax Income Available for Living Expenditures 17 or Take-Home Pay (line A minus line B) 18 19 20 21 22 23 24 D. Total Housing Expenditures 25 26 27 28 29 E. Total Food Expenditures 30 31 32 F. Total Clothing and Personal Care Expenditures 33 34 Balance Sheet Income Statement Living Expenses Housing Rent + Mortgage Payments + Utilities Maintenance, Taxes, Furniture, Other $19,656 $10,820 $30,476 Food Food and Supplies + Restaurant Expenses $5,800 $1,400 $7.200 Clothing and Personal Care $2,590 Transportation Ready E Type here to search AutoSave OF FinStatementsFA20 (4) - Protected View Search File Home Insert Draw - Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing E12 f B B D F Transportation Automobile Purchase Payments + Gas, Tolls, Parking, Other $2,588 $1,550 $4,138 Recreation + Vacations + Other Recreation Expenses $2,000 $1,700 34 35 35 37 38 G. Total Transportation Expenditures 39 40 41 42 43 H. Total Recreation Expenditures 44 45 46 I. Total Medical Expenditures 47 48 49 50 51 52 53 J. Total Insurance Expenditures 54 $3,700 Medical Expenditures $410 Insurance Expenditures Health + Life + Automobile Disability + $420 $1,260 $1.940 SS Other Expenditures Educational Expenditures (college loan payment) + Child Care + Other Expenses $1,600 S180 $1,780 $52.234 56 57 se 59 K. Total Other Expenditures 60 61 L. Total Living Expenditures (add lines D-K) 62 M. Income Available for Savings and Investment 63 64 65 66 67 Balance Sheet Income Statement | Ready Type here to search