Excel Edt View en formatos Das Wide BU Home Page Layout WIDOS STOM D View A 1 the A- 6 XOM o il 3 1 Davenport Forever 2016 contentNORDER: Lommune AND AS AND Swedbathely 200 mg 4. Comunementen had to 7 change a la former the ang 2018 2031 down the 13 CHANGES COLUMNS 13 MAN Ju 2018 M D Jay 200 A Anett 13 100 D 19 104 0000 20 w Tag 4 123 HRM 20 1 La N FI 2 Event 20 14 MacBook Air 000 esc 30 Excel Fae Edit View Formal Tools Outa Windows We flere Sun 7.06 PM Kab Pun sort D Page Layout Data View AA Com -A- $ xf Only there and have 2019 bing bing that are 9.0. 2 V 1 1M A. one Austur Accue Wis TE IN 201 RE 20 294 20 SOE 2001 TRE w 250 Sendeng 900 292 140 1 Secunda More Women EP 105 Paper DOE 13.00 43 G DRE WE O Pune TH 20000 Adana 15 2000 05 MacBook Air DO Excel file Edit View inson Format Tools Data Window Helo B. 7 Home De OLEME 7:06 PM Kabang Page Layout Ferme Data Review Men th Pasta BU 99.0 5% A9 * Only complete the changes that are tied and 2010 2000 den Mar w 704 10 B. 14 00 700 RE per PE chu LE OG 1.000 REV 1.500.000 ON 17.00 ME 110 ontbre 71 Taco Borse 712 Deci per Deprecatepe 14 beste 100 Ramin Osmontant Expert Loft 100 3. STEP 11. nu 05 1000 DOG 4.000 30 100 323 014 000 28 1234 B. (NI DO 70 ET 22 Callbrl (Body) 11 ' ' Wrap Tour General Paste B U OA non Cant $ % 9.22 A2 X fx Instructions: Using the July 31, 2020 adjusted trial balance information AND income statement complete the statemer A D F G H Davenport Docking Corporation Instructions: Lising the July 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 use, and clarity of financial statement. The other requirements are: EL ONLY use accounts that have adjusted balances for July 31, 2020 b. Include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format in order: 1. Input beginning balance (this is listed in the July, 31 2020 adjusted trial balance columns). 2. List net income flos) and cash dividends (if applicable) 3. Subtotal items from 12 to calculate net increase or decrease in retained earnings 10 4. Calculate ending balance. 13 14 15 17 18 39 20 21 22 24 W21 DO Student Fille P2 Home Insert Draw Page Layout Fermulas Data Review View Calib (Body 11 AA IN 25 Wrap The General Pante BTU AA $ % 9 Conne Formatting Ticle Cal A17 x fe H c D Der Docking Corporation Inetween deghe An 2020 trebalance information AND thement of reading complete confed Melecehat. Round all amounts to the recent follow the below formatates, the rest to the date the gredere also bewon argestion formules and cry of financial atent. The other requiremene 1 ONLY account that have added balances for July 31, 2010 4 b. Include proportite 3 N I rows or columns and to be used. Formula MUST be used when necessary 5. U the following format in order 1.Input and let counts in categorie: Current Property. Plant, and Equipment Pen Others 2. Each category from regresa subtota EXCEPT For Other Adet 9 3. Calculate Total Arts 10 4. input and liability account in 2 Megories Current Liabilities and long term its 15 S. Sacharytron requires a subtot 22 6. Calculate Total abilities 11 7.laput and stockholder's Equity Accounts including ending balance of retained wings from tement of retained earning 14 8. Calculate Total Stockholderiquity 15 Calculate Totales and Stockholder's Equity. This amount should equal Total 12 19 20 21 23 24 25 26 27 20 29 30 djusted Triat Balance IN 2020 Sol Rey 200 BS 2020 StentofCF 2020 Ready . W 14 General S%6 Candien CH Calibr (Bodyl 11 AAT WAT UM 3 8 JU A A17 * fx A 1 Beport Doc Corporation Instructor using the changeschwandeling metion from the treate ANDI Incoment.create estenent af How INDIRECT MITNOD, Round all meant to the recent follow the below the foreign to the dent. Note the grades and an evention, and clarity of foncient. Otherwiredite H Only counts that have changes or cash flows due proper report title c. Not allows or commend to be used for MUST bed when necesar 6 TIPS PLEASE READ 1. Correction of Terror Decrease in counts must be tied as part of the label where applicable 2. Caractus of Vanhador cash received must be where cable 3. Sus for each tion MUST be properly identifieds.cached in provided by 10 Ace utilise CASH. There ARE GAINS AND LOSSES from times that included in Gente 5. et chain cash beginning Chance from adjusted trace 2019 meglendingabend beinduted 11 at the bottom of this statement 14 15 16 18 19 20 21 22 23 24 25 20 37 28 asu SRESOR Adjusted that Balans + 15 y 2000 Sement of CF July 2020 Ready W 14 MacBook Air Home Insert Draw Page Layout Formulas Data Review View Arial 12 AA 29 Wrap teet General 05 Pasto BTW A 03 Mar A Center $ %) $8 Conditional Format Call Formatting as Table Styles A9 Xfx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are A D 1 Davenport Docking Corporation 2 For the Years Ended July 31, 2019 and 2020 To complete part 2 Follow IN ORDER: 1. Create multi-step Income Statement using the July 31, 2020 adjusted balances AND formatting information from Istab. 5 2. Create statement of retained earings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab. 63. Create classified balance sheet using July 31, 2020 adjusted balances AND formatting Information from BS tab. 4. Create statement of cash flows using the income statement, the changes" columns from below, and the additional notes to the right of July 31, 2020 adjusted trial balance columnis. To 7 complete the changes columns and the statement of cash flows: a. Input a formula in either the debit column OR the credit column to find the change in account balance from July 2019 to July 2020. b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed out 10 c. Use the changes amounts to create the statement of cash flows. Amounts from the income statement will also be needed 11 d. Pay attention to statement of cash flows additional information columns below. These give hints. 13 July 31, 2019 Adjusted Trial Balance Dr 16 15 16 Ad CHANGES COLUMNS Used ONLY for Statement of cash flows Debit Credit July 31, 2020 Adused Trial balance CP Acct. No Account Title Dr. 17 100 383.730.00 Cash Accounts Receivable.net 21.470.00 e05,200.00 mate! 18 102 445,000.00 424,50000 104 497,430.00 Merchandise inventory.net Office Supplies 57,000.00 106 8.500.00 B 1.250,00 12.800.00 53.650.00 10.500.00 22 Prepaid Expenses Equity Investments Trading Investments - Hold to Maturty Land 3.450.00 122 23.050.00 55,950.50 140 1.500.000,00 1.000.000.00 2.500.000 145 1.500,000.00 SAB Accu Depreciation - Building 312.500.00 400 000 000 de 208.002 00 Adjusted T Balance 70,000.00 Sunt July 20 18 July 2010 18 July 2010 Statement of July 2009 Arial 12 AA 25 Wrap Text General BU Marge & Ceres $ % ) Conditional Format Cal Formatting Table Styles x fx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed IH HIT Paste AD D 27 151 170,000.00 205.000.00 26 152 05.000.00 06.00 e depreci 29 159 Equement Accumulated Depreciation Equipment Office Furniture Acumulated Depreciation Office Furniture Account Pay 32,500.00 421009 20 194 16.250.00 16.250.00 lei 183,470.00 31 201 350 000.00 200 Weg Peable 000 400 35,000.00 12 000 24,000.00 212000 a 203 Lost Pente 204 Didends Pay 205 Ures Rent 200 Customer and Puyat 50 N Pays-Long Term 251 Bonds Payable Long Tam 252 Promo Bonds Payable Discount on one Pava Mortgage Warehouse Pays 300 200 300.00 0,000 2019 00:00 0330 000 42 301 2000 T.1723 330 25,00 2. Paid in Cap. Como Stock Radang can Down Try 1 200,000.00 540 36.02.02 18.000.00 500 .. TS 1200 COS TOLD Adjusted 000 w 14 BR MacBook Air lu Pasta a.A. BIU Marge & Conte $ %) Conditional Format Call Formatting as Table Styles X fx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cels that are gray A9 H 700 49 794,51500 799.500.00 701 50 229.000.00 49,000.00 $1 702 65.000.00 75.000.00 703 52 Waos Expense hourly workers) Salaries Expensa (Exemet Stall Marketing Expense Travel and Entertainment Expense Bad Debt Expert Property Tax Expense Ofico Marance & Repar Expense 85 800.00 525.00 53 704 6,500.00 8.900.00 150.000.00 54 705 111,200.00 30.000 55 700 56 707 Legal Expenses 6,400.00 52 1.500.00 3.500.00 48.385.00 5325.00 735 00 10.000.00 SO DO G1 708 surance Experte 709 Maceteros Expense 710 Office Sess Esperse 751 Telecommunications En 712 Depreciation Expense Bulding 713 Depreciation Equent Depreciation Expense-Office Furniture 800 Rent income 69 Canonyme Secures - Tradine 000 Interest Expense 002 Los on Hello Mar 62.500.00 12.000.00 32550 1.000 179200 62 DO DE 3023033 35.000 5.000 4,000.00 1 000.00 9259.00 1.435.000 4.3.000 32.000 ZASOD03 223.414 2452 400.45 10 income Los Ajusted T Balance ch THE JU Ready w 14 MacBook Air Home Insert Draw Page Layout Formulas Data Review View v 11 Wir Paste Calibri (Body) A A I U a. A Ax fx Instructions: Using the July 31, 2020 adjusted trial balance information + A2 A D 1 Davenport Docking Corporation Instructions: Using the July 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 use, and clarity of financial 2 statement. The other requirements are: 3a. ONLY use accounts that have adjusted balances for July 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 5 Use the following format (in order): 7 1. Input beginning balance this is listed in the July, 31 2020 adjusted trial balance columns 8 2. List net income floss) and cash dividends of applicable) 9 3. Subtotal items from #2 to calculate net increase or decrease in retained earnings, 10 4. Calculate ending balance. 22 13 14 15 16 20 21 22 21 2.4 25 26 22 Strnt RE July 2020 U July 15 July 20:30 Instruction Adjusted Thalalance Ready w 14 W2 me Insert Draw Page Layout Formulas Data Review View X Calibri (Body) | 11 AA Wrap Text aste U V A Merge & Center 7 * fx B D Davenport Docking 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, formule use, and clarity of financial statement. The other requirements are: a. ONLY use accounts that have adjusted balances for July 31, 2020 b.include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format in order: 1. Input and list asset accounts in 3 categories Current Assets Property, plant, and Equipment(PPE). Other Assets 2. Each category from it requires a subtotal EXCEPT for Other Assets 3. Calculate Total Assets 10 4. Input and list liability accounts in 2 categories: Current Liabilities and long term Liabilities 1 5. Each category from requires a subtotal 32 5. Calculate Total abilities 13 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained earnings 14 1. Calculate Total Stockholder's Equity 15 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets 17 17 20 21 22 20 20 20 20 15 July 200 5 July 2030 BS sluly 2020 Statem w 14 MacBook Data Window Help W210 Excel File Edit View Insert Format Tools s Home Insert Draw Page Layout Formulas Data Calibri (Body) 11 AA 1 Paste BIU a. A Review View Wrap Text Es Merge & Center 3 A17 x x A 8 D 1 Davenport Docking Corporation Instructions Using the changes columns" and additional information from the adjusted trial balance tob 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 clarity of financial statement. Other required Items 2 3. Only use accounts that have changes or cash flows 4 b. Include proper report title 3. Not all rows or columns need to be used Formulas MUST be used when necessary. 6 TIPS PLEASE READ 1. Correct selection of Tecrease or "Decrease in accounts must be used as part of the label where applicable 2. Correct use of cash paid" or "cash received must be used where applicable 3. Subtotals for each section MUST be properly identified as cach used in or provided by 10 4. All changes til CASH.There ARE GAINS AND LOSSES from investments that must be included in operating activities 5. Net change in cash beginning cash balance from a adjusted trial balance July 2019 column) musteguwending cash balance and be locluded 11 at the bottom of this statement 14 15 16 17 20 21 22 24 15 21 Jy2020 SEO 2000 July 2000 Statement W 14 MacBook Air Excel Edt View en formatos Das Wide BU Home Page Layout WIDOS STOM D View A 1 the A- 6 XOM o il 3 1 Davenport Forever 2016 contentNORDER: Lommune AND AS AND Swedbathely 200 mg 4. Comunementen had to 7 change a la former the ang 2018 2031 down the 13 CHANGES COLUMNS 13 MAN Ju 2018 M D Jay 200 A Anett 13 100 D 19 104 0000 20 w Tag 4 123 HRM 20 1 La N FI 2 Event 20 14 MacBook Air 000 esc 30 Excel Fae Edit View Formal Tools Outa Windows We flere Sun 7.06 PM Kab Pun sort D Page Layout Data View AA Com -A- $ xf Only there and have 2019 bing bing that are 9.0. 2 V 1 1M A. one Austur Accue Wis TE IN 201 RE 20 294 20 SOE 2001 TRE w 250 Sendeng 900 292 140 1 Secunda More Women EP 105 Paper DOE 13.00 43 G DRE WE O Pune TH 20000 Adana 15 2000 05 MacBook Air DO Excel file Edit View inson Format Tools Data Window Helo B. 7 Home De OLEME 7:06 PM Kabang Page Layout Ferme Data Review Men th Pasta BU 99.0 5% A9 * Only complete the changes that are tied and 2010 2000 den Mar w 704 10 B. 14 00 700 RE per PE chu LE OG 1.000 REV 1.500.000 ON 17.00 ME 110 ontbre 71 Taco Borse 712 Deci per Deprecatepe 14 beste 100 Ramin Osmontant Expert Loft 100 3. STEP 11. nu 05 1000 DOG 4.000 30 100 323 014 000 28 1234 B. (NI DO 70 ET 22 Callbrl (Body) 11 ' ' Wrap Tour General Paste B U OA non Cant $ % 9.22 A2 X fx Instructions: Using the July 31, 2020 adjusted trial balance information AND income statement complete the statemer A D F G H Davenport Docking Corporation Instructions: Lising the July 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 use, and clarity of financial statement. The other requirements are: EL ONLY use accounts that have adjusted balances for July 31, 2020 b. Include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format in order: 1. Input beginning balance (this is listed in the July, 31 2020 adjusted trial balance columns). 2. List net income flos) and cash dividends (if applicable) 3. Subtotal items from 12 to calculate net increase or decrease in retained earnings 10 4. Calculate ending balance. 13 14 15 17 18 39 20 21 22 24 W21 DO Student Fille P2 Home Insert Draw Page Layout Fermulas Data Review View Calib (Body 11 AA IN 25 Wrap The General Pante BTU AA $ % 9 Conne Formatting Ticle Cal A17 x fe H c D Der Docking Corporation Inetween deghe An 2020 trebalance information AND thement of reading complete confed Melecehat. Round all amounts to the recent follow the below formatates, the rest to the date the gredere also bewon argestion formules and cry of financial atent. The other requiremene 1 ONLY account that have added balances for July 31, 2010 4 b. Include proportite 3 N I rows or columns and to be used. Formula MUST be used when necessary 5. U the following format in order 1.Input and let counts in categorie: Current Property. Plant, and Equipment Pen Others 2. Each category from regresa subtota EXCEPT For Other Adet 9 3. Calculate Total Arts 10 4. input and liability account in 2 Megories Current Liabilities and long term its 15 S. Sacharytron requires a subtot 22 6. Calculate Total abilities 11 7.laput and stockholder's Equity Accounts including ending balance of retained wings from tement of retained earning 14 8. Calculate Total Stockholderiquity 15 Calculate Totales and Stockholder's Equity. This amount should equal Total 12 19 20 21 23 24 25 26 27 20 29 30 djusted Triat Balance IN 2020 Sol Rey 200 BS 2020 StentofCF 2020 Ready . W 14 General S%6 Candien CH Calibr (Bodyl 11 AAT WAT UM 3 8 JU A A17 * fx A 1 Beport Doc Corporation Instructor using the changeschwandeling metion from the treate ANDI Incoment.create estenent af How INDIRECT MITNOD, Round all meant to the recent follow the below the foreign to the dent. Note the grades and an evention, and clarity of foncient. Otherwiredite H Only counts that have changes or cash flows due proper report title c. Not allows or commend to be used for MUST bed when necesar 6 TIPS PLEASE READ 1. Correction of Terror Decrease in counts must be tied as part of the label where applicable 2. Caractus of Vanhador cash received must be where cable 3. Sus for each tion MUST be properly identifieds.cached in provided by 10 Ace utilise CASH. There ARE GAINS AND LOSSES from times that included in Gente 5. et chain cash beginning Chance from adjusted trace 2019 meglendingabend beinduted 11 at the bottom of this statement 14 15 16 18 19 20 21 22 23 24 25 20 37 28 asu SRESOR Adjusted that Balans + 15 y 2000 Sement of CF July 2020 Ready W 14 MacBook Air Home Insert Draw Page Layout Formulas Data Review View Arial 12 AA 29 Wrap teet General 05 Pasto BTW A 03 Mar A Center $ %) $8 Conditional Format Call Formatting as Table Styles A9 Xfx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are A D 1 Davenport Docking Corporation 2 For the Years Ended July 31, 2019 and 2020 To complete part 2 Follow IN ORDER: 1. Create multi-step Income Statement using the July 31, 2020 adjusted balances AND formatting information from Istab. 5 2. Create statement of retained earings using July 31, 2020 adjusted balances AND formatting information from stmnt of RE tab. 63. Create classified balance sheet using July 31, 2020 adjusted balances AND formatting Information from BS tab. 4. Create statement of cash flows using the income statement, the changes" columns from below, and the additional notes to the right of July 31, 2020 adjusted trial balance columnis. To 7 complete the changes columns and the statement of cash flows: a. Input a formula in either the debit column OR the credit column to find the change in account balance from July 2019 to July 2020. b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed out 10 c. Use the changes amounts to create the statement of cash flows. Amounts from the income statement will also be needed 11 d. Pay attention to statement of cash flows additional information columns below. These give hints. 13 July 31, 2019 Adjusted Trial Balance Dr 16 15 16 Ad CHANGES COLUMNS Used ONLY for Statement of cash flows Debit Credit July 31, 2020 Adused Trial balance CP Acct. No Account Title Dr. 17 100 383.730.00 Cash Accounts Receivable.net 21.470.00 e05,200.00 mate! 18 102 445,000.00 424,50000 104 497,430.00 Merchandise inventory.net Office Supplies 57,000.00 106 8.500.00 B 1.250,00 12.800.00 53.650.00 10.500.00 22 Prepaid Expenses Equity Investments Trading Investments - Hold to Maturty Land 3.450.00 122 23.050.00 55,950.50 140 1.500.000,00 1.000.000.00 2.500.000 145 1.500,000.00 SAB Accu Depreciation - Building 312.500.00 400 000 000 de 208.002 00 Adjusted T Balance 70,000.00 Sunt July 20 18 July 2010 18 July 2010 Statement of July 2009 Arial 12 AA 25 Wrap Text General BU Marge & Ceres $ % ) Conditional Format Cal Formatting Table Styles x fx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cells that are grayed IH HIT Paste AD D 27 151 170,000.00 205.000.00 26 152 05.000.00 06.00 e depreci 29 159 Equement Accumulated Depreciation Equipment Office Furniture Acumulated Depreciation Office Furniture Account Pay 32,500.00 421009 20 194 16.250.00 16.250.00 lei 183,470.00 31 201 350 000.00 200 Weg Peable 000 400 35,000.00 12 000 24,000.00 212000 a 203 Lost Pente 204 Didends Pay 205 Ures Rent 200 Customer and Puyat 50 N Pays-Long Term 251 Bonds Payable Long Tam 252 Promo Bonds Payable Discount on one Pava Mortgage Warehouse Pays 300 200 300.00 0,000 2019 00:00 0330 000 42 301 2000 T.1723 330 25,00 2. Paid in Cap. Como Stock Radang can Down Try 1 200,000.00 540 36.02.02 18.000.00 500 .. TS 1200 COS TOLD Adjusted 000 w 14 BR MacBook Air lu Pasta a.A. BIU Marge & Conte $ %) Conditional Format Call Formatting as Table Styles X fx b. Only complete the changes" cells that are outlined and have 2019 beginning balances and 2020 ending balances. Do not find changes in cels that are gray A9 H 700 49 794,51500 799.500.00 701 50 229.000.00 49,000.00 $1 702 65.000.00 75.000.00 703 52 Waos Expense hourly workers) Salaries Expensa (Exemet Stall Marketing Expense Travel and Entertainment Expense Bad Debt Expert Property Tax Expense Ofico Marance & Repar Expense 85 800.00 525.00 53 704 6,500.00 8.900.00 150.000.00 54 705 111,200.00 30.000 55 700 56 707 Legal Expenses 6,400.00 52 1.500.00 3.500.00 48.385.00 5325.00 735 00 10.000.00 SO DO G1 708 surance Experte 709 Maceteros Expense 710 Office Sess Esperse 751 Telecommunications En 712 Depreciation Expense Bulding 713 Depreciation Equent Depreciation Expense-Office Furniture 800 Rent income 69 Canonyme Secures - Tradine 000 Interest Expense 002 Los on Hello Mar 62.500.00 12.000.00 32550 1.000 179200 62 DO DE 3023033 35.000 5.000 4,000.00 1 000.00 9259.00 1.435.000 4.3.000 32.000 ZASOD03 223.414 2452 400.45 10 income Los Ajusted T Balance ch THE JU Ready w 14 MacBook Air Home Insert Draw Page Layout Formulas Data Review View v 11 Wir Paste Calibri (Body) A A I U a. A Ax fx Instructions: Using the July 31, 2020 adjusted trial balance information + A2 A D 1 Davenport Docking Corporation Instructions: Using the July 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 use, and clarity of financial 2 statement. The other requirements are: 3a. ONLY use accounts that have adjusted balances for July 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 5 Use the following format (in order): 7 1. Input beginning balance this is listed in the July, 31 2020 adjusted trial balance columns 8 2. List net income floss) and cash dividends of applicable) 9 3. Subtotal items from #2 to calculate net increase or decrease in retained earnings, 10 4. Calculate ending balance. 22 13 14 15 16 20 21 22 21 2.4 25 26 22 Strnt RE July 2020 U July 15 July 20:30 Instruction Adjusted Thalalance Ready w 14 W2 me Insert Draw Page Layout Formulas Data Review View X Calibri (Body) | 11 AA Wrap Text aste U V A Merge & Center 7 * fx B D Davenport Docking 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, formule use, and clarity of financial statement. The other requirements are: a. ONLY use accounts that have adjusted balances for July 31, 2020 b.include proper report title c. Not all rows or columns need to be used. Formulas MUST be used when necessary. Use the following format in order: 1. Input and list asset accounts in 3 categories Current Assets Property, plant, and Equipment(PPE). Other Assets 2. Each category from it requires a subtotal EXCEPT for Other Assets 3. Calculate Total Assets 10 4. Input and list liability accounts in 2 categories: Current Liabilities and long term Liabilities 1 5. Each category from requires a subtotal 32 5. Calculate Total abilities 13 7. Input and list Stockholder's Equity Accounts including ending balance of retained earnings from statement of retained earnings 14 1. Calculate Total Stockholder's Equity 15 9. Calculate Total Liabilities and Stockholder's Equity. This amount should equal Total Assets 17 17 20 21 22 20 20 20 20 15 July 200 5 July 2030 BS sluly 2020 Statem w 14 MacBook Data Window Help W210 Excel File Edit View Insert Format Tools s Home Insert Draw Page Layout Formulas Data Calibri (Body) 11 AA 1 Paste BIU a. A Review View Wrap Text Es Merge & Center 3 A17 x x A 8 D 1 Davenport Docking Corporation Instructions Using the changes columns" and additional information from the adjusted trial balance tob 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 clarity of financial statement. Other required Items 2 3. Only use accounts that have changes or cash flows 4 b. Include proper report title 3. Not all rows or columns need to be used Formulas MUST be used when necessary. 6 TIPS PLEASE READ 1. Correct selection of Tecrease or "Decrease in accounts must be used as part of the label where applicable 2. Correct use of cash paid" or "cash received must be used where applicable 3. Subtotals for each section MUST be properly identified as cach used in or provided by 10 4. All changes til CASH.There ARE GAINS AND LOSSES from investments that must be included in operating activities 5. Net change in cash beginning cash balance from a adjusted trial balance July 2019 column) musteguwending cash balance and be locluded 11 at the bottom of this statement 14 15 16 17 20 21 22 24 15 21 Jy2020 SEO 2000 July 2000 Statement W 14 MacBook Air