Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter MB, Problem 1M
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.
Expert Solution & Answer
To determine
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?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence.
Greg has been making regular monthly payments of $425 into an account for 15 years, and he now has $96,000. What is the annual interest rate of his account?
N=180 I= ? PV=96,000 PMT= 425 FV= ? P/Y= 12 C/Y=12
Missing Variable Value __________________
Context Sentence:
A table of data for a library is shown in the table. Normalize these data into the third normal form, preparing it for use in a relational database environment. The library’s computer is programmed to compute the due date to be 14 days after the checkout date. Document the steps necessary to normalize the data similar to the procedures found in the chapter. Index any fields necessary and show how the databases are related.
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.
Chapter MB Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- I have attached the images with the information needed for the question. The question is located in the second image. I have attempted to fill it out, but I am unsure if I am correct or not. Thank you for your help.arrow_forwardMake first a proper Chart of Accounts. Then make a proper Trial Balance from the following accounts and balances listed in alphabetical order for MN Company for August 31 of the current year. Put them in the correct order along with their debit and credit balances on your Trial Balance. Total the DR and CR column and make sure they balance. Make sure you have a heading. We will work on this in class. Upload here on D2L if you are not yet finished in class. Accounts Payable $2300, Accounts Receivable $1200, Accumulated Depreciation-Equipment $800, Advertising Expense $200, Cash $3400, Equipment $12,500, Furniture and Fixtures $6700, MN, Capital, $6500, MN, Drawing $500, Notes Payable $8000, Prepaid Insurance $1200, Professional Fees $10,000, Rent Expense $500, Supplies $100, Utilities Expense $300, Wages Expense $1000.arrow_forwardshow calculations where neededarrow_forward
- This 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_forwardCreate 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_forwardIn this homework assignment you will develop a simplified four-column ledger account system for a local bank. A four-column ledger account form has spaces to enter the account name, the account number, the date, a description of the entry, and the posting reference. It also has four columns in which to record dollar amounts: Debit, Credit, Debit Balance, and Credit Balance. A simplified four-column ledger would have the account name and number, date of transaction and the four columns.arrow_forward
- Your 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_forwardOpen the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.arrow_forwardPlease see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.arrow_forward
- Dinesh bhaiarrow_forwardPart of your job is to review customer requests for credit. You have three new credit applications on your desk and part of your analysis requires that the current ratlos and quick ratlos be compared.arrow_forwardPlease verify that all June 1 balances are in the ledgers by comparing them to the May 31, 2021 trial balance before posting. There are two tabs in the Excel spreadsheet: Income Statement Accounts and Balance Sheet Accounts. You will need both tabs to post to all the accounts. Use the given information from the General Journal below to fill in the Ledger for the balance sheet and income statement account sheets through the month of June. General Journal Date Description Post Ref. Debit Credit June 3 Inventory 116 50,400 Accounts Payable 210 50,400 June 6 Accounts Receivable 111 17,400 Sales 410 17,400 Costs Of Goods Sold 510 12,000 Inventory 116 12,000 June 8 Notes Receivable 114 500 Bad Debt Expense 522 500 June 10 Cash 104 40,000 Salaries Payable 211 40,000 Cash 104 26,000 Office Salaries Expense…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License