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 and balance sheets in thousands of dollars are shown.
Laiho Industries: Balance Sheets as of December thousands of dollars
negative values, if any.
Download spreadsheet Financial Statements, Cash Flow, and Taxesderxlsx
Laiho Industries: Income Statement for Year Ending December
thousands of dollars Laiho Industries: Statement of Stockholders' Equity, December thousands of dollars
Laiho Industries: Statement of Cash Flows for 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 longterm debt
Increase in common stock
Payment of common dividends
Net cash provided by financing activities
Summary
Net increasedecrease in cash
Cash at the beginning of the year
Cash at the end of the year
$
$
$
c Calculate and net operating working capital NOWC and free cash flow FCF Assume the firm has no excess cash.
NOWC :$ thousand
:$ thousand
:$ 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 aftertax cost of capital is What is the firm's EVA?
$ thousand
f Assume that the firm's stock price is $ per share and that at yearend the firm has million shares outstanding. What is the firm's MVA at yearend
$
thousand
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
