Using the following income statements, perform the calculations needed for horizontal analyses. Round percentages to one...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the following income statements, perform the calculations needed for horizontal analyses. Round percentages to one decimal place. LOCKEY FENCING CORPORATION Income Statements For the Years Ended December 31 Current Previous Net Sales $100,000 $75,000 Cost of Goods Sold 58,000 45,000 Gross Profit 42,000 30,000 Selling, General, and Administrative Expenses 9,000 4,500 Income from Operations 33,000 25,500 Interest Expense 3,000 3,750 Income before Income Tax 30,000 21,750 Income Tax Expense 9,000 6,525 Net Income $21,000 $15.225 Calculations for Vertical Analyses Refer to the data from the previous question. Perform the calculations needed for vertical analysis. Round percentages to one decimal place. Interpreting Horizontal Analyses Refer to the calculations from the first question. What are the two most significant year-over-year changes in terms of dollars and in terms of percentages? Give on potential cause of each of these changes. Interpreting Vertical Analyses Refer to the calculations the second question (Calculations for Vertical Analyses. Which of the ratios from Exhibit 13.5 have been included in these calculations? Have these two ratios improved or deteriorated in the current year compared to the previous year? EXHIBIT 13.5 Common Ratios Used in Financial Statement Analysis Profitability Ratios Fiscal 2016 Calculations (1) Net Profit Margin = Net Income Revenues (Ch. 3, p. 117) $3,093 $65,017 = 4.8% $65,017 $42.553 = 34.6% (2) Gross Profit Percentage = Net Sales Cost of Goods Sold Net Sales $65,017 (Ch. 6, p. 275) Fixed Asset Turnover = (3) Net Revenue Average Net Fixed Assets (Ch. 9, p. 414) Return on Equity (ROE) = (4) Net Income-Preferred Dividends Average Common Stockholders' Equity (Ch. 11, p. 523) Earnings per Share (EPS) = (5) Net Income Preferred Dividends Average Number of Common Shares Outstanding (Ch. 11, p. 523) $65,017 $19,949 - $19,577)/2 =3.29 $3,093-$29 ($6,434 - $7,654)/2 = 43.5% $3,093-$29 880 = $3.48 Price/Earnings Ratio == Stock Price (per share) $81.45 =23.4 (6) Earnings per Share (annual) $3.48 (Ch. 11, p. 523) Using the following income statements, perform the calculations needed for horizontal analyses. Round percentages to one decimal place. LOCKEY FENCING CORPORATION Income Statements For the Years Ended December 31 Current Previous Net Sales $100,000 $75,000 Cost of Goods Sold 58,000 45,000 Gross Profit 42,000 30,000 Selling, General, and Administrative Expenses 9,000 4,500 Income from Operations 33,000 25,500 Interest Expense 3,000 3,750 Income before Income Tax 30,000 21,750 Income Tax Expense 9,000 6,525 Net Income $21,000 $15.225 Calculations for Vertical Analyses Refer to the data from the previous question. Perform the calculations needed for vertical analysis. Round percentages to one decimal place. Interpreting Horizontal Analyses Refer to the calculations from the first question. What are the two most significant year-over-year changes in terms of dollars and in terms of percentages? Give on potential cause of each of these changes. Interpreting Vertical Analyses Refer to the calculations the second question (Calculations for Vertical Analyses. Which of the ratios from Exhibit 13.5 have been included in these calculations? Have these two ratios improved or deteriorated in the current year compared to the previous year? EXHIBIT 13.5 Common Ratios Used in Financial Statement Analysis Profitability Ratios Fiscal 2016 Calculations (1) Net Profit Margin = Net Income Revenues (Ch. 3, p. 117) $3,093 $65,017 = 4.8% $65,017 $42.553 = 34.6% (2) Gross Profit Percentage = Net Sales Cost of Goods Sold Net Sales $65,017 (Ch. 6, p. 275) Fixed Asset Turnover = (3) Net Revenue Average Net Fixed Assets (Ch. 9, p. 414) Return on Equity (ROE) = (4) Net Income-Preferred Dividends Average Common Stockholders' Equity (Ch. 11, p. 523) Earnings per Share (EPS) = (5) Net Income Preferred Dividends Average Number of Common Shares Outstanding (Ch. 11, p. 523) $65,017 $19,949 - $19,577)/2 =3.29 $3,093-$29 ($6,434 - $7,654)/2 = 43.5% $3,093-$29 880 = $3.48 Price/Earnings Ratio == Stock Price (per share) $81.45 =23.4 (6) Earnings per Share (annual) $3.48 (Ch. 11, p. 523)
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-0078025518
2nd edition
Authors: Stacey Whitecotton, Robert Libby, Fred Phillips
Posted Date:
Students also viewed these accounting questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
Revvit is an online motorcycle equipment store that sells motorcycle helmets, boots, jackets, and more. With no brick-and-mortar stores, Revvit relies on many systems to provide an excellent customer...
-
Find I as a function of time for the circuit of Figure 4 assuming that the switch is closed and I = 0 at t = 0 E 120 (~ sin 377t
-
Find the slope of each line. y = 3x - 2
-
Using the data in question 4, Department Xs contribution to overhead as a percentage of sales is a. 20%. c. 12%. e. 32%. b. 30%. d. 48%. Data From Question 4 A company operates three retail...
-
Here are comparative balance sheets for Taguchi Company. Additional information:1. Net income for 2010 was $103,000.2. Cash dividends of $45,000 were declared and paid.3. Bonds payable amounting to...
-
x-4 + 3x+21 Fully simplify the NPV's. x-8x+16 x2 +12x+35 expression below. Don't forget to list your
-
The ratio of mass percent of C and H of an organic compound (CxHyOz) is 6 : 1. If one molecule of the above compound ( CxHyOZ ) contains half as much oxygen as required to burn one molecule of...
-
Provide the PESTEL Analysis of GOTRANSIT Canada in bulleted form and The Ecosystem Assessment Tools of GoTRANSIT Canada?
-
State the FIVE steps in planning personal financial affairs. b) List any THREE financial plans, and identify the goal associated with each financial plan. (c) The following is an extract of Betty...
-
The Sales Manager is unhappy about the Accessories' poor performance. Based on FY21Q3 results, which product would you recommend removing from the range? a. Google Cork Card Holder b. Google PNW...
-
Can you give me quotes and a big analysis on why Sight and Blindness is important in Oedipus Rex Sight and Blindness References to eyesight and vision, both literal and metaphorical, are very...
-
Explain why Exxonmobil Corp and Agrana Group considered a process costing and give me at least 3 scholarly or journal articles for each company.
-
An electronics firm is considering how best to supply the world market for microprocessors used in consumer and industrial electronic products. A manufacturing plant costs approximately $500 million...
-
General Electric Capital, a division of General Electric, uses long-term debt extensively. In a recent year, GE Capital issued $11 billion in long-term debt to investors, then within days filed legal...
-
Using an economic balance sheet, which of the Laws current financial assets is most concerning from an asset allocation perspective? A. Equities B. Real estate C. Fixed income Raye uses a costbenefit...
-
Using the economic balance sheet approach, the Laws economic net worth is closest to: A. $925,000. B. $1,425,000. C. $1,675,000. Raye uses a costbenefit approach to rebalancing and recommends that...
-
Raye believes the previous advisers asset class specifications for equity and derivatives are inappropriate given that, for purposes of asset allocation, asset classes should be: A. diversifying. B....
Study smarter with the SolutionInn App