Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter D, Problem 22E
To determine
Prepare the condensed
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Huluduey Corporation's comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 2012 Dec. 31, 20Y1 $12,700 $12,400 59,500 60,200 28,600 28,300 28,000 26,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Accounts receivable Inventory Accounts payable Dividends payable X Open spreadsheet Adjust net income of $120,100 for changes in operating assets and liabilities to arrive at net cash flows from operating activities. 120,300 X Feedback Check My Work Once you have calculated the changes in the current operating assets and liabilities determine what impact those changes would have on cash. For example if accounts receivable has increased from last year to this year does that mean the company has collected more cash or less cash? If accounts payable has decreased does that mean the company has more cash or less cash?
Prepare a Balance Sheet using the following information for the Ginger Company as of March 31, 2019. When listing accounts for each category, you are to insert them in the order in which they are listed here. If used, type in the account names exactly as
written here.
Account
Normal Balances
Accounts Payable
$1,730
Cash
$11,050
Ginger Ale, Capital March 1
$17,300
Inventory
$8,230
Wages Payable
$2,150
Sales
$13,600
Product Expenses
$8,200
Ginger Ale, Capital March 31
$22,700
Equipment
$7,300
PLEASE NOTE:
When you fill in the dollar amounts, you must include a $ and commas as needed (i.e., $1,234).
Assets:
Total Assets
Liabilities:
Total Liabilities
Owner's Equity:
Total Liabilities and Owner's Equity
Using EDGAR (Electronic Data Gathering, Analysis, and Retrieval system), find the annual report (10-K) for Coca-Cola and PepsiCo fo the year ended December 2019. Locate the "Consolidated Statements of Income" (income statement) and "Consolidated Balance Sheets." You may also find the annual reports at the companies' websites. Required:
1. For each company, calculate the gross profit ratio, inventory turnover ratio, and average days in inventory.
2. Compare the management of each company's investment in inventory. Which company is more profitable and which company sells its inventory more quickly based on the ratios calculated in Requirement 1?
Chapter D Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. D - Prob. 1TICh. D - Prob. 2TICh. D - Prob. 3TICh. D - Prob. 4TICh. D - Prob. 5TICh. D - Prob. 6TICh. D - Prob. 7TICh. D - Prob. 8TICh. D - Prob. 9TICh. D - Prob. 10TI
Ch. D - Prob. 1QCCh. D - Prob. 2QCCh. D - Vertical analysis of Libertys balance sheet for...Ch. D - Prob. 4QCCh. D - Libertys inventory turnover during 2019 was...Ch. D - Prob. 6QCCh. D - Prob. 7QCCh. D - Prob. 8QCCh. D - Prob. 9QCCh. D - Prob. 10QCCh. D - Prob. 1RQCh. D - Prob. 2RQCh. D - Prob. 3RQCh. D - Prob. 4RQCh. D - Prob. 5RQCh. D - Prob. 6RQCh. D - Prob. 7RQCh. D - Prob. 8RQCh. D - Prob. 9RQCh. D - Prob. 10RQCh. D - Prob. 11RQCh. D - Prob. 12RQCh. D - Prob. 13RQCh. D - Prob. 1SECh. D - Verifine Corp. reported the following on its...Ch. D - Prob. 3SECh. D - Prob. 4SECh. D - Prob. 5SECh. D - Prob. 6SECh. D - Prob. 7SECh. D - Accels Companies, a home improvement store chain,...Ch. D - Prob. 9SECh. D - Prob. 10SECh. D - Prob. 11SECh. D - Prob. 12SECh. D - Prob. 13ECh. D - Prob. 14ECh. D - Prob. 15ECh. D - Refer to the data presented for Mulberry Designs,...Ch. D - Prob. 17ECh. D - Prob. 18ECh. D - Prob. 19ECh. D - Micatin, Inc.s comparative income statement...Ch. D - Prob. 21ECh. D - Prob. 22ECh. D - Prob. 23APCh. D - Prob. 24APCh. D - Prob. 25APCh. D - Prob. 26APCh. D - Comparative financial statement data of Sanfield,...Ch. D - Prob. 28APCh. D - Prob. 29APCh. D - Prob. 30BPCh. D - Prob. 31BPCh. D - Prob. 32BPCh. D - Prob. 33BPCh. D - Prob. 34BPCh. D - Prob. 35BPCh. D - In its annual report, XYZ Athletic Supply, Inc....Ch. D - Prob. 38PCh. D - Lance Berkman is the controller of Saturn, a dance...Ch. D - Prob. 1EICh. D - Prob. 1FSC
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
- Use a spreadsheet and the following excerpts from Hileah Companys financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days sales in inventory, for the year 2018.arrow_forwardThe following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardHelp me pleasearrow_forward
- The financial statements of Dandy Distributors Ltd. are shown on the "Fcl. Stmts." page. 1 Based on Dandy's financial statements, calculate ratios for the year ended December 31, 2020. Assume all sales are on credit. Show your work. 2 From these ratios, analyze the financial performance of Dandy.arrow_forwardThe following selected accounts and their current balances appear in the ledger of Kanpur Co. for the fiscal year ended June 30, 2019: 1. Prepare a multiple-step income statement.2. Prepare a statement of owner’s equity.3. Prepare a balance sheet, assuming that the current portion of the note payable is$7,000.4. Briefly explain how multiple-step and single-step income statements differ.arrow_forwardRequired: For each of the following accounts, what amount will Voltac report on its 2024 financial statements? a. Inventory b. Cost of goods sold c. Sales d. Accounts receivable e. Accounts payable f. Casharrow_forward
- PA10. O 6.6 The following is the adjusted trial balance data for Nino's Pizzeria as of December 31, 2019. NINO'S PIZZERIA Adjusted Trial Balance Year Ended December 31, 2019 Debit Credit $ 775,984 Cash Accounts Receivable Buildings Merchandise Inventory Accounts Payable Common Stock 45,688 200,460 135,624 $437,880 410,542 Sales 555,696 Interest Revenue 84,652 Rent Revenue 86,900 Sales Salaries Expense Office Supplies Expense Sales Discounts Interest Expense Sales Returns and Allowances 24,500 6,270 102,890 4,577 105,854 122,853 Cost of goods sold Rent Expense Depreciation Expense: Office Equipment Insurance Expense Advertising Expense Totals 20,000 10,555 2,780 17,635 $1,575,670 $1,575,670 A. Use the data provided to compute net sales for 2019. B. Compute the gross margin for 2019. C. Compute the gross profit margin ratio (rounded to nearest hundredth). D. Prepare a simple income statement for the year ended December 31, 2019. E. Prepare a multistep income statement for the year ended…arrow_forwardPrepare a balance sheet using the following information for the Ginger Company as of March 31, 2019.arrow_forwardReview the select information for Liquor Plaza and Beer Buddies (industry competitors) and complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- Prepare an Income Statement using the following information for DL Enterprises for the month of July 2018. When listing accounts for each category, you are to use them in the order in which they are listed here. If used, type in the account names exactly as written here. Accounts Normal Balances Sales Revenue $62,500 Rental Revenue $15,300 Product Expense $52,200 Wages Expense $18,900 Owner Investment $12,000 Equipment Purchases $56,000 Utilities Expense $1,800 Taxes Expense $400arrow_forwardThe following selected account balances were taken from Buckeye Company's general ledger at January 1, 2019 and December 31, 2022: Accounts receivable Inventory Sales revenue Cost of goods sold January 1 $126,000 $163,000 The following information was taken from Buckeye Company's 2022 income statement: Salaries expense Income tax expense Net income December 31 $139,000 131,000 $967,250 $429, 240 $211,390 $ 97,986 $228,634 Calculate the average number of days that elapse between Buckeye Company buying their inventory from suppliers and then selling the inventory to customers.arrow_forwardUsing the following select financial statement information from Black Water Industries, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Black Water Industries?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License