Autasare co 0 In Lessn 5 Amaia Gabibla + Saved Search Gabiola, Amais (gabi179guandalsuidaho.adu) P5-48 Using Excel to prepare a multi-step income statement Use the blue shaded areas on the income statement workshent far inputs. Requirements 1. Use txcel to prepare a multi-step income statement based on the adjusted trial balance. Income statement, For examplo, the Rent Expense is divided into two categories-selling and Administrative. b. LJer a formula tn add and subtract acrount amounts as indicated. r. Farmat the numbers in the dollar columins with a comrna and no decirmal places (e.g. 5,460 ). Use: a dollar sign at the top of each colurnn arid at the total (e-g $26,201). Make sure the decirnal places align. d. Double-underline the total. 2. Compute the gross profit margin percentage, Fomat percentages to two decimal places (e.E. 22.748). Excel Skills 1. Lnter numbers or text inito cells. 2. Use formulas to add or subtract. 3. Select the number fomnat (dollar signs). 4. Select the percentage format [e] to two decimal places. 5. Select the horder [double underline]. 6. Use the Increase Indent button to indent iterns in the income staternent. Autasare co 0 In Lessn 5 Amaia Gabibla + Saved Search Gabiola, Amaia (gabi5179!gandalsuidaho.adu) G30fr \( 1 4 \longdiv { \text { Accumulated Depreciation-Building } } \) 15 Equipment 16 Accumulated Deprociation-Equipment 17 Arccounts Paynble 18 Salaries Payable 20 Hefunds Payable 21 Notes Payablo P3 Commn Stork 23 Retained Earnings 24 Diwidends 25 Sales Revenue 26 Sales Discounts Forfeited 77 Cost af Gonds Scld 28 Salaries Expense \{Note N1\} 29 Rent Expense (Note N2) 30 Utilities Expense (Note 33 ) 31 Depreciation Expense - Building [Note 4 ) 33 Depreriation Fxpense - Fruipment (Nnte #.5 ) 33 Advertising Expense 31 Interest Expense 5 Delivery Expense Supplies Expense (Note \#6) Incame Tax Fxpense Notes 41 \#1 - 30\% of the salaries is for the Administrative Offices. Reacy e Accessitility: Inestigste Adjusted Trial Balance Income Statement AutaSare Cn O fin Lessan 5 Amaia Gabiola + Saved Search Gabiola, Amais (gabi179gvandalsuidaho.adu) (i) x Autasare co 0 In Lessn 5 Amaia Gabibla + Saved Search Gabiola, Amais (gabi179gvandalsuidaho.adu)