A1 ACCT& 201 Lab 1 Given Problem Datal 2 Instructions: Use the information below to complete the income statement, statement of stockholders' equity and balance sheet for Canary Company for 2016. Remember to create a cell reference (link) from the Financial Statements tab to each of these amounts- 2 don't copy and paste them 4 CANARY COMPANY 5 Financial Information (Given Data) 6 For the year 2016 $ 3,600 14,500 48,600 8,400 8 Accounts payable as of Dec. 31, 2016 9 Accounts receivable from customers as of Dec. 31, 2016 10 Cash as of Dec. 31, 2016 11 Insurance expense for the year 12 Equipment owned as of Dec. 31, 2016 (net of depreciation)69,000 13 Rent expense for the year 14 Salaries expense for the year 15 Salaries owed to employees as of Dec. 31, 2016 16 Service revenue earned during the year 17 Supplies expense for the year 18 Supplies owned as of Dec. 31, 2016 19 Utilities expense for the year 8,200 47,300 4,000 105,000 1,900 5,400 22 Common stock as of Jan 1, 2016 (issued before 2016) 23 Common stock issued during 2016 24 Retained earnings as of Jan. 1, 2016 25 Dividends paid to stockholders during the year 30,000 Excel uses a hypen to indicate the number 0. 71,300 Lab 1 Student Tem Tell me what nsert Page Layout Formules Data Review View Add-ins ACROBAT TeamTell General Conditional Formatting Copy Format Painter 8IU Merge & Center . $-% , Number B r u, B- s-. Alignment Font Income Statement For the Year Ended December 31, 2016 This frst cel has been completed for you. Revenues Service revenue Expenses S 105,000 Make sure to link al expenses to cells on the Problem Data tab Rent expense Utiities expense Salaries expense Supplies expense Insurance expense Total expenses Net income CANARY COMPANY Statement of Stockholders' Equity For the Year Ended December 31, 2016 Write a formula to add two cells together: D28+ E28 Total Retained Stockholders' use Excel to do the math! Use Stock EarningsEquity this concept to compute al of the amounts in column F Beginning balance (Jan 1) ssuance of common stock Add: Net income Less Dividends Ending balance (Dec. 31) When you Ink to the cel containing the amount of dividends paid on the Problem Data tab, enter the minus sign in front of the cell address to CANARY COMPANY Balance Sheet December 31, 2016 force it to be displayed as a negative number Assets Liabilities Accounts receivable Accounts payable Salaries payable Total liabilties Equipment, net Stockholders' Equity Common stock Retained earmings Total stockholders' equity Total liabilities and TART HERE Problem Data Financial Statements Type here to search