What is the formula for the following ratios AND what do they measure?
Inventory turnover
Days' sales in inventory
In: Accounting
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 newly hired intern, prepare a segmented income statement. The following information has been extracted from Show-Off’s accounting records:
| Las Vegas | Reno | Sacramento | |||||||
| Sales volume | 37,900 | units | 41,900 | units | 46,360 | units | |||
| Unit selling price | $ | 27.00 | $ | 25.50 | $ | 23.25 | |||
| Unit purchase price | 12.75 | 12.75 | 15.75 | ||||||
| Las Vegas | Reno | Sacramento | |||||||
| Sales commissions | 5 | % | 5 | % | 5 | % | |||
| Local advertising | $ | 17,400 | $ | 37,500 | $ | 99,000 | |||
| Local property taxes | 7,200 | 3,450 | 11,700 | ||||||
| Sales manager salary | — | — | 61,500 | ||||||
| Store manager salaries | 51,000 | 67,500 | 75,000 | ||||||
| Other noncontrollable costs | 9,600 | 7,350 | 35,700 | ||||||
Required:
Assume the role of Judson Wyatt and prepare a segmented income statement for Show-Off. (Round your answers to the nearest whole dollar.)
|
Identify the probable causes for the poor performance of the weakest store. (Select which of the following statements (is) are true by selecting an "X".)
|
Which of the following should be reviewed in evaluating the performance of the store manager?
|
In: Accounting
Ending inventory presented on the balance sheet must be based on the Lower of Cost or Market. What does this mean?
In: Accounting
Cone Corporation is in the process of preparing its December 31,
2018, balance sheet. There are some questions as to the proper
classification of the following items:
Required:
Prepare a partial classified balance sheet to show how each of the
above items should be reported.
In: Accounting
Analysis and Interpretation of Profitability
Balance sheets and income statements for Best Buy Co., Inc.
follow.
| Consolidated Statements of Earnings | |||
|---|---|---|---|
| For Fiscal Years Ended ($ millions) | February 26, 2011 | February 27, 2010 | February 28, 2009 |
| Revenue | $ 50,272 | $ 49,694 | $ 45,015 |
| Cost of goods sold | 37,611 | 37,534 | 34,017 |
| Restructuring charges - cost of goods sold | 24 | -- | -- |
| Gross Profit | 12,637 | 12,160 | 10,998 |
| Selling, general and administrative expenses | 10,325 | 9,873 | 8,984 |
| Restructuring charges | 198 | 52 | 78 |
| Goodwill and tradename impairment | -- | -- | 66 |
| Operating income | 2,114 | 2,235 | 1,870 |
| Other income (expense) | |||
| Investment income and other | 51 | 54 | 35 |
| Investment impairment | -- | -- | (111) |
| Interest expense | (87) | (94) | (94) |
| Earnings before income tax expense and equity in income of affiliates | 2,078 | 2,195 | 1,700 |
| Income tax expense | 174 | 802 | 674 |
| Equity in income of affiliates | 2 | 1 | 7 |
| Net earnings including noncontrolling interest | 1,366 | 1,394 | 1,033 |
| Net income attributable to noncontrolling interest | (89) | (77) | (30) |
| Net income attributable to Best Buy Co., Inc. | $ 1,277 | $ 1,317 | $ 1,003 |
| Consolidated Balance Sheets | ||
|---|---|---|
| ($ millions, except footnotes) | February 26, 2011 | February 27, 2010 |
| Assets | ||
| Current assets | ||
| Cash and cash equivalents | $ 1,103 | $ 1,826 |
| Short-term investments | 22 | 90 |
| Receivables | 2,348 | 2,020 |
| Merchandise inventories | 5,897 | 5,486 |
| Other current assets | 1,103 | 1,144 |
| Total current assets | 10,473 | 10,566 |
| Property and equipment | ||
| Land and buildings | 766 | 757 |
| Leasehold improvements | 2,318 | 2,154 |
| Fixtures and equipment | 4,701 | 4,447 |
| Property under capital lease | 120 | 95 |
| 7,905 | 7,453 | |
| Less: Accumulated depreciation | 4,082 | 3,383 |
| Property and equipment, net | 3,823 | 4,070 |
| Goodwill | 2,454 | 2,452 |
| Tradenames, net | 133 | 159 |
| Customer relationships, net | 203 | 279 |
| Equity and other investments | 328 | 324 |
| Other noncurrent assets | 435 | 452 |
| Total assets | $ 17,849 | $ 18,302 |
| Liabilities and equity | ||
| Current liabilities | ||
| Accounts payable | $ 4,894 | $ 5,276 |
| Unredeemed gift card liabilities | 474 | 463 |
| Accrued compensation and related expenses | 570 | 544 |
| Accrued liabilities | 1,471 | 1,681 |
| Accrued income taxes | 256 | 316 |
| Short-term debt | 557 | 663 |
| Current portion of long-term debt | 441 | 35 |
| Total current liabilities | 8,663 | 8,978 |
| Long-term liabilities | 1,183 | 1,256 |
| Long-term debt | 711 | 1,104 |
| Equity | ||
| Best Buy Co., Inc. Shareholders' equity | ||
| Preferred stock, $1.00 par value | -- | -- |
| Common stock, $0.10 par value | 39 | 42 |
| Additional paid-in capital | 18 | 441 |
| Retained earnings | 6,372 | 5,797 |
| Accumulated other comprehensive income (loss) | 173 | 40 |
| Total Best Buy Co., Inc. shareholders' equity | 6,602 | 6,320 |
| Noncontrolling interest | 690 | 644 |
| Total equity | 7,292 | 6,964 |
| Total liabilities and equity | $ 17,849 | $ 18,302 |
NOTE: Use net income attributable to controlling interests in your computations, when applicable.
a. Compute ROE for 2011.
Do not round until your final answer. Round answer to two decimal places.
ROE =Answer%
b. Confirm that ROE equals ROE computed using the component
measures for profit margin, asset turnover, and financial leverage
using: ROE = PM * AT * FL.
Compute the components of ROE.
Do not round until your final answer. Round answer to two decimal places.
PM = Answer%
AT = Answer
FL = Answer
c. Compute adjusted ROA. Assume a tax rate of: 37.0%.
Round answer to two decimal places.
Adjusted ROA =Answer%
In: Accounting
Compute and Interpret Measures for DuPont Disaggregation
Analysis
Balance sheets and income statements for 3M Company follow.
| 3M Company | ||||
|---|---|---|---|---|
| Consolidated Statements of Income | ||||
| For Years Ended Dec. 31 ($millions) | 2015 | 2014 | 2013 | |
| Net sales | $30,674 | $31,821 | $30,871 | |
| Operating expenses | ||||
| Cost of sales | 15,383 | 16,447 | 16,106 | |
| Selling, general & administrative expenses | 6,182 | 6,469 | 6,384 | |
| Research, development & related expenses | 1,763 | 1,770 | 1,715 | |
| Total operating expenses | 23,328 | 24,686 | 24,205 | |
| Operating income | 7,346 | 7,135 | 6,666 | |
| Interest expense and income | ||||
| Interest expense | 149 | 142 | 145 | |
| Interest income | (26) | (33) | (41) | |
| Total interest expense -net | 123 | 109 | 104 | |
| Income before income taxes | 7,223 | 7,026 | 6,562 | |
| Provision for income taxes | 2,167 | 2,028 | 1,841 | |
| Net income inc. noncontrolling interest | 5,056 | 4,998 | 4,721 | |
| Less: Net income attributable to NCI | 8 | 42 | 62 | |
| Net income attributable to 3M | $5,048 | $4,956 | $4,659 | |
| 3M Company | |||
|---|---|---|---|
| Consolidated Balance Sheets | |||
| At December 31 ($ millions, except per share amount) | 2015 | 2014 | |
| Current assets | |||
| Cash and cash equivalents | $1,898 | $1,997 | |
| Marketable securities--current | 198 | 1,519 | |
| Accounts receivable, net | 4,154 | 4,238 | |
| Inventories: | |||
| Finished goods | 1,655 | 1,723 | |
| Work in process | 1,008 | 1,081 | |
| Raw materials and supplies | 855 | 902 | |
| Total inventories | 3,518 | 3,706 | |
| Other current assets | 1,398 | 1,023 | |
| Total current assets | 11,166 | 12,483 | |
| Marketable securities--noncurrent | 9 | 15 | |
| Investments | 117 | 102 | |
| Property, plant and equipment | 23,098 | 22,841 | |
| Less: Accumulated depreciation | (14,583) | (14,352) | |
| Property, plant and equipment--net | 8,515 | 8,489 | |
| Goodwill | 9,249 | 7,050 | |
| Intangible assets -net | 2,601 | 1,435 | |
| Prepaid pension benefits | 188 | 46 | |
| Other assets | 1,053 | 1,769 | |
| Total assets | $32,898 | $31,389 | |
| Liabilities | |||
| Current liabilities | |||
| Short-term debt & current portion of LT debt | $2,144 | $186 | |
| Accounts payable | 1,774 | 1,907 | |
| Accrued payroll | 644 | 732 | |
| Accrued income taxes | 332 | 435 | |
| Other current liabilities | 2,404 | 2,884 | |
| Total current liabilities | 7,298 | 6,144 | |
| Long-term debt | 8,753 | 6,705 | |
| Pension and postretirement benefits | 3,520 | 3,843 | |
| Other liabilities | 1,580 | 1,555 | |
| Total liabilities | 21,151 | 18,247 | |
| Equity | |||
| 3M Company shareholders' equity: | |||
| Common stock, par value $0.01 per share; | |||
| Shares outstanding --2015: 609,330,124; | |||
| Shares outstanding --2014: 635,134,594 | 9 | 9 | |
| Additional paid-in capital | 4,791 | 4,379 | |
| Retained earnings | 36,575 | 34,317 | |
| Treasury stock | (23,308) | (19,307) | |
| Accumulated other comprehensive income (loss) | (6,359) | (6,289) | |
| Total 3M Company shareholders' equity | 11,708 | 13,109 | |
| Noncontrolling interest | 39 | 33 | |
| Total equity | 11,747 | 13,142 | |
| Total liabilities and equity | $32,898 | $31,389 | |
a. Compute the DuPont model component measures for profit margin, asset turnover, and financial leverage. Then, compute ROA.
Round profit margin and ROA to two decimal places (ex: 0.12345 =
12.35%)
Round asset turnover and financial leverage to three decimal
places.
Profit margin Answer
%
Asset turnover Answer
Financial leverage Answer
ROA Answer
b. Compute ROE. Confirm that ROE equals ROE computed using the
component measures from part a (ROE = PM x AT x FL).
Round answer to two decimal places (ex: 0.12345 = 12.35%)
Answer
c. Compute adjusted ROA (assume a statutory tax rate of 37% and
pretax net interest expense of $123).
Round answer to two decimal places (ex: 0.12345 = 12.35%)
In: Accounting
What is Porter’s Five Forces Framework? Please identify each force individually.
In: Accounting
What are the concepts and principles of effective written and oral communication? Please explain your understanding of the concepts and principles
In: Accounting
Use excel spreadsheet to solve the following problems Problem 1: A young engineer’s stating salary is 55,000. The engineer expects annual raises of 3%. The engineer will deposit 10% of the annual salary at the end of each year in a savings account. What is the savings interest rate must be so that there will be $150, 000 in savings for a business start-up after 15 years. Your spreadsheet include at least columns for the year, the year’s salary, the year’s deposit, and the year’s cumulative savings.Show the formula you use for calculation
In: Accounting
What is Petty Cash and how is it represented on the balance sheet? What types of expenses are used with petty cash?
In: Accounting
Sometimes there can be errors while making change for a customer or recording a check incorrectly. What are some of the controls we can put over cash that would help prevent errors?
In: Accounting
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow:
| Total | Dirt Bikes |
Mountain Bikes | Racing Bikes |
|||||||||
| Sales | $ | 921,000 | $ | 267,000 | $ | 403,000 | $ | 251,000 | ||||
| Variable manufacturing and selling expenses | 484,000 | 116,000 | 209,000 | 159,000 | ||||||||
| Contribution margin | 437,000 | 151,000 | 194,000 | 92,000 | ||||||||
| Fixed expenses: | ||||||||||||
| Advertising, traceable | 69,700 | 8,400 | 40,600 | 20,700 | ||||||||
| Depreciation of special equipment | 43,100 | 20,100 | 7,800 | 15,200 | ||||||||
| Salaries of product-line managers | 114,900 | 40,500 | 38,900 | 35,500 | ||||||||
| Allocated common fixed expenses* | 184,200 | 53,400 | 80,600 | 50,200 | ||||||||
| Total fixed expenses | 411,900 | 122,400 | 167,900 | 121,600 | ||||||||
| Net operating income (loss) | $ | 25,100 | $ | 28,600 | $ | 26,100 | $ | (29,600) | ||||
*Allocated on the basis of sales dollars.
Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out.
Required:
1. What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?
2. Should the production and sale of racing bikes be discontinued?
3. Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various product lines.
In: Accounting
See the "Zane Corbin, Accounting Major" case for this question. Reportedly, one member of the hearing panel believed Zane was guilty of the charge filed against him but voted to acquit him because the adverse consequences Zane faced if the Upchurch Medal was rescinded far outweighed the severity of the "indiscretion" he had committed. Was that a reasonable or appropriate justification for voting to acquit Zane? Defend your answer.
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,759,800 | |
| Cost of goods sold | 1,231,750 | ||
| Gross margin | 528,050 | ||
| Selling and administrative expenses | 620,000 | ||
| Net operating loss | $ | (91,950 | ) |
Hi-Tek produced and sold 60,400 units of B300 at a price of $21 per unit and 12,600 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,500 | $ | 162,200 | $ | 562,700 |
| Direct labor | $ | 120,300 | $ | 42,200 | 162,500 | |
| Manufacturing overhead | 506,550 | |||||
| Cost of goods sold | $ | 1,231,750 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $53,000 and $102,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 199,550 | 90,600 | 62,900 | 153,500 | |
| Setups (setup hours) | 144,900 | 75 | 270 | 345 | ||
| Product-sustaining (number of products) | 101,800 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,300 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 506,550 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
In: Accounting