AutoSave OFF Problem 3 Excel Template a Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments X a insert v Arial C. v 11 ~ A ab Wrap Textv .. Ceneral 4 v Paste BIU AYA Av ZY Sort & Filter = = = Delete Format Merge & Center v Y Conditional Format Cell Formatting es Table Styles Ideas Y Sensitivity Find & Select v M43 fx D E E F H K M N P R 5 Trial Balance Cumberland City Cycles, Inc. Income Statement For the Year Ended December 31, 2021 Cumberland City Cycles, Inc. Balance Sheet 31 Dec 21 1 2 3 4 5 CAN 5 7 8 DR #REFI RAVANUAR Rental Revenue Total Revenues 10 11 12 11 14 15 10 17 18 Fspan Salates Expense Advertising Expense Ultes Expense Insurance Fipan Rent Experie Supplies Expense Depreciation Experes-Building Depreciation Experce-Equipment | Interest Expense Total Expenses Aagala Cush Accounts Receivable Suppies Prepaid Rant Prepaid Insurance Equipment Accumulated Depreciation Equipment Buiding Accumulated Depreciation Building Total Assets 20 21 Net Income AREFI . 23 Liabities Accounts Payable Uncamed Ravanud Notes Paab Salaries Payable Interest Payable Notes Payabc-Long Term Total Liabilia Sloxholders' Equity Common Stock Heta ned Lamngs Total Stockholders' Equity Total Liabile & Stockholders' Equiy 26 1 32 33 34 1 Cumberland City Cycles, Inc. Statement of Retained Earnings For the Year Ended December 31, 2021 37 Beginning Rolained Eaminys Add: Not Income Less: Driends Ending Ratinad Faminga 44 00 47 D Adjusted Trial Balance Financial Statements + + # - 94% AutoSave OFF Problem 3 Excel Template a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X 2 Insert v Arial ~ A v 11 5 Wrap Text Custom HU 4 v Delete Paste BIU Av = = = Merge & Center Y Conditional Format Cell Formatting es Table Styles Y Ideas Sensitivity Sort Filter Il Format v Find & Select C37 - D E F G H L M N N O P P C A B C 1 Cumberland City Cycles, Inc. 2 Adjusted Trial Balance 3 31-Dec-21 4 5 DR CR 6 Cash 12,500 7 Accounts Receivable 25,000 8 Office Supplies 7.500 9 Prepaid Rent 750 10 Prepaid Insurance 4.200 11 Equipment 50,000 12 Accumulated Depreciation Equipment 10,000 13 Building 250,000 14 Accumulated Depreciation Building 25,000 15 Accounts Payable 32,000 16 Unearned Revenue 6,500 17 Notes Payable 10,0XX) 18 Interest Payable 1,000 19 Salaries Payable 1,200 20 Notes Payable--Long Term 15,000 21 Common Stock 100,000 22 Dividends 2,000 23 Retained Earnings 24 Rental Revenue 229,200 25 Salaries Expense 23,000 26 Advertising Expense 5,000 27 Utilities Expense 6,400 28 Insurance Expense 2,300 29 Rent Expense 250 30 Supplies Experise 5,000 31 Depreciation Expense-Equipment 10.000 32 Depreciation Expnse-Building 25,000 33 Interest Expense 1,000 34 35 429,900 429,900 36 37 38 Adjusted Trial Balance Financial Statements + # - 120% elearn.apsu.edu Ar OneStop Austin Paay State University Problem 3--Chapter 4 - Accounting 2014 - W04, woe, W33 W34, W38 Com... A https://elearn.apsu.edu/d21e/dropbox/8379730/6925433/DownloadAttac Problem 3 Chapter 4 Instructions On the Excel file, you will find two tabs: 1) Adjusted Trial Balance and 2) Financial Statements. The Adjusted Trial Balance is completed and correct. The Financial Statements tab shows an outline for the financial statements with all headings, accounts, columns, and lines correct. Note that this format is almost exactly the same as Problem 2 Chapter 3. The only difference is the inclusion of a couple more accounts. REQUIRED: Complete the financial statements using formulas in Excel. DO NOT just enter the numbers- enter formulas for ALL amounts. Referring back to Problem 2 Chapter 3 will be helpful