AO OMR? 3.5 GB * 78% [42 Mon 9:28 PM Q Finder File Edit View Go Window Help OOO AutoSave 0 BESU 2021 DuPont model-5.xls - Compatibility Mode View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. X D5 T A B c H 1 1 . K M N N 0 P o R 3 E F DuPont Financial Model 2 ImmE S DOCS God bruin 24,139 1 Nat Pro Variable Experges 2,630 Trap Warn JJ. + 45819 hal Expo 10 11 1 12 Inventor SON [3::. . X Return on Assets 48.16 1,674 43.813 7.822 Dr Axels ABX Tumper 1.18 23 + 33424 14 Art HVAR 15 16 Other Current 42 18 Fred Assets 10 18 22.332 MAIS x Haturn Warth 14.15% 21 Els Me 416 23 Notes Payebe 2,164 Tocal Current Lates 13,282 29 Cher Current URT 3.3 JS.CL 27 LUNI 22,710 Lag Term Lima 22,71 Total Wal & NW 84,186 1 Levage 1.75 Nail art Na Vari 45 Tre Varth 44,176 Sales 49,013 10, : Sales to Assets 1.48 OH OH * Lipidly 19,202 Current Assets : isitin Caah - Aces 7 C.men: Uables Total XX Polii Balore Tu 1. 1e, 147 Palun on Assets : 4a7 Culok Rab C.GE 13.282 In Turner Total Assets Coer of Goods So . In Cry " 365 ! 24.132 1,574.00 385 13 MIN1 46 Solvency Dob: 1o Eq. Tullius 4 Esuty 38,0 1 28,70 75% Asset Mngmt 23.81 16.3316914 67 624 24,865 51% 365 ER 51 Profitability GoP Gross Pron: Nei ! Sales Pont Belor Tax Pro-Tec Prof New 1 43,818 Inventory Tume Sass Ace 1 TIMER Acest FORVIN 365 Col Period Net Roc Tumove Cost of Goods So A PTI Ace Penale 1 G3.49 6.2 2,12 51 55 ? SH 7,505 57 Sheet1 Sheet22 Sheet23 Sheet24 Sheet25 Sheet26 Sheet27 Sheet28 Sheet29 Sheets Sheet31 Sheet32 Sheet33 Sheet34 Sheet35 Sheet36 She + 11 Enter E 71% 1809 22 A W A m2 3 * 97% [42 Mon 1:06 PM Q Finder File Edit View Go Window Help AutoSave 0 BESU Auditing analytic review assignment-spring-2021-5 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments No T N 8 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left aft? Yes C26 A x fx B D E F G H 1 K L M 1 2 2 3 Class assignment. Due 12:30 pm on 2/25/21: Obtain the most recent three years' financial statements for the company you selected earlier. Perform an analytical review as follows: 4 1. Using the format prescribed in this worksheet, perform the analysis for every Income statement and balance sheet account, observe trends and unusual items. Note your question or observation for discussion 5 2. Using the du Pont Model template (available on Blackboard) enter data for most recent two years and note significant changes 6 3. Identify what you believe are high risk areas where you would spend more audit time and areas where little time should be invested 7 4. From your analysis, set an aggregate materiality level and describe how it was determined. 5. Write all your results (questions, risk assessments, materiality, etc. on this worksheet and save it using filename AAPA-yourname-submit through Turnitin 9 6. Write no less than three and no more than five questions to ask the CFO or CEO about your findines. 10 NOTE: This assignment, along with the du Pont Model template, is available under the Content tab on Blackboard. 11 12 FORMAT for financial statement level analytical review: 13 COMPANY NAME 14 ACCOUNT NAME YEAR 1 YEAR 2 YEAR 3 HORIZONTAL HORIZONTAL VERTICAL QUESTION OR COMMENT 15 ANALYSIS 1 TO 2 ANALYSIS 2 TO 3 ANALYSIS YR. 3 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 + Ready 110% 111 22 8 A W ... AO OMR? 3.5 GB * 78% [42 Mon 9:28 PM Q Finder File Edit View Go Window Help OOO AutoSave 0 BESU 2021 DuPont model-5.xls - Compatibility Mode View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. X D5 T A B c H 1 1 . K M N N 0 P o R 3 E F DuPont Financial Model 2 ImmE S DOCS God bruin 24,139 1 Nat Pro Variable Experges 2,630 Trap Warn JJ. + 45819 hal Expo 10 11 1 12 Inventor SON [3::. . X Return on Assets 48.16 1,674 43.813 7.822 Dr Axels ABX Tumper 1.18 23 + 33424 14 Art HVAR 15 16 Other Current 42 18 Fred Assets 10 18 22.332 MAIS x Haturn Warth 14.15% 21 Els Me 416 23 Notes Payebe 2,164 Tocal Current Lates 13,282 29 Cher Current URT 3.3 JS.CL 27 LUNI 22,710 Lag Term Lima 22,71 Total Wal & NW 84,186 1 Levage 1.75 Nail art Na Vari 45 Tre Varth 44,176 Sales 49,013 10, : Sales to Assets 1.48 OH OH * Lipidly 19,202 Current Assets : isitin Caah - Aces 7 C.men: Uables Total XX Polii Balore Tu 1. 1e, 147 Palun on Assets : 4a7 Culok Rab C.GE 13.282 In Turner Total Assets Coer of Goods So . In Cry " 365 ! 24.132 1,574.00 385 13 MIN1 46 Solvency Dob: 1o Eq. Tullius 4 Esuty 38,0 1 28,70 75% Asset Mngmt 23.81 16.3316914 67 624 24,865 51% 365 ER 51 Profitability GoP Gross Pron: Nei ! Sales Pont Belor Tax Pro-Tec Prof New 1 43,818 Inventory Tume Sass Ace 1 TIMER Acest FORVIN 365 Col Period Net Roc Tumove Cost of Goods So A PTI Ace Penale 1 G3.49 6.2 2,12 51 55 ? SH 7,505 57 Sheet1 Sheet22 Sheet23 Sheet24 Sheet25 Sheet26 Sheet27 Sheet28 Sheet29 Sheets Sheet31 Sheet32 Sheet33 Sheet34 Sheet35 Sheet36 She + 11 Enter E 71% 1809 22 A W A m2 3 * 97% [42 Mon 1:06 PM Q Finder File Edit View Go Window Help AutoSave 0 BESU Auditing analytic review assignment-spring-2021-5 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments No T N 8 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left aft? Yes C26 A x fx B D E F G H 1 K L M 1 2 2 3 Class assignment. Due 12:30 pm on 2/25/21: Obtain the most recent three years' financial statements for the company you selected earlier. Perform an analytical review as follows: 4 1. Using the format prescribed in this worksheet, perform the analysis for every Income statement and balance sheet account, observe trends and unusual items. Note your question or observation for discussion 5 2. Using the du Pont Model template (available on Blackboard) enter data for most recent two years and note significant changes 6 3. Identify what you believe are high risk areas where you would spend more audit time and areas where little time should be invested 7 4. From your analysis, set an aggregate materiality level and describe how it was determined. 5. Write all your results (questions, risk assessments, materiality, etc. on this worksheet and save it using filename AAPA-yourname-submit through Turnitin 9 6. Write no less than three and no more than five questions to ask the CFO or CEO about your findines. 10 NOTE: This assignment, along with the du Pont Model template, is available under the Content tab on Blackboard. 11 12 FORMAT for financial statement level analytical review: 13 COMPANY NAME 14 ACCOUNT NAME YEAR 1 YEAR 2 YEAR 3 HORIZONTAL HORIZONTAL VERTICAL QUESTION OR COMMENT 15 ANALYSIS 1 TO 2 ANALYSIS 2 TO 3 ANALYSIS YR. 3 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 + Ready 110% 111 22 8 A W