Myaccountinglab With Pearson Etext -- Access Card -- For Horngren's Accounting, The Managerial Chapters
12th Edition
ISBN: 9780134490663
Author: MILLER-NOBLES, Tracie L., Mattison, Brenda L., Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem P5.48CT
Using Excel to prepare a multi-step income statement.
Download an Excel template for this problem online in My Accounting Lab or at htt://www.pearsonhighered.com/Horngren.
Cougar Mountain Sports has prepared an adjusted
Notes to the adjusted trial balance are located below the totals.
Use the blue shaded areas on the income statement worksheet for inputs.
Requirements:
- Use Excel to prepare a multi-step income statement based on the adjusted trial balance.
- Use formulas to link the balances on the adjusted trial balance to the amounts on the income statement. Note that some balances are split between two different areas of the Income Statement. For example. The Rent Expense is divided into two categories-Selling and administrative.
- Use a formula to add and subtract account amounts as indicated.
- Format the numbers in the dollar columns with a comma and no decimal places (e.g.5, 460) Use a dollar sign at the top of each column and at the total (e.g. $ 26,201). Make sure the decimal places align.
- Double-underline the total.
- Compute the gross profit margin percentage. Format percentages to two decimal places (e.g. 22.74%).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Accounts Receivable
$160,250
Accumulated Depreciation-Building
783,500
Administrative Expenses
524,850
Building
2,563,700
Cash
184,450
Common Stock
306,600
Cost of Goods Sold
3,721,950
Dividends
185,600
Interest Expense
9,550
Inventory
1,005,950
Notes Payable
254,900
Office Supplies
20,800
Retained Earnings
1,324,350
Salaries Payable
8,100
Sales
6,255,450
Selling Expenses
692,550
Store Supplies
89,550
Select the letter of the item below that best matches the definitions that follow.
a. Balance Sheet Standard report.
b. To date
c. Summary Balance Sheet report
d. QuickZoom
e. Transactions by Account report
f. % of Column
g. Memorizing a report
h. Divided by 1000
1. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to add a column representing the percentage of each item compared to total assets.
2. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to round amounts to the nearest whole dollar.
3. ________ The start of the reporting period.
4. ________ A financial statement reporting in detail the assets, liabilities, and equities of a business as of a certain date.
5. ________ A process by which modified reports are saved for later use.
6. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands.
7. ________ The end…
I included the definition and the the second picture is the words to choose from. Just match the one that correlates to the definition.
Chapter 5 Solutions
Myaccountinglab With Pearson Etext -- Access Card -- For Horngren's Accounting, The Managerial Chapters
Ch. 5 - Which account does a merchandiser use that a...Ch. 5 - 2. The two main inventory accounting system are...Ch. 5 - The journal entry for the purchase of inventory on...Ch. 5 - JC manufacturing purchased inventory for $5,300...Ch. 5 - Austin sold inventory for $2/10, n/30. Cost of...Ch. 5 - Prob. 6QCCh. 5 - Which of the following accounts would be closed at...Ch. 5 - What is the order of the subtotals that appear on...Ch. 5 - Assume Juniper Natural Dyes made Net Sales Revenue...Ch. 5 - Prob. 10AQC
Ch. 5 - (
11B_ The journal entry for the purchase of...Ch. 5 - Prob. 1RQCh. 5 - Prob. 2RQCh. 5 - Describe the operating cycle of a merchandiser.Ch. 5 - What is Cost of Goods (COGS), and where is it...Ch. 5 - How is gross profit calculated, and what does it...Ch. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - 8. What account is debited when recording a...Ch. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - 17. What is freight out and how is it recorded by...Ch. 5 - Prob. 18RQCh. 5 - Prob. 19RQCh. 5 - Prob. 20RQCh. 5 - Prob. 21RQCh. 5 - What financial statement is merchandise inventory...Ch. 5 - Prob. 23RQCh. 5 - Prob. 24ARQCh. 5 - Prob. 25BRQCh. 5 - Prob. 26BRQCh. 5 - Prob. 27BRQCh. 5 - Prob. 28BRQCh. 5 - Prob. 29BRQCh. 5 - Prob. 30BRQCh. 5 - Prob. 31BRQCh. 5 - Comparing periodic and perpetual inventory systems...Ch. 5 - Journalizing purchase transactions Learning...Ch. 5 - Prob. S5.3SECh. 5 - Journalizing sales transactions Learning Objective...Ch. 5 - Estimating sales returns Learning Objective 3 On...Ch. 5 - Journalizing purchase and sales transactions...Ch. 5 - Journalizing purchase and sales transactions...Ch. 5 - Adjusting for inventory shrinkage Learning...Ch. 5 - ournalizing closing entries Learning Objective 4...Ch. 5 - Preparing a merchandiser’s income statement...Ch. 5 - Preparing a merchandiser’s statement of owner’s...Ch. 5 - Computing the gross profit percentage Learning...Ch. 5 - Prob. S5A.13SECh. 5 - Journalizing purchase transactions—periodic...Ch. 5 - Journalizing sales transactions—periodic inventory...Ch. 5 - Journalizing closing entries-periodic inventory...Ch. 5 - Computing cost of goods sold in a periodic...Ch. 5 - E5-18 Using accounting vocabulary Learning...Ch. 5 - Prob. E5.19ECh. 5 - Howie Jewelers had the following purchase...Ch. 5 - E5-21 Journalizing sales transactions Learning...Ch. 5 - Journalizing purchase and sales transactions...Ch. 5 - Journalizing closing entries Learning Objective 4...Ch. 5 - Preparing a single-step income statement Learning...Ch. 5 - Preparing a multi-step income statement. Learning...Ch. 5 - Journalizing adjusting entries including estimate...Ch. 5 - Prob. E5.27ECh. 5 - Journalizing multiple performance obligations and...Ch. 5 - Prob. E5B.29ECh. 5 - Prob. E5B.30ECh. 5 - Prob. E5B.31ECh. 5 - Prob. E5B.32ECh. 5 - Prob. E5B.33ECh. 5 - Prob. P5.34APGACh. 5 - Journalizing purchase and sale transaction...Ch. 5 - P5-36A Preparing a multi-step income statement,...Ch. 5 - Journalizing adjusting entries, preparing adjusted...Ch. 5 - Preparing Single-Step income statement, preparing...Ch. 5 - Journalizing purchase and sale...Ch. 5 - Preparing a multi-step income statement and...Ch. 5 - Journalizing purchase and sale transaction...Ch. 5 - Prob. P5.42BPGBCh. 5 - Prob. P5.43BPGBCh. 5 - Prob. P5.44BPGBCh. 5 - Prob. P5.45BPGBCh. 5 - Journalizing purchase and sale transation-periddic...Ch. 5 - Preparing a multi-step income statement and...Ch. 5 - Using Excel to prepare a multi-step income...Ch. 5 - Journalizing and posting purchase and sale...Ch. 5 - Prob. P5.50CP2Ch. 5 - Prob. P5.51PSCh. 5 - Tying It All Together Case 5-1 Before you begin...Ch. 5 - Prob. 5.1DCCh. 5 - Prob. 5.1EICh. 5 - Prob. 5.1FCCh. 5 - Financial Statement Case 51 This cause uses both...
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
- 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 trial balance (file name PTB). Use the data provided as input for your model. 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.arrow_forwardClick the Chart sheet tab. This chart is based on the problem data and the two income statements. Answer the following questions about the chart: a. What is the title for the X-axis? b. What is the title for the Y-axis? c. What does data range A represent? d. What does data range B represent? e. Why do the two data ranges cross? f. What would be a good title for this chart? When the assignment is complete, close the file without saving it again. Worksheet. The VARCOST2 worksheet is capable of calculating variable and absorption income when unit sales are equal to or less than production. An equally common situation (that this worksheet cannot handle) is when beginning inventory is present and sales volume exceeds production volume. Revise the worksheet Data Section to include: Also, change actual production to 70,000. Revise the Answer Section to accommodate this new data. Assume that Anderjak uses the weighted-average costing method for inventory. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as VARCOSTT. Check figure: Absorption income, 670,000. Chart. Using the VARCOST2 file, fix up the chart used in requirement 5 by adding appropriate titles and legends and formatting the X- and Y-axes. Enter your name somewhere on the chart. Save the file again as VARCOST2. Print the chart.arrow_forwardPlease analyze, assess, and synthesize the Annual Report or Form 10-K or Form 20 - F (whatever they call it in that jurisdiction) of the company you choose. You can usually find it on the Company's website in Investor R. Introduction 2. Industry situation and company plans A. Management Letter B. B. Review Company's Products and Services 3. Financial Statements A. Income Statement B. Cash Flow Statement C. Balance Sheet D. Accounting Policies 4. Financial Analysis & Ratio A. Financial Analysis B. Ratio C. Market Indicator Financial Ratios 5. References 6. Complete Calcuation of Part 4 in excelLimiarrow_forward
- After completing your first degree in accounting you have been employed by XYZ Company as an account officer. The Management of the company has tasked you to implement a computerized accounting system.RequiredIn a paragraph each, address the following questions:a) Discuss five benefits associated with the implementation of the computerizedaccounting system within the company.b) Giventhattherearesomanyaccountingpackagesonthemarket,whatshouldyoube looking for when selecting a computerized accounting package for the company?Explain any five factors to considerc) Assuming you procure a Sales Ledger package, what kind of reports should weexpect? List five types of reports expected to be generated.d) Explainthedifferencebetweenastand-alonepackageandanintegratedpackage?Explain two advantaged and two disadvantages of an integrated packagee) Before a new accounting package can be deployed, it needs to be configured. What does it mean to configure an accounting package? Explain the processes…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_forwardAfter completing the preparation, the necessary credit adjustments are made to adjust the balances of the accounts shown in * the balance with a view to Photographing the compang's general profit and loss accounts and photographing the balance sheet Balance Sheet - Asset Side circulated Profit and loss account on the revenue side Administrative expenses statementarrow_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,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_forwardYour Task… Using your assigned financial statements calculate the required ratios below Indicate if the change from year to year is favorable or unfavorable. All values should be accurate to at least two decimal places. The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer. All calculations are to be represented. Analysis of Profitability Gross Profit Ratio Operating Profit Ratio Net Profit Ratio Sales to Total Assets Ratio Return on Total Assets Return on Equity Earnings Per Sharearrow_forwardCould you help me with this simulation I have attached both images?arrow_forward
- The Steps in Preparing a Worksheet Put the steps in the correct order that the worksheet is prepared. 1. [ Choose ] [Choose] Enter adjustment data. Enter adjusted balances. Total the statements columns, computer net income/(loss), and complete the worksheet. Prepare a trial balance on the worksheet. Extended adjusted balances to appropriate statement columns. (Choose 3 [ Choose ) (Choose ] 2.arrow_forwardAdditional Activities Directions: Do the task listed bélow using the transacions of Matapang Company for Deccmber 2019. Writc your answers on a separate sheet of paper. 1. Prepare the journal entries. 2. Post each transaction to its ledger account. 3. Prepare the trial balance. 4. Use the provided account numbers. Ralph Matapang cstablishcd Happy Repair Busincss. The following are the transactions for the montb of Decembocr 2019. Dec. He invested P150,000 in the firm. He paid P8,000 for monthly rent. He bought supplies on account amounting to P7,200. He purchascd office equipment amounting to P75,000. paid P37,000 and the balance on account. 2. 2. 3. He paid accounts payable for supplies purchased worth P7,200. He paid P6,000 for the salary of an employec. He received P20,000 for services rendered. He billed clients P48,000 for services on account. 8. 14. 20. 28. 31. Matapang withdrew P12,000 for his personal use. 302 Matapang, Drawings 401 Service Revenue 101 Cash 102 Accounts…arrow_forwardHello accounting tutors. Can you help me to answer this?. kindly see the attached image below or this link >> https://drive.google.com/file/d/1D4KNMJHHVMxVKdYvbABzQLTSijz2ZU9m/viewarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
College Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License