Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For my accounting class i chose EA the game company for industry you need EA's 2021 10k form to answer the questions below. Yellow requires
For my accounting class i chose EA the game company for industry you need EA's 2021 10k form to answer the questions below. Yellow requires the formula.
All yellow highlighted cell must use cell reference or points will be deducted. Cell reference is A4 A5, not 4*5, not 20 When reading the financial - make sure you notice if they say the numbers are in millions or billions. Read the top of statements to see how the numbers are represented. 95% of the time, the financials will state these number are in thousand, million or billions. Ex: Net Sales on the financial statement says 125,000 but the financial says it is in millions. So net sales would be actually be 125,000,000,000. Do not enter 125,000 M or 125,000 B as references will not work Basic Information Answer each question Fiscal Year (Ex: 1/1/21-12/31/21) Auditor (Not audia Committee) Have you every reviewed 10K before Vertical Analysis-Income Statement Complete a vertical analysis for 2020 using just the accounts listed Percentages and formulas must use cell reference (ex: A1 A2, not 23, not 12. Amount Net Sales Cost of Good Sold Gross Profit (must be formala) Other revenues Income Operating Expenses Operating Income (must be formula) Interest expense Interest revenue Other income expenses not listed above Income before income tax (must be formula) Income tax (provision for income tax) Consolidated net income (must be formala) PDF page number for income statement Current Assets Long Term Assets Property. Plant and Equipment Intangible Assets Other Assets and Deferred Charges Total Assets (must be formula) Current Liabilities Long Term Liabilities Commitments and contingencies Total Liabilities (must be formula) Common Stock Additional; Paid in Capital Retained Earnings Vertical Analysis Balance Sheet Complete a vertical analysis for 2020 using just the accounts listed Percentage must use cell reference (ex: A1 A2, not 23, not 12. Amount Percentage Percentage Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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