Last year, Stevens Inc. had sales of $400,000 with a cost of goods sold of $112,000....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Last year, Stevens Inc. had sales of $400,000 with a cost of goods sold of $112,000. The firm's operating expenses were $130,000, and its increase in retained earnings was $58,000. There are currently 22,000 common stock shares outstanding and the firm pays a $1.60 dividend per share. Assuming the firm's earnings are taxed at 21 percent, construct the firm's income statement. b. Compute the firm's operating profit margin. 4. What was the times interest earned? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest 5 appearance of the data in your formulas, usually the Given Data section. 6 DATA 7 Sales Cost of goods sold 9 Operating expenses 10 Increase in retained earnings II Common stock outstanding 12 Dividend per share 13 Tax rate 14 15 SOLUTION Assuming the firm's earnings are taxed at 21 percent, construct the firm's income 16 statement. 17 18 Income Statement: 19 Net sales 20 Cost of goods sold 21 Gross profit 22 Operating expenses 23 Operating income 24 Interest expense 25 Income before taxes 26 Tax 27 Net income 28 29 b. Compute the firm's operating profit margin. 30 $400,000 112,000 130,000 58,000 31 Operating profit margin 32 33 e. What was the times interest earned? 34 35 Times interest earned 36 22,000 shares $1.60 21% $400,000 112,000 $288,000 130,000 $158.000 Last year, Stevens Inc. had sales of $400,000 with a cost of goods sold of $112,000. The firm's operating expenses were $130,000, and its increase in retained earnings was $58,000. There are currently 22,000 common stock shares outstanding and the firm pays a $1.60 dividend per share. Assuming the firm's earnings are taxed at 21 percent, construct the firm's income statement. b. Compute the firm's operating profit margin. 4. What was the times interest earned? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest 5 appearance of the data in your formulas, usually the Given Data section. 6 DATA 7 Sales Cost of goods sold 9 Operating expenses 10 Increase in retained earnings II Common stock outstanding 12 Dividend per share 13 Tax rate 14 15 SOLUTION Assuming the firm's earnings are taxed at 21 percent, construct the firm's income 16 statement. 17 18 Income Statement: 19 Net sales 20 Cost of goods sold 21 Gross profit 22 Operating expenses 23 Operating income 24 Interest expense 25 Income before taxes 26 Tax 27 Net income 28 29 b. Compute the firm's operating profit margin. 30 $400,000 112,000 130,000 58,000 31 Operating profit margin 32 33 e. What was the times interest earned? 34 35 Times interest earned 36 22,000 shares $1.60 21% $400,000 112,000 $288,000 130,000 $158.000
Expert Answer:
Answer rating: 100% (QA)
Solution Income Statement Sales Cost of goods sold opera... View the full answer
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these accounting questions
-
What are the times interest earned ratio?
-
what is the Times Interest Earned ratio?
-
The Taylor Company Limited reported a cost of goods sold of $640,000 last year, when 20,000 units were produced and sold. The cost of goods sold was 35% materials, 42% direct labour, and 23%...
-
A cylindrical rod of steel (E =207 GPa, 30 106 psi) having a yield strength of 310 MPa (45,000 psi) is to be subjected to a load of 11,100 N (2500 lbf). If the length of the rod is 500 mm (20.0...
-
Construct an amortization schedule for a four-year, $10,000 loan at 6% interest compounded annually.
-
A group of new machines was purchased on February 17, 2021, under a royalty agreement with the following terms: The purchaser, Keller Corp., is to pay a royalty of $1 to the machinery supplier for...
-
Consider the regression model fit to the baseball data in Table B.22, using team ERA to predict the number of wins. a. Construct a normal probability plot of the residuals. Is there any indication of...
-
1. Advise Sara on whether she is really learning some valuable lessons as a potential manager. 2. What should Sara tell Johnny on her review of her experiences? 3. Which managerial roles has Sara...
-
A company is expected to pay its first dividend in the amount of $2 a share 7 years from today. The dividend in year 8 will be $2.25 a share and the dividend in year 9 will be $2.50 a share, after...
-
Pathfinder College is a small liberal arts college that wants to improve its admissions process. In particular, too many of its incoming freshmen have failed to graduate for a variety of reasons,...
-
An record company wants to employ personnel to create songs for persons under its label to record and perform. As a result, the record company has decided that it needs to onboard a composer. The...
-
1 M AC AB Determine: LA, QB. FAC Griven: MA = MB = 9kg CA = B = 0.25m KA K = KB = 0.2m Me= 3kg rc = Oolm Ke= 0.075m M. 5 Nm
-
Oil used to lubricate the surfaces of a rotating bearing behaves such that viscous dissipation is not negligible. The properties of the oil are assumed to be constant. The problem can be modelled as...
-
7. Which one of the following is true about age-hardenable 2000-series aluminium alloys? A. The increase in strength associated with the ageing heat-treatment is due to diffusion of the alloy element...
-
The concentrated force applied at the free end of the cantilever is 400 kN. What is the bending stress at point A located at 100 mm from the bottom at section a-a? -0.5 m- a a 400 KN -0.5 m- 11 100...
-
An industrial operation is working with 70 % capacity. The annual variable production cost is 140 000 $. Total annual fixed cost is 100 000 $. If the unit selling price of the product is 20 $ and...
-
Office Automation is obliged to choose between two copiers: A and B. The economic lives of these copiers are different. The costs and maintenance expenses of these copiers are given below in real...
-
Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...
-
A companys financial statements consist of the balance sheet, income statement, and statement of cash flows. Describe what each statement tells us.
-
Identify the primary characteristics of each form of legal organization. (a) sole proprietor (b) partnership (c) Corporation
-
What is the relationship between financial decision making and risk and return? Would all financial managers view risk return trade- offs similarly?
-
Figure 5 shows a scatterplot for the variables number of farms and mean farm size in the United States. Each dot represents data from a single year between 1950 and 2000; on this diagram, the earlier...
-
Youve conducted a study to determine how the number of calories a person consumes in a day correlates with time spent in vigorous bicycling. Your sample consisted of ten women cyclists, all of...
-
The scatterplots in Figure 6 show two weeks of data comparing the actual high temperature for the day with the same-day forecast (part a) and the three-day forecast (part b). Estimate the correlation...
Study smarter with the SolutionInn App