Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Laiho Industries: Balance Sheets as of December 3 1 ( thousands of dollars ) 2 0 2 1 2 0 2 0 Cash $ 1

Laiho Industries: Balance Sheets as of December 31(thousands of dollars)
20212020
Cash $ 100,972 $ 90,855
Accounts receivable 104,72787,064
Inventories 38,43635,330
Total current assets $ 244,135 $ 213,249
Net fixed assets 65,20341,427
Total assets $ 309,338 $ 254,676
Accounts payable $ 31,038 $ 23,750
Accruals 28,03421,188
Notes payable 15,93613,266
Total current liabilities $ 75,008 $ 58,204
Long-term debt 73,93362,333
Total liabilities $ 148,941 $ 120,537
Common stock 96,00086,000
Retained earnings 64,39748,139
Total common equity $ 160,397 $ 134,139
Total liabilities and equity $ 309,338 $ 254,676
The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Enter your answers in thousands. For example, an answer of $1 thousand should be entered as 1, not 1,000. Round your answers to the nearest whole number. Use a minus sign to enter negative values, if any.
Download spreadsheet Financial Statements, Cash Flow, and Taxes-64786c.xlsx
Sales for 2021 were $442,150,000, and EBITDA was 14% of sales. Furthermore, depreciation and amortization were 17% of net fixed assets, interest was $8,929,000, the corporate tax rate was 25%, and Laiho pays 48.25% of its net income as dividends. Given this information, construct the firm's 2021 income statement.
Laiho Industries: Income Statement for Year Ending December 31,2021(thousands of dollars)
2021
Sales $ fill in the blank 2
442150
Operating costs excluding depreciation and amortization fill in the blank 3
380249
EBITDA $ fill in the blank 4
61901
Depreciation and amortization fill in the blank 5
11085
EBIT $ fill in the blank 6
50816
Interest fill in the blank 7
8929
EBT $ fill in the blank 8
41887
Taxes (25%) fill in the blank 9
10472
Net income $ fill in the blank 10
31415
Common dividends $ fill in the blank 11
15158
Addition to retained earnings $ fill in the blank 12
16257
Construct the statement of stockholders' equity for the year ending December 31,2021, and the 2021 statement of cash flows. Hint: The difference in accumulated depreciation from one year to the next is the annual depreciation expense for the year.
Laiho Industries: Statement of Stockholders' Equity, December 31,2021(thousands of dollars)
Common Stock Retained Earnings Total Stockholders' Equity
Balances, December 31,2020 $ fill in the blank 13
86000
$ fill in the blank 14
48139
$ fill in the blank 15
134139
Common stock issue fill in the blank 16
10000
fill in the blank 17
10000
2021 Net income fill in the blank 18
31415
Cash dividends fill in the blank 19
-15157
Addition to retained earnings fill in the blank 20
16258
Balances, December 31,2021 $ fill in the blank 21
96000
$ fill in the blank 22
64397
$ fill in the blank 23
160397
Laiho Industries: Statement of Cash Flows for 2021(thousands of dollars)
2021
Operating Activities
Net income $ fill in the blank 24
31415
Depreciation and amortization fill in the blank 25
11085
Increase in accounts payable fill in the blank 26
7288
Increase in accruals fill in the blank 27
6846
Increase in accounts receivable fill in the blank 28
-17663
Increase in inventories fill in the blank 29
-3106
Net cash provided by operating activities $ fill in the blank 30
35865
Investing Activities
Additions to property, plant, and equipment $ fill in the blank 31
Net cash used in investing activities $ fill in the blank 32
Financing Activities
Increase in notes payable $ fill in the blank 33
2670
Increase in long-term debt fill in the blank 34
11600
Increase in common stock fill in the blank 35
10000
Payment of common dividends fill in the blank 36
-15158
Net cash provided by financing activities $ fill in the blank 37
9112
Summary
Net increase/decrease in cash $ fill in the blank 38
Cash at the beginning of the year fill in the blank 39
90855
Cash at the end of the year $ fill in the blank 40
Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excess cash.
NOWC2020: $ fill in the blank 41
168311
thousand
NOWC2021: $ fill in the blank 42
185063
thousand
FCF2021: $ fill in the blank 43
thousand
If Laiho increased its dividend payout ratio, what effect would this have on corporate taxes paid? What effect would this have on taxes paid by the company's shareholders?
If Laiho increased its dividend payout ratio, the firm would pay
the same amount of
corporate taxes and the company's shareholders would pay
more
taxes on the dividends they would receive.
Assume that the firm's after-tax cost of capital is 10.5%. What is the firm's 2021 EVA?
$ fill in the blank 46
thousand

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investing All In One For Dummies

Authors: Eric Tyson

2nd Edition

1119873037, 978-1119873037

More Books

Students also viewed these Finance questions