1 2 3 Use the information provided below to complete the related Financial Statements. Remember: Use the power of Excel to reference the account names & amounts within each of the statements, as well as to calculate subtotals and totals. Copying/pasting or typing directly into the cells will not earn full credit! Balance Accounts Receivable $22,000 Retained Earnings, Start of Year $186,000 $48,000 Account Name 4 S 6 Inventory Interest Expense Land 7 8 9 Accounts Payable 10 Sales Revenue 11 Cash 12 Payroll Expense 13 Contributed Capital 14 Loan Payable 15 Cost of Goods Sold 16 17 18 19 Dividends Retained Earnings, End of Year $10,500 $127,000 $18,000 $275,000 $194,000 $76,000 $139,500 $54,000 $144,000 $51,000 Assets Cash Total Assets Liabilities Balance Sheet Total Liabilities Stockholder's Equity Total Stockholder's Equity Total Liabilities & Stockholder's Equity $194,000 Revenues Total Revenue Expenses Total Expenses Net Income Income Statement Statement of Retained Earnings Retained Earnings, Start of Year Net Income Dividends Retained Earnings, End of Year