Question

431428470293373958327&eISBN=9781337911009&id=705774549&snapshotid=15798828 mnts, Cash Flow, and Taxes Comprehensive/Spreadshe
a. Sales for 2019 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 18% of net
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
431428470293373958327&eISBN=9781337911009&id=705774549&snapshotid=15798828 mnts, Cash Flow, and Taxes Comprehensive/Spreadsheet Problem 3-19. FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx...

    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...

    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...

    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...

    (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)...

    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...

    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

    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...

    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...

    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,...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT