Please i need help with this homework. Zoom in to see everything clearly

I need Help with my homework.

actions Input area: In ThousandsS 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 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% $ 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% 15,000 New equity 21% Tax rate 21% Dividend percentage 25% 25% 24 25 Instructions To earn credit, please make sure to use referecne cell in formular. For example, to enter "Sales" in 2020, you should enter"-D55/154". If you directly enter numbers as your answers below, there would be no credit. 27 If you don't know how to use reference cell in formalar, please watch 29 28623ZARRAS 19 20 30 https://support.microsoft.com/en-us/office/video-understand-and-use-cell-references ecb125bb-c0cb-48c 33 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 34 changed the top corporate tax rate from 35% to one flat rate of 21%. This rate will be effective for corporations 35 whose tax year begins after January 1, 2019, and it is a permanent change.) 36 37 2. Complete Balance Sheet of 2020 2021 38 39 Output area: 2020 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings PERTORI 2021 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings Balance sheet as of Dec. 31, 2020 Balance sheet as of Dec. 31. 2021 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets Cash Accounts receivable Inventory Current assets Net fixed assets Total assets at 2021 Cash From Operating Activities (Put zero if there is no change in the item) Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liab. & equity Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liab. & equity 77 283 Work out 2021 Cash From Operating Activities (Pue zero if there is no change in the items) Statement of Cash Flows-Operating 31 82 Net income 03 Depreciation Chage in AR Change in Inv Change in AP M Net Cash used by Operating Activities 199 Work out 2021 Cash From Investing Activities Statement of Cash Flows lavesting Cash used in FA Change in S-T Investments Net cash wied by Investing Activities Hist lacrease (Decrose) in yccts from 15 of 85 (e AR, mory, ) is The (Source) of Ca Monry out of (o) the Pocker sad the signis Native Hist Cash med we cash outflows, so the sign should be estive 100 1035 Works 2021 Cash From Finocing Activities 102 105 Statement of Cash Flows Fiscing Han 104 Total Equity Paid Capal-RT 106 Chape in Notes Payable Repache-New Stock 300 Change in LTD Or New Equity Ice New stuck imal Chin Chope i Tinal Eity Figy 300 Repurchase Payment of Cash Dividends Repore in cash low, so it is give Net Cash provided by Financing Activtes Pay of dividend i al cask allow, so it is gove 111 132 10 114 115 4. How would you describe the company cash flows for 20217 Write a brief discossion EST 116 1197, In light of your discussion is theprevious quesion, do you thod it is a good time for the company to expand business (te, buy are equipos wachines) at this time? 120 Trey Mock Chape in Retained Earrings-Chee in Totality 115000) Net Iacoor Dividend Paywar-Addition to Rata Fase 2021 11 2021-2030 122 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 UA 124 Rates 2020 2021 as Ratio Category Liquidity Ratio Current Ratio Quick Ratio IN Had 221 Inventory Turner Asin, please misks to references informed Asset Management Ratie: Days Sales Outstanding 129 Fixed Asset Turnover Total Asset Turnover Debt Ratis Debt Management Ratio: Times interest carard (TIK) Net Proft Margin MAY TH Operating Profit Margin th Profitabity Rati Basic Earsing Power ROA 117 ROE 3.38 1199 Please calculate the Du Peer Ratio in 2020 and 2021, respectiveby. Please explain the changes over years Hot please dat to Unit 2 Inches and nobook chaper 2 to calodne Do Pou tatio is compostos 341 347 34 10. By the end of year 2021, the firm has 100 millions of common shares Stock price per share is 540 is 2020 and 550 in 2021. 344 Please calculate the P/E ratio and EPS in 2020 and 2021, respectively. Please explain the changes over years. 345 Sheet! 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 SA 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"-D55154 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 https://support.microsoft.com/ene/office/video-understand-and-ase-cell-references ecb125bb c0cb 48c1-b30f-cdb3arc05261 Questions 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 changed the top corporate tax rate from 35% to one Bat rate of 11%. This rate will be effective for corporations whose tax year begins after January 1, 2019, and it is a permanence) 2. Complete Balance Sheet of 2020 & 2021 O Output area 2020 Income Statement 2021 Incoise Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Tarm Sheet1 O Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Texes 2020 lacome Staten Sales Cost of goods sold Selling & Administrative Depreciation ENIT Interest EBT Taxes Net income Dividende Addition to retained earnings Cal Accounts receivable Inventory Current assets Net fixed assets Total s Balance sheet as of Dec. 31, 2020 2021 Income Stateme Sales Cost of goods sold Selling & Administrative Depreciation EBIT terest EBT Txtes Net income Dividends Addition to retained earnings O Accots payable Notes payable Current liabilities Long-term debe Owners equity Total liab. & equity Balance sheet as of Dec. 31, 2021 Cash Accounts receivable linatory Carred assets Net fixed assets Total assets 3. Work ose 2021 Cash From Operating Activities (Put zero if there is no change in the item) Statement of Cash Flows Operating Net income Depreciation Chage in AR Change in lev Change in AP Net Cask used by Operating Activities Accounts payable Notes payable Current liabilities Long-term debe Owners' equity Total liah & equity Hist crease (Decrease) in any accounts from Lits of 1% (eg AR, vory, etc.) is "Use (Source) of Cashe", (Positive), L. "Money out of (into) the Pocket" and the sign is Negative 4. Work out 2021 Cash From Investing Activities 5. Work out 2021 Cash From Pancing Activies 21 31 34 12 Statement of Cash Flows-Investing Cash wedi FA Change in S-T lovestments Net cash used by Investing Activities Statement of Cash Flows Financing Change in Notes Payable Change in LTD New Equity Ince Repurchase Payment of Cash Dividend Net Cash provided by Financing Activities Het Cash wad see cash ourdous, so the sign shedd be negative Hint Total Expaty-Paid Capital + JUE+Treamy Stock Repeche-New Stock Imance Change a Retained Famings-Change New stock - $15000 (en) Change in Retained Earning Net Income-Dividerul Payused Cloge in Total Fity-Epity in 2021 Equity in 2020 Repurchase ish outflow, so it is negative Payment of dividend is she cash outflow, neve Totality Addion to Retained Earnings (soe 2021 ISY 4 15 16 6. How would you describe the company cash flows for 2021? Write a brief discussion. 17 197. In light of your discussion in th eprevious quesion, 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 Hint: 126 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 Basic Earning Power 114 135 Profitabiltly Ratio: 136 ROA ROE 137 130 129 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 B 24 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. actions Input area: In ThousandsS 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 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% $ 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% 15,000 New equity 21% Tax rate 21% Dividend percentage 25% 25% 24 25 Instructions To earn credit, please make sure to use referecne cell in formular. For example, to enter "Sales" in 2020, you should enter"-D55/154". If you directly enter numbers as your answers below, there would be no credit. 27 If you don't know how to use reference cell in formalar, please watch 29 28623ZARRAS 19 20 30 https://support.microsoft.com/en-us/office/video-understand-and-use-cell-references ecb125bb-c0cb-48c 33 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 34 changed the top corporate tax rate from 35% to one flat rate of 21%. This rate will be effective for corporations 35 whose tax year begins after January 1, 2019, and it is a permanent change.) 36 37 2. Complete Balance Sheet of 2020 2021 38 39 Output area: 2020 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings PERTORI 2021 Income Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings Balance sheet as of Dec. 31, 2020 Balance sheet as of Dec. 31. 2021 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets Cash Accounts receivable Inventory Current assets Net fixed assets Total assets at 2021 Cash From Operating Activities (Put zero if there is no change in the item) Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liab. & equity Accounts payable Notes payable Current liabilities Long-term debt Owners' equity Total liab. & equity 77 283 Work out 2021 Cash From Operating Activities (Pue zero if there is no change in the items) Statement of Cash Flows-Operating 31 82 Net income 03 Depreciation Chage in AR Change in Inv Change in AP M Net Cash used by Operating Activities 199 Work out 2021 Cash From Investing Activities Statement of Cash Flows lavesting Cash used in FA Change in S-T Investments Net cash wied by Investing Activities Hist lacrease (Decrose) in yccts from 15 of 85 (e AR, mory, ) is The (Source) of Ca Monry out of (o) the Pocker sad the signis Native Hist Cash med we cash outflows, so the sign should be estive 100 1035 Works 2021 Cash From Finocing Activities 102 105 Statement of Cash Flows Fiscing Han 104 Total Equity Paid Capal-RT 106 Chape in Notes Payable Repache-New Stock 300 Change in LTD Or New Equity Ice New stuck imal Chin Chope i Tinal Eity Figy 300 Repurchase Payment of Cash Dividends Repore in cash low, so it is give Net Cash provided by Financing Activtes Pay of dividend i al cask allow, so it is gove 111 132 10 114 115 4. How would you describe the company cash flows for 20217 Write a brief discossion EST 116 1197, In light of your discussion is theprevious quesion, do you thod it is a good time for the company to expand business (te, buy are equipos wachines) at this time? 120 Trey Mock Chape in Retained Earrings-Chee in Totality 115000) Net Iacoor Dividend Paywar-Addition to Rata Fase 2021 11 2021-2030 122 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 UA 124 Rates 2020 2021 as Ratio Category Liquidity Ratio Current Ratio Quick Ratio IN Had 221 Inventory Turner Asin, please misks to references informed Asset Management Ratie: Days Sales Outstanding 129 Fixed Asset Turnover Total Asset Turnover Debt Ratis Debt Management Ratio: Times interest carard (TIK) Net Proft Margin MAY TH Operating Profit Margin th Profitabity Rati Basic Earsing Power ROA 117 ROE 3.38 1199 Please calculate the Du Peer Ratio in 2020 and 2021, respectiveby. Please explain the changes over years Hot please dat to Unit 2 Inches and nobook chaper 2 to calodne Do Pou tatio is compostos 341 347 34 10. By the end of year 2021, the firm has 100 millions of common shares Stock price per share is 540 is 2020 and 550 in 2021. 344 Please calculate the P/E ratio and EPS in 2020 and 2021, respectively. Please explain the changes over years. 345 Sheet! 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 SA 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"-D55154 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 https://support.microsoft.com/ene/office/video-understand-and-ase-cell-references ecb125bb c0cb 48c1-b30f-cdb3arc05261 Questions 1. Complete Income Statement of 2020 & 2021 (Plase note The Tax Cuts and Jobs Act of 2020 changed the top corporate tax rate from 35% to one Bat rate of 11%. This rate will be effective for corporations whose tax year begins after January 1, 2019, and it is a permanence) 2. Complete Balance Sheet of 2020 & 2021 O Output area 2020 Income Statement 2021 Incoise Statement Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Tarm Sheet1 O Sales Cost of goods sold Selling & Administrative Depreciation EBIT Interest EBT Texes 2020 lacome Staten Sales Cost of goods sold Selling & Administrative Depreciation ENIT Interest EBT Taxes Net income Dividende Addition to retained earnings Cal Accounts receivable Inventory Current assets Net fixed assets Total s Balance sheet as of Dec. 31, 2020 2021 Income Stateme Sales Cost of goods sold Selling & Administrative Depreciation EBIT terest EBT Txtes Net income Dividends Addition to retained earnings O Accots payable Notes payable Current liabilities Long-term debe Owners equity Total liab. & equity Balance sheet as of Dec. 31, 2021 Cash Accounts receivable linatory Carred assets Net fixed assets Total assets 3. Work ose 2021 Cash From Operating Activities (Put zero if there is no change in the item) Statement of Cash Flows Operating Net income Depreciation Chage in AR Change in lev Change in AP Net Cask used by Operating Activities Accounts payable Notes payable Current liabilities Long-term debe Owners' equity Total liah & equity Hist crease (Decrease) in any accounts from Lits of 1% (eg AR, vory, etc.) is "Use (Source) of Cashe", (Positive), L. "Money out of (into) the Pocket" and the sign is Negative 4. Work out 2021 Cash From Investing Activities 5. Work out 2021 Cash From Pancing Activies 21 31 34 12 Statement of Cash Flows-Investing Cash wedi FA Change in S-T lovestments Net cash used by Investing Activities Statement of Cash Flows Financing Change in Notes Payable Change in LTD New Equity Ince Repurchase Payment of Cash Dividend Net Cash provided by Financing Activities Het Cash wad see cash ourdous, so the sign shedd be negative Hint Total Expaty-Paid Capital + JUE+Treamy Stock Repeche-New Stock Imance Change a Retained Famings-Change New stock - $15000 (en) Change in Retained Earning Net Income-Dividerul Payused Cloge in Total Fity-Epity in 2021 Equity in 2020 Repurchase ish outflow, so it is negative Payment of dividend is she cash outflow, neve Totality Addion to Retained Earnings (soe 2021 ISY 4 15 16 6. How would you describe the company cash flows for 2021? Write a brief discussion. 17 197. In light of your discussion in th eprevious quesion, 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 Hint: 126 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 Basic Earning Power 114 135 Profitabiltly Ratio: 136 ROA ROE 137 130 129 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 B 24 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