Please i need help with this Homework

Input area: In Thousands$ Cost of goods sold Cash Depreciation Interest expense Selling & Administrative Accounts payable Net fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity Tax rate Dividend percentage S 2020 196,619 28,372 55,506 12,067 38,668 20,143 244,881 385,724 20,104 22,855 123,607 38,706 21% 25% S 2021 248,263 42,865 62,738 13,831 50,469 34,091 298,350 470,172 26,078 24,955 140,000 52,057 15,000 21% 25% Instructions Te eam credit, please make sure to use referecne cell in formular. For example, to enter "Sales" in 2020, you should enter"-D55354" If you directly enter ambers as your answers below, there would be no credit. If you don't know how to use reference cell in formular, please watch Question 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 changed the top corporate tax sate from 35% to one flat rate of 21%. This rate will be effective for corporations whose tax yese begins after January 1, 2019, and it is a permanence) 2. Complete Balance Sheet of 2020 & 2021 9 Output area 2020 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Tarm Sheet1 https://support.microsoft.com/ene/office/video-understand-and-use-cell-references ecb125bbc0cb 48c1-b30f-cdb3arc05261 2021 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Trees 2020 Income Statenci Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings Cas Accounts receivable Incestory Carrete Net fixed as Total Balance sheet as of Dec. 31, 2020 2021 Income Stateme Sales Cost of goods sold Selling & Administrative Depreciation EBIT latest EBT Times Net incom Dividends Addition to retained ning O Accounts payable Notes payable Current liabilities Long-term del Owners' equity Total liab. & equity Balance sheet as of Dec. 31, 2021 Cask Accounts receivable In anory Caravels Net fixed assets Total 3. Work out 2021 Cash From Operating Activities (Pat zero if there is no change in the them) Statement of Cash Flows Operating Net income Depreciation Chape in AR Change in lev Change in AP Net Cask used by Operating Activities Accoans payable Notes payable Curren liabilities Long-term debe Owners' equity Total liah & equity O Hist. lacrosse (Decrease) in any accounts from LiS of % (es ARL, aveory, etc.) is "Use (Source) of Cash", (Positive) L, "Money out of (into) the Pocket and the sign is Negative 4. Work out 2021 Cass From Investing Actrotes 5 Work out 2021 Cash From Pancing Activies 11 31 24 m 00 12 13 Statement of Cash Flows-Investing Cashed in FA Change in S-T lavestments Net cash used by Investing Activities Statement of Cash Flows Financing Change in Notes Payable Change in LTD New Equity Ince Repechase Payment of Cash Dividends Net Cash provided by Financing Activis Head Cash wad see cash outflows, so the sign should be negative. Hint Total Equity-Padin Capital + JUE+Treasury Stock Repurchase-New Stock Iance Change in Retained Earings-Change in Total Equity New stock ice $15000 (given) Clin Retained Eaming-Net Income-Dividerul Payment Addition to Retainel Earnings (ice 2021 ISY Change in Total Pity-Equity in 2021 Eery in 2020 Repurchasesh outbow, so it is negative Payment of dividend is she cash outflow, anis negative 4 5 16 6. How would you describe the company cash flows for 2021? Write a brief discussion. 37 18 197. In light of your discussion in th eprevious quesiotn, do you think it is a good time for the company to expand business (i.e., buy more equipments/machines) at this time? 20 21 22 8. Please calculate the following Financial Ratios of the company, in year 2020 and 2021 respectively. Please briefly explain the trend of the company's financial position. 23 124 Ratios 2020 2021 Ratio Category Liquidity Ratio: 125 Current Ratio Quick Ratio 126 Hint: 127 Inventory Turnover Again, please make sure to use references in formular. For example, current ratio in 2020 "D72/171" 128 Days Sales Outstanding Asset Management Ratio: 129 Fixed Asset Turnover 130 Total Asset Turnover Debt Ratio: 131 Debt Management Ratio: 132 333 Times interest earned (TTE) Net Profit Margin Operating Profit Margin 134 135 Profitabiltiy Ratio: Basic Earning Power 136 ROA ROE 137 130 139 9. Please calculate the Du Pont Ratio in 2020 and 2021, respectively. Please explain the changes over years. 140 Hint: please refer to Unit 2 lecture and textbook chatper 2 to calculate Du Pont Ratio in 3 compontents A 4 Operating Profit Margin Basic Earning Power 85 Profitabiltiy Ratio: 36 ROA ROE 37 38 39 9. Please calculate the Du-Pont Ratio in 2020 and 2021, respectively. Please explain the changes over years. -40 Hint: please refer to Unit 2 lecture and textbook chatper 2 to calculate Du Pont Ratio in 3 compontents. 41 -42 43 10. By the end of year 2021, the firm has 100 millions of common shares. Stock price per share is $40 in 2020 and $50 in 2021. 44 Please calculate the P/E ratio and EPS in 2020 and 2021, respectively. Please explain the changes over years. Input area: In Thousands$ Cost of goods sold Cash Depreciation Interest expense Selling & Administrative Accounts payable Net fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity Tax rate Dividend percentage S 2020 196,619 28,372 55,506 12,067 38,668 20,143 244,881 385,724 20,104 22,855 123,607 38,706 21% 25% S 2021 248,263 42,865 62,738 13,831 50,469 34,091 298,350 470,172 26,078 24,955 140,000 52,057 15,000 21% 25% Instructions Te eam credit, please make sure to use referecne cell in formular. For example, to enter "Sales" in 2020, you should enter"-D55354" If you directly enter ambers as your answers below, there would be no credit. If you don't know how to use reference cell in formular, please watch Question 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 changed the top corporate tax sate from 35% to one flat rate of 21%. This rate will be effective for corporations whose tax yese begins after January 1, 2019, and it is a permanence) 2. Complete Balance Sheet of 2020 & 2021 9 Output area 2020 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Tarm Sheet1 https://support.microsoft.com/ene/office/video-understand-and-use-cell-references ecb125bbc0cb 48c1-b30f-cdb3arc05261 2021 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Trees 2020 Income Statenci Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings Cas Accounts receivable Incestory Carrete Net fixed as Total Balance sheet as of Dec. 31, 2020 2021 Income Stateme Sales Cost of goods sold Selling & Administrative Depreciation EBIT latest EBT Times Net incom Dividends Addition to retained ning O Accounts payable Notes payable Current liabilities Long-term del Owners' equity Total liab. & equity Balance sheet as of Dec. 31, 2021 Cask Accounts receivable In anory Caravels Net fixed assets Total 3. Work out 2021 Cash From Operating Activities (Pat zero if there is no change in the them) Statement of Cash Flows Operating Net income Depreciation Chape in AR Change in lev Change in AP Net Cask used by Operating Activities Accoans payable Notes payable Curren liabilities Long-term debe Owners' equity Total liah & equity O Hist. lacrosse (Decrease) in any accounts from LiS of % (es ARL, aveory, etc.) is "Use (Source) of Cash", (Positive) L, "Money out of (into) the Pocket and the sign is Negative 4. Work out 2021 Cass From Investing Actrotes 5 Work out 2021 Cash From Pancing Activies 11 31 24 m 00 12 13 Statement of Cash Flows-Investing Cashed in FA Change in S-T lavestments Net cash used by Investing Activities Statement of Cash Flows Financing Change in Notes Payable Change in LTD New Equity Ince Repechase Payment of Cash Dividends Net Cash provided by Financing Activis Head Cash wad see cash outflows, so the sign should be negative. Hint Total Equity-Padin Capital + JUE+Treasury Stock Repurchase-New Stock Iance Change in Retained Earings-Change in Total Equity New stock ice $15000 (given) Clin Retained Eaming-Net Income-Dividerul Payment Addition to Retainel Earnings (ice 2021 ISY Change in Total Pity-Equity in 2021 Eery in 2020 Repurchasesh outbow, so it is negative Payment of dividend is she cash outflow, anis negative 4 5 16 6. How would you describe the company cash flows for 2021? Write a brief discussion. 37 18 197. In light of your discussion in th eprevious quesiotn, do you think it is a good time for the company to expand business (i.e., buy more equipments/machines) at this time? 20 21 22 8. Please calculate the following Financial Ratios of the company, in year 2020 and 2021 respectively. Please briefly explain the trend of the company's financial position. 23 124 Ratios 2020 2021 Ratio Category Liquidity Ratio: 125 Current Ratio Quick Ratio 126 Hint: 127 Inventory Turnover Again, please make sure to use references in formular. For example, current ratio in 2020 "D72/171" 128 Days Sales Outstanding Asset Management Ratio: 129 Fixed Asset Turnover 130 Total Asset Turnover Debt Ratio: 131 Debt Management Ratio: 132 333 Times interest earned (TTE) Net Profit Margin Operating Profit Margin 134 135 Profitabiltiy Ratio: Basic Earning Power 136 ROA ROE 137 130 139 9. Please calculate the Du Pont Ratio in 2020 and 2021, respectively. Please explain the changes over years. 140 Hint: please refer to Unit 2 lecture and textbook chatper 2 to calculate Du Pont Ratio in 3 compontents A 4 Operating Profit Margin Basic Earning Power 85 Profitabiltiy Ratio: 36 ROA ROE 37 38 39 9. Please calculate the Du-Pont Ratio in 2020 and 2021, respectively. Please explain the changes over years. -40 Hint: please refer to Unit 2 lecture and textbook chatper 2 to calculate Du Pont Ratio in 3 compontents. 41 -42 43 10. By the end of year 2021, the firm has 100 millions of common shares. Stock price per share is $40 in 2020 and $50 in 2021. 44 Please calculate the P/E ratio and EPS in 2020 and 2021, respectively. Please explain the changes over years