complete the financial statement using formulas in excel

A Matthew A Pankey E O Problem 3 Excel Template (2) - Excel Insert File Home Page Layout Formulas Data Review ab X % Arial BIU. AA View Help Tell me what you want to do Asha Conditional Formatting o Formatas Table Cells Editing Sensitivity 12 Cell Styles Styles Sensitivity - Number Paste Clipboard Font Alignment R22 3 X v f C D E H Cumberland City Cycles, Inc. Income Statement For the Year Ended December 31, 2021 Cumberland City Cych Balance Sheet 31-Dec-21 DR HREFI Revenues Rental Revenue Total Revenues Assets Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Equipment Accumulated Depreciation Equipment Building Accumulated Depreciation-Building Total Assets 1 12 Expenses Salates Expense Advertising Expense Unities Expense Insurance Expense Rent Expense Supplies Expense Depreciation Expense-Building Depreciation Expense-Equipment Interest Expense Total Expenses 14 20 Net Income Labs Accounts Payable Uneamed Revenue Notes Payable Salaries Payable Interest Payable Notes Payable-Long Term Total Liabilities Stockholders' Equity Common Stock Retained Eaming Total Stockholders' Equity Total Liabilities & Stockholders' Equity Cumberland City Cycles, Inc. Statement of Retained Earnings For the Year Ended December 31, 2021 Beginning Retained A Nincome Less: Dividende Ending Retained Earrings Adjusted Trial Balance Financial Statements Type here to search O i a 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. 10:25 AM 10/19/2020 A Matthew A Pankey E O Problem 3 Excel Template (2) - Excel Insert File Home Page Layout Formulas Data Review ab X % Arial BIU. AA View Help Tell me what you want to do Asha Conditional Formatting o Formatas Table Cells Editing Sensitivity 12 Cell Styles Styles Sensitivity - Number Paste Clipboard Font Alignment R22 3 X v f C D E H Cumberland City Cycles, Inc. Income Statement For the Year Ended December 31, 2021 Cumberland City Cych Balance Sheet 31-Dec-21 DR HREFI Revenues Rental Revenue Total Revenues Assets Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Equipment Accumulated Depreciation Equipment Building Accumulated Depreciation-Building Total Assets 1 12 Expenses Salates Expense Advertising Expense Unities Expense Insurance Expense Rent Expense Supplies Expense Depreciation Expense-Building Depreciation Expense-Equipment Interest Expense Total Expenses 14 20 Net Income Labs Accounts Payable Uneamed Revenue Notes Payable Salaries Payable Interest Payable Notes Payable-Long Term Total Liabilities Stockholders' Equity Common Stock Retained Eaming Total Stockholders' Equity Total Liabilities & Stockholders' Equity Cumberland City Cycles, Inc. Statement of Retained Earnings For the Year Ended December 31, 2021 Beginning Retained A Nincome Less: Dividende Ending Retained Earrings Adjusted Trial Balance Financial Statements Type here to search O i a 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. 10:25 AM 10/19/2020