a. | |
Sales | $455,150 |
EBITDA as a percentage of sales | 15% |
Depr. as a % of fixed assets | 18% |
Tax rate | 25% |
Interest expense | $8,583 |
Dividend payout ratio | 47% |
Laiho Industries Income Statement | |
(in thousands of dollars) | |
2019 | |
Sales | $455,150 |
Expenses excluding depreciation and amortization | $386,878 |
EBITDA | $68,273 |
Depreciation and amortization | $12,090 |
EBIT | $56,183 |
Interest expense | $8,583 |
EBT | $47,600 |
Taxes (25%) | $11,900 |
Net Income | $35,700 |
Common dividends | $16,868 |
Addition to retained earnings | $18,832 |
b. | |
Statement of Stockholders' Equity | |
(in thousands of dollars) | |
Balance of Retained Earnings, December 31, 2018 | $38,773 |
Add: Net Income, 2019 | $35,700 |
Less: Common dividends paid, 2019 | -16,868 |
Balance of Retained Earnings, December 31, 2019 | $57,605 |
Statement of Cash Flows | |
(in thousands of dollars) | |
Operating Activities | |
Net Income | $35,700 |
Depreciation and amortization | 12,090 |
Increase in accounts payable | 7,651 |
Increase in accruals | 7,821 |
Increase in accounts receivable | ($17,838) |
Increase in inventories | ($3,462) |
Net cash provided by operating activities | $41,962 |
Investing Activities | |
Additions to property, plant, and equipment | ($36,819) |
Net cash used in investing activities | ($36,819) |
Financing Activities | |
Increase in notes payable | $2,500 |
Increase in long-term debt | 12,350 |
Increase in common stock | 10,000 |
Payment of common dividends | ($16,868) |
Net cash provided by financing activities | $7,982 |
Summary | |
Net increase/decrease in cash | $13,125 |
Cash balance at the beginning of the year | 89,725 |
Cash balance at the end of the year | $102,850 |
c. | ||||
Net Working Capital | ||||
NWC18 = | current assets | - | (A/P and accruals) | |
NWC18 = | $210,234 | - | $45,766 | |
NWC18= | $164,468 | |||
NWC19 = | current assets | - | (A/P and accruals) | |
NWC19 = | $244,659 | - | $61,238 | |
NWC19 = | $183,421 |
Free Cash Flow | |||||
FCF19 = | EBIT(1-T) | + | Depreciation | - | [Capital expenditure+Increase in NWC] |
FCF19 = | $42,137 | + | $12,090 | - | 36819+18953 |
FCF19= | ($1,545) |
d. | An increase in the firm's dividend payout ratio would have no effect on its corporate taxes paid because dividends are paid with after-tax dollars. However, the company's shareholders would pay additional taxes on the additional dividends they would receive. | |||
e. | |
EVA | = EBIT(1 – Tax) – (Total invested capital x After-tax cost of capital) |
Total invested capital | = Notes payable + Long term debt + Common equity |
Total invested capital 2019 | = $16,717 + $76,264 + $157,605 = $250,586 |
EVA 2019= | = $42137.1 – ($250,586 x 0.105) |
$ 15,825.57 |
f.
MVA = (Stock price x shares) – Book value of common equity | |
MVA 2019 = | = ($22 x 10,000) - $157,605 = $62,395 |
431428470293373958327&eISBN=9781337911009&id=705774549&snapshotid=15798828 mnts, Cash Flow, and Taxes Comprehensive/Spreadsheet Problem 3-19. FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho...
Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...
3. Andrea Aerospace's 2018 and 2017 balance sheets (in thousands of dollars) are shown. Andrea Aerospace December 31 Balance Sheets (in thousands of dollars) 2018 2017 s Assets Cash Accounts receivable Inventories Total current assets Net fixed assets Total assets 102.850 103,365 38.444 244,659 67,165 311.824 s $ 89.725 85.527 34,982 $ 210.234 42,436 $ 252.670 $ Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earings Total common equity Total...
Below are Laiho Industries’ 2017 and 2018 balance sheet items: 2018 2017 Cash 102,850 89,725 Accounts receivable 103,365 85,527 Long-term debt 76,264 63,914 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 Accruals 30,477 22,656 Inventories 38,444 34,982 Retained earnings 57,605 38,774 Sales for 2018 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575,000, the corporate tax rate was 40%,...
(30 points) Financial Statements: Laiho Industries's 2014 and 2015 balance sheets in thousands of dollars) are shown. Laiho Indus tries December 31 Balance Sheets (in thousands of dollars) 2015 2014 Assets Cas h Accounts receivable Inventories Total current assets Net fixed assets Total assets S 102,850 S 89,725 85,527 34,982 S 244,659 S 210,234 42,436 S 311,824 S 252,670 103,365 38,444 67,165 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained...
lookign to have a b c completed F92 6 Balance Sheets 7 (in thousands of dollars) 2013 2012 9 Assets S91,450 $11,400 103,365 $38,444 $244,659 $67,165 311,824 $74,625 15,100 $85,527 34,982 $210,234 $42,436 $252,670 Cash and cash equivalents 11 Short-term investments 2 Accounts Receivable 4 Total current assets 15 Net fixed assets 16 Total assets 17 18 Liabilities and equity 19 Accounts payable 20 Accruals 21 Notes payable 22 Total current liabilities 23 Long-term debt 4 Total liabilities 25 Common...
Ch 03: Blueprint Problems - Financial Statements, Cash Flow, and Taxes Quantitative Problem: Roshan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets y Tools 2018 $85 300 2019 $100 275 375 $750 2,300 $3,050 250 $635 1,490 $2,125 ips Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets Labies and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings...
Ch 03: End-of-Chapter Problems - Financial Statements, Cash Flow, and Taxes The assets of Dallas & Associates consist entirely of current assets and net plant and equipment, and the firm has no excess cash. The firm has total assets of $2.6 million and net plant and equipment equals $2.3 million. It has notes payable of $160,000, long-term debt of $757,000, and total common equity of $1.45 million. The firm does have accounts payable and accruals on its balance sheet. The firm...
What is the Cash Flow from Operation Activiy for 2019? Whats is Cash Flow from Investing Activity for 2019? What is the Cash Flow form Financing Activity for 2019? 2018 2019 2018 2019 Assets Liabilities & Equity Current assets: Cash and marketable securities $ 5 19 29 Current liabilities: Accrued wages and taxes Accounts payable Notes payable $ 5 20 36 S 6 15 Accounts receivable S 10 16 = = = Inventory Total $ 53 $ 61 Total $...
What is the Cash Flow from Operating Activiy for 2019 What is Cash Flow from investing Activity for 2019 What is the Cash Flow from Financing Activity for 2019 2018 2019 2018 2019 Assets Liabilities & Equity Current assets: Cash and marketable securities $ 5 19 29 Current liabilities: Accrued wages and taxes Accounts payable Notes payable $ 5 20 36 S 6 15 Accounts receivable S 10 16 = = = Inventory Total $ 53 $ 61 Total $...
a. Calculate the firm's net operating profit after taxes (NOPAT) for the year ended December 31, 2019 b. Calculate the firm's operating cash flow (OCF) for the year ended December 31, 2019 c. Calculate the firm's free cash flow (FCF) for the year ended December 31, 2019 d. Interpret, compare and contrast your cash flow estimate in parts (b) and (c) Keith Corporation Balance Sheets December 31 Assets Cash Marketable securities Accounts receivable Inventories 2019 2018 $1,510 1,750 1,980 2,860...