I have to fill in all of the blanks. Please help.

Excel Activity: Financial Statements, Cash flow, and Taxes Laho industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Laiho Industries: Balance Sheets as of December 31 (thousands of dnllare). The data has been collected in the Microsoft Excel fle 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, oop. b. Constructing the statement of steckholders' equify for the year ending December 31,2011 . and the 2021 statemert of cash fices 622021 Net income 63 Cash dividends 64 Addtion to retalhed eamings 03 Balances. December 31, 2021 66 67) 7) Litho industries: Statement of Cash Flows for 2021 55 fin thousands of dollars) 69 Operating Activities 70 Ret incorme 71. Depreciation and amortization 72. Incease in accounts payable 73 increase in aconials 74 increase in acoounts recelvable 75 Increse in mveriories 76 Net eath provided by operating activist 20. Nel cash used in investing activites E2 Pinancing Acevitisa il3 incease in notes payable b4 Incresse in lynguemm debi 85. Porease in corrren stock. t6. Payment of convenen diNitends 8) Net cath provided by fhancing actries Summary 1) Nist increaseidecrease in eash 1. Eavh al the Deginning of the yeat 8 Cash at the end of the year. 5. Calculating 2020 and 2021 net operating working capital (NOWC) and 2021 tres cash Bow (FCF). Cachsal cash 25Pverem (en thousands of dolars) Nowerer (in thousands of colars) Qli FCE mu (in thousands of dolan) 100 \%. Caleculating the Fren's 2021 EVA 101 Alerdax cost of captal 1 tad EvA,uy (n thousende of dolar) 1041 Caiculasing the firmi MrVA at year and 2021 1055 tock price 100 timares outatanding 107 MvAyan (en thousands of eolars) 100160 10.000 BFUA 3. Sales for 2021 were $442,650,000, and EBITDA was 16% of sales, Furthermore, depreciation and amortization were 1946 of net fxed assets, interest was $7,838,000, the corporate tax rate was 25%, and Laifo pays 46.25% of its net incore as dividendts Given this information, condtuct the firm's 2021 income statement. Laiho Industries: Income statement for Year Ending December 31, 2021 (thousands of doliars) b. Construc the statement of stockholders' equity for the year anding December 31, 2021, and the 2021 statement of cash Fawn font: Fhe difference in acrumulared depreciation from one year to the next is the ancund depreciation exsense for the year. Laiho Industriest Statemant of Stochholders' Equify, December. 31, 2021 (thousands of doliars) Total stockholders Construct the statement of stockholders' equity for the year ending December 31,2021, and the 2021 statement of cash fiows. Hint: Fhe 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 31, 2021 (thousands of dollars) Laihe Industriest Statement of Cash Flows for 2021 (theusands of dollars) c. Calculate 2020 and 2021 net eperiting working captal (NOwC) and 2021 free cash flow (fFCr), Assume the fim has no excess cash, NowCrozots thousand NoWC2021's thousand FCF20211 thousand c. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excess cash. NOWC No20t 5 thousand NOWC 20215 thousand FCF Fedi 2015 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 compary's shareholders? If Laiho increased its dividend payout ratio, the firm would pay taxes on the dividends they would receive. corporate takes and the company's sharehelders would pay e. Assume that the firm's after-tax cost of capital is 11.5\%. What is the firm's 2021 EVA? 1 thousand f. Assume that the firm's stock price is 523 per share and that at year-end 2021 the firm has 10 milion shares outstanding, What is the firm's MvA at Yeariend 2021 ? 5 thousand Excel Activity: Financial Statements, Cash flow, and Taxes Laho industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Laiho Industries: Balance Sheets as of December 31 (thousands of dnllare). The data has been collected in the Microsoft Excel fle 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, oop. b. Constructing the statement of steckholders' equify for the year ending December 31,2011 . and the 2021 statemert of cash fices 622021 Net income 63 Cash dividends 64 Addtion to retalhed eamings 03 Balances. December 31, 2021 66 67) 7) Litho industries: Statement of Cash Flows for 2021 55 fin thousands of dollars) 69 Operating Activities 70 Ret incorme 71. Depreciation and amortization 72. Incease in accounts payable 73 increase in aconials 74 increase in acoounts recelvable 75 Increse in mveriories 76 Net eath provided by operating activist 20. Nel cash used in investing activites E2 Pinancing Acevitisa il3 incease in notes payable b4 Incresse in lynguemm debi 85. Porease in corrren stock. t6. Payment of convenen diNitends 8) Net cath provided by fhancing actries Summary 1) Nist increaseidecrease in eash 1. Eavh al the Deginning of the yeat 8 Cash at the end of the year. 5. Calculating 2020 and 2021 net operating working capital (NOWC) and 2021 tres cash Bow (FCF). Cachsal cash 25Pverem (en thousands of dolars) Nowerer (in thousands of colars) Qli FCE mu (in thousands of dolan) 100 \%. Caleculating the Fren's 2021 EVA 101 Alerdax cost of captal 1 tad EvA,uy (n thousende of dolar) 1041 Caiculasing the firmi MrVA at year and 2021 1055 tock price 100 timares outatanding 107 MvAyan (en thousands of eolars) 100160 10.000 BFUA 3. Sales for 2021 were $442,650,000, and EBITDA was 16% of sales, Furthermore, depreciation and amortization were 1946 of net fxed assets, interest was $7,838,000, the corporate tax rate was 25%, and Laifo pays 46.25% of its net incore as dividendts Given this information, condtuct the firm's 2021 income statement. Laiho Industries: Income statement for Year Ending December 31, 2021 (thousands of doliars) b. Construc the statement of stockholders' equity for the year anding December 31, 2021, and the 2021 statement of cash Fawn font: Fhe difference in acrumulared depreciation from one year to the next is the ancund depreciation exsense for the year. Laiho Industriest Statemant of Stochholders' Equify, December. 31, 2021 (thousands of doliars) Total stockholders Construct the statement of stockholders' equity for the year ending December 31,2021, and the 2021 statement of cash fiows. Hint: Fhe 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 31, 2021 (thousands of dollars) Laihe Industriest Statement of Cash Flows for 2021 (theusands of dollars) c. Calculate 2020 and 2021 net eperiting working captal (NOwC) and 2021 free cash flow (fFCr), Assume the fim has no excess cash, NowCrozots thousand NoWC2021's thousand FCF20211 thousand c. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excess cash. NOWC No20t 5 thousand NOWC 20215 thousand FCF Fedi 2015 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 compary's shareholders? If Laiho increased its dividend payout ratio, the firm would pay taxes on the dividends they would receive. corporate takes and the company's sharehelders would pay e. Assume that the firm's after-tax cost of capital is 11.5\%. What is the firm's 2021 EVA? 1 thousand f. Assume that the firm's stock price is 523 per share and that at year-end 2021 the firm has 10 milion shares outstanding, What is the firm's MvA at Yeariend 2021 ? 5 thousand