here is the excel spreadsheet. questions come from fundamentals of financial accounting fourth edition mcgraw-hill irwin
maddogmania
unit_4_homework_template_acc111_1.xlsxM4-18
| M4-18 | SOLUTIONS! | |||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | |||||
| DB | CR | |||||
M4-19
| M4-19 | SOLUTIONS! | ||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | ||||
| DB | CR | ||||
M4-20
| M4-20 | SOLUTIONS! | |||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | |||||
| SOLUTIONS! | ||||||
| DB | CR | |||||
M4-21
| M4-21 | SOLUTIONS! | |||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | |||||
| DB | CR | |||||
M4-22
| M4-22 | SOLUTIONS! | ||||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | ||||||
| DB | CR | ||||||
M4-23
| M4-23 | SOLUTIONS! | |||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | |||||
| DB | CR | |||||
M4-24
| M4-24 | SOLUTIONS! | |||||
| SOLUTIONS! | Preparing and Posting Adjusting Entries | |||||
| DB | CR | |||||
E4-16
| E4-16 | SOLUTIONS! | |
| SOLUTIONS! | Recording Four Adjusting Journal Entries and Preparing as Adjusted Trial Balance | |
| Preparing Journal Entries | ||
E4-16 T-accounts
| E4-16 T-accounts | SOLUTIONS! | |||||||
| SOLUTIONS! | ||||||||
| Cash | Accounts Receivable | Prepaid Insurance | ||||||
| Equipment | Accumulated Depreciation | Accounts Payable | ||||||
| Total | ||||||||
| Retained Earnings | Sales Revenue | Administrative Expenses | ||||||
| Total | Total | Total | ||||||
| Wages Payable | Income Tax Payable | Contributed Capital | ||||||
| Total | Total | Total | ||||||
| Retained Earnings | Sales Revenue | Administrative Expenses | ||||||
| Total | Total | Total | ||||||
| Wages Expense | Depreciation Expense | Insurance Expense | ||||||
| Total | Total | Total | ||||||
| Income Tax Expense | ||||||||
| Total |
E4-16 Adjusted TB
| MINT CLEANING | ||
| Adjusted Trial Balance | ||
| December 31 20XX | ||
| (in thousands of dollars) | ||
| Debit | Credit | |
| Cash | ||
| Accounts Receivable | ||
| Prepaid Insurance | ||
| Equipment | ||
| Accumulated Depreciation | ||
| Accounts Payable | ||
| Wages Payable | ||
| Income Tax Payable | ||
| Contributed Capital | ||
| Retained Earnings | ||
| Sales Revenue | ||
| Administrative Expenses | ||
| Wages Expense | ||
| Depreciation Expense | ||
| Insurance Expense | ||
| Income Tax Expense | ||
| Totals | ||
| Part 3 |
E4-17
| E4-17 | SOLUTIONS! | ||||||||||||||
| SOLUTIONS! | Reporting an Income Statement, Statement of Retained Earnings, and Balance Sheet | ||||||||||||||
| MINT CLEANING INC | MINT CLEANING INC | ||||||||||||||
| Income Statement | Statement of Retained Earnings | ||||||||||||||
| For the Year Ending December 31, 20XX | For the Year Ending December 31, 20XX | ||||||||||||||
| Amount | Amount | ||||||||||||||
| Sales Revenue | Beginning Balance, 1/1/10 | ||||||||||||||
| Add: Net Income | |||||||||||||||
| Administrative Expenses | Subtract: Dividends Declared | ||||||||||||||
| Wages Expense | Ending Balance, 12/31/10 | ||||||||||||||
| Depreciation Expense | |||||||||||||||
| Insurance Expense | |||||||||||||||
| Income Tax Expense | |||||||||||||||
| Total Expenses | |||||||||||||||
| Net Income | |||||||||||||||
| MINT CLEANING INC | |||||||||||||||
| Balance Sheet | |||||||||||||||
| For the Year Ending December 31, 20XX | |||||||||||||||
| Assets | Amount | Liabilities | Amount | ||||||||||||
| Cash | Accounts Payable | ||||||||||||||
| Accounts Receivable | Wages Payable | ||||||||||||||
| Prepaid Insurance | Income Tax Payable | ||||||||||||||
| Machinery | Total Liabilites | ||||||||||||||
| Accumulated Depreciation | |||||||||||||||
| Machinery, NET | Stockholders' Equity | ||||||||||||||
| Contributed Capital | |||||||||||||||
| Retained Earnings | |||||||||||||||
| Total Liabilites and Stockholders' | |||||||||||||||
| Total Assets | Equity | ||||||||||||||
E4-18
| E4-18 | SOLUTIONS! | ||||
| SOLUTIONS! | Recording Closing Entries | ||||
| Preparing Journal Entries | |||||
| DB | CR | ||||
