Fill in these financials in orange using cell refrences.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 BALANCE SHEET (Thousands of Dollars - $000) Current Assets Cash & Cash Equivalents counts Receivable Inventory otal Current Assets ixed Assets Gross Plant & Equipment Accumulated Depreciation Net Plant & Equipment Other Net Fixed Assets otal Net Fixed Assets otal Assets INCOME STATEMENT ($000) otal Sales Cost of Goods Sold Gross Profit (Margin) ariable Operating Expenses Fixed Operating Expenses otal Operating Expenss EBITDA Depreciation Operating Income (EBIT) Interest Expense Earnings Before Tax (EBT or Taxable Income) axes @ 40% Net Income Common Dividends Retained Eamings 2022 100 2,100 100 2022 8,500 380 185 2021 160 640 800 1,600 4,000 1,800 2,200 100 2,300 3,900 2021 5,740 4,707 1,033 138 207 345 161 527 138 1131t96 233 107 126 Current Liabilities Accounts Payable Accrued Expenses Short Term Debt Total Short Term Liabilities Long Term Liabilities Long Term debt Total Long Term Liabilities Total Liabilities Common Equity Common Stock Accumulated Retained Earnings Total Common Equity Total Liabilities and equity F 2022 240 172 2,000 G 2021 60 220 140 420 ano 440 860 2,000 1,040 3,040 3,900 OTHER INFORMATION - 2020 (Mixed Format) Common Shares Outstanding (in thousands) P/E Ratio Stock Price Per Share Fixed Asset Turnover Quick Ratio EPS (Earnings per share in dollars and cents) ROA ROE Accounts Rceivable Turnover Days Sales in Inventory Variable Operating Expenses as a % of Sales Dividend Payout Ratio Gross Profit Margin STATEMENT OF CASH FLOWS ($000) Cash Flow from Operations Net Income Additions (Source of Funds) Depreciation Increase in Accounts Payable Increase in Accruals Subtractions (Use of Funds) Increase in Accounts Receivable Increase in Inventory Net Cash Flow From Operations Cash Flow From Investinq Activities Acquisition of Fixed Assets (Capex) Net Cash Flow From Investing Cash Flow From Financinq Activities Increase in Long Term Debt Increase in Short Term Debt Dividend Payments Net Cash Flow From Financing Net Change In Cash Cash at Beginning of Year Cash at End of Year 15.0 53.70 3.4 1.6 8.33 89 15.00% 48.00% 30.00% 2022 (500) (500)