Please help me! NO HARDCODED CELLS ALLOWED. I will rate positive if correct! All info is in the excel spreadsheet!
X fx ??? DIGBY ??? ??? ??? Financial Statement Analysis FINANCIALS: ANDREWS BALDWIN CHESTER Sales ??? ??? ??? EBIT ??? ??? ??? 7 Profits ??? ??? ??? 8 SG&A % ??? ??? ??? 9 Contribution Margins % ??? ??? ??? 10 Emergency Loans ??? ??? ??? 11 RATIOS: ANDREWS BALDWINCHESTER 12 Return on Assets ??? ??? ??? ?? 13 Return on Equity ??? ??? 14 Return on Sales ??? ??? ??? 15 Asset Turnover ??? ??? ??? 16 Leverage ??? ??? ??? 17 Analysis Questions: (Briefly explain in 2-3 sentences) 18 1)Which Company is performing the best and 19 using the above key financials and ratios? --> ??? ??? ??? DIGBY ??? ??? ??? ??? ??? ??? Caps im Website (Contains helpful formulas) 20 23 2)Which Company is performing the worst and 24 using the above key financials and ratios? --> 25 26 27 3)Explain the relationship between the Income 28 Statement, Balance Sheet, and Cash Flows--> 29 30 32 Cash Flow Summary: ANDREWS BALDWIN CHESTER D IGBY 2,123 $ (2,356) $ (4,573) $ 5,109 33 34 Cash Flows from Operating Activities 35 Net Income (Loss) 36 Adjustment for Non Cash Items 37 Depreciation 38 Extraordinary Gain/Losses/Writeoff CHECK FIGURES (Cells should be Green) $ 3,535 $ 2,704 $ ??? 2,760 (156) $ - S E5 , X fx ??? 40 41 52 $ 6,838 $ (806) $ ??? (1,334) S 3,350 609 $ 2,973 S (979) S ??? S 766 $ (17,744) S 1,256 (5,884) (1,734) 3,158 (7,700) $ $ - $ (11,240) - $ 39 Changes in Current Assets and Liabilities Accounts Payable Inventory 42 Accounts Receivable 43 Net Cash From Operations: 44 Cash Flows from Investing Activities Plant Improvements (Net): S 46 Cash Flows from Financing Activities 47 Dividends Paid Sales of Common Stock 49 Purchase of Common Stock 50 Cash from Long Term Debt Early Retirement of Long Term Debt 52 Retirement of Current Debt Cash from Current Debt Borrowing 54 Cash From Emergency Loan 55 Net Cash From Financing Activities: S 56 Effect of Exchange Rate S Net Change in Cash Position: $ 48 4,000 3,000 (5,168) (2.200) (11,700) $ 2.750 $ 1,340 $ - $ (6,877) $ 13,715 $ ??? $ 15,662 S (259) $ - (2,168) S (232) S 1,641 $ (8,950) S (66) $ (6,043) $ 4,800 (419) ??? 58 62 63 64 Cash Accounts Receivable Inventory Total Current Assets Plant and Equipment Accumulated Deprecation Total Fixed Assets DIGBY 7,755 9.196 15,098 32,049 66,160 (22,971) 43,189 ??? 6,444 Balance Sheet: ANDREWS BALDWINCHESTER 1,641 $ 9,779 $ - $ $ 5,352 $ 3,360 $ 4,707 $ ??? $ 9,419 $ 33,240 $ $ 13,425 2?? 37,947 $ $ 53,020 $ 40,560 $ 41,400 $ $ (21,259) S (19,808) S (19,044) $ $ 31,761 ??? S 22,356 $ Total Assets: ??? ??? ??? $ 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 13,519 ??? S 66 67 68 69 70 71 72 73 Accounts Payable Current Debt Long Term Debt Total Liabilities Common Stock Retained Earnings ??? 29,444 15,808 29,987 ??? 74 E5 X v fx ??? F G H Total Equity 75 76 $ Total Liabilities & Owners Equity: $ B 31,106 45,186 C ??? 43,310 $ $ D 12,575 60,303 E ??? ??? $ 77 78 79 80 Sales 81 Variable Cost (Labor, Material, Carry, Ship) 82 Depreciation 83 SG&A (R&D/Promo/Sales/Admin) 84 Other Fees/Writeoffs) 85 EBIT 86 Interest (Short Term/Long Term) Taxes 88 Profit Sharing 89 Net Profit Income Statement: ANDREWS BALDWINCHESTER ??? 40,879 $ 57,274 $ 45,081 $ 31,653 $ 45,466 $ 3,535 $ 2,704 ??? $ 11,613 ??? S 10,475 $ 150 (89) $ 4,742 $ (1,077) $ (1,339) $ 1,474 $ 2,469 $ 5,681 $ 1,102 $ (1,190) $ (2,447) $ 43 $ - S 2,123 ??? ??? DIGBY ??? 74,330 4,411 19,255 350 13,538 2,779 5,545 105 ??? 87 S
