Student Name 91 For the balance sheet prepare a VERTICAL Analysis (Do not perform this analysis for the cells colored black, only perform for the cells in yellow) Perform work in the table below." --PLEASE USE NIE EXCEL FUNTIONALITY TO PERFORM THE ANALYSIS. (DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS 01 Analyze the change in the accounts indicated below in yellow. Think about what could be causing this channe? What concerns does this raise for you? ANSWER: Perform your analysis in the yellow cells below. See Accounts Receivable as an example of what an answer should look like What phase of the audit would this analytic (Vertical Analysis) most likely be performed? (Planning, substantive, completion Pick 1) Briefly Explan why (1 Sentence) ANSWER: (exe substantive because it would be useful for the auditor to detect a material estatement as this analytic is very detailed and provides very reliable evidence 02- Technologies de BALANCE SHEET December 11 20X8 and XT fin housands % of % of Assets 20x8 20x7 Assets 20x8 20x71 Changel Analysis of Change Assets Current assets Cash and cash equivalents $3741 $3,019 1,119 900 1% Accounts receivables 16% Accounts Recewable wealager page for Arse. This could be indicative of the coming -15% out credit more opel of customers wing back the company more slowl This could represent a big ito bedendo Hint coneider the charge of the 100 150 30 21 4,069 711 Hint Uniongonhanced Theobabwe 20.000 Inventory Total current assets Property Plan & Equipment (PPE), het Goodwie Investments Other assets Total assets Liabilities and shareholders equity Current liabilities Notes payabile Accounts payable 12 5450 633 10 $5,543 27 3130 $140) $100 He consider theirloo the changementen 51,009 20 0 2000 2.320 y cooking change PAN 10 12219 12 Long Term Debt Total abilities Shareholders equity Common stock Retained coming Total shareholders equity Total liabilities plus shareholders equity 91.131 1020 944100 2179 24000 4,820 55.440 10 27 10