Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need the formulas for the orange shaded cells. Sales for 2021 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were
i need the formulas for the orange shaded cells.
Sales for 2021 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 18% of net fixed assets, interest was $8,583,000, the corporate tax rate was 25%, and Laiho pays 47.25% of its net income as dividends. Given this information, construct the firm's 2021 income statement. The input information required for the problem is outlined in the "Key Input Data" section below. Using this data and the balance sheet above, I constructed the income statement shown below. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excesss cash. Construct the statement of stockholders' equity for the year ending December 31, 2021, and the 2021 statement of cash flows. Sales for 2021 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 18% of net fixed assets, interest was $8,583,000, the corporate tax rate was 25%, and Laiho pays 47.25% of its net income as dividends. Given this information, construct the firm's 2021 income statement. The input information required for the problem is outlined in the "Key Input Data" section below. Using this data and the balance sheet above, I constructed the income statement shown below. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excesss cash. Construct the statement of stockholders' equity for the year ending December 31, 2021, and the 2021 statement of cash flows 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