Concept explainers
The general ledger of Jay Consulting shows the following balances at July 31:
Jay has asked you to develop a worksheet that will serve as a
Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, $17,731.
To test your model, use the following balances at August 31:
Print the worksheet when done. Check figure: Total debits, $18,810.
CHART (optional)
Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.
Prepare a trial balance in a worksheet for the month ended July 31, and August 31.
Explanation of Solution
Want to see more full solutions like this?
Chapter MB Solutions
Excel Applications for Accounting Principles
- Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.arrow_forwardHey there.The question is in the attached document. Can you please answer this question in a spreadsheet-like manner and show the formulas?It's only through the formulas that I can truly understand and learn from your work.Please note that the question has five subparts. If you want, please deduct five questions from my total amount of 30 questions to be asked.I am looking forward to hearing from you.arrow_forwardSolar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…arrow_forward
- Your company has loaned money to an outside entity. You earned the monthly interest on the loan but have not received the payment yet. The payment is expected to be received next month. To capture the interest expected to be received in the future, you have created account #901, Interest Receivable, in your chart of accounts and booked the journal entry to DR: Interest Receivable and CR: Interest Income. While the basic journal entry was correct, your manager is questioning how you set up this new account. What needs to be corrected in the chart of accounts shown below, and how would you fix it?arrow_forwardYour company has loaned money to an outside entity. You earned the monthly interest on the loan but have not received the payment yet. The payment is expected to be received next month. To capture the interest expected to be received in the future, you have created account #901, Interest Receivable, in your chart of accounts and booked the journal entry to DR: Interest Receivable and CR: Interest Income. While the basic journal entry was correct, your manager is questioning how you set up this new account. What needs to be corrected in the chart of accounts shown below, and how would you fix it? Teacher Feedback: Review the detail type and the account number.arrow_forwardThis problem is designed to enable you to apply the knowledge you have acquired in the preceding chapters. In accounting, the ultimate test is being able to handle data in real-life situations. This problem will give you valuable experience. CHART OF ACCOUNTS You are to record transactions in a two-column general journal. Assume that the fiscal period is one month. You will then be able to complete all of the steps in the accounting cycle. When you are analyzing the transactions, think them through by visualizing the T accounts or by writing them down on scratch paper. For unfamiliar types of transactions, specific instructions for recording them are included. However, reason them out for yourself as well. Check off each transaction as it is recorded. Required 1. Journalize the transactions. (Start on page 1 of the general journal if using Excel or Working Papers.) 2. Post the transactions to the ledger accounts. (Skip this step if using CLGL.) 3. Prepare a trial balance. (If using a work sheet, use the first two columns.) 4. Data for the adjustments are as follows: a. Insurance expired during the month, 1,020. b. Depreciation of building for the month, 480. c. Depreciation of pool/slide facility for the month, 675. d. Depreciation of pool furniture for the month, 220. e. Wages accrued at July 31, 920. Your instructor may want you to use a work sheet for these adjustments. 5. Journalize adjusting entries. 6. Post adjusting entries to the ledger accounts. (Skip this step if using CLGL.) 7. Prepare an adjusted trial balance. 8. Prepare the income statement. 9. Prepare the statement of owners equity. 10. Prepare the balance sheet. 11. Journalize closing entries. 12. Post closing entries to the ledger accounts. (Skip this step if using CLGL.) 13. Prepare a post-closing trial balance. Check Figure Trial balance total, 601,941; net income, 16,293; post-closing trial balance total, 569,614arrow_forward
- Create a two-variable data table as follows to provide the comparison that Liam requests: a)In cell A12, enter a formula without using a function that references the Monthly_Payment amount (cell D6) because Liam wants to compare the monthly payments. b) Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.arrow_forwardYour company has loaned money to an outside entity. You earned the monthly interest on the loan but did not receive the payment yet. The payment is expected to be received next month. To capture the interest expected to be received in the future you have created account #901 , Interest Receivable in your chart of accounts and booked the journal entry to DR: Interest Receivable and CR: Interest Income. While the basic journal entry was correct, your manager is questioning how you setup this new account. Based on this image of the chart of accounts below what needs to be corrected and how would you correct this?arrow_forwardFurther info is in the attached images For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50. Thank you!arrow_forward
- For the transaction below, determine which QuickBooks Online task is the most appropriate to record it. Select a task from the drop down list. Apr. 4: Purchase office supplies from The Office Store, for cash, $900. Review the source documents before answering. The most appropriate QuickBooks task isarrow_forwardThis problem is designed to enable you to apply the knowledge you have acquired in the preceding chapters. In accounting, the ultimate test is being able to handle data in real life situations. This problem will give you valuable experience. CHART OF ACCOUNTS You are to record transactions in a two-column general journal. Assume that the fiscal period is one month. You will then be able to complete all of the steps in the accounting cycle. When you are analyzing the transactions, think them through by visualizing the T accounts or by writing them down on scratch paper. For unfamiliar types of transactions, specific instructions for recording them are included. However, reason them out for yourself as well. Check off each transaction as it is recorded. Required 1. Journalize the transactions. (Start on page 1 of the general journal if using Excel or Working Papers.) 2. Post the transactions to the ledger accounts. (Skip this step if using CLGL.) 3. Prepare a trial balance. (If using a work sheet, use the first two columns.) 4. Data for the adjustments are as follows: a. Insurance expired during the month, 1,000. b. Depreciation of pool structure for the month, 715. c. Depreciation of fan system for the month, 260. d. Depreciation of sailboats for the month, 900. e. Wages accrued at June 30, 810. Your instructor may want you to use a work sheet for these adjustments. 5. Journalize adjusting entries. 6. Post adjusting entries to the ledger accounts. (Skip this step if using CLGL.) 7. Prepare an adjusted trial balance 8. Prepare the income statement 9. Prepare the statement of owners equity. 10. Prepare the balance sheet. 11. Journalize closing entries. 12. Post closing entries to the ledger accounts. (Skip this step if using CLGL.) 13. Prepare a post-dosing trial balance. Check Figure Trial balance total, 281,858; net income, 7,143; post-dosing trial balance total, 263,341arrow_forwardRequired: Record the payment that Mookie The Beagle Concierge receives from Sandy Copper in payment for services provided Remy. 1. Create Receive Payment. a. From the Navigation Bar, select Projects > Sandy Copper: Remy b. From the Add to project menu, select Receive payment c. Select Payment Date: 01/23/2023 d. Select Payment Method: Check e. Select Deposit to: 1600 Undeposited Funds f. Select Invoice Number 1002 g. After selecting the Invoice, what is the Amount Received displayed? Note: Answer this question in the table shown below. Round your answer 2 decimal places. h. Select Save and close Amount received $ 2. View the Transaction Journal for Receive Payment. a. From the Navigation Bar, select Sales > All Sales tab b. From the Sales Transactions List, select the Sandy Copper: Remy payment just entered c. From the bottom of Receive Payment, select More > Transaction Journal d. What are the Account and Amount Debited? Debit Credit 20.00 Note: Answer this question in the table shown…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub