Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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) 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. a. Sales for 2021 were $459,150,000, and EBITDA was 14% of sales. Furthermore, depreciation and amortization were 17% of net fixed assets, interest was $8,743,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) b. Construct the satement of mockholden' equity for the year ending December 31, 2021, and the 2021 statement of cath fows. Hinte The anference in ackumulated depreciathos from one year to ife next is the annoal deprecabbet evpenie for the year. Iaiho Industries Statement of 5tockholders' Equity, December 31, 2021 (theusande of Aollars) Laihe Induntriest Statement of Cash Flows for 2021 (thousands of dellars) Cyculate 2020 and 2021 net bperating working capital (NOWC) and 2021 free cash flow (FCF), Astume the frm has ne facess cast. a. If Lino inereased its dividend paryout retio, whot effect would tis have on corporate taxes paid? what effect would the have on taves peid by the comparty's sharaholders? If Lahe increased its dinsend pavout ratio, the firm nould pay mould receive. f corporate tanes and the comoneri sharebsiders would poy thousend thousend

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

Step: 3

blur-text-image

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

Treasury Financial Manual Volume II III And IV

Authors: US Treasury

1st Edition

1790321824, 978-1790321827

More Books

Students also viewed these Accounting questions