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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Performing horizontal analysis—income statement Data for Mulberry Designs, Inc. follow: Requirements Prepare a horizontal analysis of the comparative income statement of Mulberry Designs, Inc. Round percentage changes to one decimal place. Why did 2018 net income increase by a higher percentage than net sales revenue?
Make Analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Industry Ratio 2010 2011 2011 Liquidity Ratios Current Ratio 2.6 2.08 2.7 Quick Ratio 1.8 1.32 1.75 Activity Ratios Inventory Turnover 4.5 3.00 4.7 Average Collection Period 40days 53days 42 days Total Asset Turnover 1.2 0.80 1 Debt Ratios Debt Ratio 20% 28% 21% Times Interest Earned 9 6 8.9 Profitability Ratios Gross Profit Margin 43% 43% 44% Operating Profit Margin 30% 26% 32% Net Profit Margin 20% 17% 21% Return on total assets 12% 14% 13% Return on Equity 15% 19% 16% Market Ratios Price/Earnings Ratio 7.3 4.4 8
8.2)
Find the following financial ratios for LVMH Moet Hennessy Louis Vuitton SA (use year-end figures rather than average values where appropriate) (Round your answers to 2 decimal places (e.g., 32.16).) : 2015 2016 Short-term solvency ratios: Current ratio Quick ratio Cash ratio Asset utilization ratios: Total asset turnover Inventory turnover Receivables turnover Long-term solvency ratios: Total debt ratio Debt–equity ratio Equity multiplier Times interest earned ratio Profitability ratios: Profit margin % % Return on assets % % Return on equity % %
Sales SOLVE IT ON MS EXCEL or GOOGLE SPREADSHEET (please send the file) Ziegen, Inc. Income Statement for 2013 Make a Proforma Income Statement and ProForma Balance Sheet using the Financial Planning attached. Use 15% as the Sales Growth Rate of the 2013 base year, all other data remain the same. Net Income Ziegen, Inc. Balance Sheet for 2013 Current assets Net fixed assets Total Total Accounts payable Accrued expenses Notes payable Current liabilities Long-term debt Total liabilities Common stock (par) Paid-in capital Retained earnings Common equity $10,000,000 $ 500,000 $ 2,000,000 4,000,000 $ 6,000,000 $ 1,000,000 1,000,000 500,000 $ 2,500,000 2,000,000 $ 4,500,000 100,000 200,000 1,200,000 $ 1,500,000 $6,000,000 Calculation $.5m/$10m = Calculation $2m/$10m = $4m/$10m = $1m/$10m = $1m/$10m = Ziegen, Inc. Pro Forma Income % of 2013 Sales Statement for 2014 5.0% % of 2013 Sales 20.0% 40.0% 10.0% 10.0% NAª NA NA" NA" Calculation 20% Sales growth rate = Sales Net Income Ziegen, Inc. Pro…
Prepare a financial statement analysis in terms of liquidity, solvency, profitability and efficiency of the following company. Financial Ratios Fiscal Year Ended Previous Fiscal Year Formula Dec 31, 2019 Dec 31, 2018 Liquidity Analysis Ratios: Current Assets / Current Liabilities Current Ratio or 1.46 1.36 Working Capital Ratio (Current Assets - Inventory - Prepayments) / Current Liabilities Quick Ratio 0.96 0.86 Solvency Ratio Total Assets / Total Liabilities 1.46 1.44 Financial Leverage Ratios Debt Ratio Total Debt/Total Assets 0.47 0.48 Total Debt/Total Stockholders Equity Debt-to-Equity Ratio 1.48 1.57 Earnings Before Interest and Taxes (EBIT) / Interest Charges Total Assets / Total Stockholders' Equity Interest Coverage 2.38 2.61 Asset to Equity Ratio 3.16 3.28 Profitability Ratios Gross Profit Margin Sales - Cost of Goods Sold or Cost of Service / Sales 19.76 19.43 Net Profit Margin Net Profit / Sales 11.34 11.42 Net Income / Total Assets 2.67 2.9 Return on Assets Net Income /…
Requirements 1. Prepare a comparative common-size income statement for Mariner Designs, Inc. using the 2024 and 2023 data. Round percentages to one-tenth percent. 2. To an investor, how does 2024 compare with 2023 ? Explain your reasoning
Access the February 21, 2017, filing of the December 31, 2016, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2016, and December 31, 2015. Interpret its profitability using the results obtained for these two years. 1. Profit margin ratio (round the percent to one decimal). 2. Gross profit ratio (round the percent to one decimal). 3. Return on total assets (round the percent to one decimal). (Total assets at year-end 2014 were $5,622,870 in thousands.) 4. Return on common stockholders’ equity (round the percent to one decimal). (Total shareholders’ equity at year-end 2014 was $1,519,530 in thousands.) 5. Basic net income per common share (round to the nearest cent).
Based on this analysis how would I assess the financial stability and operational efficiency of this company? Ratio and Ratio Formula (in thousands) 2015 2014 2013 Current Industry Average Liquidity Current Ratio =Current Asset / Current Liability 9,900/6,300 1.57 1.61 1.62 1.63 Acid Test Ratio or Quick Ratio = (Cash + Marketable securities + Accounts receivable)/Current liabilities (400+300+3,200)/6,300 0.62 0.64 0.63 0.68 Solvency Times Interest Earned =Earnings before interest & taxes/interest expense, gross (7,060+900)/900 8.84 8.55 8.5 8.45 Profitability Profit margin on sales = net income/sales 7,060/30,500 14% 13.20% 12.10% 13.00% Productivity Asset turnover = sales/avg total assets 30,500/6,000+5,400)/2) 1.85 1.84 1.83 1.84 Inventory turnover = COGS/avg inv 17,600/ (6,000+5,400)/2) 3.09 3.17 3.21 3.18
What is the comparison (analysis) of the Earnings Per Share (EPS) of Industry Average Ratio and the Company A Ratio? The EPS has decreased and increased. Why? Industry Average, Earnings Per Share 2015: RM10.38 2016: RM15.05 2017: RM11.53 2018: RM10.71 2019: RM6.37 Company A, Earnings Per Share 2015: RM5.70 2016: RM3.30 2017: RM6.21 2018: RM6.20 2019: RM4.91
The following balances were reported in the financial statements for Ruby Company. 2016 2015 Net Sales $1,650,000 $1,750,000 Net Income 170,000 205,000 Current Assets 410,000 535,000 Current Liabilities 170,000 210,000 Total Liabilities 500,000 675,000 Total Assets 1,550,000 2,450,000 Required: 1. Compute the following ratios for 2016 and 2015 for Ruby Company. a. Return on sales ratio b. Current ratio c. Debt-to-total-assets ratio