FIN 333 Some Measures of Profitability and an EVA calculation
docx
School
Stephen F Austin State University *
*We aren’t endorsed by this school
Course
333
Subject
Finance
Date
Apr 27, 2024
Type
docx
Pages
2
Uploaded by DeanTurtleMaster2563
Some Measures of Profitability and an EVA Calculation
The J.M. Smucker reports STATEMENTS OF CONSOLIDATED INCOME
Year Ended April 30,
2018
2017
2016
(Dollars in millions)
Net Sales
7,357.1 7,392.3 7,811.2 Cost of products sold
4,521.0 4,557.0 4,843.4 Gross Profit
2,836.1 2,835.3 2,967.8 Selling, distribution, and administrative expenses
1,370.8 1,390.7 1,510.3 Amortization
206.8 207.3 208.4 Goodwill impairment charge
145.0 Other intangible assets impairment charges
31.9 133.2 Other special project costs
45.4 76.9 135.9 Other operating expense (income) -- net
0.1 (4.3)
(32.1)
Operating Income
1,036.1 1,031.5 1,145.3 Interest expense -- net
(174.1)
(163.1)
(171.1)
Other income (expense) -- net
(1.0)
10.0 3.7 Income Before Income Taxes
861.0 878.4 977.9 Income tax expense (benefit)
(477.6)
286.1 289.2 Net Income
1,338.6 592.3 688.7 In addition, J.M. Smucker reports an effective tax rate in fiscal year 2018 equal to 30.4 percent. The effective tax rate for fiscal year 2017 is equal to 32.6 percent, and the effective tax rate in fiscal year 2016 is equal to 29.6 percent. Also, J.M. Smucker reports total assets on their balance sheet at the end of fiscal year 2018 to equal $15,301.2 million. At the end of fiscal year 2017 total assets on their balance
sheet equals $15,639.7 million. At the end of fiscal year 2016 total assets on their balance sheet equals $15,984.1 million. For the fiscal years ended April 30, 2018, 2017, 2016 the J.M. Smucker Capital Structure looks like this:
2018
2017
2016
(Dollars in millions)
Long-term debt
4,688.0 4,445.5 5,146.0 Shareholders' equity
7,891.1 6,850.2 7,008.5 Total Invested Capital
12,579.1 11,295.7 12,154.5 Questions and answers follow on the next page.
1.
What is the operating margin equal to for the fiscal year ended April 30, 2018?
Operating margin
=
EBIT
Sales
=
1,036.1
7,357.1
=
14.1%
2.
What is the profit margin equal to for the fiscal year ended April 30, 2018?
Profit margin
=
Net Income
Sales
=
1,338.6
7,357.1
=
18.2%
3.
What is the return on total assets (ROA) equal to for the fiscal year ended April 30, 2018?
ROA
=
Net Income
Total assets
=
1,338.6
15,301.2
=
8.7 %
4.
What is the return on invested capital (ROIC) equal to for the fiscal year ended April 30, 2018?
ROIC
=
EBIT
(
1
−
T
)
Debt
+
Equity
=
1,036.1
(
1
−
.304
)
4,688.0
+
7,891.1
=
5.7%
5.
What is the Basic earning power (BEP) ratio equal to for the fiscal year ended April 30, 2018?
BEP
=
EBIT
Total assets
=
1,036.1
15,301.2
=
6.8%
6.
What is the total assets turnover ratio equal to for the fiscal year ended April 30, 2018?
Total assetturnover
=
Sales
Total assets
=
7,357.1
15,301.2
=
0.481
×
¿
7.
What is the equity multiplier equal to for the fiscal year ended April 30, 2018?
Equity multiplier
=
Total assets
Equity
=
15,301.2
7,891.1
=
1.939
×
¿
8.
What is return on equity (ROE) equal to for the fiscal year ended April 30, 2018?
ROE
=
Net Income
Equity
=
(
Profit margin
) (
Total assetturnover
) (
Equity multiplier
)
=
17 %
9.
Assuming that the after-tax cost of capital for Smucker’s is equal to six percent, what is the economic value added (EVA) equal to for the fiscal year ended April 30, 2018?
EVA
=
EBIT
(
1
−
T
)
−
(
Totalinvested capital
) (
Aftertax costof capital
)
EVA
=
$
1036.1
million
(
1
−
.304
)
−
(
$
12,579.1
million
) (
0.06
)
=−
$
33.62
million
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
please explain the result of income statement that provided in image below
arrow_forward
GIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW
JOLLIBEE INCOME STATEMENT
ITEM
2016
2017
2018
2019
2020
Sales/Revenue
113.81B
133.61B
161.17B
179.63B
129.31B
Sales Growth
-
17.40%
20.62%
11.45%
-28.01%
Cost of Goods Sold (COGS) incl. D&A
-
-
132.96B
150.88B
115.39B
COGS Growth
-
-
-
13.47%
-23.52%
COGS excluding D&A
89.27B
105.39B
121.08B
137.38B
100.82B
Depreciation & Amortization Expense
4B
4.75B
11.89B
13.5B
14.57B
Depreciation
3.93B
4.66B
11.73B
13.34B
14.32B
Amortization of Intangibles
68.99M
78.95M
151.82M
145.42M
245.23M
Gross Income
20.54B
23.48B
28.21B
28.75B
13.92B
Gross Income Growth
-
14.30%
20.12%
1.93%
-51.57%
Gross Profit Margin
-
-
-
-
10.77%
SG&A Expense
-
-
17.64B
20.21B
20.42B
SGA Growth
-
-
-
14.57%
1.02%…
arrow_forward
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31, 2019, 2018, and 2017
2019
2018
2017
Sales
$
459,716
$
352,180
$
244,400
Cost of goods sold
276,749
223,282
156,416
Gross profit
182,967
128,898
87,984
Selling expenses
65,280
48,601
32,261
Administrative expenses
41,374
30,992
20,285
Total expenses
106,654
79,593
52,546
Income before taxes
76,313
49,305
35,438
Income tax expense
14,194
10,108
7,194
Net income
$
62,119
$
39,197
$
28,244
KORBIN COMPANY
Comparative Balance Sheets
December 31, 2019, 2018, and 2017
2019
2018
2017
Assets
Current assets
$
58,718
$
39,300
$
52,535
Long-term investments
0
500
4,280
Plant assets, net
109,047
99,561
58,646
Total assets
$
167,765
$
139,361
$
115,461
Liabilities and Equity
Current liabilities
$
24,494…
arrow_forward
Vertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer.
Vertical Analysis
2018
2017
2016
Sales revenue
100.0%
100.0%
100.0%
Cost of goods sold
60.0
63.9
65.0
Expenses
26.0
26.6
27.5
arrow_forward
Mac Donald company reported the following on its comparative income statement:
2017
2018
2019
Revenue
9,000
10,000
14,000
Cost of goods sold
6,000
4,000
9,000
Prepare a horizontal analysis of revenue , cost of goods sold and gross profit
arrow_forward
Gross Profit ℅?
arrow_forward
What is the impact on retained earnings each year?
arrow_forward
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?
arrow_forward
Refer to the following mentioned data.
Net sales
Cost of products sold
Gross margin
(In millions)
2017
2016
$34,954 $30, 040
14,274
13, 395
$20, 680
$16, 645
2017
2016
2015
Required:
a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.)
2015
$26, 091
13, 655
$12, 436
59.16 %
55.41 %
47.66 %
arrow_forward
Refer to the following mentioned data.
Net sales
Cost of products sold
Gross margin
2017
2016
2015
Required:
a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2
decimal places.)
(In millions)
2016
2017
2015
$34,894
$30,411
$26,113
14,318
13,376
13,767
$20,576 $17,035 $12,346
Cost of goods sold
Gross profit
58.94 %
%
%
b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.79 billion.
Calculate an estimated cost of goods sold and gross profit for the four months, using the gross
profit ratio for 2017. (Round Intermediate calculations to 2 decimal places. Enter your answers
in millions rounded to nearest whole number (1.e., 5,000,000 should be entered as 5).)
million
million
arrow_forward
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2017 and 2018
2018
2017
Gross sales
$
22,600
$
17,700
Sales returns and allowances
1,000
100
Net sales
$
21,600
$
17,600
Cost of merchandise (goods) sold
11,100
7,800
Gross profit
$
10,500
$
9,800
Operating expenses:
Depreciation
$
1,060
$
780
Selling and administrative
4,900
3,800
Research
910
680
Miscellaneous
720
480
Total operating expenses
$
7,590
$
5,740
Income before interest and taxes
$
2,910
$
4,060
Interest expense
920
680
Income before taxes
$
1,990
$
3,380
Provision for taxes
796
1,352
Net income
$
1,194
$
2,028
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2017 and 2018
2018
2017
Assets
Current assets:
Cash
$…
arrow_forward
10: Application of Financial Ratios Used to Measure Profitability
The income statement of Garnet Mfg. Corp. for 2018 shows the following:
Sales, net
P 700,000
15,000
400,000
Net credit sales
Cost of goods sold
Cost of goods manufactured
Net credit purchases
410,000
150,000
225,000
90,000
212,500
20,000
Raw materials used
Net income
Total operating expenses
Depreciation
Net income
90,000
The balance sheet figures as of December 31, 2017 and 2018 are as follows:
December 31
2017
2018
P12,500
P 25,000
Cash
17,500
28,750
Marketable securities
10,000
20,000
Accounts receivable, net
Inventories:
25,000
35,000
Finished goods
Work in process
22,500
15,000
3,750
P 150,000
37,500
17,500
10,000
Raw materials
Prepaid expenses
Total current assets
2,500
P95,000
37,500
Investments
117,500
187,500
Plant, property and equipment, net
arrow_forward
Current Attempt in Progress
The comparative statements of Pharoah Company are presented here.
Pharoah Company
Income Statements
For the Years Ended December 31
Net sales
Cost of goods sold
Gross profit
Selling and administrative expenses
Income from operations
Other expenses and losses
Interest expense
Income before income taxes
Income tax expense
Net income
2025
$2,104,400
1,167,000
937,400
570.000
367,400
25.080
342,320
102,696
$239,624
2024
$1,960,000
1,146.840
813,160
546,060
267.100
22,800
244.300
73,290
$171.010
Assets
Current assets
Cash
Debt investments (short-term)
Accounts receivable (net)
Inventory
Total current assets
Plant assets (net)
Total assets
Pharoah Company
Balance Sheets
December 31
Liabilities and Stockholders' Equity.
Current liabilities
Accounts payable
Income taxes payable
Total current liabilities
Bonds payable
Total liabilities
Stockholders' equity
2025
$68,514
84,360
134,292
143,640
430,806
739,860
$1,170,666
$182,400
49,590
231,990
250,800
482,790
2024…
arrow_forward
please help me solve
arrow_forward
Calculate the gross profit percentage
arrow_forward
Selected comparative financial statements of Haroun Company follow.
HAROUN COMPANY
Comparative Income Statements
For Years Ended December 31, 2021–2015
($ thousands) 2021 2020 2019 2018 2017 2016 2015
Sales $ 2,260 $ 1,979 $ 1,801 $ 1,651 $ 1,540 $ 1,432 $ 1,174
Cost of goods sold 1,625 1,322 1,137 995 925 865 689
Gross profit 635 657 664 656 615 567 485
Operating expenses 483 378 347 256 222 219 182
Net income $ 152 $ 279 $ 317 $ 400 $ 393 $ 348 $ 303
HAROUN COMPANY
Comparative Year-End Balance Sheets
December 31, 2021–2015
($ thousands) 2021 2020 2019 2018 2017 2016 2015
Assets
Cash $ 111 $ 147 $ 153 $ 156 $ 162 $ 160 $ 165
Accounts receivable, net 800 840 760 583 514 487 343
Merchandise inventory 2,893 2,106 1,840 1,551 1,393 1,183 858
Other current assets 74 67 41 74 62 63 33
Long-term investments 0 0 0 228 228 228 228
Plant assets, net 3,541 3,527 3,086 1,740 1,799 1,599 1,373
Total assets $ 7,419 $ 6,687 $ 5,880 $ 4,332 $ 4,158 $ 3,720 $ 3,000
Liabilities and…
arrow_forward
Superior electronic reported sales solve this accounting questions
arrow_forward
Need help this question general accounting
arrow_forward
horizontal analysis
arrow_forward
Finding Correct Answer
arrow_forward
Use the following tables to answer the question:
LOGIC COMPANY Income Statement For years ended December 31, 2016 and 2017
(values in $) 2016 2017
Gross sales 19,800 15,600
Sales returns and allowances 900 100
Net sales 18,900 15,500
COGS 11,800 8,800
Gross profit 7,100 6,700
Depreciation 780 640
Selling and administrative expenses 2,800 2,400
Research 630 540
Miscellaneous 440 340
Total operating expenses 4,650 3,920
Income before interest and taxes 2,450 2,780
Interest expense 640 540
Income before taxes 1,810 2,240
Provision for taxes 724 896
LOGIC COMPANY Balance Sheet For years ended December 31, 2016 and 2017
(values in $) 2016 2017
Current assets 12,300 9,400
Accounts receivable 16,900 12,900
Merchandise inventory 8,900 14,400
Prepaid expenses 24,400 10,400
Total current assets 62,500 47,100
Building (net) 14,900 11,400
Land 13,900 9,400
Total plant and equipment 28,800 20,800
Total assets 91,300 67,900
Accounts payable 13,400 7,400
Salaries payable 7,500 5,400
Total current…
arrow_forward
Performing horizontal analysis
Verifine Corp reported the following on its comparative income statementPrepare a horizontal analysis of revenues and gross profit-both in dollar amounts and in percentages-for 2019 and 2018.
arrow_forward
Selected comparative financial statements of Haroun Company follow.
HAROUN COMPANY
Comparative Income Statements
For Years Ended December 31, 2021–2015
($ thousands)
2021
2020
2019
2018
2017
2016
2015
Sales
$ 2,272
$ 1,989
$ 1,810
$ 1,659
$ 1,548
$ 1,440
$ 1,180
Cost of goods sold
1,634
1,329
1,143
1,001
930
870
693
Gross profit
638
660
667
658
618
570
487
Operating expenses
486
380
349
257
223
220
183
Net income
$ 152
$ 280
$ 318
$ 401
$ 395
$ 350
$ 304
HAROUN COMPANY
Comparative Year-End Balance Sheets
December 31, 2021–2015
($ thousands)
2021
2020
2019
2018
2017
2016
2015
Assets
Cash
$ 85
$ 113
$ 117
$ 120
$ 124
$ 123
$ 127
Accounts receivable, net
613
644
583
447
394
373
263
Merchandise inventory
2,218
1,615
1,411
1,189
1,068
907
658
Other current assets
57
51
32
56
48
48
25
Long-term investments
0
0
0
175
175
175
175
Plant assets, net
2,715
2,704
2,365
1,334
1,379
1,226
1,052
Total assets
$ 5,688
$ 5,127
$ 4,508
$ 3,321…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- please explain the result of income statement that provided in image belowarrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardKORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales $ 459,716 $ 352,180 $ 244,400 Cost of goods sold 276,749 223,282 156,416 Gross profit 182,967 128,898 87,984 Selling expenses 65,280 48,601 32,261 Administrative expenses 41,374 30,992 20,285 Total expenses 106,654 79,593 52,546 Income before taxes 76,313 49,305 35,438 Income tax expense 14,194 10,108 7,194 Net income $ 62,119 $ 39,197 $ 28,244 KORBIN COMPANY Comparative Balance Sheets December 31, 2019, 2018, and 2017 2019 2018 2017 Assets Current assets $ 58,718 $ 39,300 $ 52,535 Long-term investments 0 500 4,280 Plant assets, net 109,047 99,561 58,646 Total assets $ 167,765 $ 139,361 $ 115,461 Liabilities and Equity Current liabilities $ 24,494…arrow_forward
- Vertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer. Vertical Analysis 2018 2017 2016 Sales revenue 100.0% 100.0% 100.0% Cost of goods sold 60.0 63.9 65.0 Expenses 26.0 26.6 27.5arrow_forwardMac Donald company reported the following on its comparative income statement: 2017 2018 2019 Revenue 9,000 10,000 14,000 Cost of goods sold 6,000 4,000 9,000 Prepare a horizontal analysis of revenue , cost of goods sold and gross profitarrow_forwardGross Profit ℅?arrow_forward
- What is the impact on retained earnings each year?arrow_forwardPerforming 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?arrow_forwardRefer to the following mentioned data. Net sales Cost of products sold Gross margin (In millions) 2017 2016 $34,954 $30, 040 14,274 13, 395 $20, 680 $16, 645 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) 2015 $26, 091 13, 655 $12, 436 59.16 % 55.41 % 47.66 %arrow_forward
- Refer to the following mentioned data. Net sales Cost of products sold Gross margin 2017 2016 2015 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) (In millions) 2016 2017 2015 $34,894 $30,411 $26,113 14,318 13,376 13,767 $20,576 $17,035 $12,346 Cost of goods sold Gross profit 58.94 % % % b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.79 billion. Calculate an estimated cost of goods sold and gross profit for the four months, using the gross profit ratio for 2017. (Round Intermediate calculations to 2 decimal places. Enter your answers in millions rounded to nearest whole number (1.e., 5,000,000 should be entered as 5).) million millionarrow_forwardLOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2017 and 2018 2018 2017 Gross sales $ 22,600 $ 17,700 Sales returns and allowances 1,000 100 Net sales $ 21,600 $ 17,600 Cost of merchandise (goods) sold 11,100 7,800 Gross profit $ 10,500 $ 9,800 Operating expenses: Depreciation $ 1,060 $ 780 Selling and administrative 4,900 3,800 Research 910 680 Miscellaneous 720 480 Total operating expenses $ 7,590 $ 5,740 Income before interest and taxes $ 2,910 $ 4,060 Interest expense 920 680 Income before taxes $ 1,990 $ 3,380 Provision for taxes 796 1,352 Net income $ 1,194 $ 2,028 LOGIC COMPANY Comparative Balance Sheet December 31, 2017 and 2018 2018 2017 Assets Current assets: Cash $…arrow_forward10: Application of Financial Ratios Used to Measure Profitability The income statement of Garnet Mfg. Corp. for 2018 shows the following: Sales, net P 700,000 15,000 400,000 Net credit sales Cost of goods sold Cost of goods manufactured Net credit purchases 410,000 150,000 225,000 90,000 212,500 20,000 Raw materials used Net income Total operating expenses Depreciation Net income 90,000 The balance sheet figures as of December 31, 2017 and 2018 are as follows: December 31 2017 2018 P12,500 P 25,000 Cash 17,500 28,750 Marketable securities 10,000 20,000 Accounts receivable, net Inventories: 25,000 35,000 Finished goods Work in process 22,500 15,000 3,750 P 150,000 37,500 17,500 10,000 Raw materials Prepaid expenses Total current assets 2,500 P95,000 37,500 Investments 117,500 187,500 Plant, property and equipment, netarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning