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 the current I as a function of time for the circuit of Figure 3 if the switch S is closed and I = 0 at t = 0 R= 106 8L-1H
-
The following ratios are available for beverage competitors DAVIDsTEA Inc. and Starbucks Corporation for a recent year: Instructions (a) Which company is more liquid? Explain. (b) Which company is...
-
The following selected accounts and balances appear on the adjusted trial balance for Ray Service, Inc., on December 31, 2010: 1. What is the net income or net loss? 2. What is the change in Retained...
-
Paul Smith is opening a plumbing supply store in University City. He plans to sell plumbing parts and materials to both wholesale and retail customers. Since contractors (wholesale customers) prefer...
-
A client of the firm holds the following shares in an investment portfolio: Ocka Limited $60,000,000 beta 0.9 Techno Limited $40,000,000 beta 1.3 Mega Bank Limited $80,000,000 beta 0.8 a. Explain the...
-
Case Study link: https://hbsp.harvard.edu/tu/b871ff21 Synopsis Priya Paul, chairperson of The Park Hotels, an award-winning portfolio of thirteen boutique hotels scattered across India, was in the...
-
Tracy Company, a manufacturer of air conditioners, sold 1 5 0 units to Thomas Company on November 1 7 , 2 0 2 4 . The units have a list price of $ 7 6 0 each, but Thomas was given a 2 5 % trade...
-
SE Company is trying to calculate the company's cost of capital. It has a capital structure of 45% debt and 55% equity financing. If the before-tax costs of debt and equity are 6% and 10%,...
-
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price Units in beginning inventory $120 0 Units produced...
-
Discuss how quantum computing might revolutionize the field of electrical engineering. What potential applications or advancements do you foresee in power systems, signal processing, or semiconductor...
-
The pole-zero diagram of the longitudinal motion of an airplane is given in Fig. 8 in terms of output angle of attack a and input elevator deflection : -1.0 2.65 *-0.092 -0.043 Figure 8 1) Write down...
-
1) The spectrum of the x(t) signal X(f) is given below. Using the signal x (t) and its Hilbert transform X(t), the signals x1 (t) and x2 (t) are defined as follows. Draw the spectra X1 (f) and X2 (f)...
-
The cash records of Holly Company show the following four situations. 1. The June 30 bank reconciliation indicated that deposits in transit total $720. During July, the general ledger account Cash...
-
Pauls Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 60 percent of their fees...
-
Complete the followingtable: Product A Unit Product B Unit Contribution Margin Weighted-Average Contribution Margin Contribution Margin Product Mix $9.00 2.50 15.75 45.60 S 8.00 4.20 11.90 55.50...
-
Refer to the information in PA9-5 for Bullseye Company. Bullseye has the following actual results for the month of September: Number of units produced and sold ....... 140,000 Number of square feet...
-
True or False. The natural frequency of a system can be changed by varying its damping.
-
An unbalanced flywheel shows an amplitude of \(0.165 \mathrm{~mm}\) and a phase angle of \(15^{\circ}\) clockwise from the phase mark. When a trial weight of magnitude \(50 \mathrm{~g}\) is added at...
-
Fill in the Blank. Laminated structures have ____________ damping.
Study smarter with the SolutionInn App