Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

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

Gold And Debt

Authors: William Lyman Fawcett

1st Edition

1144211727, 978-1144211729

More Books

Students also viewed these Finance questions

Question

Are auditors responsible for catching material fraud?

Answered: 1 week ago