Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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? 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started