please help with questions 2 and 3

that is all the info needsd

i just need the ratios answered and the cashflow. statement for year 10

its not incomplete

ected View Enable Editing . . Assets, Liabilities and Net Worth Mary has come to you for help preparing personal financial statements. She presents you with the following facts. Her assets and liabilities include: $3,000 in a Checking account and $5,000 in a Savings account Her Brokerage Account has $15,000 in Stocks With her employer she has a 401K with a balance of $50,000. She has cash value life Insurance with a $250,000 death benefit and a cash value of $25,000 Her home was purchased for $300,000 and has a mortgage balance of $250,000, currently worth $320,000. A car purchased for $35,500 where the current blue book value is $15,000 and she owes $18,000 on the auto loan Mary has a Student Loan originally for $60,000 with a current Principal Balance of 30,000 Lastly, she has Credit Card Balances of $8,500 . Editing AnishDAD Cash Flow Statement . . . . Based on current income and expenses, Mary provides the following breakdown: Her gross salary is $122,500 annually with Income Tax and FICA of $26,950 She has dividend income of $800 per year and interest income of $50 annually Her mortgage payment is $1,700 monthly: property taxes are $4,000 per year Mary's auto payment is $500 a month Her Homeowner's insurance premium is $900 annually, and all other insurance products are around $2,000 annually She has monthly expenses of $700 for food, $500 for transportation, $400 for clothing and personal, 500 for entertainment & vacation, $350 for medical and dental, $250 for utilities Mary Pays $600 Monthly for Her Student Loan Mary pays $600 monthly for credit card payments not separately categorized Mary estimates Miscellaneous Expenses of about $5,000 by subtracting expenses she can identify and savings from her Total Inflows . . . . Personal Financial Statement Ratios - Part 2 Calculate the following Financial Ratios: a) Liquidity Ratio b) Savings Ratio c) Front End Ratio d) Back End Ratio e) Net Investment Assets to Net Worth In your view, based on the statements and ratio analysis, briefly describe Mary strengths and weaknesses in financial position Personal Financial Statement Ratios - Part 3 Prepare a Pro Forma Cash Flow Statement 10 Years in the Future You should apply inflation or escalation to line items as appropriate How would this change Mary's ability to save? AutoSave On Net Worth Part 1 Practed View Search File Home Page Layout Formas Data Review www O PROTECTED VIEW Becurile there can you need to do Protected in bediting 8 D G H $ 3,000 5.000 LIABILITIES Liabilities Credit card balance $ Student Loan Debt Auto note balance Mortgage Balance Total Liabilities 8,500 30,000 18,000 250,000 306,500 25,000 8 33.000 1 NET WORTH STATEMENT 2 ASSETS 3 Cash/Cash Equivalents 4 Checking account 5 Savings Account 6 Money Market Account 7 Life Insurace Cash Value Total Cash/Cash Equivalents 9 Invested Assets 10 Brokerage Acct 11 Business 12 IRAs 13 401k or Vested Pension 14 Total Invested Assets 15 Use Assets 16 Residence 17 Automobiles 18 Personal property 19 Total Use Assets 20 15,000 50.000 65,000 TOTAL LIABILITIES 306,500 NET WORTH 126,500 320,000 15,000 335.000 TOTAL LIABILITIES AND NET WORTH 433,000 433,000 21 TOTAL ASSETS 22 23 24 25 26 27 28 29 30 AutoSave Cash Flow Statement Protected View O Sesh File Home Insert Page Layout Formula Data Review View Help PROTECTIO VIEW Become ancora Unless you need to edit's safe to stay in Protected View MESAS Cash Flow Statement Enable Editing A1 B D Outflows Inflows Totals 1 Cash Flow Statement 2 3 INFLOWS 4 Gross salaries 5 Dividend income 6 Interest income 7 Other Income 8 TOTAL INFLOWS GA OOOOO $ 0 9 $ 0 $ OOOOO 18 S 0 S 10 OUTFLOWS 11 Savings and Investments 12 Fixed Outflows 13 Housing 14 Property Taxes 15 Student Loan Payments 16 Auto Loan Payments 17 Insurance premiums Total Fixed Outflows 19 Variable Outflows 20 Taxes 21 Food 22 Transportation 23 Clothing/personal 24 Entertainment/vacation 25 Medica dental care 26 Utilities/household 27 Credit card payments 28 Miscellaneous Total Variable Outflows 30 TOTAL OUTFLOWS 31 32 OOOOOOOOO 0 29 S 0 33 34 35 Seine File Home Insor Page Layout Form Data Review Ve Helva 0 PROTECTED VIEW Beems there can be unless you need to edit to stay in Protected View Enable Editing B58 B C D E F G H Monthly Outflows Inflows Totals 1 Cash Flow Statement 2 3 INFLOWS 4 Gross salaries 5 Dividend income 6 Interest income 7 Other Income 8 TOTAL INFLOWS $ 122,500 800 50 0 123,350 123,350 $ 11,300 92% $ 1700 600 20.400 4,000 7 200 6.000 2.900 500 $ 40,500 10 OUTFLOWS 11 Savings and Investments 12 Fixed Outflows 13 Housing 14 Property Taxes 15 Student Loan 16 Auto loan payments 17 Insurance premiums 18 Total Fixed Outflows 19 Variable Outflows 20 Taxes 21 Food 22 Transportation 23 Clothing/personal 24 Entertainment/vacation 25 Medical/dental care 26 Utilities/household 27 Credit card payments 28 Miscellaneous Total Variable Outflows 30 TOTAL OUTFLOWS 31 $ 700 500 400 500 350 250 600 26,950 8,400 6,000 4.800 6,000 4.200 3,000 7 200 5,000 71,550 29 $ 112,050 33 35 Search Fid Home Insert Page Layout Formas Data Rew View Helo PROTECTED VIEW comment can contre you need to saler to stay in Protected w Enable doing C14 8 D E $ 3,000 5,000 LIABILITIES Liabilities Credit card balance $ Student Loan Debt Auto note balance Mortgage Balance Total Liabilities 8,500 30,000 18,000 250,000 306,500 25.000 33,000 1 NET WORTH STATEMENT 2 ASSETS 3 Cash/Cash Equivalents 4 Checking account 5 Savings Account 6 Money Market Account 7 Life Insurace Cash Value 8 Total Cash/Cash Equivalents 9 Invested Assets 10 Brokerage Acct 11 Business 12 IRAS 13 401k or Vested Pension 14 Total Invested Assets 15 Use Assets 16 Residence 17 Automobiles 18 Personal property 19 Total Use Assets 20 15.000 50,000 65,000 TOTAL LIABILITIES 306,500 NET WORTH 126,500 320,000 15,000 335,000 TOTAL LIABILITIES AND NET WORTH 433,000 433,000 21 TOTAL ASSETS 22 23 24 25 26 27 28 29 30 31 32 Sheet1 Assets, Liabilities and Net Worth Mary has come to you for help preparing personal financial statements. She presents you with the following facts. Her assets and liabilities include: $3,000 in a Checking account and $5,000 in a Savings account Her Brokerage Account has $15,000 in Stocks With her employer she has a 401K with a balance of $50,000. She has cash value life Insurance with a $250,000 death benefit and a cash value of $25,000 . Her home was purchased for $300,000 and has a mortgage balance of $250,000, currently worth $320,000. A car purchased for $35,500 where the current blue book value is $15,000 and she owes $18,000 on the auto loan Mary has a Student Loan originally for $60,000 with a current Principal Balance of 30,000 Lastly, she has Credit Card Balances of $8,500 . . ected View Enable Editing . . Assets, Liabilities and Net Worth Mary has come to you for help preparing personal financial statements. She presents you with the following facts. Her assets and liabilities include: $3,000 in a Checking account and $5,000 in a Savings account Her Brokerage Account has $15,000 in Stocks With her employer she has a 401K with a balance of $50,000. She has cash value life Insurance with a $250,000 death benefit and a cash value of $25,000 Her home was purchased for $300,000 and has a mortgage balance of $250,000, currently worth $320,000. A car purchased for $35,500 where the current blue book value is $15,000 and she owes $18,000 on the auto loan Mary has a Student Loan originally for $60,000 with a current Principal Balance of 30,000 Lastly, she has Credit Card Balances of $8,500 . Editing AnishDAD Cash Flow Statement . . . . Based on current income and expenses, Mary provides the following breakdown: Her gross salary is $122,500 annually with Income Tax and FICA of $26,950 She has dividend income of $800 per year and interest income of $50 annually Her mortgage payment is $1,700 monthly: property taxes are $4,000 per year Mary's auto payment is $500 a month Her Homeowner's insurance premium is $900 annually, and all other insurance products are around $2,000 annually She has monthly expenses of $700 for food, $500 for transportation, $400 for clothing and personal, 500 for entertainment & vacation, $350 for medical and dental, $250 for utilities Mary Pays $600 Monthly for Her Student Loan Mary pays $600 monthly for credit card payments not separately categorized Mary estimates Miscellaneous Expenses of about $5,000 by subtracting expenses she can identify and savings from her Total Inflows . . . . Personal Financial Statement Ratios - Part 2 Calculate the following Financial Ratios: a) Liquidity Ratio b) Savings Ratio c) Front End Ratio d) Back End Ratio e) Net Investment Assets to Net Worth In your view, based on the statements and ratio analysis, briefly describe Mary strengths and weaknesses in financial position Personal Financial Statement Ratios - Part 3 Prepare a Pro Forma Cash Flow Statement 10 Years in the Future You should apply inflation or escalation to line items as appropriate How would this change Mary's ability to save? AutoSave On Net Worth Part 1 Practed View Search File Home Page Layout Formas Data Review www O PROTECTED VIEW Becurile there can you need to do Protected in bediting 8 D G H $ 3,000 5.000 LIABILITIES Liabilities Credit card balance $ Student Loan Debt Auto note balance Mortgage Balance Total Liabilities 8,500 30,000 18,000 250,000 306,500 25,000 8 33.000 1 NET WORTH STATEMENT 2 ASSETS 3 Cash/Cash Equivalents 4 Checking account 5 Savings Account 6 Money Market Account 7 Life Insurace Cash Value Total Cash/Cash Equivalents 9 Invested Assets 10 Brokerage Acct 11 Business 12 IRAs 13 401k or Vested Pension 14 Total Invested Assets 15 Use Assets 16 Residence 17 Automobiles 18 Personal property 19 Total Use Assets 20 15,000 50.000 65,000 TOTAL LIABILITIES 306,500 NET WORTH 126,500 320,000 15,000 335.000 TOTAL LIABILITIES AND NET WORTH 433,000 433,000 21 TOTAL ASSETS 22 23 24 25 26 27 28 29 30 AutoSave Cash Flow Statement Protected View O Sesh File Home Insert Page Layout Formula Data Review View Help PROTECTIO VIEW Become ancora Unless you need to edit's safe to stay in Protected View MESAS Cash Flow Statement Enable Editing A1 B D Outflows Inflows Totals 1 Cash Flow Statement 2 3 INFLOWS 4 Gross salaries 5 Dividend income 6 Interest income 7 Other Income 8 TOTAL INFLOWS GA OOOOO $ 0 9 $ 0 $ OOOOO 18 S 0 S 10 OUTFLOWS 11 Savings and Investments 12 Fixed Outflows 13 Housing 14 Property Taxes 15 Student Loan Payments 16 Auto Loan Payments 17 Insurance premiums Total Fixed Outflows 19 Variable Outflows 20 Taxes 21 Food 22 Transportation 23 Clothing/personal 24 Entertainment/vacation 25 Medica dental care 26 Utilities/household 27 Credit card payments 28 Miscellaneous Total Variable Outflows 30 TOTAL OUTFLOWS 31 32 OOOOOOOOO 0 29 S 0 33 34 35 Seine File Home Insor Page Layout Form Data Review Ve Helva 0 PROTECTED VIEW Beems there can be unless you need to edit to stay in Protected View Enable Editing B58 B C D E F G H Monthly Outflows Inflows Totals 1 Cash Flow Statement 2 3 INFLOWS 4 Gross salaries 5 Dividend income 6 Interest income 7 Other Income 8 TOTAL INFLOWS $ 122,500 800 50 0 123,350 123,350 $ 11,300 92% $ 1700 600 20.400 4,000 7 200 6.000 2.900 500 $ 40,500 10 OUTFLOWS 11 Savings and Investments 12 Fixed Outflows 13 Housing 14 Property Taxes 15 Student Loan 16 Auto loan payments 17 Insurance premiums 18 Total Fixed Outflows 19 Variable Outflows 20 Taxes 21 Food 22 Transportation 23 Clothing/personal 24 Entertainment/vacation 25 Medical/dental care 26 Utilities/household 27 Credit card payments 28 Miscellaneous Total Variable Outflows 30 TOTAL OUTFLOWS 31 $ 700 500 400 500 350 250 600 26,950 8,400 6,000 4.800 6,000 4.200 3,000 7 200 5,000 71,550 29 $ 112,050 33 35 Search Fid Home Insert Page Layout Formas Data Rew View Helo PROTECTED VIEW comment can contre you need to saler to stay in Protected w Enable doing C14 8 D E $ 3,000 5,000 LIABILITIES Liabilities Credit card balance $ Student Loan Debt Auto note balance Mortgage Balance Total Liabilities 8,500 30,000 18,000 250,000 306,500 25.000 33,000 1 NET WORTH STATEMENT 2 ASSETS 3 Cash/Cash Equivalents 4 Checking account 5 Savings Account 6 Money Market Account 7 Life Insurace Cash Value 8 Total Cash/Cash Equivalents 9 Invested Assets 10 Brokerage Acct 11 Business 12 IRAS 13 401k or Vested Pension 14 Total Invested Assets 15 Use Assets 16 Residence 17 Automobiles 18 Personal property 19 Total Use Assets 20 15.000 50,000 65,000 TOTAL LIABILITIES 306,500 NET WORTH 126,500 320,000 15,000 335,000 TOTAL LIABILITIES AND NET WORTH 433,000 433,000 21 TOTAL ASSETS 22 23 24 25 26 27 28 29 30 31 32 Sheet1 Assets, Liabilities and Net Worth Mary has come to you for help preparing personal financial statements. She presents you with the following facts. Her assets and liabilities include: $3,000 in a Checking account and $5,000 in a Savings account Her Brokerage Account has $15,000 in Stocks With her employer she has a 401K with a balance of $50,000. She has cash value life Insurance with a $250,000 death benefit and a cash value of $25,000 . Her home was purchased for $300,000 and has a mortgage balance of $250,000, currently worth $320,000. A car purchased for $35,500 where the current blue book value is $15,000 and she owes $18,000 on the auto loan Mary has a Student Loan originally for $60,000 with a current Principal Balance of 30,000 Lastly, she has Credit Card Balances of $8,500