Complete the following problem in Excel. Use a different tab for each financial statement. A. Calculate the ending balance for each account. (The area shaded in yellow) B. Create the income statement. C. Create the statement of owner's equity. D. Create the balance sheet. Assets Liabilities Owner's Equity Inventory Equipment Accounts Payable Cash Wages Рayable Common Retained Stock Earnings $50,000 (6,000) 50,000 6,000 22,000 22,000 1,250 (750) 1,250 (750) (600) (3,000) 3,200 (175) 600 3,000 3,200 175 (1,000) 1,000

Complete the following problem in Excel. Use a different tab for each financial statement. A. Calculate the ending balance for each account. (The area shaded in yellow) B. Create the income statement. C. Create the statement of owner's equity. D. Create the balance sheet. Assets Liabilities Owner's Equity Inventory Equipment Accounts Payable Cash Wages Рayable Common Retained Stock Earnings $50,000 (6,000) 50,000 6,000 22,000 22,000 1,250 (750) 1,250 (750) (600) (3,000) 3,200 (175) 600 3,000 3,200 175 (1,000) 1,000

Name: Complete the following problem in Excel. Use a different tab for each
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: Complete the following problem in Excel. Use a different tab for each financialstatement.A. Calculate the ending balance for each account.(The area shaded in yellow)B. Create the income statement.C. Create the statement of owner's equity.D. Create t

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Dakota Company experienced the following events during Year 2. 1. Acquired $20,000 cash from the issue of common stock. 2. Paid $25,000 cash to purchase land. 3. Borrowed $10,000 cash. 4. Provided services for $50,000 cash. 5. Paid $1,500 cash for utilities expense. 6. Paid $35,500 cash for other operating expenses. 7. Paid a $5,000 cash dividend to the stockholders. 8. Determined that the market value of the land purchased in Event 2 is now $28,000. Required a. The January 1, Year 2, general ledger account balances are shown in the following accounting equation. Record the eight events in the appropriate general ledger accounts. Record the amounts of revenue, expense, and dividends in the Retained Earnings column. Provide the appropriate titles for these accounts in the last column of the table. The first event is shown as an example. b-1. Prepare an income statement for the Year 2 accounting period. b-2. Prepare a statement of changes in equity for the Year 2 accounting period. b-3.…
Build a T-account for each part of the expanded accounting equation. (1) Drag the debit "DR" and credit "CR" labels to the appropriate sides of the T-account. (2) Drag the normal balance label to the correct side of the T- account. (3) Label which side of the t-account increases "+" and decreases "" that account. view drag.and drop keyboard instructions Debit Normal Credit Balance Land Common Stock Dividends Depreciation Expense- Equipmerit Unearnied Revenue Service Revenue
23. Prepare closing entries rom the following end-of period spreadsheet. Austin Entergrises Fadof Peried Spreadsheet For the Year Eaded December JI Adnted Trial Balance Credit Income Statement Debt Balance Sheet Deb 26.500 7000 Account Titie Crede Debit Crede 26,500 7,000 1,000 18300 Cash Accounts Receivable Supplies Equipment Accumalated Depr 18.500 5.000 5.000 Accoures Payabie Wages Payable Common Stock Retained arnings Dividends Eees Earmed Wages Eapense Rest Esgeme Depreciation Eapense Toals Net omeLo) 11,000 100 6.000 2.000 1000 1,000 6.000 2.000 2.000 2,000 59.500 59.500 19,000 7.000 3.00 19000 7000 3.300 .500 .500 29,500 20.0 59.500 5.000 25,000 20.000
! Required information [The following information applies to the questions displayed below.] The general ledger of Zips Storage at January 1, 2024, includes the following account balances: Accounts Cash Accounts Receivable Prepaid Insurance Land Accounts Payable Deferred Revenue Common Stock Retained Earnings Debits $25,400 Credits 16,200 13,600 156,000 $7,500 6,600 151,000 46,100 Totals $211,200 $211,200 The following is a summary of the transactions for the year: 1. January 9 2. February 12 3. April 25 4. May 6 5. July 15 6. September 10 7. October 31 8. November 20 9. December 30 Provide storage services for cash, $142,100, and on account, $56,200. Collect on accounts receivable, $52,300. Receive cash in advance from customers, $13,700. Purchase supplies on account, $10,800. Pay property taxes, $9,300. Pay on accounts payable, $12,200. Pay salaries, $131,600. Issue shares of common stock in exchange for $35,000 cash. Pay $3,600 cash dividends to stockholders. 1. 3. 6. & 10. Post the…
Use the May 31 fiscal year-end information from the following ledger accounts (assume that all accounts have normal balances). M. Muncel, Capital Dated May 31 M. Muncel, Withdrawals Date May 31 Services Revenue Date May 31 Depreciation Expense Date May 31 PR G2 PR G2 PR G2 PR G2 Debit Debit Debit Debit General Ledger Account Number 301 Salaries Expense Credit Balance 84,000 Account Number 302 Credit Balance 50,000 Account Number 403 Credit Balance 148,008 Account Number 603 Credit Balance 15,000 Date May 31 Insurance Expense Date May 31 Rent Expense Date May 31 Income Summary Date PR G2 PR G2 PR G2 PR Debit Debit Debit Debit Account Number 622 Credit Balance 42,000 Account Number 637 Credit Balance 3,900 Account Number 640 Credit Balance 8,400 Account Number 901 Balance Credit (a) Prepare closing journal entries from the above ledger accounts. (b) Post the entries from Requirement (a) to the General Ledger accounts below. Use the transaction number from Requirement (a) as the date.
Please do not give image format
Prepare the second closing entry by selecting the account names from the pull-down menus and entering dollar amounts in the debit and credit columns.
The account balances of Awesome Travel Services at December 31 are listed below. There were no additional investments or dividends by Awesome Travel Services during the year. Accounts Amount Accounts Amount Accounts payable $12,000 Retained earnings (Jan. 1) $6,000 Accounts receivable 14,000 Supplies 1,000 Cash 18,000 Income taxes expense 1,300 Common stock 4,000 Utilities expense 8,000 Computer equipment 21,000 Wages expense 25,000 Fees earned 78,000 Supplies expense 1,700 Rent expense 10,000 Required: Prepare an income statement, a statement of stockholder's equity, and a balance sheet as of December 31. Refer to the lists of Accounts in the information given, Labels, and Amount Descriptions for the exact wording of the answer choices for text entries. You will not need to enter colons (:) on the financial statements. Be sure to complete the statement heading.
A company provides services to customers on account for $2,100. Indicate the amount of increases and decreases in the accounting equation. Assets Liabilities Stockholders' Equity + 4) 44 F10 F7 20 F3 F5 F2 F1 & # 3 4 5 6 7 8 Q W E R T Y K S D F G C V alt alt command option ption command .. .. * co
Use the following T-accounts to prepare the four journal entries required to close the books: T-Accounts. Accounts Receivable debit balance 45,500. Fees Earned Revenue credit balance 60,000. Commission expense debit balance 7,200. Supplies Expense debit balance 5,500. Wages Expense debit balance 42,000. Dividends debit balance 3,500. Retained Earnings credit balance 51,000.
Use the following T-accounts: Accounts Receivable Bal. 46,500 Fees Earned Revenue Bal. 63,000 Commission Expense Bal. 7,500 Supplies Expense Bal. 5,900 Wages Expense Bal. 47,000 Dividends Bal. 3,800 Retained Earnings Bal. 54,000 Prepare the four journal entries required to close the books. If an amount box does not require an entry, leave it blank.