just to use cell referencing to complete the spreadsheet and needing to know where everything goes

A B El L N P S U w Y AA A AD AF A A AL AN AP Balance Sheet 1 2 Assets Liabilities Stockholder's Equity Accounts Receivable Prepaid Insurance Prepaid Rent Unearned Service Revenue Notes Payable Salaries Payable Accounts Payable Interest Payable Common Stock Retained Earnings Numbers! Account Title Enter Expenses as Positive Income Statement Date Amount Cash Equipment Supplies 3 Description 4 5 Beginning Balances, January 1st Year 2 Revenue Expense Net Income 15-Jan Paid employees for one month of work $ 32,959 6 32,959 32,959 1-Feb 177,244 7 177,244 15-Mar 42,114 8 Paid back the note payable in full, plus interest, at a rate of 10% Performed half of the services for customer who paid in advance Issued additional common stock in exchange for cash Collected cash from customers for services previously performed 20-Jun 17,496 9 26-Jul 93,603 10 16-Aug Performed services for cash 328,378 11 20-Sep Performed services on account 254,807 12 8-Oct 42,114 13 Performed remaining services for customer who paid in advance Paid for maintenance on equipment in cash 7-Nov 26,243 14 15-Dec Paid employee salaries 362,549 15 30-Dec Paid a cash dividend to owners of the business 5,859 16 Balance Sheet Assets Liabilities Stockholder's Equity Accounts Receivable Prepaid Insurance Prepaid Rent Accounts Payable Unearned Service Revenue Notes Payable Salaries Payable Interest Payable Common Stock Retained Earnings Number ! Account Title Enter Expenses as Positive Income Statement Date Description Amount Cash Supplies Equipment Revenue Expense Net Income Beginning Balances, January 1st Year 2 December 31st Adjustments: 7 a Remaining three months of one-year insurance policy were used up 8 A physical count of supplies at the end of b the year reveals all remaining supplies 9 were used The equipment is estimated to have a C useful life of five years with no salvage 0 value; depreciation must be recorded. The rented storage facility has been used 1 for twelve months Employees have worked for half a month e in the current year but won't be paid until 2 January 15. 3 4 Ending Balances, December 31st Year 2 5 6 7 8 Total Assets $ Total L&SE $ 0 Balance Sheet Income Statement Statement of Stockholders' Equity 3 4 5 Assets Service Revenue Beginning Common Stock 6 Cash Less: Expenses Plus: Stock Issued 7 Accounts Receivable Salaries Expense Ending Common Stock 8 Supplies Interest Expense 9 Prepaid Insurance Advertising Expense Beginning Retained Earnings 10 Prepaid Rent Maintenance Expense Plus: Net Income 11 Equipment (Net) Insurance Expense Minus: Dividends 12 Total Assets Supplies Expense Ending Retained Earnings 13 Depreciation Expense 14 Liabilities Rent Expense Total Stockholders' Equity 15 Accounts Payable Total Expenses 16 Unearned Revenue Net Income 17 Notes Payable 18 Salaries Payable 19 Interest Payable B Balance Sheet Income Statement Statement of Stockholders' Equity 0 Prepaid Rent Maintenance Expense Plus: Net Income 1 Equipment (Net) Insurance Expense Minus: Dividends 2 Total Assets Supplies Expense Ending Retained Earnings 3 Depreciation Expense 4 Liabilities Rent Expense Total Stockholders' Equity 5 Accounts Payable Total Expenses 6 Unearned Revenue Net Income 7 Notes Payable 8 Salaries Payable 9 Interest Payable CO Total Liabilities 1 Stockholders' Equity -2 Common Stock -3 Retained Earnings 4 Total Stockholders' Equity 5 Total Liabilities and Stockholders' Equity 3 5 6 Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustments in yellow boxes (using formulas Post adjustments to the Ledger for the corresponding year (using formulas) Prepare the following financial statements (using formulas) for the corresponding year: (a) Balance Sheet (b) Income Statement (c) Statement of Stockholders' Equity 7 A B El L N P S U w Y AA A AD AF A A AL AN AP Balance Sheet 1 2 Assets Liabilities Stockholder's Equity Accounts Receivable Prepaid Insurance Prepaid Rent Unearned Service Revenue Notes Payable Salaries Payable Accounts Payable Interest Payable Common Stock Retained Earnings Numbers! Account Title Enter Expenses as Positive Income Statement Date Amount Cash Equipment Supplies 3 Description 4 5 Beginning Balances, January 1st Year 2 Revenue Expense Net Income 15-Jan Paid employees for one month of work $ 32,959 6 32,959 32,959 1-Feb 177,244 7 177,244 15-Mar 42,114 8 Paid back the note payable in full, plus interest, at a rate of 10% Performed half of the services for customer who paid in advance Issued additional common stock in exchange for cash Collected cash from customers for services previously performed 20-Jun 17,496 9 26-Jul 93,603 10 16-Aug Performed services for cash 328,378 11 20-Sep Performed services on account 254,807 12 8-Oct 42,114 13 Performed remaining services for customer who paid in advance Paid for maintenance on equipment in cash 7-Nov 26,243 14 15-Dec Paid employee salaries 362,549 15 30-Dec Paid a cash dividend to owners of the business 5,859 16 Balance Sheet Assets Liabilities Stockholder's Equity Accounts Receivable Prepaid Insurance Prepaid Rent Accounts Payable Unearned Service Revenue Notes Payable Salaries Payable Interest Payable Common Stock Retained Earnings Number ! Account Title Enter Expenses as Positive Income Statement Date Description Amount Cash Supplies Equipment Revenue Expense Net Income Beginning Balances, January 1st Year 2 December 31st Adjustments: 7 a Remaining three months of one-year insurance policy were used up 8 A physical count of supplies at the end of b the year reveals all remaining supplies 9 were used The equipment is estimated to have a C useful life of five years with no salvage 0 value; depreciation must be recorded. The rented storage facility has been used 1 for twelve months Employees have worked for half a month e in the current year but won't be paid until 2 January 15. 3 4 Ending Balances, December 31st Year 2 5 6 7 8 Total Assets $ Total L&SE $ 0 Balance Sheet Income Statement Statement of Stockholders' Equity 3 4 5 Assets Service Revenue Beginning Common Stock 6 Cash Less: Expenses Plus: Stock Issued 7 Accounts Receivable Salaries Expense Ending Common Stock 8 Supplies Interest Expense 9 Prepaid Insurance Advertising Expense Beginning Retained Earnings 10 Prepaid Rent Maintenance Expense Plus: Net Income 11 Equipment (Net) Insurance Expense Minus: Dividends 12 Total Assets Supplies Expense Ending Retained Earnings 13 Depreciation Expense 14 Liabilities Rent Expense Total Stockholders' Equity 15 Accounts Payable Total Expenses 16 Unearned Revenue Net Income 17 Notes Payable 18 Salaries Payable 19 Interest Payable B Balance Sheet Income Statement Statement of Stockholders' Equity 0 Prepaid Rent Maintenance Expense Plus: Net Income 1 Equipment (Net) Insurance Expense Minus: Dividends 2 Total Assets Supplies Expense Ending Retained Earnings 3 Depreciation Expense 4 Liabilities Rent Expense Total Stockholders' Equity 5 Accounts Payable Total Expenses 6 Unearned Revenue Net Income 7 Notes Payable 8 Salaries Payable 9 Interest Payable CO Total Liabilities 1 Stockholders' Equity -2 Common Stock -3 Retained Earnings 4 Total Stockholders' Equity 5 Total Liabilities and Stockholders' Equity 3 5 6 Post transactions to the Ledger for the corresponding year (using formulas) Calculate amounts for December 31 adjustments in yellow boxes (using formulas Post adjustments to the Ledger for the corresponding year (using formulas) Prepare the following financial statements (using formulas) for the corresponding year: (a) Balance Sheet (b) Income Statement (c) Statement of Stockholders' Equity 7