I need help with filling in the question mark cells.

0 Financial Statement Analysis Directions : Financial Statements are heavily linked and rely on one another to provide various Key Performance Indicators and other important financial figures and ratios. Through this assignment you will finalize the missing pieces of the Statement of Cash Flows, Balance Sheet, and Income Statement. Once completed, use the necessary figures and calculate the proper Financial Figures and Ratios (ALL CELLS with 3 question marks should be filled using Excel Functions and Capabilities; Hard Coding a cell (typing the answer) will result in a 50% deduction). Understanding the logic behind the interaction of financial statements and ratios will help greatly as the answers and calculations are common questions on the Capsim Exam! DIGBY 5,109 CHECK FIGURES (Cells should be Green) ??? 1,256 (5,884) (1,734) 3,158 Cash Flow Summary: Cash Flows from Operating Activities ANDREWS BALDWIN CHESTER Net Income (Loss) $ 2,123 $ (2,356) $ (4,573) $ Adjustment for Non Cash Items Depreciation $ 3,535 $ 2,704 $ 2,760 Extraordinary Gain/Losses/Writeoff $ $ $ (156) $ Changes in Current Assets and Liabilities Accounts Payable $ 52 $ (1,334) $ (979) $ Inventory $ 6,838 $ 3,350 ??? $ Accounts Receivable $ (806) $ 609 $ 766 $ Net Cash From Operations: ??? $ 2,973 $ (17,744) Cash Flows from Investing Activities Plant Improvements (Net): $ (7,700) $ $ $ Cash Flows from Financing Activities Dividends Paid $ $ $ $ Sales of Common Stock $ 3,000 $ $ $ Purchase of Common Stock $ $ $ $ Cash from Long Term Debt $ $ $ 1,340 $ Early Retirement of Long Term Debt $ $ $ $ Retirement of Current Debt $ (5,168) $ (11,700) $ (6,877) $ Cash from Current Debt Borrowing $ $ 2,750 $ 13,715 $ Cash From Emergency Loan $ $ ??? $ Net Cash From Financing Activities: $ (2,168) $ (8,950) $ 15,662 $ Effect of Exchange Rate $ (232) $ (66) $ (259) $ (11,240) 4,000 $ - 3,000 (2,200) 4,800 (419) (259) $ Effect of Exchange Rate $ Net Change in Cash Position: $ (232) $ 1,641 $ (66) $ (6,043) $ (419) ??? Cash Accounts Receivable Inventory Total Current Assets Plant and Equipment Accumulated Deprecation Total Fixed Assets Total Assets: Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings Total Equity Total Liabilities & Owners Equity: Balance Sheet: ANDREWS BALDWIN CHESTER $ 1,641 $ 9,779 $ $ $ 5,352 $ 3,360 $ 4,707 $ ??? $ 9,419 $ 33,240 $ $ 13,425 ??? $ 37,947 $ $ 53,020 $ 40,560 $ 41,400 $ $ (21,259) $ (19,808) $ (19,044) $ $ 31,761 ??? $ 22,356 $ ??? ??? ??? $ 3,080 $ 2,233 $ 4,688 $ $ $ 2,750 $ 21,200 $ $ 11,000 $ 17,000 $ 21,840 $ 14,080 $ 21,983 $ 47,728 $ ??? $ 7,808 $ 6,808 $ $ 21,859 $ 13,519 ??? $ $ 31,106 ??? $ 12,575 $ 45,186 $ 43,310 $ 60,303 DIGBY 7,755 9,196 15,098 32,049 66,160 (22,971) 43,189 ??? 6,444 u $ ??? 29,444 15,808 29,987 ??? ??? Income Statement: ANDREWS BALDWIN CHESTER Sales ??? $ 40,879 $ 57,274 Variable Cost (Labor, Material, Carry, Ship) $ 45,081 $ 31,653 $ 45,466 $ Depreciation $ 3,535 $ 2,704 ??? $ SG&A (R&D/Promo/Sales/Admin) $ 11,613 ??? $ 10,475 $ Other (Fees/Writeoffs) $ 150 $ $ (89) $ EBIT $ 4,742 $ (1,077) $ (1,339) $ Interest (Short Term/Long Term) $ 1,474 $ 2,469 $ 5,681 $ Taxes $ 1,102 $ (1,190) $ (2,447) $ Profit Sharing $ 43 $ $ $ Net Profit $ 2.123 ??? ??? DIGBY ??? 74,330 4,411 19,255 350 13,538 2,779 5,545 105 ??? $ Net Profit $ 2,123 ??? ??? ??? FINANCIALS: ANDREWS Sales ??? EBIT ??? Net Profit ??? SG&A% ??? Contribution Margins % ??? Emergency Loans ??? RATIOS: ANDREWS Return on Assets ??? Return on Equity ??? Return on Sales ??? Asset Turnover ??? Leverage ??? Analysis Questions (Briefly explain in 2-3 sentences): 1) Which Company is performing the best and using the above key financials and ratios? --> BALDWIN ??? ??? ??? ??? ??? ??? BALDWIN ??? ??? ??? ??? ??? CHESTER ??? ??? ??? ??? ??? ??? CHESTER ??? ??? ??? ??? ??? DIGBY ??? ??? ??? ??? ??? ??? DIGBY ??? ??? ??? ??? ??? 2) Which Company is performing the worst and using the above key financials and ratios? --> 3) Explain the relationship between the Income Statement, Balance Sheet, and Cash Flows -->