Question: if possible could i get this in a downloadable excel file? 1. Common Size Statements (vertical) Refer to the AAA Inc. comparative balance sheets and

if possible could i get this in a downloadable excel file?
if possible could i get this in a downloadable excel file? 1.
Common Size Statements (vertical) Refer to the AAA Inc. comparative balance sheets
and income statements below. For all three years (2021,2020,2019) restate the balance

1. Common Size Statements (vertical) Refer to the AAA Inc. comparative balance sheets and income statements below. For all three years (2021,2020,2019) restate the balance sheet and income statement in common size (vertical) form. all assets as a percentage of total assets all liabilities and equities as a percentage of total liabilities and equity all items on the income statement as a percentage of sales 2. Common Size Statements (horizontal) 4. Refer to the AAA Inc. comparative balance sheets and income statements below. 5 For all three years (2021,2020,2019) restate the balance sheets and income statements in common size (horizontal) form. everything as a percentage of its counterpart in 2021 AAA Incorporated Comparative Balance Sheet Income Statement sales cost of goods sold other expenses depreciation expense EBIT interest expense EBT taxes (40%) NI \begin{tabular}{|r|r|r|} \hline 2021 & 2020 & 2019 \\ \hline 7035600 & 5834400 & 3432000 \\ \hline 5728000 & 4980000 & 2864000 \\ \hline 680000 & 720000 & 340000 \\ \hline 116960 & 116960 & 18900 \\ \hline 510640 & 17440 & 209100 \\ \hline 88000 & 176000 & 62500 \\ \hline 422640 & 158560 & 146600 \\ \hline 169056 & 63424 & 58640 \\ \hline 253584 & 95136 & 87960 \\ \hline & & \\ \hline 55000 & 11000 & 22000 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!