OBS.. FILE HOME PowerView W20 PP Student File P2 (1) - Excel DATA REVIEW VIEW DEVELOPER INSERT PAGE LAYOUT FORMULAS INQUIR AS X Jr a. Panther Pacific mangement is very impressed with the work you have done so far there fiscal year end and now need your help creating the financial statements for til COMPLETELY separate from PARTI. 4 Financial Statements a. Panther Pacific mangement is very impressed with the work you have done so far filling in for the regular accountant. They have reached there fiscal year end and now need your help creating the financial statements for the fiscal year ended August 31, 2020. PART II IS COMPLETELY separate from PARTI. b. Check figures are NOT available for part II. Financial statements have the following built-in check ligures: 1. Balance sheet total assets must equal total liabilities and stockholder's equity 2. Statement of cash flows net change in cash MUST equal the change in cash from "changes columns adjusted trial balance sheet. c. Each worksheet within this workbook contains further instructions. READ ALL INSTRUCTIONS BEFORE COMPLETING EACH WORKSHEET. PART II IS COMPLETELY INDEPENDENT OF PARTI. Below is a brief overview of the required work to complete each worksheet. Students MUST follow the order below: 1. Complete Is August 2020 worksheet: Create a multi-step income statement 2. Complete Smnt of RE August 2020 worksheet: Create a statement of retained earnings 3. Complete BS August 2020 worksheet: Create a classified balance sheet 4. Complete adjusted trial balance worksheet: "changes" columns (only the identified cells). 5. Complete Statement of CF August 2020 worksheet: Create a statement of cash flows using the INDIRECT method Instructions Adjusted Trial Balance S August 2020 Stmt RE August 2020 BS August 2020 S READY Start your search o i Pae wi DELL F4 FILE HOME PowerView INSERT PAGE LAYOUT FORMULAS W20 PP Student File P2 (1) - Excel DAIA REVIEW VIEW DEVELOPER X N27 INCE POWERTVO 7 - Michael Clemons For Parthe Pacific Corporation d ed and To com p at2 Follow IN ORDER Cincome w 2 crore we are coming e dba Domingo and balance AD forma r from below and the o 4 Cre a th the comment the changed come To compete changes and then cho Ingula forma in the the debt column Heredil com to Complete the chance the dardha g therhof the change Count balance from August 2013 to A end ding b enodi g B d out men of color in Aug 31. 2018 CHANGES COLUMNS Additional Notes for Statement of Cash Flows BE L ivet Hild Instructions READY Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o e gwix] A WO DELL FILE HOME PowerView INSERT PAGE LAYOUT FORMULAS W20 PP Student File P2 (1) - Excel DATA REVIEW VIEW DEVELOPER INQUIRE POWERPIVOT Michael Cle N27 X V fx Amedeon ng ! underholm %E85BBS Depreciation Chief Magagawa Padin Capital Instructions Pam on Soch Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o pa e @w x ] 90 23/201 DELL NEW DEVELOPER INQUIRE POWERPIVO 400.00 500 Gold W hat works perem Thendranmer Expert Manteca Rep l.com nown E e Les con perseling on Expona ment Interne Instructions Adjusted Trial Balance READY Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o BL2e9wx] A 000 DELL N27 62,500.00 17.000.00 72 Depreciation Experteiding ishon En quipment Depreciation Expense-Office Furniture 800Rent Income R ealidan. Egunement Securbes Trading is E. 35.000.00 Resored Loss Held Mouvements 6100000 30 250.00 0.1356050000195505.000 3.109100 7 47000.00 338.870.00 333 336 PERZEERE 85 88 88 Instructions Adjusted Trial Balance Is August 2020 READY Stmt RE August 2020 BS August 2020 Statement of CF August # Start your search of Pae 9 w X] DELL DIE FG UN Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information complete a multi-step income statement. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement Other requirements are: a. ONLY use accounts that have adjusted balances for August 31, 2020 b. Include proper report title C. Not all rows or columns need to be used. Formulas MUST be used when necessary. 6 Use the following format (in order): 7 1. Input and list sales revenue, COGS, and calculate Gross Proft. 2. Input and list operating expenses - these are normal expenses incurred while selling marine parts. Subtotal these amounts. Operating expenses do NOT have to be separated into selling or general and administrative expense categories. 3. Calculate income from operations. 4. Input and list other revenues and gains amounts - revenue earned, but NOT part of normal operations 10 and subtotal these amounts. 5. Input and list other expenses and losses amounts - expenses incurred, but NOT part of normal 11 operations. Interest expense is always included in this category. Subtotal these amounts. 6. Calculate Net Income (Loss). Instructions Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Sta READY Start your search . DE B Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information AND income statement complete the statement of retained earnings. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula 2 use, and clarity of financial statement. The other requirements are: 3 a. ONLY use accounts that have adjusted balances for August 31, 2020 4 b. Include proper report title 5 c. Not all rows or columns need to be used. Formulas MUST be used when necessary. 6 Use the following format (in order): 7 1. Input beginning balance (this is listed in the August, 31 2020 adjusted trial balance columns). 8 2. List net income (loss) and cash dividends (if applicable) 9 3. Subtotal items from #2 to calculate net increase or decrease in retained earnings. 10 4. Calculate ending balance. 14 16 Instructions Adjusted Trial Balance IS August 2020 Stmt RE August 2020 BS August 2020 Sta READY Start your search o I PI e 9w] D Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information AND the statement of retained earnings complete a classified balance sheet. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement. The other 2 requirements are: 3 a. ONLY use accounts that have adjusted balances for August 31, 2020 4 b. Include proper report title 5 C. Not all rows or columns need to be used. Formulas MUST be used when necessary, 6 Use the following format (in order): 7 1. Input and list asset accounts in 3 categories: Current Assets; Property, Plant, and Equipment(PPE); Other Assets 8 2. Each category from #1 requires a subtotal EXCEPT for Other Assets 9 3. Calculate Total Assets 104. Input and list liability accounts in 2 categories: Current Liabilities and Longterm Liabilities 11 5. Each category from #4 requires a subtotal 12 6. Calculate Total Liabilities 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained 13 earnings. 14 8. Calculate Total Stockholder's Equity 15 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets Instructions Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Stateme READY Start your search DELL DE Panther Pacific Corporation Instructions: Using the "changes columns" and additional information from the adjusted trial balance tab AND the income statement, create a statement of cash flows following the INDIRECT METHOD. Round all amounts to the nearest cent. Follow the below tips The formatting is up to the student. Note that grades are based on organization, formula use, and 2 clarity of financial statement. Other required items: 3 a. Only use accounts that have changes or cash flows 4 b. Include proper report title 5 c. Not all rows or columns need to be used. Formulas MUST be used when necessary 6 TIPS PLEASE READ: 7 1. Correct selection of "Increase" or "Decrease" in accounts must be used as part of the label where applicable 8 2. Correct use of "cash paid" or "cash received" must be used where applicable 9 3. Subtotals for each section MUST be properly identified as cash "used in" or "provided by" 10 4. All changes utilize CASH. There is no GAIN or LOSS from sale of office furniture 5. Net change in cash + beginning cash balance (from a adjusted trial balance August 2019 column) must equal ending cash - 11 balance and be included at the bottom of this statement. = Instructions Adjusted Trial Balance IS August 2020 Stmt RE August 2020 BS August 2020 Stat READY ) Start your search ' RI PI e 9 w OBS.. FILE HOME PowerView W20 PP Student File P2 (1) - Excel DATA REVIEW VIEW DEVELOPER INSERT PAGE LAYOUT FORMULAS INQUIR AS X Jr a. Panther Pacific mangement is very impressed with the work you have done so far there fiscal year end and now need your help creating the financial statements for til COMPLETELY separate from PARTI. 4 Financial Statements a. Panther Pacific mangement is very impressed with the work you have done so far filling in for the regular accountant. They have reached there fiscal year end and now need your help creating the financial statements for the fiscal year ended August 31, 2020. PART II IS COMPLETELY separate from PARTI. b. Check figures are NOT available for part II. Financial statements have the following built-in check ligures: 1. Balance sheet total assets must equal total liabilities and stockholder's equity 2. Statement of cash flows net change in cash MUST equal the change in cash from "changes columns adjusted trial balance sheet. c. Each worksheet within this workbook contains further instructions. READ ALL INSTRUCTIONS BEFORE COMPLETING EACH WORKSHEET. PART II IS COMPLETELY INDEPENDENT OF PARTI. Below is a brief overview of the required work to complete each worksheet. Students MUST follow the order below: 1. Complete Is August 2020 worksheet: Create a multi-step income statement 2. Complete Smnt of RE August 2020 worksheet: Create a statement of retained earnings 3. Complete BS August 2020 worksheet: Create a classified balance sheet 4. Complete adjusted trial balance worksheet: "changes" columns (only the identified cells). 5. Complete Statement of CF August 2020 worksheet: Create a statement of cash flows using the INDIRECT method Instructions Adjusted Trial Balance S August 2020 Stmt RE August 2020 BS August 2020 S READY Start your search o i Pae wi DELL F4 FILE HOME PowerView INSERT PAGE LAYOUT FORMULAS W20 PP Student File P2 (1) - Excel DAIA REVIEW VIEW DEVELOPER X N27 INCE POWERTVO 7 - Michael Clemons For Parthe Pacific Corporation d ed and To com p at2 Follow IN ORDER Cincome w 2 crore we are coming e dba Domingo and balance AD forma r from below and the o 4 Cre a th the comment the changed come To compete changes and then cho Ingula forma in the the debt column Heredil com to Complete the chance the dardha g therhof the change Count balance from August 2013 to A end ding b enodi g B d out men of color in Aug 31. 2018 CHANGES COLUMNS Additional Notes for Statement of Cash Flows BE L ivet Hild Instructions READY Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o e gwix] A WO DELL FILE HOME PowerView INSERT PAGE LAYOUT FORMULAS W20 PP Student File P2 (1) - Excel DATA REVIEW VIEW DEVELOPER INQUIRE POWERPIVOT Michael Cle N27 X V fx Amedeon ng ! underholm %E85BBS Depreciation Chief Magagawa Padin Capital Instructions Pam on Soch Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o pa e @w x ] 90 23/201 DELL NEW DEVELOPER INQUIRE POWERPIVO 400.00 500 Gold W hat works perem Thendranmer Expert Manteca Rep l.com nown E e Les con perseling on Expona ment Interne Instructions Adjusted Trial Balance READY Is August 2020 Stmt RE August 2020 BS August 2020 Statement of CF August 2020 Start your search o BL2e9wx] A 000 DELL N27 62,500.00 17.000.00 72 Depreciation Experteiding ishon En quipment Depreciation Expense-Office Furniture 800Rent Income R ealidan. Egunement Securbes Trading is E. 35.000.00 Resored Loss Held Mouvements 6100000 30 250.00 0.1356050000195505.000 3.109100 7 47000.00 338.870.00 333 336 PERZEERE 85 88 88 Instructions Adjusted Trial Balance Is August 2020 READY Stmt RE August 2020 BS August 2020 Statement of CF August # Start your search of Pae 9 w X] DELL DIE FG UN Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information complete a multi-step income statement. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement Other requirements are: a. ONLY use accounts that have adjusted balances for August 31, 2020 b. Include proper report title C. Not all rows or columns need to be used. Formulas MUST be used when necessary. 6 Use the following format (in order): 7 1. Input and list sales revenue, COGS, and calculate Gross Proft. 2. Input and list operating expenses - these are normal expenses incurred while selling marine parts. Subtotal these amounts. Operating expenses do NOT have to be separated into selling or general and administrative expense categories. 3. Calculate income from operations. 4. Input and list other revenues and gains amounts - revenue earned, but NOT part of normal operations 10 and subtotal these amounts. 5. Input and list other expenses and losses amounts - expenses incurred, but NOT part of normal 11 operations. Interest expense is always included in this category. Subtotal these amounts. 6. Calculate Net Income (Loss). Instructions Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Sta READY Start your search . DE B Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information AND income statement complete the statement of retained earnings. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula 2 use, and clarity of financial statement. The other requirements are: 3 a. ONLY use accounts that have adjusted balances for August 31, 2020 4 b. Include proper report title 5 c. Not all rows or columns need to be used. Formulas MUST be used when necessary. 6 Use the following format (in order): 7 1. Input beginning balance (this is listed in the August, 31 2020 adjusted trial balance columns). 8 2. List net income (loss) and cash dividends (if applicable) 9 3. Subtotal items from #2 to calculate net increase or decrease in retained earnings. 10 4. Calculate ending balance. 14 16 Instructions Adjusted Trial Balance IS August 2020 Stmt RE August 2020 BS August 2020 Sta READY Start your search o I PI e 9w] D Panther Pacific Corporation Instructions: Using the August 31, 2020 adjusted trial balance information AND the statement of retained earnings complete a classified balance sheet. Round all amounts to the nearest cent. Follow the below format notes, the rest is up to the student. Note that grades are also based on organization, formula use, and clarity of financial statement. The other 2 requirements are: 3 a. ONLY use accounts that have adjusted balances for August 31, 2020 4 b. Include proper report title 5 C. Not all rows or columns need to be used. Formulas MUST be used when necessary, 6 Use the following format (in order): 7 1. Input and list asset accounts in 3 categories: Current Assets; Property, Plant, and Equipment(PPE); Other Assets 8 2. Each category from #1 requires a subtotal EXCEPT for Other Assets 9 3. Calculate Total Assets 104. Input and list liability accounts in 2 categories: Current Liabilities and Longterm Liabilities 11 5. Each category from #4 requires a subtotal 12 6. Calculate Total Liabilities 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained 13 earnings. 14 8. Calculate Total Stockholder's Equity 15 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets Instructions Adjusted Trial Balance Is August 2020 Stmt RE August 2020 BS August 2020 Stateme READY Start your search DELL DE Panther Pacific Corporation Instructions: Using the "changes columns" and additional information from the adjusted trial balance tab AND the income statement, create a statement of cash flows following the INDIRECT METHOD. Round all amounts to the nearest cent. Follow the below tips The formatting is up to the student. Note that grades are based on organization, formula use, and 2 clarity of financial statement. Other required items: 3 a. Only use accounts that have changes or cash flows 4 b. Include proper report title 5 c. Not all rows or columns need to be used. Formulas MUST be used when necessary 6 TIPS PLEASE READ: 7 1. Correct selection of "Increase" or "Decrease" in accounts must be used as part of the label where applicable 8 2. Correct use of "cash paid" or "cash received" must be used where applicable 9 3. Subtotals for each section MUST be properly identified as cash "used in" or "provided by" 10 4. All changes utilize CASH. There is no GAIN or LOSS from sale of office furniture 5. Net change in cash + beginning cash balance (from a adjusted trial balance August 2019 column) must equal ending cash - 11 balance and be included at the bottom of this statement. = Instructions Adjusted Trial Balance IS August 2020 Stmt RE August 2020 BS August 2020 Stat READY ) Start your search ' RI PI e 9 w