Answered step by step
Verified Expert Solution
Link Copied!

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?
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

=+17.3. Extend Theorem 17.1 to R *.

Answered: 1 week ago