Connect Access Card for Financial Accounting
9th Edition
ISBN: 9781259738678
Author: Robert Libby, Patricia Libby, Frank Hodge Ch
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 1, Problem 1.7E
Preparing an Income Statement and Inferring Missing Values
Walgreen Co. is one of the nation's leading drugstore chains. Its recent income statement contained the following items (in millions). Prepare an income statement for the year ended August 31. current year. (Hint: First order the items as they would appear on the income statement and then confirm the values of the subtotals and totals. Exhibit 1.3 in the chapter provides a good model for completing this exercise.)
| Cost of sales | $51,692 |
| Provision for income taxes* | 1,580 |
| Interest expense | 71 |
| Net earnings | 2,714 |
| Net sales | 72,184 |
| Pretax income | 4,294 |
| Selling, general, and administration expense | 16,561 |
| Other income | 434 |
| Total expenses | 68,324 |
| Total revenues/income | 72,618 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Perform the Reperformance or Recalculation procedures to check the mathematical accuracy ofthe Income Statement. What issue did you find? What is the next step? Create a Correctedversion of the Income Statement.
Income Statement
For the Year Ended
For the Year Ended
Revenue
3/31/2021
3/31/2022
Sales Revenue: Corporate Accounts
$ 353,739.57
$ 343,050.56
Sales Revenues: Storefront
$ 80,649.00
$ 91,411.50
Total Sales Revenue
$ 434,388.57
$ 434,462.06
Cost of Goods Sold: Ingredients
$ 69,736.39
$ 64,645.64
Cost of Goods Sold: Boxes and Cupcake Cups
$ 3,875.55
$ 3,755.55
Cost of Goods Sold: Beverages
$ 5,466.50
$ 5,681.50
Total COGS
$ 76,078.44
$ 74,082.69
Gross Profit
$ 358,310.13
$ 360,379.37
Interest Revenue
$…
Alex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images)
Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.
Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2022, and from its Complete this question by entering your answers in the tabs below.
March 31, 2022, balance sheet to complete the requirements.
Computer services revenue
Net sales (of goods)
Total sales and revenue
Cost of goods sold.
Net income
Quick assets
Current assets
Total assets
Current liabilities
Total liabilities.
Total equity
Required 1
Required:
1. Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio.
2. Compute the current ratio and acid-test ratio.
3. Compute the debt ratio and equity ratio.
4. What percent of its assets are current? What percent are long term?
Required 2
Complete this question by entering your answers in the tabs below.
$ 25,307
18,693
44,000
Required 3
Gross margin ratio
Net profit margin ratio
14,052
18,833
90,924
95,568
120,268
875
875
119,393
%
Compute the gross margin ratio (both with and…
Chapter 1 Solutions
Connect Access Card for Financial Accounting
Ch. 1 - Define accounting.Ch. 1 - Briefly distinguish financial accounting from...Ch. 1 - Prob. 3QCh. 1 - Prob. 4QCh. 1 - Prob. 5QCh. 1 - Complete the following: Name of Statement...Ch. 1 - What information should be included in the heading...Ch. 1 - What are the purposes of (a) the income statement,...Ch. 1 - Explain why the income statement and the statement...Ch. 1 - Prob. 10Q
Ch. 1 - Prob. 11QCh. 1 - Explain the equation for the income statement....Ch. 1 - Explain the equation for the balance sheet. Define...Ch. 1 - Explain the equation for the statement of cash...Ch. 1 - Explain the equation for retained earnings....Ch. 1 - The financial statements discussed in this chapter...Ch. 1 - Prob. 17QCh. 1 - Prob. 18QCh. 1 - (Supplement A) Briefly differentiate between a...Ch. 1 - Prob. 20QCh. 1 - Which of the following is not one of the four...Ch. 1 - Prob. 2MCQCh. 1 - Prob. 3MCQCh. 1 - Which of the following regarding retained earnings...Ch. 1 - Which of the following is not one of the four...Ch. 1 - Prob. 6MCQCh. 1 - Prob. 7MCQCh. 1 - Which of the following is true regarding the...Ch. 1 - Prob. 9MCQCh. 1 - Prob. 10MCQCh. 1 - Matching Elements with Financial Statements M1-1...Ch. 1 - Matching Financial Statement Items to Financial...Ch. 1 - Prob. 1.3MECh. 1 - Prob. 1.1ECh. 1 - Matching Financial Statement Items to Financial...Ch. 1 - Matching Financial Statement Items to Financial...Ch. 1 - Preparing a Balance Sheet Honda Motor Corporation...Ch. 1 - Completing a Balance Sheet and Inferring Net...Ch. 1 - Prob. 1.6ECh. 1 - Preparing an Income Statement and Inferring...Ch. 1 - Prob. 1.8ECh. 1 - Inferring Values Using the Income Statement and...Ch. 1 - Inferring Values Using the Income Statement and...Ch. 1 - Preparing an Income Statement and Balance Sheet...Ch. 1 - Preparing an Income Statement and Balance Sheet...Ch. 1 - Preparing a Statement of Stockholders Equity...Ch. 1 - Focus on Cash Flows: Matching Cash Flow Statement...Ch. 1 - Preparing an Income Statement, Statement of...Ch. 1 - Analyzing a Student's Business and Preparing an...Ch. 1 - Comparing Income with Cash Flow (Challenging)...Ch. 1 - Evaluating Data to Support a Loan Application...Ch. 1 - Preparing an Income Statement, Statement of...Ch. 1 - Analyzing a Students Business and Preparing an...Ch. 1 - Prob. 1.3APCh. 1 - Prob. 1.1CONCh. 1 - Finding Financial Information LO1-1 Refer to the...Ch. 1 - Prob. 1.2CPCh. 1 - Comparing Companies within an Industry Refer to...Ch. 1 - Using Financial Reports: Identifying and...Ch. 1 - Prob. 1.5CPCh. 1 - Prob. 1.6CPCh. 1 - Prob. 1.7CP
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
- Consider again the example introduced in Section 4.5 of a credit card company that has a database of information provided by its customers when the customers apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3). Figure 4.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? d. Recall the multiple regression in Figure 4.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts a, b, and c? What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? e. Add the coefficients of determination for the simple linear regression in parts a, b, and c, and compare the result to the coefficient of determination for the multiple regression model in Figure 4.23. What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? f. Add age, a dummy variable for gender, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 4.23. Code the dummy variable for gender as 1 if the customers gender is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?arrow_forwardI need help filling out the excel template with this given information. Kate has just completed her first year of Kate's Cards. She has been preparing monthly income statements and balance sheets, so she knows that her company has been profitable and that there is cash in the bank. She has not, however, prepared a statement of cash flows. Kate's provides you with the year-end income statement and balance sheet and asks that you construct an statement of cash flows for Kate's Cards.Additional information:1. There were no disposals of equipment during the year2. Dividends in the amount of $1,300 were paid in cash during the year.3. Prepaid expenses relate to operating expenses.Requireda. Construct an statement of cash flows for Kate's Cards for the year-ended August 31, 2019, using the indirect method. Hint: Since this was Kate's first year of operations, the beginning balance sheet account balances were zero.b. Construct an statement of cash flows for Kate's Cards for the year ended…arrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then 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
- 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 financial data (in thousands) were taken from recent financial statements of Staples, Inc.: Please see the attachment for details: 1. Determine the times interest earned ratio for Staples in Year 3, Year 2, and Year 1? Round your answers to one decimal place.2. Evaluate this ratio for Staples.arrow_forwardPlease tell me what type of the analysis is if the analysis wants to know which customer purchased over $5000 last year but bought nothing this year. Descriptive analytics. B. Diagnostic analytics. Predictive analytics. D. Prescriptive analyticsarrow_forward
- conduct horizontal and vertical analyses for the balance sheet and income statement accounts and report any significant observations for a two-year period. Accounts Receivable: Use basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time. Use basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time.arrow_forwardCommon-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel formulas using cell references. 2. create absolute cell references to perform calculations efficiently and correctly. 3. apply conditional formatting to highlight cells based on criteria that you specify. Case scenario: You are working at a small business that has been mostly stable. You want to analyze the financial statements of the past five years to examine the trends over time and compare the percentages of income statement items relative to overall sales. You also want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount. Required: Download spreadsheet CommonSizeCaseData-52d586.xlsx You will build a spreadsheet that performs common-size analysis using five years of a company's income statements. Specifically, you will create two sheets within the workbook, one for the horizontal analysis and one for the…arrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then 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. BEAN SUPERSTORE LEGUMES PLUS Comparative Balance Sheet December 31, 2017, 2018, and 2019 Comparative Balance Sheet December 31, 2017, 2018, and 2019 2019 2018 2017 2019 2018 2017 Assets Cash $345,600 67,000 145,830 100,465 $330,460 62,000 178,011 101,202 $300,000 59,000 155,205 103,085 $407,000 85,430 128,080 182,006 $386,450 82,670 40,036 23,400 $356,367 79,230 52,142 111,701 Accounts Receivable Inventory Equipment Total Assets $658,895 $671,673 $617,290 $802,516 $532,556 $599,440 Liabilities Salaries Payable Accounts Payable Notes Payable $ 91,455 $ 90,200 70,000 41,000 $ 88,563…arrow_forward
- Ay 1. Using your financial analysis of Gap Clothing company, Refer to the Annual Reports located in the Class Resources. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel: Three liquidity ratios for the past 2 years Three solvency ratios for the past 2 years Three profitability ratios for the past 2 yearsarrow_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_forwardYou are working as an accountant in Hotel Four Seasons. You are asked to make a meaningful comparison of your financial statements against the figures of your main competitor in town. Required: Choose the best method of analysis to compare the following figures (assets) of Four Seasons and Hotel Two Moons. Also explain your choice method (2-3 sentences). Use a prepared grid for your results! Show all figures with 2 decimal places! Hotel Four Seasons. December 31. 2020 Assets Cash 14,000 Marketable Securities 15,000 Accounts Receivable (net) 65,000 Inventories 9,000 Building 2,617,000 Furnishings and Equipment 943,000 Less: Accumulated Depreciation 565,000 Total 3,098,000 Hotel Two Moons, December 31, 2020 Assets Cash 134,000 Marketable Securities 898,000 Account Receivable (net) 1,981,000 Inventories 186,000 Building 5,207,000 Furnishing and Equipment 2,650,000 Less:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License