Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
On April 1, 2020, these were the account balances of Ayala Architects Debit $ 23.125 Accumulated Depreciation $ 27.500 Accounts Receivable 6.700 Accounts Payable 3.200
On April 1, 2020, these were the account balances of Ayala Architects Debit $ 23.125 Accumulated Depreciation $ 27.500 Accounts Receivable 6.700 Accounts Payable 3.200 Common Stock 420.000 Building 420.000 Retained Earnings 5453075 $452.075 These selected events and transactions occurred in April. Apr.2 Bradley issued 18,000 shares of $1 par value common stock at par 5 Paid interest on loan for the month $900. 12 Purchased supplies for $1,300 on account. 16 Completed blueprints on a carport and billed client $1,900. 20 Received $2,800 cash for services completed and delivered to S. Melvin 25 Paid receptionist for the month, $1.500 28 Paid $675 on an account payable due. 29 Paid a $500 cash dividend. Ayala has these accounts in its chart of accounts: Cash, Accounts Receivable Supplies Building. Accumulated Depreciation, Accounts Payable, Salaries Payable. Common Stock Retained Earnings, Dividends, Income Summary, Service Revenue Interest Expense Salaries Expense, Supplies Expense, Depreciation Expense. Instructions: Perform the following steps on the Excel workbook 1. Journalize the month's transactions. You may amit journal entry descriptions 2. Post the month's journal entries to the general ledger. Omit post references Prepare an (unadjusted) trial balance on April 30. 4. Journalize and post the following adjusting entries for April: 1. Supplies remaining at the end of the month amounted to $2,900 2. Building depreciation is $2,600 per month 3. Ayala finished and delivered blueprints to another dient for a job totaling $7.900 4. Accrued salaries are $1.480. 5. Prepare an adjusted trial balance on April 30. column total = 483,380 6. Prepare financial statements: a income statement b. statement of stockholders' equity balance sheet 7. Journaline and post closing entries for April 8. Prepare a post-closing trial balance on April 30 9. Check ALL steps against the rubrice and make any necessary corrections. Do not sp "I did instructions through 3, but need help with adjusting the adjusted trial balance instruction 4) AYALA ARCHITECTS TRIAL BALANCE APRIL 30, 2020 Supplies Acumulated Depec Corrmen Stock Service Revenue Interest Expense 5. 6. 2. Building depreciation is $2,600 per month 3. Ayala finished and delivered blueprints to another client for a job totaling $7.900 4. Accrued salaries are $1,480. Prepare an adjusted trial balance on April 30. olumn totals 4 380 Prepare financial statements: a. income statement b. statement of stockholders' equity balance sheet Journalize and post closing entries for April Prepare a post-closing trial balance on April 30. Check ALL steps against the rubric and make any necessary corrections. Do not skip 7. 8. 9. *I did instructions 1 through 3, but need help with adjusting the adjusted trial balance instruction 14) AYALA ARCHITECTS TRIAL BALANCE APRIL 30, 2020 Supplies Building Common Stok Interest Expense Metained Earrings ADJUSTED TRIAL BALANCE APRIL 30, 2020 On April 1, 2020, these were the account balances of Ayala Architects. Debit Credit $ 27,500 Cash Accounts Receivable Supplies Building $ 23,175 6,700 3,200 420,000 $ 453,075 Accumulated Depreciation Accounts Payable Common Stock Retained Earnings 675 420,000 4,900 $ 453,075 These selected events and transactions occurred in April. Apr. 2 Bradley issued 18,000 shares of $1 par value common stock at par. 5 Paid interest on loan for the month, $900. 12 Purchased supplies for $1,300 on account. 16 Completed blueprints on a carport and billed client $1,900. 20 Received $2,800 cash for services completed and delivered to S. Melvin. 25 Paid receptionist for the month, $1,500. 28 Paid $675 on an account payable due. 29 Paid a $500 cash dividend. Ayala has these accounts in its chart of accounts: Cash, Accounts Receivable, Supplies, Building, Accumulated Depreciation, Accounts Payable, Salaries Payable, Common Stock. Retained Earnings, Dividends, Income Summary, Service Revenue, Interest Expense, Salaries Expense, Supplies Expense, Depreciation Expense. TITUL U TU Uului JCI VICE Revenue, IlleresL Expense, Salaries Expense, Supplies Expense, Depreciation Expense. Instructions: Perform the following steps on the Excel workbook. 1. Journalize the month's transactions. You may omit journal entry descriptions. Post the month's journal entries to the general ledger. Omit post references. Prepare an (unadjusted) trial balance on April 30. Journalize and post the following adjusting entries for April: 1. Supplies remaining at the end of the month amounted to $2,900. 2. Building depreciation is $2,600 per month. 3. Ayala finished and delivered blueprints to another client for a job totaling $7,900. 4. Accrued salaries are $1,480. Prepare an adjusted trial balance on April 30. (column totals = $488,380] Prepare financial statements: a. income statement b. statement of stockholders' equity c. balance sheet Journalize and post closing entries for April. Prepare a post-closing trial balance on April 30. 9. Check ALL steps against the rubric and make any necessary corrections. Do not skip 6 . Nooi *I did instructions 1 through 3, but need help with adjusting the adjusted trial balance (instruction #4)* AYALA ARCHITECTS TRIAL BALANCE APRIL 30, 2020 Debit Credit 40,400 8,600 4,500 420,000 Cash AIR Supplies Building Accumulated Depreciation A/P Dividends Common Stock Service Revenue Interest Expense Salaries Expense Retained Eamings 27,500 1,300 500 438,000 4,700 900 1,500 4,900 476,400 476,400 1,500 Salaries Expense Retained Eamings 4,900 476,400 476,400 ADJUSTED TRIAL BALANCE APRIL 30, 2020 Debit Credit
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f0ccf2b5_67666836f0c579ed.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f0d9b13a_67766836f0d110ed.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f0e7d029_67766836f0dc71ea.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f0f71f9b_67866836f0ebfa6c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f1074479_67966836f0fbcc28.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66836f1166613_68066836f10bc12c.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started