20162015 Industry Avg Formula UsedRatio AnalysisProfitability RatiosProfit MarginBasic Earning PowerReturn on Assets5.78% net income/sales13.65% EBIT/Total Asset:5.90% Net income/total a10.04% net income/total cReturn on EquityAsset Management RatiosInventory Turnover (Total COGS/Inventories)Days Sales OutstandingFixed Assets Turnover1.95 (COGS minus dep59.85 Accounts Receiva2.17 sales/net fixed as1.05 sales/total assetsTotal Assets TurnoverPatieLiquidity RatiosCurrent Ratio3.25 total current asseQuick Ratio1.75 (total current asseDebt Management RatiosDebt Ratio (Total debt-to-assets)23.0% (notes payable +32.2% total liabilities / tot8.75 EBIT / interest exLiabilities-to-assets ratioTimes-interest-earned ratioEBITDA coverage ratioMarket Value Ratios2.74 (EBIT + depreciatRatioeEarnings per sharePrice-to-earnings ratioCash flow per shareNA net income / numPrice-to-cash flow ratioBook Value per shareMarket-to-book ratio18.17 year end stock prNA (net income + dep9.54 year end stock prNA total common eqi2.00 year end stock prPerform a Dupont Analysis for Dunder Mifflin, Inc. for 2015 and 2016Hint: Use the Product(...) function of Excel for ROEROE =x TA Turnover x Equity MultiplierPM20162015Perform a Common Size Analysis of the balance sheets and income statements for Dunder Mifflinucture.com Module 1 Problem Set Financial AnalysisDirections: Dunder Mifflin, Inc. is a regional paper distributor located on the eastcoast of the United States. The CFO has requested that data for the previous yearsof 2015 and 2016 be compared to industry averages as well as previous activity.Using the financial data provided below, calculated the requested ratios and analysis.Use the functions of Excel for calculating your data.Dunder Mifflin, Inc.December 31 Balance Sheets(Thousands of Dollars)Assets2016Cash and cash equivalentsShort-term investmentsAccounts ReceivableInventoriesTotal current assetsNet fixed assetsTotal assets$36,0002,76565,900105,000$209,665178,000$387.6652015$42,5751,50064,88998,780$207,744175,000$382.744Liabilities and equityAccounts payableAccrualsNotes payableTotal current liabilitiesLong-term debtTotal liabilitiesCommon stockRetained EarningsTotal common equityTotal liabilities and equity$24,76514,23022,890$61,88563,780$125,665208,00054,000$262,000$387.665$25,00014,00025,400$64,40062,335$126,735203,00053,009$256,009$382.744Dunder Mifflin Inc.December 31 Income Statements(Thousands of Dollars)2016$389,000285,70023,60034,000$45,7006,300$39,40015,760$23.6402015$376,000259,00022,45032,500$62,0506,000$56,05022,420$33.630SalesCOGS except excluding depr. and amort.Depreciation and AmortizationOther operating expensesEBITInterest ExpenseEBTTaxes (40%)Net IncomeCommon dividendsAddition to retained earnings$17,950$16,730$18,900$23,680Other DataYear-end Stock Price# of shares (Thousands)Lease payment (Thousands of Dollars)Sinking fund payment (Thousands of Dollar2016$84.006,203$30,000$3,0002015$92.006,100$31,000$3,000Ratio AnalysisProfitability RatiosProfit Margin20162015 Industry Avg Formula Used5.78% net income/sales

Ratio Analysis It is important for the business entity to calculate the required percentage of ratio…

Perform a Dupont Analysis for Dunder Mifflin, Inc. for 2015 and 2016 Hint: Use the Product(...) function of Excel for ROE ROE = x TA Turnover x Equity Multiplier PM 2016 2015 Perform a Common Size Analysis of the balance sheets and income statements for Dunder Mifflin

Perform a Dupont Analysis for Dunder Mifflin, Inc. for 2015 and 2016 Hint: Use the Product(...) function of Excel for ROE ROE = x TA Turnover x Equity Multiplier PM 2016 2015 Perform a Common Size Analysis of the balance sheets and income statements for Dunder Mifflin

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter1: The Role Of Accounting In Business

Section: Chapter Questions

Problem 1.6.2MBA: Return on assets ExxonMobil Corporation (XOM) explores, produces, and distributes oil and natural...

See similar textbooks

Similar questions

Case 1-74 Comparative Analysis: Under Armour, lnc., versus Columbia Sportswear Refer to the 10-K reports of Under Armour, Inc., and Columbia Sportswear that are available for download from the companion website at CengageBrain.com Required: Answer the following questions: What is managements assessment of each companys past performance and future prospects? Where did you find this information?
Brief Exercise 1-24 The Accounting Equation Financial information for three independent cases is as follows: The liabilities of Dent Company are $82,000, and its stockholders' equity is $120,000. What is the amount of Dents total assets? The total assets of Wayne Inc. are $55,000, and its stockholders' equity is $22,500. What is the amount of Waynes total liabilities? Gordon Companys total assets increased by $60,000 during the year, and its liabilities decreased by $35,000. Did Gordons stockholders' equity increase or decrease? By how much? Required: Determine the missing amount for each case.
MBA 2-4 Common-sized income statements Southwest Airlines Co. (LUV) provides passenger services throughout the United Sates, Mexico, Jamaica, The Bahamas. Aruba. and the Dominican Republic. The following operating data (in millions) were adapted from recent financial statements of Southwest. Prepare common-sized income statements for Years 1 and 2. Round to one decimal place. Using your answer to (1), analyze and comment on the performance of Southwest in Year 2.
Comparing Two Companies in the Same Industry: Chipotle and Panera Bread Refer to the financial information for Chipotle and Panera Bread reproduced at the end of this book and answer the following questions: Required What is the dollar amount of inventories that each company reports on its balance sheet at the end of the most recent year? What percentage of total assets do inventories represent for each company? What does this tell you about the nature of their business? Refer to Note 1 in Chipotles annual report. What inventory valuation method does the company use? Refer to Note 2 in Panera Breads annual report. What inventory valuation method does the company use? How do both companies deal with situations in which the market value of inventory is less than its cost? Given the nature of their businesses, which inventory system, periodic or perpetual, would you expect both Chipotle and Panera Bread to use? Explain your answer.
Exercise 1-35 Accounting Concepts OBJECTIVE 06Â° A list of accounting concepts and related definitions is presented below. Concept Definition 1. Revenue a. Owners claim on the resources of a company 2, Expense b. The difference between revenues and expenses 3. Net income (1055) c. Increase in assets from the sale of goods or services 4, Dividend d. Economic resumes of a company 5. Asset e. Cost of assets consumed in the operation of a business 6, Liability f. Creditors' claims on the resources of a company 7. Stock holders, equity g. Distribution of earnings to stockholders Required: Match each of the concepts with its corresponding definition
Return on assets The financial statements of The Hershey Company (HSY) are shown in Exhibits 6 through 9 of this chapter. Based upon these statements, answer the following questions. What is the percentage of net income to sales for Hershey? Round to one decimal place.
Return on assets ExxonMobil Corporation (XOM) explores, produces, and distributes oil and natural gas. The Coca-Cola Company (KO) produces and distributes soft drink beverages, including Coke. Wal-Mart Stores, Inc.., (WMT) operates retail stores and supermarkets. The following data (in millions) were taken from recent financial statements of each company: Compute the return on assets for each company using the preceding data, and rank the companies’ return on assets from highest to lowest. Round the return on assets to one decimal place.
MBA 2-7 Common-sized income statements General Mills Inc. (GIS) produces. markets, and distributes cereal and food products including Cheerios. Wheaties, Cocoa Puffs. Yoplait, and Pillsbury branded products. The following part income statements (in millions) were adapted from recent financial statements. Prepare common-sized income statements for Years 1 and 2. Round to one decimal place. Using your answer to (1), analyze the performance of General Mills in Year 2.
Financial statements 1. Net income: 10,900 Jose Loder established Bronco Consulting on August 1, 20Y1. The effect of each transaction and the balances after each transaction for August follow: Instructions 1. Prepare an income statement for the month ended August 31, 20Y1. 2. Prepare a statement of stockholders equity for the month ended August 31, 20Y1. 3. Prepare a balance sheet as of August 31, 20Y1. 4. (Optional) Prepare a statement of cash flows for the month ending August 31, 20Y1.
QUESTION # 1 a) In an accounting conference, discussion turned to the possibility of preparing financial statements from a few key accounts together with financial or cost ratios. The assistant controller of a participating firm provided the following data: Pretax income $ 2100000/-. Pre tax Income rate on sales 20%, Gross Profit rate 45%, Rate of marketing expense to sales 25%, 5% Bond Payable represent 37.5 % of the total liabilities of $ 1000000/-. Required: - An Income statement for the year based on the above information. b) If amongst the cost of goods sold in the above question 40% is Direct material and remaining is FOH and Direct Material. FOH is 75% of Direct labour. In the coming year it is expected that material would increase by 20% and amongst total FOH 40% is fixed. If margin rate is 40% and the ratio between Variable FOH and Direct Labour remains same find out the new selling price.
I need help figuring out the correct journey entries for the items 4d & 10j. Problem#8. Required information [The following information applies to the questions displayed below.] At January 1 (beginning of its fiscal year), Conover, Inc., a financial services consulting firm, reported the following account balances (in thousands, except for par and market value per share): Cash $ 1,990 Accounts payable $ 300 Short-term investments 500 Unearned revenue 1,410 Accounts receivable 3,660 Salaries Payable 960 Supplies 240 Short-term note payable 870 Prepaid expenses 4,810 Common stock ($1 par value) 140 Office equipment 1,620 Additional paid-in capital 6,650 Accumulated depreciation-office equipment* (390) Retained earnings 2,100 *This account has a credit balance representing the portion of the cost of the equipment used in the…
Instruction: (Horizontal Analysis) Present an interpretation and conclusions about the result of "Riel Corporation Comparative Statements of Financial Position December 31, 2015 (in Thousand pesos)" computations and analysis. *refer to the pic*