Question: send to an expert and please help me solve this problem by answering everything in the pictures. Excel Activity: Financial Statements, Cash Flow, and Taxes

send to an expert and please help me solve this problem by answering everything in the pictures.
Excel Activity: Financial Statements, Cash Flow, and Taxes
Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown.
Laiho Industries: Balance Sheets as of December 31(thousands of dollars)
negative values, if any.
Download spreadsheet Financial Statements, Cash Flow, and Taxes-5d74er.xlsx
Laiho Industries: Income Statement for Year Ending December 31,2021
(thousands of dollars) Laiho Industries: Statement of Stockholders' Equity, December 31,2021(thousands of dollars)
Laiho Industries: Statement of Cash Flows for 2021(thousands of dollars)
Operating Activities
Net income
Depreciation and amortization
Increase in accounts payable
Increase in accruals
Increase in accounts receivable
Increase in inventories
Net cash provided by operating activities
Investing Activities
Additions to property, plant, and equipment
Net cash used in investing activities
Financing Activities
Increase in notes payable
Increase in long-term debt
Increase in common stock
Payment of common dividends
Net cash provided by financing activities
Summary
Net increase/decrease in cash
Cash at the beginning of the year
Cash at the end of the year
$
$
$
?
c. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excess cash.
NOWC ?(()2020):$ thousand
NOWC2021:$ thousand
FCF2021:$1 thousand
d. 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
corporate taxes and the company's shareholders would pay
taxes on the dividends they would receive.
e. Assume that the firm's after-tax cost of capital is 11.5%. What is the firm's 2021 EVA?
$ thousand
f. Assume that the firm's stock price is $23 per share and that at year-end 2021 the firm has 10 million shares outstanding. What is the firm's MVA at year-end 2021?
$
thousand
 send to an expert and please help me solve this problem

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!