Mant Adjusted Trial Balance Income Statement Carte Statement of Owner's Equity Balance Sheet . 0 H Directions: The goal of this assignment is to gain an understanding of basic Excel Functions. Excel is a program that is used in so many types of businesses and jobs, and this assignment will teach you to link data, and create a formulas. Save this file as LastName ACG 2001EC.xlsx This assignment will be worth a total of 15 extra credit points. S Points will be for completed, and correct, financial statements. 10 Points will be for proper excel linking and formula usage in order to earn full points you for the excel portion of this assignment, all cells must be linked. Any cells shaded gray will require an excel formula, To start an excel formula or cell reference begin with the enter (-) sign. 8,200 2.400 800 Once you click the enter sign, you will able to select individual cells (we call this referencing cells) You can also create simple formulas such as 1+2, by typing in a plus sign. A formula will look like -C2+02. Bxcel will then do the math for you and show you the answer 13,400 3,500 Corgi Company Adjusted Trial Balance December 31, 2020 Cash $ Accounts Receivable $ Prepaid Expenses $ Supplies 5 Accounts Payable Notes Payable-Due on June 30, 2021 Corgi Company, Capital Corgi Company, Drawing $ Fees Earned Wages Expense S Rent Expense $ Utilities Expense $ Depreciation Expense 5 Miscellaneous Expense s Total $ $ $ 3,000 A cell reference will look like. A cell reference from another tab will look like ='Adjusted Trial Balance 019. A cell reference will put the same information from the references cell into the cell you want 13,000 830 $ 8,970 In the adjusted trial balance, I want you to add the rows, using a SUM formula. I have done the first column for you. 1.250 895 1 See the links below for some tutorials on excel 2 470 145 Basic Excel Tutorial Autosome Tutorial - BO 28,4705 28.470 Cell Reference. Tutorial NetSolutions Income Statement For the Month Ended November 30, 2018 $7,500 $2125 800 Fees earned Expenses: Wages expense Rent expense Supplies expense. Utilities expense Miscellaneous expense Total expenses Net income...... 800 450 275 4.450 $3.050 Net Solutions Statement of Owner's Equity For the Month Ended November 30, 2018 0 $ 25,000 3,050 Chris Clark, capital, November 1, 2018., Investment on November 1, 2018 Net income for November... Withdrawals...... Increase in owner's equity Chris Clark, capital, November 30, 2018 (2,000 26,050 526,050 NetSolutions Balance Sheet November 30, 2018 Assets Liabilities $ S. 5.900 550 Cash Supplies. Land 400 Accounts payable Owner's Equity Chris Clark, capital........ Total liabilities and owner's equity...... Total assets 20,000 $ 26,450 26,050 $ 26,450 NetSolutions Statement of Cash Flows For the Month Ended November 30, 2018 $ 7,500 (4.600) $ 2,900 Cash flows from operating activities: Cash receipts from customers.... Deduct Cash payments for expenses and payments to creditors Net cash flow from operating activities Cash flows used for investing activities: Cash payments for purchase of land... Cash flows from financing activities: Cash receipt of owner's investment.... Deduct Cash withdrawal by owner..... Net cash flow from financing activities Net increase in cash and November 30, 2018, cash balance (20,000) 525.000 (2.000) 23,000 $5.900 Corgi Company Income Statement December 31, 2020 Fees Earned $ 8,970 1,250 895 470 expenses Wage expense Rent expense utilities expense depreciation expense miscellaneous expense Total expenses Net income 145 80 $ $ 2,840 6,130 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it. 10,000 Corgi Company Statement of Owner's Equity December 31, 2020 Corgi Company, Capital 1/1/2020 $ Investment on Jan 1,2020 3000 Net income for January 6130 Withdrawals 830 Increase in owners equity Corgi Company, Capital, jan 30 2020 8300 18,300 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it. Cash Accounts Receivable Pre-paid expenses supplies Total Assets Corgi Company Adjusted Trial Balance December 31, 2020 Assets $ 8,200 $ 2,400 $ 800 $ 13,400 $ Liabilities $ 3,500 $ 3,000 $ 24,800 Accounts payable Notes payable 6,500 Owner's Equity Corgi Company, capital $ 18,300 Total Liabilities and Owner's Equity $ 24,800 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it. Mant Adjusted Trial Balance Income Statement Carte Statement of Owner's Equity Balance Sheet . 0 H Directions: The goal of this assignment is to gain an understanding of basic Excel Functions. Excel is a program that is used in so many types of businesses and jobs, and this assignment will teach you to link data, and create a formulas. Save this file as LastName ACG 2001EC.xlsx This assignment will be worth a total of 15 extra credit points. S Points will be for completed, and correct, financial statements. 10 Points will be for proper excel linking and formula usage in order to earn full points you for the excel portion of this assignment, all cells must be linked. Any cells shaded gray will require an excel formula, To start an excel formula or cell reference begin with the enter (-) sign. 8,200 2.400 800 Once you click the enter sign, you will able to select individual cells (we call this referencing cells) You can also create simple formulas such as 1+2, by typing in a plus sign. A formula will look like -C2+02. Bxcel will then do the math for you and show you the answer 13,400 3,500 Corgi Company Adjusted Trial Balance December 31, 2020 Cash $ Accounts Receivable $ Prepaid Expenses $ Supplies 5 Accounts Payable Notes Payable-Due on June 30, 2021 Corgi Company, Capital Corgi Company, Drawing $ Fees Earned Wages Expense S Rent Expense $ Utilities Expense $ Depreciation Expense 5 Miscellaneous Expense s Total $ $ $ 3,000 A cell reference will look like. A cell reference from another tab will look like ='Adjusted Trial Balance 019. A cell reference will put the same information from the references cell into the cell you want 13,000 830 $ 8,970 In the adjusted trial balance, I want you to add the rows, using a SUM formula. I have done the first column for you. 1.250 895 1 See the links below for some tutorials on excel 2 470 145 Basic Excel Tutorial Autosome Tutorial - BO 28,4705 28.470 Cell Reference. Tutorial NetSolutions Income Statement For the Month Ended November 30, 2018 $7,500 $2125 800 Fees earned Expenses: Wages expense Rent expense Supplies expense. Utilities expense Miscellaneous expense Total expenses Net income...... 800 450 275 4.450 $3.050 Net Solutions Statement of Owner's Equity For the Month Ended November 30, 2018 0 $ 25,000 3,050 Chris Clark, capital, November 1, 2018., Investment on November 1, 2018 Net income for November... Withdrawals...... Increase in owner's equity Chris Clark, capital, November 30, 2018 (2,000 26,050 526,050 NetSolutions Balance Sheet November 30, 2018 Assets Liabilities $ S. 5.900 550 Cash Supplies. Land 400 Accounts payable Owner's Equity Chris Clark, capital........ Total liabilities and owner's equity...... Total assets 20,000 $ 26,450 26,050 $ 26,450 NetSolutions Statement of Cash Flows For the Month Ended November 30, 2018 $ 7,500 (4.600) $ 2,900 Cash flows from operating activities: Cash receipts from customers.... Deduct Cash payments for expenses and payments to creditors Net cash flow from operating activities Cash flows used for investing activities: Cash payments for purchase of land... Cash flows from financing activities: Cash receipt of owner's investment.... Deduct Cash withdrawal by owner..... Net cash flow from financing activities Net increase in cash and November 30, 2018, cash balance (20,000) 525.000 (2.000) 23,000 $5.900 Corgi Company Income Statement December 31, 2020 Fees Earned $ 8,970 1,250 895 470 expenses Wage expense Rent expense utilities expense depreciation expense miscellaneous expense Total expenses Net income 145 80 $ $ 2,840 6,130 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it. 10,000 Corgi Company Statement of Owner's Equity December 31, 2020 Corgi Company, Capital 1/1/2020 $ Investment on Jan 1,2020 3000 Net income for January 6130 Withdrawals 830 Increase in owners equity Corgi Company, Capital, jan 30 2020 8300 18,300 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it. Cash Accounts Receivable Pre-paid expenses supplies Total Assets Corgi Company Adjusted Trial Balance December 31, 2020 Assets $ 8,200 $ 2,400 $ 800 $ 13,400 $ Liabilities $ 3,500 $ 3,000 $ 24,800 Accounts payable Notes payable 6,500 Owner's Equity Corgi Company, capital $ 18,300 Total Liabilities and Owner's Equity $ 24,800 *Note: Review Chapter 1 Exhibit 8 (page 22) for a review of the financial statements. Any boxes that are white you are required to type in the correct heading/account. Each box should have something in it