Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents have asked these similar questions
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…
The accountant wishes you to provide an analysis of the company’s annual operating expenses. Add an extra worksheet called “Expense analysis”, and add your 20Y3 data next to the given 20Y2 data.
You must link this new Expense Analysis table/worksheet (relevant cells in column “E”) with the respective data from your 20Y3 income statement. Do not hard code the 20Y3 data. Use appropriate formula to calculate the total expenses in cell E10, E12 and percentages in column F and G.
Question-Specific Notes:
you are given a role in a scenario, that of preparing an income statement for DL Enterprises for the month ending July 31, 20X8. The DL Enterprises info below may help you with the task of categorizing items.
QUESTION:
For each independent situation below calculate the missing values
Chapter 5 Solutions
Horngren's Accounting (12th Edition)
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
- Review the PetMed Express and create an Excel table updating exhibit 2 and create a bar chart for key data. Information can be obtained from the company's annual report.arrow_forwardThe 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_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_forward
- use the transaction information to create a Accrual-Based Income Statement for January using the following template. Please answer completely and correctly with explanation computation formula steps answer in text no copy paste show explanation and computation clearly for numbers provide full working for all steps with explanation answer in text formarrow_forwardInsert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors. Thom-Pierre Consultants (TPC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold 460,000 **Selling and admin administrative 195,000 ***Computer (operating) **Depreciation 55,000 **Interest expense 25,200 Total expenses and losses Income before taxes Income tax expense (30%) Net Incomearrow_forwardUse the following information to answer Exercises E5-23 through E5-25. The adjusted trial balance of Quality Office Systems at March 31, 2018, follows: Preparing a single-step income statement Prepare Quality Office’s single-step income statement for the year ended March 31, 2018.arrow_forward
- Use the following information to answer Exercises E5-23 through E5-25. The adjusted trial balance of Quality Office Systems at March 31, 2018, follows: Preparing a multi-step income statement Prepare Quality Office’s multi-step income statement for the year ended March 31, 2018.arrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the courses. Comment on how your analysis has changed for each course. B. Perform a vertical analysis for each course. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explainarrow_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_forward
- Select 30 transactions of various kinds such as sales, costs (direct and indirect), revenues earned, revenue received in advance, expenses incurred, paid in advance, outstanding expenses, assets (current, non-current), liabilities (current, long term), Equity and so on.1. Record those transactions in journal,2. post them to ledger,3. Transfer the balances in trail balance,4. Prepare income statement and balance sheet.5. Follow the proper format considering IAS-1.6. Explanation: At the end, apply the concepts such as long term assets, capital or revenueincomes or expenses and their treatment involved in your above requirements Transactions of Mr. Akram travel world business Mr Akram started business with cash for rs 400,000. Paid wages rs 20,000. Paid office rent in advance 2000. Paid rs 10000 for insurance in advance. Babar and sons paid 2500 for goods on advance. Purchased office equipment on credit rs 5000. Paid 7000 for advertising expenses. Paid 3000 to accounts payable. Provided…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_forwardUse the following information to answer Exercises E1-31 through E1-33. The account balances of Wilson Towing Service at June 30, 2018, Follow: Preparing the income statement Requirements Prepare the income statement for Wilson Towing Service for the month ending June 30, 2018. What does the income statement report?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 LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License