Can I please have assistance on how to do this homework, please?
I need assistance on this assignment please:
Using the information provided by the CFO, your assignment is to create the following financial statement analysis documents:
1. vertical common size statements (both balance sheet and income statements) for all four years of data;
2. horizontal common size statements (both balance sheet and income statements) for all four years of data;
3. a ratio analysis of all four years of data using current ratio, quick ratio, inventory turnover ratio, total asset turnover ratio, net profit margin, and debt ratio;
4. a DuPont analysis of the companys return on assets (ROA) and return on equity (ROE) for all four years; and
5. statements of cash flow for the years 2021, 2020, and 2019. NOTE: the format for the statements of cash flow is included in the spreadsheet provided.
The CFO is very interested in the DuPont Analysis. Be certain to show all parts of the analysis and dont simply show the ROA and ROE.
Tools Data Window Help Sat Feb 5 5:45 PM Excel File Edit View Insert Format ... A6 AutoSave OFF ... Carswell's comparative BS and IS (1) View Tell me Home Developer Insert Draw Page Layout Formulas Data Review Share Comments Default IF Ruler Formula Bar Split Zoom 75% Ho H KAAP Exit Kamp Now = Options Normal Page Break Page Custom Preview Layout Views Gridlines Headings Zoom to 100% Zoom to Selection New Arrange Freeze Freeze Freeze First Window All Panes Top Row Column Hide Switch Unhide Windows View Record Use Relative Macros Macro References L NN T VW X X . Z NA Z 43 AC AL AU AH 4 AL 040 fr : . Du C D T Carswell's Incorporated 2 Comparative Income Statements ($ in millions) 7121 AVO 2014 ANS ws GS 20 7222 *** 439013471 GI Trare sing oras x 1004 24 1307 2024 NH Or 1229 62 156 116 11 23 > depred 20 34 24 total SST ES SE DAJ 1433 BE! ve 150% SE 27 w 263 46 F Statement of Cash Flows for year??? w www 14 annem Morical UAIRE NEESI waisla warisan w Ewelinin Europe Cruquisiti Einhelatie Markedsritis to ARTESIA Cound alles P4- 5723 033 123 13 kerepek 18 14 Carswell's Incorporated 2D Comparative Balance Sheets ($ in millions) LE 3 211 Crurgis werin PAPER canada Las balenis web HT:TH AVO 30 554 242 31 1953 An 222 30 27 209 24 TT we Thi Curge la pared Chuquins MIT din piel 301 115 13 . wan www VRIER wan lotalasi 584 3211 4382 us 16 21/t 100 2TT wa 42% at peattaargaieties Sarren Materih 153 .. 3333 9035 wana 402 ST des sed walls DACI 12 22 : 2) 24 522 50 423 JE 133 37 37 M 62 95 1933 SA 13 14:3 42 225 131 253 a D 20 20 20 2 200 SIA 238) arwin rested CATTO York casal are ali O 20 SV Ti ? 41 1 SD Sheet1 Sheet2 Sheet3 + Ready 75% HH 5 itv w 4 Aa Tools Data Window Help Sat Feb 5 5:45 PM Excel File Edit View Insert Format ... A6 AutoSave OFF ... Carswell's comparative BS and IS (1) View Tell me Home Developer Insert Draw Page Layout Formulas Data Review Share Comments Default IF Ruler Formula Bar Split Zoom 75% Ho H KAAP Exit Kamp Now = Options Normal Page Break Page Custom Preview Layout Views Gridlines Headings Zoom to 100% Zoom to Selection New Arrange Freeze Freeze Freeze First Window All Panes Top Row Column Hide Switch Unhide Windows View Record Use Relative Macros Macro References L NN T VW X X . Z NA Z 43 AC AL AU AH 4 AL 040 fr : . Du C D T Carswell's Incorporated 2 Comparative Income Statements ($ in millions) 7121 AVO 2014 ANS ws GS 20 7222 *** 439013471 GI Trare sing oras x 1004 24 1307 2024 NH Or 1229 62 156 116 11 23 > depred 20 34 24 total SST ES SE DAJ 1433 BE! ve 150% SE 27 w 263 46 F Statement of Cash Flows for year??? w www 14 annem Morical UAIRE NEESI waisla warisan w Ewelinin Europe Cruquisiti Einhelatie Markedsritis to ARTESIA Cound alles P4- 5723 033 123 13 kerepek 18 14 Carswell's Incorporated 2D Comparative Balance Sheets ($ in millions) LE 3 211 Crurgis werin PAPER canada Las balenis web HT:TH AVO 30 554 242 31 1953 An 222 30 27 209 24 TT we Thi Curge la pared Chuquins MIT din piel 301 115 13 . wan www VRIER wan lotalasi 584 3211 4382 us 16 21/t 100 2TT wa 42% at peattaargaieties Sarren Materih 153 .. 3333 9035 wana 402 ST des sed walls DACI 12 22 : 2) 24 522 50 423 JE 133 37 37 M 62 95 1933 SA 13 14:3 42 225 131 253 a D 20 20 20 2 200 SIA 238) arwin rested CATTO York casal are ali O 20 SV Ti ? 41 1 SD Sheet1 Sheet2 Sheet3 + Ready 75% HH 5 itv w 4 Aa
