Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter C, Problem 2C
To determine
Determine and group the ratios for all the five years, by type. Compare ratios to industry standards, and draw a 3-D area chart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Show-Off, Inc., sells merchandise through three retail outlets-in Las Vegas, Reno, and Sacramento-and operates a general corporate
headquarters in Reno. A review of the company's income statement indicates a record year in terms of sales and profits. Management,
though, desires additional insights about the individual stores and has asked that Judson Wyatt, a newiy hired intern, prepare a
segmented income statement. The following information has been extracted from Show-Off's accounting records:
• The sales volume, sales price, and purchase price data follow:
Reno
Sacramento
Las Vegas
37,100 units
$ 19.00
8.75
Sales volume
Unit selling price
Unit purchase price
41, 100 units
$ 17.50
8.75
46, 040 units
$ 15.25
9.75
•The following expenses were incurred for sales commissions, local advertising, property taxes, management salaries, and other
noncontrollable (but traceable) costs:
Reno
Las Vegas
5%
Sacramento
5%
Sales commissions
5%
Local advertising
Local property taxes
Sales manager…
Harrison and Company is a leading retailer of casual apparel for men, women, and
children. Assume that you are employed as a stock analyst and your boss has just
completed a review of the new Harrison annual report. She provided you with her
notes, but they are missing some information that you need. Her notes show that
the ending inventory for Harrison in the current and previous years was
$272,472,000 and $233,103,000, respectively. Net sales for the current year were
$2,540,266,000. Cost of goods sold was $178,524,000. Income before taxes was
$172,335,000.
Required:
Determine the amount of purchases for the year. (Hint: Use the cost of goods sold
equation or the inventory T-account to solve for the needed value.)
Amount of purchases
Federal Way, Incorporated, is a major department store chain. The dominant portion of the company's business consists of providing
merchandise and services to consumers through department stores and online. In a prior annual report, Federal Way reported cost of
goods sold of $11,572 million, ending inventory for the current year of $3,260 million, and ending inventory for the previous year of
$3,638 million.
Required:
Develop a reasonable estimate of the merchandise purchases for the year.
Note: Enter your answers in millions.
Purchases
million
million
million
million
Chapter C Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- Abercrombie and Fitch is a leading retailer of casual apparel for men, women, and children. Assume that you are employed as a stock analyst and your boss has just completed a review of the new Abercrombie annual report. She provided you with her notes, but they are missing some information that you need. Her notes show that the ending inventory for Abercrombie in the current and previous years was $424,393,000 and $399,795,000, respectively. Net sales for the current year were $3,492,690,000. Cost of goods sold was $1,408,848,000. Income before taxes was $55,161,000. Required: Determine the amount of purchases for the year. (Hint: Use the cost of goods sold equation or the inventory T-account to solve for the needed value.)arrow_forwardBefore you begin this assignment, it will be helpful if you review Macy's, Inc. 2015 annual report (https://www.sec.gov/Archives/edgar/data/794367/000079436716000221/m-0130201610k.htm) Macy's, Inc. is a premier retailer in the United States, operating nearly 900 stores in 45 states. Macy's, Bloomingdale's, and Bloomingdale's Outlet are all brands that operate under Macy's, Inc. The company sells a wide range of merchandise including apparel and accessories, cosmetics, home furnishings, and other goods. Macy's, Inc. purchases its merchandise from many suppliers and also develops its own private label brands. Read the requirements: 1. Under the new revenue recognition rules, how will Macy's record and recognize sales revenue? Which financial statement is sales revenue reported on? 2. Macy's, Inc. reported cost of sales of $16,496 million for the year ending January 30, 2016. Which financial statement is cost of sales (also known as cost of goods sold)…arrow_forwardThe general merchandise retail industry has a number of segments represented by the following companies: Company Name Costco Wholesale Corporation Merchandise Concept Membership warehouse Wal-Mart Discount general merchandise JCPenney Company Department store For a recent year, the following cost of merchandise sold and beginning and ending inventories have been provided from corporate annual reports (in millions) for these three companies: Wal-Mart Costco JCPenney $365,086 Cost of merchandise sold $101,065 $8,074 Merchandise inventory, beginning Merchandise inventory, ending 45,141 8,908 2,721 8,456 44,858 2,652 a. Determine the inventory turnover ratio for all three companies. Round to two decimal places. b. Determine the days' sales in inventory for all three companies. Use 365 days and round to one decimal place. c. Interpret these results based on each company's merchandise concept.arrow_forward
- Jodi's Chop Shop is a retail chain specializing in salon-quality hair-care products. During the year, Jodi's Chop Shop had sales of $39,235,000. The company began the year with $3,500,000 of merchandise inventory and ended the year with $4,445,000 of inventory. During the year, Jodi's Chop Shop purchased $24,215,000 of merchandise inventory. The company's selling, general, and administrative expenses totaled $7,185,000 for the year. Prepare Jodi's Chop Shop's income statement for the year. Begin by calculating Jodi's Chop Shop's cost of goods sold using the table below. Jodi's Chop Shop Calculation of Cost of Goods Sold For the Year Ended Beginning inventory Purchases Plus: Cost of goods available for sale Less: Ending inventory Cost of goods soldarrow_forwardThe general merchandise retail industry has a number of segments represented by the following companies: For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports (in millions) for these three companies: a. Determine the inventory turnover ratio for all three companies. Round all calculations to one decimal place. b. Determine the number of days sales in inventory for all three companies. Use 365 days and round all calculations to one decimal place. c. Interpret these results based on each companys merchandising concept.arrow_forwardBURTS BEES, Durham, North Carolina Burts Bees describes itself as an Earth-Friendly, Natural Personal Care Company that produces products for health, beauty, and personal hygiene. The company manufactures over 197 products distributed in nearly 30,000 retail outlets worldwide. As a merchandising company, Burts Bees follows its inventory closely. This requires monitoring the receipt, production, purchasing, and planning of inventory. At the end of each time period, Burts Bees must make adjusting entries to prepare its financial statements accurately. Many of the adjustments are entries you have already learned, such as depreciation, expiration of prepaid expenses, adjustment of supplies used, and recording of accrued expenses. However, merchandising companies also require adjusting entries related to merchandise inventory. Companies such as Burts Bees monitor inventory, prepare a worksheet, and record adjusting entries using either the perpetual or periodic inventory system. Using your book and/or conducting a brief Internet search to find the differences between perpetual and periodic inventory systems, answer the following questions: 1. What type of inventory system do you think Burts Bees uses? Why? 2. Using the inventory system you selected in no. 1, what is an example of the type of journal entry Burts Bees would make when purchasing merchandise on account? 3. Using the inventory system you selected in no. 1, what journal entry would Burts Bees use to record the sale of merchandise on account?arrow_forward
- Easley-O'Hara Office Equipment sells furniture and technology solutions to consumers and to businesses. Most consumers pay for their purchases with credit cards and business customers make purchases on open account with terms 1/10, net 30. Costs of furniture Inventory purchases have generally been rising and costs of computer Inventory purchases have generally been declining. The company's Income tax rate is 20 percent. Casey Easley, the general manager, was particularly Interested in the financial statement effects of the following facts related to first quarter operations. a. Credit card sales (discount 2 percent) were $39,000. b. Sales on account were $116,000. The company expects one-half of the accounts to be paid within the discount period. c. The company computed cost of goods sold for the transactions in (a) and (b) above under FIFO and LIFO for Its two product lines and chose the method for each product that minimizes Income taxes: Furniture Computer equipment FIFO $ 28,600…arrow_forwardUma Foodstuff Ltd. is a large chain of food stores. The financial statements for Uma Ltd. are given below. Income statement for the year ended 31 December 2021 2020 $m. $m. Revenue 145,000 160,000 Cost of sales 86,000 91,200 Gross profit 59,000 68,800 Selling and distribution expenses 17,500 17,600 Administrative expenses 7,500 6,400 Operating profit 34,000 44,800 Interest expense 2,000 400 Profit before taxation 32,000 44,400 Income tax expense 6,400 8,880 Net profit 25,600 35,520 Statement of financial position as at 31 December 2021 2020 $m. $m. ASSETS Non-current assets Land and buildings 40,000 68,600 Equipment 34,000 35,000 74,000 103,600 Current assets Inventories 20,000 12,000 Trade receivables 4,000 2,000 Cash 4,000 7,000…arrow_forwardSalon Hair is a retail chain specializing in salon-quality hair-care products. During the year, Salon Hair had sales of $38,850,000. The company began the year with $3,500,000 of merchandise inventory and ended the year with $4,445,000 of inventory. During the year, Salon Hair purchased $23,975,000 of merchandise inventory. The company's selling, general, and administrative expenses totaled $7,100,000 for the year. Prepare Salon Hair's income statement for the year. Begin by calculating Salon Hair's cost of goods sold using the table below. Salon Hair Calculation of Cost of Goods Sold For the Year Ended Plus: Less: Now prepare Salon Hair's income statement for the year. Salon Hair Income Statement For the Year Ended Less: Less: ...arrow_forward
- Nur Inc., is a private company that designs, manufactures, and distributes branded consumer products. During its most recent fiscal year, the had revenues of $200 million and earnings of $30 million. The company has filed a registration statement with the SEC for its IPO. Before the stock is offered, Nur's investment bankers would like to estimate the value of the company using comparable companies. The investment bankers have assembled the following information based on data for other companies in the same industry that have recently gone public. In each case, the ratios are based on the IPO price. After the IPO, Nur Inc will have 10 million shares outstanding. Estimate the IPO price for Nur Inc using the price/earnings ratio and the price/revenues ratio. Company Ray Products Corp. Byce-Frasier Inc. Fashion Industries Group Recreation International Average Price/Earnings Price/Revenues 18.8 X 19.5 X 24.1 X 22.4 X 21.2 X 1.2 X 0.9 X 0.8 X 0.7 X 0.9 Xarrow_forwardSituation: To pump up sales of all brands, Chapman Inc. is moving aggressively to ship extra cases of inventory into distributors’ warehouses and record them as sales, a practice generally known as “trade loading.” Chapman’s president has asked you whether these shipments may be recognized as revenue. Directions: Research the related generally accepted accounting principles and prepare a short memo to the president. Cite your references and applicable paragraph numbers.arrow_forwardThe Zwatch Company manufactures trendy, high-quality moderately priced watches. As Zwatch’s senior financial analyst, you are asked to recommend a method of inventory costing. The CFO will use your recommendation to prepare Zwatch’s 2019 income statement. The following data are for the year ended December 31, 2019: Beginning inventory, January 1, 2019 85,000 units Ending inventory, December 31, 2019 34,500 units 2019 sales 345,400 units Selling price (to distributor) $22.00 per unit Variable manufacturing cost per unit, including direct materials $5.10 per unit Variable operating (marketing) cost per unit sold $1.10 per unit sold Fixed manufacturing costs $1,440,000 Denominator-level machine-hours 6,000 Standard production rate 50 units per machine-hour Fixed operating (marketing) costs $1,080,000 Assume standard costs per unit are the same for units in beginning inventory and units produced during the year. Also, assume no price, spending, or efficiency variances. Any…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
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