I need help completing this Accounting 3 excel worksheet. All the information needed to fill out the excel worksheet is in the pictures I have provided. The pictures are in order. This is one problem that I need help completing, everything goes together.

B E F Financial Statement Analysis Data for Example Problems Instructions: Use this data to complete the example problems on the other tabs of this workbook. 2014 2013 $ $ 4,061 5,272 3,333 8,004 $ 9,408 448 $ 8,767 417 Comparative Balance Sheet (in Thousands) also called Statement of Financial Condition Current assets Cash Marketable securities Accounts receivable Less allowance for doubtful accounts Inventory Prepaid expenses Total current assets Property, plant and equipment Land Buildings and leasehold improvements Equipment 8,960 47,041 512 65,846 8,350 37,720 759 58,166 $ $ 811 $ $ 18,273 21,523 40,607 11,528 29,079 373 95,298 811 11,928 13,768 26,507 7,530 18,977 668 77,811 $ $ $ Less accumulated depreciation and amortization Net property, plant and equipment Other assets Total assets Current liabilities Accounts payable Notes payable to banks Current maturities of long-term debt Accrued liabilities Total current liabilities Deferred federal income taxes Long-term debt Total liabilities Stockholders' Equity Common stock, par value $1, authorized 10,000,000 shares; issued & outstanding 4,803,000 shares in 2014 market price $3.23) and 4,594,000 shares in 2013(market price $2.20) Additional paid-in capital Retained Earnings Data Horizontal Vertical Ratios $ 14,294 5,614 1,884 5,669 $ 27,461 843 21,059 $ 49,363.00 $ 7,591 6,012 1,516 5,313 $ 20,432 635 16,975 $ 38,042.00 4,803 957 40,175 4,594 910 34,265 B D E Retained Earnings Total stockholders' equity Total liabilities and stockholders' equity F 34,265 39,769 77,811 40,175 45,935 95,298 $ $ $ $ 2014 2013 $ $ $ $ Comparative Income Statement (in Thousands) also called Statement of Operations or Earnings Net sales Cost of goods sold Gross profit Selling and administrative expenses Advertising Depreciation and amortization Repairs and maintenance Operating profit Other income/(expense) Interest income Interest expense Earnings before income taxes Income taxes Net Income 215,600 129,324 86,276 45,722 14,258 3,998 3,015 19,283 153,000 91,879 61,121 33,493 10,792 2,984 2,046 11,806 $ $ $ 422 (2,585) 17,120 7,686 9,434 $ 838 (2,277) 10,367 4,457 5,910 $ $ NOTE 1 - Restriction on retained earnings. At December 31,2010, $5,000,000 of retained earnings is restricted for contingencies. Accordingly, dividends are limited to a maximum of $35,175,000. Data Horizontal vertical Ratios + ady Type here to search O Accounting 3 Financial Statement Analysis Horizontal Statement Analysis Instructions: Complete a horizontal, or trend/time series, analysis Increase/ (Decrease) Percent Change 2014 2013 $ $ 4,061 5,272 3,333 8,004 Comparative Balance Sheet (in Thousands) also called Statement of Financial Condition Current assets Cash Marketable securities Accounts receivable Less allowance for doubtful accounts Inventory Prepaid expenses Total current assets Property, plant and equipment Land Buildings and leasehold improvements Equipment 8,960 47,041 512 65,846 8,350 37,720 759 58,166 $ $ $ $ 811 18,273 21,523 40,607 11,528 29,079 373 95,298 811 11,928 13,768 26,507 7,530 18,977 668 77,811 $ $ $ $ $ $ 14,294 5,614 1,884 5,669 27,461 843 21.059 49,363 Less accumulated depreciation and amortization Net property, plant and equipment Other assets Total assets Current liabilities Accounts payable Notes payable to banks Current maturities of long-term debt Accrued liabilities Total current liabilities Deferred federal income taxes Long-term debt Total liabilities Stockholders' Equity Common stock, par value $1, authorized 10,000,000 shares; issued & outstanding 4,803,000 shares in 2014 (market price $3.23) and 4,594,000 shares in 2013(market price $2.20) Additional paid-in capital Data Horizontal Vertical Ratios 7,591 6,012 1,516 5,313 20,432 635 16,975 38,042 $ $ $ $ 4,803 957 4,594 910 ly Additional paid-in capital Retained Earnings Total stockholders' equity Total liabilities and stockholders' equity 957 40,175 45,935 95,298 910 34,265 39,769 77,811 $ $ $ $ 2014 2013 $ $ $ $ Comparative Income Statement (in Thousands) also called Statement of Operations or Earnings Net sales Cost of goods sold Gross profit Selling and administrative expenses Advertising Depreciation and amortization Repairs and maintenance Operating profit Other income/expense) Interest income Interest expense Earnings before income taxes Income taxes Net Income 215,600 129,324 86,276 45,722 14,258 3,998 3,015 19,283 153,000 91,879 61,121 33,493 10,792 2,984 2,046 11,806 $ $ $ 422 (2,585) 17,120 7,686 9,434 $ 838 (2,277) 10,367 4,457 5,910 $ $ Data Horizontal Vertical Ratios + dy Type here to search RI W Accounting 3 Financial Statement Analysis Vertical Statement Analysis Instructions: Complete a vertical, or common-sized statement, analysis Percent Change 2014 $ 4,061 5,272 Comparative Balance Sheet (in Thousands) also called Statement of Financial Condition Current assets Cash Marketable securities Accounts receivable Less allowance for doubtful accounts Inventory Prepaid expenses Total current assets Property, plant and equipment Land Buildings and leasehold improvements Equipment 8,960 47,041 512 65,846 $ $ 811 18,273 21,523 40,607 11,528 29,079 373 95,298 $ $ $ Less accumulated depreciation and amortization Net property, plant and equipment Other assets Total assets Current liabilities Accounts payable Notes payable to banks Current maturities of long-term debt Accrued liabilities Total current liabilities Deferred federal income taxes Long-term debt Total liabilities Stockholders' Equity Common stock, par value $1, authorized 10,000,000 shares; issued & outstanding 4,803,000 shares in 2014 market price $3.23) and 4,594,000 shares in 2013(market price $2.20) Additional paid-in capital Data Horizontal Vertical Ratios 14,294 5,614 1,884 5,669 27,461 843 21,059 49,363 $ $ 4,803 957 B C D E F 957 A Additional paid-in capital Retained Earnings Total stockholders' equity Total liabilities and stockholders' equity $ $ 40,175 45,935 95,298 2014 $ $ Comparative Income Statement (in Thousands) also called Statement of Operations or Earnings Net sales Cost of goods sold Gross profit Selling and administrative expenses Advertising Depreciation and amortization Repairs and maintenance Operating profit Other income/expense) Interest income Interest expense Earnings before income taxes Income taxes Net Income 215,600 129,324 86,276 45,722 14,258 3,998 3,015 19,283 $ $ 422 (2,585) 17,120 7,686 9,434 11 $ Data Horizontal Vertical Ratios ady Type here to search O IT Instructions: Use the data on the other tabs to complete the ratio analysis below. ***Note: For Favorable or Unfavorable questions use industry averages from the book. Liquidity and Efficiency Current Ratio Current Assets Numerator Current Liabilities Denominator Current Ratio? Fav. or Unfav. Quick/Acid-test Ratio Numerator Cash Shot-term investments Net current Receivables Current Liabilities Denominator Quick Ratio? Fav. or Unfav. Inventory Turnover COGS Numerator Ave. Inventory Denominator Inventory Turnover? Is 2014 better than 2013 if 2013 was 2.5? Data Horizontal Vertical Ratios dy Receivables Turnover Net Sales Numerator Average Net Accounts Receivable Denominator Receivables Turnover? Is 2014 better than 2013 if 2013 was 22.5? Days' sales Uncollected Net Accounts Receivable Numerator Net Sales Denominator NOTE: take answer x 365 Days' sales Uncollected? Compared to Credit Terms of N/15(Good or Bad) Solvency Debt Ratio Total Liabilities Numerator Total Assets Denominator Debt Ratio? Fav. or Unfav. Times Interest Earned Ratio Operating profit Numerator Interest Expense Denominator Number of Times Interest Earned? Is 2014 better than 2013 if 2013 was 5.5?| Profitability > Data Horizontal Vertical Ratios + ady A Type here to search O W 77 78 Profitability 79 80 81 Profit Margin 82 Net Income Numerator 83 84 Net Sales Denominator 85 86 Profit Margin 87 88 Fav. or Unfav. 89 90 Rate of Return on Total Assets 91 Net Income Numerator 92 93 Average Total Assets DOD DIJO DOOD Denominator 94 95 Return on Total Assets Ratio? 96 97 Fav. or Unfav. Net Income - Preferred dividends Numerator Denominator Average common stockholders' equity Rate of Return on Common Stockholder's Equity? 98 99 Rate of Return on Common Stockholder's Equity 100 101 102 103 104 105 106 107 108 Market Prospects 109 110 Earnings per share of common stock 111 Fav. or Unfav. Net Income - Preferred dividends Numerator 112 113 Number of shares of Common Stock outstanding Denominator 114 115 Earnings per share of common stock? 116 Data Horizontal Vertical Ratios Ready Type here to search o ji IH Price/earnings ratio Market price per share of common stock | Numerator EPS Denominator Price/earnings ratio? Is 2014 better than 2013