Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Activity: Financial Statements, Cash Flow, and TaxesLaiho Industries's 2 0 2 0 and 2 0 2 1 balance sheets ( in thousands of dollars
Excel Activity: Financial Statements, Cash Flow, and TaxesLaiho Industries's and balance sheets in thousands of dollars are shown.Laiho Industries: Balance Sheets as of December thousands of dollarsCash$$Accounts receivableInventories Total current assets$$Net fixed assetsTotal assets$$ Accounts payable$$AccrualsNotes payable Total current liabilities$$Longterm debt Total liabilities$$Common stockRetained earnings Total common equity$$Total liabilities and equity$$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 $ thousand should be entered as not 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 TaxesbdbxlsxSales for were $ and EBITDA was of sales. Furthermore, depreciation and amortization were of net fixed assets, interest was $ the corporate tax rate was and Laiho pays of its net income as dividends. Given this information, construct the firm's income statement.Laiho Industries: Income Statement for Year Ending December thousands of dollarsSales$ fill in the blank Operating costs excluding depreciation and amortizationfill in the blank EBITDA$ fill in the blank Depreciation and amortizationfill in the blank EBIT$ fill in the blank Interestfill in the blank EBT$ fill in the blank Taxes fill in the blank Net income$ fill in the blank Common dividends$ fill in the blank Addition to retained earnings$ fill in the blank Construct the statement of stockholders' equity for the year ending December and the 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 thousands of dollarsCommon StockRetained EarningsTotal Stockholders' EquityBalances, December $ fill in the blank $ fill in the blank $ fill in the blank Common stock issuefill in the blank fill in the blank Net incomefill in the blank Cash dividendsfill in the blank Addition to retained earningsfill in the blank Balances, December $ fill in the blank $ fill in the blank $ fill in the blank Laiho Industries: Statement of Cash Flows for thousands of dollarsOperating ActivitiesNet income$ fill in the blank Depreciation and amortizationfill in the blank Increase in accounts payablefill in the blank Increase in accrualsfill in the blank Increase in accounts receivablefill in the blank Increase in inventoriesfill in the blank Net cash provided by operating activities$ fill in the blank Investing ActivitiesAdditions to property, plant, and equipment$ fill in the blank Net cash used in investing activities$ fill in the blank Financing ActivitiesIncrease in notes payable$ fill in the blank Increase in longterm debtfill in the blank Increase in common stockfill in the blank Payment of common dividendsfill in the blank Net cash provided by financing activities$ fill in the blank SummaryNet increasedecrease in cash$ fill in the blank Cash at the beginning of the yearfill in the blank Cash at the end of the year$ fill in the blank Calculate and net operating working capital NOWC and free cash flow FCF Assume the firm has no excess cash.NOWC: $ fill in the blank thousandNOWC: $ fill in the blank thousandFCF: $ fill in the blank thousandIf 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.Assume that the firm's aftertax cost of capital is What is the firm's EVA?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started