Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Fill in the missing cells with ??? in the financial statement sheets. (Please show equations used for all answers) 2. Fill In the cells with
Fill in the missing cells with "???" in the financial statement sheets. (Please show equations used for all answers)
2. Fill In the cells with "???" based off the previous financial statements above. (Please show equations used for all answers)
2,123 $ (2,356) S (4.573) S 5,109 CHECK FIGURES (Cells should be Green) 4,411 3,535 $ $ 2,704 S $ 2,760 (156) S 52 $ 6,838 $ (806) S 11,742 $ (1,334) S 3,350 $ 609 $ 2,973 $ (979) S (15,562 766 S (17,744) S 1,256 (5.884) (1.734) 3,158 (7,700) $ $ $ (11.240) Net Income (Loss) $ Adjustment for Non Cash Items Depreciation $ Extraordinary Gain/Losses/Writeoff $ Changes in Current Assets and Liabilities Accounts Payable $ Inventory $ Accounts Receivable $ Net Cash From Operations: Cash Flows from Investing Activities Plant Improvements (Net): $ Cash Flows from Financing Activities Dividends Paid $ Sales of Common Stock $ Purchase of Common Stock $ Cash from Long Term Debt $ Early Retirement of Long Term Debt $ Retirement of Current Debt $ Cash from Current Debt Borrowing $ Cash From Emergency Loan $ Net Cash From Financing Activities: $ Effect of Exchange Rate $ Net Change in Cash Position: $ 4,000 $ 3,000 $ $ $ $ (5,168) $ $ 3,000 $ $ s s s (11,700) S 2,750 $ $ (8,950) S (66) S (6,043) $ $ $ s 1,340 $ s (6,877) $ 13,715 7,484 | s 15,662 S (259) $ (2,200) $ (2.168) $ (232) 1,641 $ 4.800 (419) (3,701 Balance Sheet: ANDREWS BALDWIN CHESTER Cash $ 1,641 $ 9,779 $ s Accounts Receivable $ 5,352 $ 3,360 s 4,707 S Inventory $ 6,432 | 5 9,419 $ 33.240 $ Total Current Assets $ 13.425 22,558S 37,947 S Plant and Equipment $ 53,020 $ 40,560 $ 41,400 $ Accumulated Deprecation $ (21,259) S (19.808) $ (19,044) S Total Fixed Assets $ 31,761 $ 20,752 | s 22,356 S Total Assets: 45,186 $ 43,310 $ 60,303 Accounts Payable $ 3,080 $ 2.233 S 4,688 S Current Debt $ $ 2.750 S 21,200 $ Long Term Debt $ 11,000 $ 17,000 S 21,840 Total Liabilities S 14,080 $ 21,983 S 47,728 $ Common Stock 9,247 7,808 S 6,808 S Retained Earnings $ 21,859 S 13,519 5,767 S Total Equity $ 31,106 21,327S 12,575 Total Liabilities & Owners Equity: $ 45,186 $ 43,310 S 60,303 DIGBY 7,755 9.196 15,098 32,049 66,160 (22.971) 43,189 75,238 6.444 23,000 29,444 15,808 29.987 45,795 75,239 DIGBY ??? 74,330 Income Statement: ANDREWS BALDWIN CHESTER Sales ??? $ 40,879 S 57.274 Variable Cost (Labor, Material, Carry, Ship) S 45,081 $ 31,653 $ 45,466 $ Depreciation $ 3.535 S 2,704 ??? S SG&A (R&D Promo/Sales/Admin) $ 11,613 S 10,475 S Other Fees/Writeoffs) $ 150 $ $ (89) S EBIT $ 4,742 $ (1,077) $ (1,339) S Interest (Short Term/Long Term) $ 1.474 $ 2,469 $ 5,681 S Taxes $ 1,102 $ (1,190) S (2.447) $ Profit Sharing $ 43 $ S S Net Profit $ 2,123 1,356 (4,573) 19.255 350 13,538 2,779 5.545 105 5,109 Financial Statement Analysis 8 SE re id FINANCIALS: Sales EBIT Profits SG&A % Contribution Margins % Emergency Loans RATIOS: Return on Assets Return on Equity Return on Sales Asset Turnover Leverage m st CE ANDREWS mm ?? ?? ?? ?? ?? ANDREWS ?? mm ??? mm ??? BALDWIN ??? ??? ??? ??? ??? ??? CHESTER ??? ??? ??? ??? ??? ??? CHESTER ??? ??? ??? ??? DIGBY ??? ??? ??? ??? ??? ??? DIGBY ?? ?? ?? ?? 77? BALDWIN ??? ??? ??? ??? 772 Y
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started