Sales for 2018 were $455,150 and EBITDA was 15% of sales. Furthermore, depreciation and amortization were...

Transcribed Image Text:

Sales for 2018 were $455,150 and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends. Given this information, construct the firm's 2018 balance sheet, income statement, statement of cash flows, and statement of owner's equity. 1. What are expenses excluding depreciation and amortization for 2018? 2. What is EBIT for 2018? 3. What is income for 2018? 4. What is the total balance of stockholders' Equity at the end of 2018? 5. What was net cash provided by (used in) operating activities for 2018? 6. What was net cash provided by (used in) investing activities for 2018? 7. What was net cash provided by (used in) financing activities for 2018? 8. What was the increase/decrease in cash for 2018? 9. What is NOWC for 2017? 10. What is NOWC for 2018? 11. What is the free cash flow for 2018? 2018 2017 Operating Activities Net Income Depreciation and amortization Cash $102,850 $ 89,725 Account Payable Accounts receivable 103,365 85.527 accruals Long-term debt 76.264 63.914 accounts receivable Accounts payable $ 30,761 $ 23,109 Common stock 100.000 90,000 Notes payable 16.717 14.217 Net fixed assets 67.165 42,436 inventories Net cash provided by (used in) operating activities Investing Activities Accruals 30,477 22,656 PPE Inventories 38.444 34,982 Net cash provided by (used in) investing activities Retained earnings 57,605 38,774 Financing Activities Notes payable Long-term debt Common Stock Common Dividends Net cash provided by (used in) financing activities Summary Net increase/decrease in cash Cash balance at the beginning of the year Cash balance at the end of the year Sales for 2018 were $455,150 and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends. Given this information, construct the firm's 2018 balance sheet, income statement, statement of cash flows, and statement of owner's equity. 1. What are expenses excluding depreciation and amortization for 2018? 2. What is EBIT for 2018? 3. What is income for 2018? 4. What is the total balance of stockholders' Equity at the end of 2018? 5. What was net cash provided by (used in) operating activities for 2018? 6. What was net cash provided by (used in) investing activities for 2018? 7. What was net cash provided by (used in) financing activities for 2018? 8. What was the increase/decrease in cash for 2018? 9. What is NOWC for 2017? 10. What is NOWC for 2018? 11. What is the free cash flow for 2018? 2018 2017 Operating Activities Net Income Depreciation and amortization Cash $102,850 $ 89,725 Account Payable Accounts receivable 103,365 85.527 accruals Long-term debt 76.264 63.914 accounts receivable Accounts payable $ 30,761 $ 23,109 Common stock 100.000 90,000 Notes payable 16.717 14.217 Net fixed assets 67.165 42,436 inventories Net cash provided by (used in) operating activities Investing Activities Accruals 30,477 22,656 PPE Inventories 38.444 34,982 Net cash provided by (used in) investing activities Retained earnings 57,605 38,774 Financing Activities Notes payable Long-term debt Common Stock Common Dividends Net cash provided by (used in) financing activities Summary Net increase/decrease in cash Cash balance at the beginning of the year Cash balance at the end of the year

Answer rating: 100% (QA)

Answer To answer these questions we need to start by calculating various financial metrics based on the given information Then we can use these metric... View the full answer