GeneralMills_Topic12_FinalAdjustmentsExcelSensitivity
xlsx
keyboard_arrow_up
School
Utah Valley University *
*We aren’t endorsed by this school
Course
3300
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
77
Uploaded by JudgeViper3976
General Mills
GIS
Amounts in millions
Assigned
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Assets
Current assets
Cash and cash equivalents
Split
334.2 763.7 766.1 399.0 Receivables
Operating
1,386.7 1,360.8 1,430.1 1,684.2 Inventories
Operating
1,540.9 1,413.7 1,483.6 1,642.2 Prepaid expenses and other current assets
Operating
423.8 399.0 381.6 398.3 fn
Total current assets
3,685.6 3,937.2 4,061.4 4,123.7 Land, buildings, and equipment
Operating
3,783.3 3,743.6 3,687.7 4,047.2 Goodwill
Operating
8,874.9 8,741.2 8,747.2 14,065.0 Other intangible assets
Operating
4,677.0 4,538.6 4,530.4 7,445.1 fn
Other assets
Operating
811.2 751.7 785.9 943.0 fn
Total assets
21,832.0 21,712.3 21,812.6 30,624.0 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
(1,684.0) (2,046.5) (2,119.8) (2,746.2)
Current portion of long-term debt
Financial
(1,000.4) (1,103.4) (604.7) (1,600.1)
Notes payable
Financial
(615.8) (269.8) (1,234.1) (1,549.8)
Other current liabilities
Operating
(1,589.9) (1,595.0) (1,372.2) (1,445.8)
fn
Total current liabilities
(4,890.1) (5,014.7) (5,330.8) (7,341.9)
Long-term debt
Financial
(7,575.3) (7,057.7) (7,642.9) (12,668.7)
Deferred income taxes
Operating
(1,450.2) (1,399.6) (1,719.4) (2,003.8)
fn
Other liabilities
Operating
(1,744.8) (2,087.6) (1,523.1) (1,341.0)
fn
Redeemable interest
Financial
(778.9) (845.6) (910.9) (776.2)
Total liabilities
(16,439.3) (16,405.2) (17,127.1) (24,131.6)
Shareholders' equity
Common stock - $0.10 par value
Equity
(75.5) (75.5) (75.5) (75.5)
Additional paid-in capital
Equity
(1,296.7) (1,177.0) (1,120.9) (1,202.5)
Retained earnings
Equity
(11,990.8) (12,616.5) (13,138.9) (14,459.6)
Common stock in treasury, at cost
Equity
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
Equity
2,310.7 2,612.2 2,244.5 2,429.0 Noncontrolling interests
Financial
(396.0) (376.9) (357.6) (351.3)
Total shareholders' equity
(5,392.7) (5,307.1) (4,685.5) (6,492.4)
Total liabilities and shareholders' equity
(21,832.0) (21,712.3) (21,812.6) (30,624.0)
Sanity checks:
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Common shareholders' equity
Common stock - $0.10 par value
(75.5) (75.5) (75.5) (75.5)
Additional paid-in capital
(1,296.7) (1,177.0) (1,120.9) (1,202.5)
Retained earnings
(11,990.8) (12,616.5) (13,138.9) (14,459.6)
Common stock in treasury, at cost
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
2,310.7 2,612.2 2,244.5 2,429.0 (4,996.7) (4,930.2) (4,327.9) (6,141.1)
Free cash flows to equity holders
Cash dividends declared
1,071.7 1,135.1 1,139.7 Shares purchased
606.7 1,651.5 601.6 Shares issued
- - (969.9)
Stock compensation plans
(289.4) (218.8) (130.1)
Unearned compensation related to stock unit awards
63.3 78.5 58.1 Earned compensation
(84.8) (94.9) (77.0)
Increase (decrease) in redemption value of redeemable interest
91.5 75.9 (159.7)
Acquisition of interest in subsidiary
3.4 0.2 - - 1,462.4 2,627.5 462.7
Clean surplus relation:
Beginning common shareholders' equity
(4,996.7) (4,930.2) (4,327.9)
Comprehensive (income) loss attributable to General Mills
(1,395.9) (2,025.2) (2,275.9)
Free cash flows to equity holders
1,462.4 2,627.5 462.7 Ending common shareholders' equity
(4,996.7) (4,930.2) (4,327.9) (6,141.1)
Checks:
Balance sheet in balance
- - - - Common shareholders' equity balance
- - - -
General Mills
Amounts in millions
Assigned
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Net sales
Operating
17,630.3 16,563.1 15,619.8 15,740.4 Cost of sales
Operating
(10,733.6) (10,056.0) (10,312.9)
Selling, general, and administrative expenses
Operating
(3,118.9) (2,801.3) (2,752.6)
Divestitures (loss) gain
Operating
148.2 (13.5) - Restructuring, impairment, and other exit costs
Operating
(151.4) (182.6) (165.6)
Operating profit
2,707.4 2,566.4 2,509.3 Interest expense
Financial
(303.8) (295.1) (373.7)
Earnings before income taxes and after-tax earnings from joint ventures
2,403.6 2,271.3 2,135.6 Income taxes
Split
(755.2) (655.2) (57.3)
After-tax earnings from joint ventures
Operating
88.4 85.0 84.7 Net earnings, including earnings attributable to redeemable and noncontrolling interests
1,736.8 1,701.1 2,163.0 Net earnings attributable to redeemable and noncontrolling interests
Financial
(39.4) (43.6) (32.0)
Net earnings attributable to General Mills
1,697.4 1,657.5 2,131.0 Comprehensive income items:
Foreign currency translation
Operating
(108.7) 6.3 (37.0)
Net actuarial income (loss)
Financial
(325.9) 197.9 140.1 Other fair value changes: Securities
Financial
0.1 0.8 1.2 Other fair value changes: Hedge deriviatives
Operating
16.0 53.3 (50.8)
Reclassification to earnings: Securities
Financial
- - (5.1)
Reclassification to earnings: Hedge deriviatives
Operating
(9.5) (25.7) 17.4 Reclassification to earnings: Amortization of losses and prior service costs
Financial
128.6 122.5 117.6 Other comprehensive income attributable to noncontrolling interests, net
Financial
(2.1) 12.6 (38.5)
Comprehensive income attributable to General Mills
1,395.9 2,025.2 2,275.9
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
General Mills
From
Amounts in millions
Reported
5/31/2015
5/29/2016
Assets
Current assets
Cash and cash equivalents
Split
334.2 331.3 Receivables
Operating
1,386.7 1,360.8 Inventories
Operating
1,540.9 1,413.7 Prepaid expenses and other current assets
Operating
423.8 399.0 Total current assets
Land, buildings, and equipment
Operating
3,783.3 3,743.6 Goodwill
Operating
8,874.9 8,741.2 Other intangible assets
Operating
4,677.0 4,538.6 Other assets
Operating
811.2 751.7 Total assets
21,832.0 21,279.9 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
(1,684.0)
(2,046.5)
Current portion of long-term debt
Financial
Notes payable
Financial
Other current liabilities
Operating
(1,589.9)
(1,595.0)
Total current liabilities
Long-term debt
Financial
Deferred income taxes
Operating
(1,450.2)
(1,399.6)
Other liabilities
Operating
(1,744.8)
(2,087.6)
Redeemable interest
Financial
Total liabilities
Shareholders' equity
Common stock - $0.10 par value
Equity
Additional paid-in capital
Equity
Retained earnings
Equity
Common stock in treasury, at cost
Equity
Accumulated other comprehensive income/(loss)
Equity
Noncontrolling interests
Financial
Total shareholders' equity
Total liabilities and shareholders' equity
(6,468.9)
(7,128.7)
NOA based on as Reported
15,363.1 14,151.2 5/31/2015
5/29/2016
Assets
Current assets
Cash and cash equivalents
Split
- 432.4
Receivables
Operating Inventories
Operating Prepaid expenses and other current assets
Operating Total current assets
Land, buildings, and equipment
Operating Goodwill
Operating Other intangible assets
Operating Other assets
Operating Total assets
- 432.4 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating Current portion of long-term debt
Financial
(1,000.4) (1,103.4)
Notes payable
Financial
(615.8) (269.8)
Other current liabilities
Operating Total current liabilities
Long-term debt
Financial
(7,575.3) (7,057.7)
Deferred income taxes
Operating Other liabilities
Operating Redeemable interest
Financial
(778.9) (845.6)
Total liabilities
Shareholders' equity
Common stock - $0.10 par value
Equity
Additional paid-in capital
Equity
Retained earnings
Equity
Common stock in treasury, at cost
Equity
Accumulated other comprehensive income/(loss)
Equity
Noncontrolling interests
Financial
(396.0) (376.9)
Total shareholders' equity
Total liabilities and shareholders' equity
(10,366.4) (9,653.4)
NFL based on as Reported
(10,366.4) (9,221.0)
Checks:
Net of NOA - NFL
4,996.7 4,930.2 Difference between check figure and CSE from BS reported
- -
5/28/2017
5/27/2018
312.4 314.8 1,430.1 1,684.2 1,483.6 1,642.2 381.6 398.3 3,687.7 4,047.2 8,747.2 14,065.0 4,530.4 7,445.1 785.9 943.0 21,358.9 30,539.8 (2,119.8)
(2,746.2)
(1,372.2)
(1,445.8)
(1,719.4)
(2,003.8)
(1,523.1)
(1,341.0)
(6,734.5)
(7,536.8)
14,624.4 23,003.0 5/28/2017
5/27/2018
453.7 84.2
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
453.7 84.2 (604.7) (1,600.1)
(1,234.1) (1,549.8)
(7,642.9) (12,668.7)
(910.9) (776.2)
(357.6) (351.3)
(10,750.2) (16,946.1)
(10,296.5) (16,861.9)
4,327.9 6,141.1 - -
Assumed current marginal tax rate:
35.0%
Assumed future marginal tax rate as of May 1:
35.0%
General Mills
From
Amounts in millions
Reported
5/29/2016
Net sales
Operating
16,563.1 Cost of sales
Operating
(10,733.6)
Selling, general, and administrative expenses
Operating
(3,118.9)
Divestitures (loss) gain
Operating
148.2 Restructuring, impairment, and other exit costs
Operating
(151.4)
Operating profit
Interest expense
Financial
Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
(861.5)
After-tax earnings from joint ventures
Operating
88.4 Net earnings, including earnings attributable to redeemable and noncontrolling inte
Net earnings attributable to redeemable and noncontrolling interests
Financial
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
(108.7)
Net actuarial income (loss)
Financial
Other fair value changes: Securities
Financial
Other fair value changes: Hedge deriviatives
Operating
16.0 Reclassification to earnings: Securities
Financial
Reclassification to earnings: Hedge deriviatives
Operating
(9.5)
Reclassification to earnings: Amortization of losses and prior service costs
Financial
Other comprehensive income attributable to noncontrolling interests, net
Financial
Comprehensive income attributable to General Mills
NOPAT from as Reported
1,832.1 5/29/2016
Net sales
Operating
Cost of sales
Operating
Selling, general, and administrative expenses
Operating
Divestitures (loss) gain
Operating
Restructuring, impairment, and other exit costs
Operating
Operating profit
Interest expense
Financial
(303.8)
Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
106.3
After-tax earnings from joint ventures
Operating
Net earnings, including earnings attributable to redeemable and noncontrolling inte
Net earnings attributable to redeemable and noncontrolling interests
Financial
(39.4)
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
Net actuarial income (loss)
Financial
(325.9)
Other fair value changes: Securities
Financial
0.1 Other fair value changes: Hedge deriviatives
Operating
Reclassification to earnings: Securities
Financial
0.0 Reclassification to earnings: Hedge deriviatives
Operating
Reclassification to earnings: Amortization of losses and prior service costs
Financial
128.6 Other comprehensive income attributable to noncontrolling interests, net
Financial
(2.1)
Comprehensive income attributable to General Mills
FEAT from as Reported
(436.2)
Checks:
Comprehensive Income attributable to GIS from above
1,395.9 Difference from comprehensive income attrib to GIS from IS Reported
0.0
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
35.0%
29.4%
21.0%
21.0%
5/28/2017 5/27/2018
15,619.8 15,740.4 (10,056.0) (10,312.9)
(2,801.3)
(2,752.6)
(13.5)
0.0 (182.6)
(165.6)
(758.5)
(167.2)
85.0 84.7 6.3 (37.0)
53.3 (50.8)
(25.7)
17.4 1,926.8 2,356.4 5/28/2017 5/27/2018
(295.1)
(373.7)
103.3 109.9
(43.6)
(32.0)
197.9 140.1 0.8 1.2 0.0 (5.1)
122.5 117.6 12.6 (38.5)
98.4 (80.5)
2,025.2 2,275.9 0.0 0.0
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Footnote 6:
Goodwill:
North America Retail
6,546.2 6,410.3 6,406.5 6,410.6 Pet
- - - 5,294.9 Convenience Stores & Foodservice
921.1 921.1 918.8 918.8 Europe & Australia
719.1 716.5 700.8 729.9 Asia & Latin America
287.0 287.1 312.4 285.0 Joint Ventures
401.5 406.2 408.7 425.8 8,874.9 8,741.2 8,747.2 14,065.0 Other intangible assets:
Brands and other indefinite-lived intangibles
4,262.1 4,147.5 4,161.1 6,818.7 Franchise agreements, customer relationships, and other
544.0 536.9 524.8 811.7 Accumulated amortization
(129.1) (145.8) (155.5) (185.3)
4,677.0 4,538.6 4,530.4 7,445.1 Footnote 8:
Notes payable:
US commercial paper
432.0 - 954.7 1,213.5 Financial institutions
183.8 269.8 279.4 336.3 615.8 269.8 1,234.1 1,549.8 Footnote 13:
Funded status:
Defined benefit pension plans:
Benefit obligation
(6,252.1) (6,448.5) (6,458.6) (6,416.0)
Plan assets
5,758.5 5,539.9 5,925.2 6,177.4 (493.6) (908.6) (533.4) (238.6)
Other postretirement benefit plans:
Benefit obligation
(1,079.6) (1,028.9) (951.4) (871.8)
Plan assets
582.8 602.4 694.8 726.1 (496.8) (426.5) (256.6) (145.7)
Postemployment benefit plans:
Benefit obligation
(146.6) (164.1) (134.5) (126.7)
(146.6) (164.1) (134.5) (126.7)
(1,137.0) (1,499.2) (924.5) (511.0)
Net periodic benefit expense:
Defined benefit pension plans:
Service cost
137.0 134.6 119.7 102.9 Interest cost
249.2 267.8 216.5 217.9 Expected return on plan assets
(476.4) (496.9) (486.7) (480.2)
Amortization of losses
141.7 189.8 190.2 177.0 Amortization of prior service cost
7.4 4.7 2.5 1.9
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
Other adjustments
15.1 5.0 3.1 - Settlements or curtailment losses
18.0 13.1 3.8 - 92.0 118.1 49.1 19.5 Other postretirement benefit plans:
Service cost
22.4 19.0 12.5 11.6 Interest cost
46.9 44.1 32.2 30.1 Expected return on plan assets
(40.2) (46.2) (48.5) (52.2)
Amortization of losses
4.9 6.6 2.5 0.8 Amortization of prior service cost
(1.6) (5.4) (5.4) (5.4)
Other adjustments
3.3 2.3 1.3 - Settlements or curtailment losses
1.3 (1.0) (0.9) - 37.0 19.4 (6.3) (15.1)
Postemployment benefit plans:
Service cost
7.5 7.6 8.8 8.6 Interest cost
4.3 3.9 2.6 2.3 Amortization of losses
0.7 0.7 1.7 0.8 Amortization of prior service cost
2.4 2.5 0.6 0.6 Other adjustments
9.5 10.7 1.3 6.7 Settlements or curtailment losses
- - (1.4) - 24.4 25.4 13.6 19.0 153.4 162.9 56.4 23.4 Defined contribution plan expense
44.0 61.2 54.1 49.2 Footnote 14:
Effective income tax rate
33.3%
31.4%
28.8%
2.7%
Deferred tax assets:
Accrued liabilities
98.0 89.9 70.0 47.2 Compensation and employee benefits
536.2 491.5 419.2 210.2 Unrealized hedges
0.8 - - - Pension
169.0 322.0 196.3 57.1 Tax credit carryforwards
5.6 4.5 18.4 7.4 Stock, partnership, and miscellaneous investments
384.1 353.6 276.4 147.9 Capital losses
6.1 14.5 29.8 12.9 Net operating losses
89.3 97.9 109.5 161.2 Other
74.5 84.1 85.6 52.9 Valuation allowance
(215.4) (227.0) (231.8) (176.0)
1,148.2 1,231.0 973.4 520.8 Deferred tax liabilities:
Brands
(1,346.3) (1,311.7) (1,310.1) (1,498.7)
Fixed assets
(446.5) (476.3) (484.5) (329.5)
Intangible assets
(208.4) (221.8) (238.6) (255.1)
Tax lease transactions
(50.8) (48.0) (45.8) (26.0)
Inventories
(59.7) (53.0) (60.0) (38.8)
Stock, partnership, and miscellaneous investments
(472.5) (476.0) (479.4) (317.1)
Unrealized hedges
- (22.6) (45.4) (28.5)
Other
(14.2) (21.2) (29.0) (30.9)
(2,598.4) (2,630.6) (2,692.8) (2,524.6)
(1,450.2) (1,399.6) (1,719.4) (2,003.8)
Footnote 16:
Net sales:
North America retail
11,612.1 10,936.6 10,196.9 10,115.4 Convenience stores & foodservice
1,995.1 1,923.8 1,870.0 1,930.2 Europe & Australia
2,126.5 1,998.0 1,824.5 1,984.6 Asia & Latin America
1,896.6 1,704.7 1,728.4 1,710.2 17,630.3 16,563.1 15,619.8 15,740.4 Footnote 17:
Receivables:
Customers
1,412.0 1,390.4 1,454.4 1,712.6 Allowance for doubtful accounts
(25.3) (29.6) (24.3) (28.4)
1,386.7 1,360.8 1,430.1 1,684.2 Inventories:
Raw materials and packaging
390.8 397.3 395.4 400.0 Finished goods
1,268.6 1,163.1 1,224.3 1,364.2 Grain
95.7 72.6 73.0 91.2 Excess of FIFO over LIFO cost
(214.2) (219.3) (209.1) (213.2)
1,540.9 1,413.7 1,483.6 1,642.2 Prepaid expenses and other current assets:
Other receivables
148.8 159.3 163.7 174.4 Prepaid expenses
169.3 177.9 168.9 165.6 Derivative receivables, primarily commodity-related
80.9 44.6 35.0 40.5 Grain contracts
3.3 1.8 2.7 7.1 Miscellaneous
21.5 15.4 11.3 10.7 423.8 399.0 381.6 398.3 Land, buildings, and equipment:
Land
96.0 92.9 79.8 77.7 Buildings
2,272.7 2,236.0 2,249.2 2,396.3 Buildings under capital lease
0.3 0.3 0.3 0.3 Equipment
6,091.1 5,945.6 6,095.9 6,236.6 Equipment under capital lease
9.8 3.0 3.0 5.8 Capitalized software
499.0 523.0 545.4 593.6 Construction in progress
622.2 702.7 553.0 692.9 Accumulated depreciation
(5,807.8) (5,759.9) (5,838.9) (5,956.0)
3,783.3 3,743.6 3,687.7 4,047.2 Other assets:
Investments in and advances to joint ventures
530.6 518.9 505.3 499.6
Pension assets
138.2 90.9 144.9 309.9 Exchangable note with related party
30.7 12.7 - - Life insurance
26.6 26.3 25.6 26.9 Miscellaneous
85.1 102.9 110.1 106.6 811.2 751.7 785.9 943.0 Other current liabilities:
Accrued trade and consumer promotions
564.7 563.7 482.6 499.6 Accrued payroll
361.8 386.4 326.6 347.0 Dividend payable
27.9 23.8 21.5 17.5 Accrued taxes
20.7 110.5 58.0 94.8 Accrued interest, including interest rate swaps
91.8 90.4 83.8 107.7 Grain contracts
7.8 5.5 5.6 1.2 Restructuring and other exit costs reserve
120.8 76.6 85.0 66.8 Derivative payable
122.9 35.6 18.1 8.3 Miscellaneous
271.5 302.5 291.0 302.9 1,589.9 1,595.0 1,372.2 1,445.8 Other noncurrent liabilities:
Accrued compensation and benefits, including pensions
1,451.4 1,755.0 1,249.7 999.4 Accrued taxes
202.5 204.0 162.3 265.3 Miscellaneous
90.9 128.6 111.1 76.3 1,744.8 2,087.6 1,523.1 1,341.0 Research expense
229.4 222.1 218.2 219.1 Advertising expense
823.1 754.4 623.8 575.9 Interest, net:
Interest expense
335.5 319.6 306.7 389.5 Capitalized interest
(6.9) (7.7) (4.6) (4.1)
Interest income
(13.2) (8.1) (7.0) (11.7)
315.4 303.8 295.1 373.7
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
General Mills
From
Amounts in millions
Reported
Assigned
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Assets
Cash and cash equivalents
Split
334.2 763.7 766.1 399.0 Receivables: Customers
Operating
1,412.0 1,390.4 1,454.4 1,712.6 Receivables: Allowance for doubtful accounts
Operating (25.3) (29.6) (24.3) (28.4)
Inventories: Raw materials and packaging
Operating
390.8 397.3 395.4 400.0 Inventories: Finished goods
Operating
1,268.6 1,163.1 1,224.3 1,364.2 Inventories: Grain
Operating
95.7 72.6 73.0 91.2 Inventories: Excess of FIFO over LIFO cost
Operating
(214.2) (219.3) (209.1) (213.2)
Deferred tax assets: Accrued liabilities
Operating
98.0 89.9 70.0 47.2 Deferred tax assets: Compensation and employee benefits
Operating
536.2 491.5 419.2 210.2 Deferred tax assets: Unrealized hedges
Operating 0.8 - - - Deferred tax assets: Pension
Financial
169.0 322.0 196.3 57.1 Deferred tax assets: Tax credit carryforwards
Operating 5.6 4.5 18.4 7.4 Deferred tax assets: Stock, partnership, and miscellaneous investments
Financial
384.1 353.6 276.4 147.9 Deferred tax assets: Capital losses
Operating 6.1 14.5 29.8 12.9 Deferred tax assets: Net operating losses
Operating
89.3 97.9 109.5 161.2 Deferred tax assets: Other
Operating
74.5 84.1 85.6 52.9 Deferred tax assets: Valuation allowance
Operating
(215.4) (227.0) (231.8) (176.0)
Prepaid expenses and other current assets: Other receivables
Operating
148.8 159.3 163.7 174.4 Prepaid expenses and other current assets: Prepaid expenses
Operating
169.3 177.9 168.9 165.6 Prepaid expenses and other current assets: Derivative receivables, primarily commodity-related
Operating
80.9 44.6 35.0 40.5 Prepaid expenses and other current assets: Grain contracts
Operating 3.3 1.8 2.7 7.1 Prepaid expenses and other current assets: Miscellaneous
Operating
21.5 15.4 11.3 10.7 Land, buildings, and equipment: Land
Operating
96.0 92.9 79.8 77.7 Land, buildings, and equipment: Buildings
Operating
2,272.7 2,236.0 2,249.2 2,396.3 Land, buildings, and equipment: Buildings under capital lease
Operating 0.3 0.3 0.3 0.3 Land, buildings, and equipment: Equipment
Operating
6,091.1 5,945.6 6,095.9 6,236.6 Land, buildings, and equipment: Equipment under capital lease
Operating 9.8 3.0 3.0 5.8 Land, buildings, and equipment: Capitalized software
Operating
499.0 523.0 545.4 593.6 Land, buildings, and equipment: Construction in progress
Operating
622.2 702.7 553.0 692.9 Land, buildings, and equipment: Accumulated depreciation
Operating
(5,807.8) (5,759.9) (5,838.9) (5,956.0)
Goodwill: North America Retail
Operating
6,546.2 6,410.3 6,406.5 6,410.6 Goodwill: Pet
Operating
- - - 5,294.9 Goodwill: Convenience Stores & Foodservice
Operating
921.1 921.1 918.8 918.8 Goodwill: Europe & Australia
Operating
719.1 716.5 700.8 729.9 Goodwill: Asia & Latin America
Operating
287.0 287.1 312.4 285.0 Goodwill: Joint Ventures
Operating
401.5 406.2 408.7 425.8 Other intangible assets: Brands and other indefinite-lived intangibles
Operating
4,262.1 4,147.5 4,161.1 6,818.7 Other intangible assets: Franchise agreements, customer relationships, and other
Operating
544.0 536.9 524.8 811.7 Other intangible assets: Accumulated amortization
Operating
(129.1) (145.8) (155.5) (185.3)
Other assets: Investments in and advances to joint ventures
Operating
530.6 518.9 505.3 499.6 Other assets: Exchangable note with related party
Financial
30.7 12.7 - - Other assets: Life insurance
Operating
26.6 26.3 25.6 26.9 Other assets: Miscellaneous
Operating
85.1 102.9 110.1 106.6 Defined benefit pension plans: Plan assets
Financial
5,758.5 5,539.9 5,925.2 6,177.4 Other postretirement benefit plans: Plan assets
Financial
582.8 602.4 694.8 726.1 Total assets
29,183.3 28,994.7 29,261.1 37,738.4 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
(1,684.0) (2,046.5) (2,119.8) (2,746.2)
Current portion of long-term debt
Financial
(1,000.4) (1,103.4) (604.7) (1,600.1)
Notes payable: US commercial paper
Financial
(432.0) - (954.7) (1,213.5)
Notes payable: Financial institutions
Financial
(183.8) (269.8) (279.4) (336.3)
Other current liabilities: Accrued trade and consumer promotions
Operating
(564.7) (563.7) (482.6) (499.6)
Other current liabilities: Accrued payroll
Operating
(361.8) (386.4) (326.6) (347.0)
Other current liabilities: Dividend payable
Financial
(27.9) (23.8) (21.5) (17.5)
Other current liabilities: Accrued taxes
Operating (20.7) (110.5) (58.0) (94.8)
Other current liabilities: Accrued interest, including interest rate swaps
Financial
(91.8) (90.4) (83.8) (107.7)
Other current liabilities: Grain contracts
Operating
(7.8) (5.5) (5.6) (1.2)
Other current liabilities: Restructuring and other exit costs reserve
Operating
(120.8) (76.6) (85.0) (66.8)
Other current liabilities: Derivative payable
Operating
(122.9) (35.6) (18.1) (8.3)
Other current liabilities: Miscellaneous
Operating
(271.5) (302.5) (291.0) (302.9)
Long-term debt
Financial
(7,575.3) (7,057.7) (7,642.9) (12,668.7)
Deferred tax liabilities: Brands
Operating
(1,346.3) (1,311.7) (1,310.1) (1,498.7)
Deferred tax liabilities: Fixed assets
Operating
(446.5) (476.3) (484.5) (329.5)
Deferred tax liabilities: Intangible assets
Operating
(208.4) (221.8) (238.6) (255.1)
Deferred tax liabilities: Tax lease transactions
Operating (50.8) (48.0) (45.8) (26.0)
Deferred tax liabilities: Inventories
Operating (59.7) (53.0) (60.0) (38.8)
Deferred tax liabilities: Stock, partnership, and miscellaneous investments
Financial
(472.5) (476.0) (479.4) (317.1)
Deferred tax liabilities: Unrealized hedges
Operating
- (22.6) (45.4) (28.5)
Deferred tax liabilities: Other
Operating (14.2) (21.2) (29.0) (30.9)
Other noncurrent liabilities: Accrued compensation and benefits, including pensions
Financial
(176.2) (164.9) (180.3) (178.5)
Other noncurrent liabilities: Accrued taxes
Operating
(202.5) (204.0) (162.3) (265.3)
Other noncurrent liabilities: Miscellaneous
Operating (90.9) (128.6) (111.1) (76.3)
Defined benefit pension plans: Benefit obligation
Financial
(6,252.1) (6,448.5) (6,458.6) (6,416.0)
Other postretirement benefit plans: Benefit obligation
Financial
(1,079.6) (1,028.9) (951.4) (871.8)
Postemployment benefit plans: Benefit obligation
Financial
(146.6) (164.1) (134.5) (126.7)
Redeemable interest
Financial
(778.9) (845.6) (910.9) (776.2)
Total liabilities
(23,790.6) (23,687.6) (24,575.6) (31,246.0)
Shareholders' equity
Common stock - $0.10 par value
Equity
(75.5) (75.5) (75.5) (75.5)
Additional paid-in capital
Equity
(1,296.7) (1,177.0) (1,120.9) (1,202.5)
Retained earnings
Equity
(11,990.8) (12,616.5) (13,138.9) (14,459.6)
Common stock in treasury, at cost
Equity
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
Equity
2,310.7 2,612.2 2,244.5 2,429.0 Noncontrolling interests
Financial
(396.0) (376.9) (357.6) (351.3)
Total shareholders' equity
(5,392.7) (5,307.1) (4,685.5) (6,492.4)
Total liabilities and shareholders' equity
(29,183.3) (28,994.7) (29,261.1) (37,738.4)
Sanity checks:
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Common shareholders' equity
Common stock - $0.10 par value
(75.5) (75.5) (75.5) (75.5)
Additional paid-in capital
(1,296.7) (1,177.0) (1,120.9) (1,202.5)
Retained earnings
(11,990.8) (12,616.5) (13,138.9) (14,459.6)
Common stock in treasury, at cost
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
2,310.7 2,612.2 2,244.5 2,429.0 (4,996.7) (4,930.2) (4,327.9) (6,141.1)
Free cash flows to equity holders
Cash dividends declared
1,071.7 1,135.1 1,139.7 Shares purchased
606.7 1,651.5 601.6 Shares issued
- - (969.9)
Stock compensation plans
(289.4) (218.8) (130.1)
Unearned compensation related to stock unit awards
63.3 78.5 58.1 Earned compensation
(84.8) (94.9) (77.0)
Increase (decrease) in redemption value of redeemable interest
91.5 75.9 (159.7)
Acquisition of interest in subsidiary
3.4 0.2 - 1,462.4 2,627.5 462.7 Clean surplus relation:
Beginning common shareholders' equity
(4,996.7) (4,930.2) (4,327.9)
Comprehensive (income) loss attributable to GIS
(1,395.9) (2,025.2) (2,275.9)
Free cash flows to equity holders
1,462.4 2,627.5 462.7 Ending common shareholders' equity
(4,996.7) (4,930.2) (4,327.9) (6,141.1)
Checks:
Balance sheet in balance
0.0
0.0
0.0
0.0
Shareholders' equity balance
0.0
0.0
0.0
0.0
No change in equity from BS Reported
0.0
0.0
0.0
0.0
General Mills
From
Amounts in millions
Reported
Net sales - North America retail
Net sales - Convenience stores & foodservice
Net sales - Europe & Australia
Net sales - Asia & Latin America
Cost of sales
Operating
Gross profit
Advertising expense
Research expense
Defined benefit pension plans: Service cost
Defined benefit pension plans: Interest cost
Defined benefit pension plans: Expected return on plan assets
Defined benefit pension plans: Amortization of losses
Defined benefit pension plans: Amortization of prior service cost
Defined benefit pension plans: Other adjustments
Defined benefit pension plans: Settlements or curtailment losses
Other postretirement benefit plans: Service cost
Other postretirement benefit plans: Interest cost
Other postretirement benefit plans: Expected return on plan assets
Other postretirement benefit plans: Amortization of losses
Other postretirement benefit plans: Amortization of prior service cost
Other postretirement benefit plans: Other adjustments
Other postretirement benefit plans: Settlements or curtailment losses
Postemployment benefit plans: Service cost
Postemployment benefit plans: Interest cost
Postemployment benefit plans: Amortization of losses
Postemployment benefit plans: Amortization of prior service cost
Postemployment benefit plans: Other adjustments
Postemployment benefit plans: Settlements or curtailment losses
Defined contribution plan expense
Other selling, general, and administrative expenses
Divestitures (loss) gain
Operating
Restructuring, impairment, and other exit costs
Operating
Operating profit
Interest expense
Capitalized interest
Interest income
Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
After-tax earnings from joint ventures
Operating
Net earnings, including earnings attributable to redeemable and noncontrolling interests
Net earnings attributable to redeemable and noncontrolling interests
Financial
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
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
Net actuarial income (loss)
Financial
Other fair value changes: Securities
Financial
Other fair value changes: Hedge deriviatives
Operating
Reclassification to earnings: Securities
Financial
Reclassification to earnings: Hedge deriviatives
Operating
Reclassification to earnings: Amortization of losses and prior service costs
Financial
Other comprehensive income attributable to noncontrolling interests, net
Financial
Comprehensive income attributable to General Mills
Check:
No change in comprehensive income from IS Reported
Assigned
5/31/2015 5/29/2016
5/28/2017
5/27/2018
Operating
11,612.1 10,936.6 10,196.9 10,115.4 Operating
1,995.1 1,923.8 1,870.0 1,930.2 Operating
2,126.5 1,998.0 1,824.5 1,984.6 Operating
1,896.6 1,704.7 1,728.4 1,710.2 (10,733.6) (10,056.0) (10,312.9)
5,829.5 5,563.8 5,427.5 Operating
(754.4) (623.8) (575.9)
Operating
(222.1) (218.2) (219.1)
Operating
(134.6) (119.7) (102.9)
Financial
(267.8) (216.5) (217.9)
Financial
496.9 486.7 480.2 Financial
(189.8) (190.2) (177.0)
Financial
(4.7) (2.5) (1.9)
Financial
(5.0) (3.1) - Financial
(13.1) (3.8) - Operating
(19.0) (12.5) (11.6)
Financial
(44.1) (32.2) (30.1)
Financial
46.2 48.5 52.2 Financial
(6.6) (2.5) (0.8)
Financial
5.4 5.4 5.4 Financial
(2.3) (1.3) - Financial
1.0 0.9 - Operating
(7.6) (8.8) (8.6)
Financial
(3.9) (2.6) (2.3)
Financial
(0.7) (1.7) (0.8)
Financial
(2.5) (0.6) (0.6)
Financial
(10.7) (1.3) (6.7)
Financial
- 1.4 - Operating
(61.2) (54.1) (49.2)
Operating
(1,918.3) (1,848.8) (1,885.0)
148.2 (13.5) - (151.4) (182.6) (165.6)
2,707.4 2,566.4 2,509.3 Financial
(319.6) (306.7) (389.5)
Financial
7.7 4.6 4.1 Financial
8.1 7.0 11.7 2,403.6 2,271.3 2,135.6 (755.2) (655.2) (57.3)
88.4 85.0 84.7 1,736.8 1,701.1 2,163.0 (39.4) (43.6) (32.0)
1,697.4 1,657.5 2,131.0 (108.7) 6.3 (37.0)
(325.9) 197.9 140.1 0.1 0.8 1.2 16.0 53.3 (50.8)
- - (5.1)
(9.5) (25.7) 17.4 128.6 122.5 117.6 (2.1) 12.6 (38.5)
1,395.9 2,025.2 2,275.9 0.0
0.0
0.0
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
5/31/2015
5/29/2016
Year-end closing share price (Yahoo)
56.15 62.87 Footnote 11:
Stock Options
Outstanding at end of year
39,077.2 32,401.6 Weighted avg. exercise price, Outstanding
34.35 37.09 Equity Classified
Nonvested at end of year
6,235.6 5,100.4 Weighted avg. exercise price, ending
46.44 48.60 Footnote 15:
Operating lease payments
189.1
Future Operating Lease payments
Year plus 1
108.4 107.9 Year plus 2
76.2 83.5 Year plus 3
56.9 67.2 Year plus 4
45.0 49.6 Year plus 5
32.4 39.6 Thereafter
81.6 49.8 400.5 397.6 Spread out payments!
108.4 107.9 76.2 83.5 56.9 67.2 45.0 49.6 32.4 39.6 32.4 39.6 32.4 10.2 16.8 - - - - - - -
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
Footnote 8:
Calculation of long-term debt average rate
5/31/2015
4.200% - 5.650% 1,150.0 5.700% 1,000.0 3.150% 1,000.0 3.700% - 4.000% - 3.200% - 4.700% - 3.200% - 2.100% 549.4 1.000% 549.4 1.400% 500.0 4.550% - 2.600% - 5.400% 500.0 4.150% 500.0 3.650% 500.0 2.200% 500.0 1.500% 439.5 0.875% 250.0 2.200% 219.7 7,658.0
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
5/28/2017
5/27/2018
57.32 42.64 29,834.4 28,963.8 40.47 42.90 4,491.2 3,731.8 56.08 57.50 118.1
189.4
118.8 137.4 101.7 115.7 80.7 92.3 60.7 70.9 49.7 51.8 89.1 91.2 500.7 559.3 118.8 137.4 101.7 115.7 80.7 92.3 60.7 70.9 49.7 51.8 49.7 51.8 39.4 39.4 - - - - - - - -
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
5/29/2016
5/28/2017
5/27/2018
0
4.200% - 0
4.200% - 0
4.200% 1,400.0 0.008484591
5.650% 1,150.0 0.008748
5.650% 1,150.0 0.009039
5.650% 1,150.0 0.007443197
5.700% 1,000.0 0.007674
5.700% - 0
5.700% - 0.004113346
3.150% 1,000.0 0.004241
3.150% 1,000.0 0.004382
3.150% 1,000.0 0
3.700% - 0
3.700% - 0
3.700% 850.0 0
4.000% - 0
4.000% - 0
4.000% 800.0 0
3.200% - 0
3.200% 750.0 0.003339
3.200% 750.0 0
4.700% - 0
4.700% - 0
4.700% 650.0 0
3.200% - 0
3.200% - 0
3.200% 600.0 0.001506581
2.100% 555.8 0.001571
2.100% 559.2 0.001634
2.100% 582.6 0.00071742
1.000% 555.8 0.000748
1.000% 559.2 0.000778
1.000% 582.6 0.000914077
1.400% 500.0 0.000942
1.400% 500.0 0.000974
1.400% - 0
4.550% - 0
4.550% - 0
4.550% 500.0 0
2.600% - 0
2.600% - 0
2.600% 500.0 0.003525725
5.400% 500.0 0.003635
5.400% 500.0 0.003756
5.400% 500.0 0.002709585
4.150% 500.0 0.002794
4.150% 500.0 0.002887
4.150% 500.0 0.002383129
3.650% 500.0 0.002457
3.650% 500.0 0.002539
3.650% 500.0 0.001436406
2.200% 500.0 0.001481
2.200% 500.0 0.00153
2.200% 500.0 0.000860864
1.500% 444.6 0.000898
1.500% 447.3 0.000933
1.500% 466.1 0.000285649
0.875% - 0
0.875% - 0
0.875% - 0.000631157
2.200% 221.0 0.000655
2.200% 222.8 0.000682
2.200% 232.8 3.50%
7,427.2 3.58%
7,188.5 3.25%
12,064.1
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
0.004874
0.005386
0
0.002611
0.002607
0.002652
0.001989
0.002532
0.001591
0.001014
0.000483
0
0.001886
0.001078
0.002238
0.00172
0.001513
0.000912
0.00058
0
0.000425
3.61%
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
5/31/2015
5/29/2016
5/28/2017
5/27/2018
LIFO Reserve
214.2 219.3 209.1 213.2 Future tax rate
35%
35%
21%
21%
Adjustment:
Inventory
214.2 219.3 209.1 213.2 Taxes payable
(75.0) (76.8) (43.9) (44.8)
Cost of goods sold
(5.1) 10.2 (4.1)
Tax expense
1.8 (32.8) 0.9 Retained earnings
(139.2) (139.2) (142.5) (165.2)
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
5/31/2015 5/29/2016
5/28/2017
Adjustment for Leases
Calculated lease liability
364.5 365.1 459.4 Assumed lease assets @ 100%
364.5 365.1 459.4 Disclosed operating lease payments
189.1 118.1 Estimated interest payment
13.1 13.4 Estimated principal payment
176.0 104.7 Estimate depreciation equal to principal payment
176.0 104.7 Record liability and asset
Capitalized lease obligation
(364.5) (365.1) (459.4)
Asset under capital lease
364.5 365.1 459.4 Reclassify payments
SG&A - Operating lease expense
(189.1) (118.1)
Interest expense
13.1 13.4 Depreciation expense
176.0 104.7
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
5/27/2018
509.9 Corrected
Note that the numbers reported in the text on p. 5.14 are errors -
509.9 the text incorrectly referenced
rows 27 to 37 in the prior spreadsheet rather than correctly 189.4 referencing rows 32 to 42. Note
17.5 that many of the numbers going forward are affected.
171.9 171.9 (509.9)
509.9 (189.4)
17.5 171.9
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
Text
Corrected
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
5/31/2015
5/29/2016
5/28/2017 5/27/2018
Stock options:
Ending price
56.15 62.87 57.32 42.64 Avg exercise price for ending outstanding
34.35 37.09 40.47 42.90 Max (0, Price - exercise)
21.80 25.78 16.85 - End number of options outstanding
39,077.2 32,401.6 29,834.4 28,963.8 Value of option overhang liability
851.9 835.3 502.7 - Assumed future tax rate
35%
35%
21%
21%
Related DTA (Financial)
298.2 292.4 105.6 - Opening balances:
Opening SBC liability
(851.9) (835.3) (502.7)
Opening DTA (Financial)
298.2 292.4 105.6 Prior period adjustment to CSE
553.7 543.0 397.1 Adjustments for Options
Decrease (increase) in SBC overhang
16.6 332.6 502.7 Increase (decrease) in related financial DTA
(5.8) (186.8) (105.6)
Increase (decrease) in FEAT
(10.8) (145.8) (397.1)
Equity Classified:
Ending price
56.15 62.87 57.32 42.64 Avg exercise price for ending outstanding
46.44 48.60 56.08 57.50 Max (0, Price - exercise)
9.71 14.27 1.24 - End number of options outstanding
6,235.6 5,100.4 4,491.2 3,731.8 Value of equity classified overhang liability
60.5 72.8 5.6 - Assumed future tax rate
35%
35%
21%
21%
Related DTA (Financial)
21.2 25.5 1.2 - Opening balances:
Opening SBC liability
(60.5) (72.8) (5.6)
Opening DTA (Financial)
21.2 25.5 1.2 Prior period adjustment to CSE
39.4 47.3 4.4 Adjustments for Equity Classified
Decrease (increase) in SBC overhang
(12.2) 67.2 5.6 Increase (decrease) in related financial DTA
4.3 (24.3) (1.2)
Increase (decrease) in FEAT
8.0 (42.9) (4.4)
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
Summary of adjustments:
Opening balances:
Opening share based compensation liability
(912.4) (908.1) (508.3)
Opening DTA (Financial)
319.4 317.8 106.7 Prior period adjustment to CSE
593.1 590.3 401.5 Current year effects:
Adjustment to share based compensation liability
4.3 399.8 508.3 Adjustment to DTA (Financial)
(1.5) (211.1) (106.7)
Adjustment to FEAT
(2.8) (188.7) (401.5)
Check figure:
0.0
0.0
0.0
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
General Mills
From
Amounts in millions
Expanded
Assigned
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Assets
Cash and cash equivalents
Split
334.2 763.7 766.1 399.0 Receivables: Customers
Operating
1,412.0 1,390.4 1,454.4 1,712.6 Receivables: Allowance for doubtful accounts
Operating
(25.3) (29.6) (24.3) (28.4)
Inventories: Raw materials and packaging
Operating
390.8 397.3 395.4 400.0 Inventories: Finished goods
Operating
1,268.6 1,163.1 1,224.3 1,364.2 Inventories: Grain
Operating
95.7 72.6 73.0 91.2 Inventories: Excess of FIFO over LIFO cost
Operating
- - - - Deferred tax assets: Accrued liabilities
Operating
98.0 89.9 70.0 47.2 Deferred tax assets: Compensation and employee benefits
Operating
536.2 491.5 419.2 210.2 Deferred tax assets: Unrealized hedges
Operating
0.8 - - - Deferred tax assets: Pension
Financial
169.0 322.0 196.3 57.1 Deferred tax assets: Tax credit carryforwards
Operating
5.6 4.5 18.4 7.4 Deferred tax assets: Stock, partnership, and miscellaneous investments
Financial
384.1 353.6 276.4 147.9 Deferred tax assets: Capital losses
Operating
6.1 14.5 29.8 12.9 Deferred tax assets: Net operating losses
Operating
89.3 97.9 109.5 161.2 Deferred tax assets: Other
Operating
74.5 84.1 85.6 52.9 Deferred tax assets: Valuation allowance
Operating
(215.4) (227.0) (231.8) (176.0)
Deferred tax assets: Stock-based compensation
Financial
319.4 317.8 106.7 - Prepaid expenses and other current assets: Other receivables
Operating
148.8 159.3 163.7 174.4 Prepaid expenses and other current assets: Prepaid expenses
Operating
169.3 177.9 168.9 165.6 Prepaid expenses and other current assets: Derivative receivables, primarily com
Operating
80.9 44.6 35.0 40.5 Prepaid expenses and other current assets: Grain contracts
Operating
3.3 1.8 2.7 7.1 Prepaid expenses and other current assets: Miscellaneous
Operating
21.5 15.4 11.3 10.7 Land, buildings, and equipment: Land
Operating
96.0 92.9 79.8 77.7 Land, buildings, and equipment: Buildings
Operating
2,272.7 2,236.0 2,249.2 2,396.3 Land, buildings, and equipment: Buildings under capital lease
Operating
0.3 0.3 0.3 0.3 Land, buildings, and equipment: Equipment
Operating
6,091.1 5,945.6 6,095.9 6,236.6 Land, buildings, and equipment: Equipment under capital lease
Operating
9.8 3.0 3.0 5.8 Land, buildings, and equipment: Capitalized software
Operating
499.0 523.0 545.4 593.6 Land, buildings, and equipment: Construction in progress
Operating
622.2 702.7 553.0 692.9 Land, buildings, and equipment: Accumulated depreciation
Operating
(5,807.8) (5,759.9) (5,838.9) (5,956.0)
Capitalized lease asset
Operating
364.5 365.1 459.4 509.9 Goodwill: North America Retail
Operating
6,546.2 6,410.3 6,406.5 6,410.6 Goodwill: Pet
Operating
- - - 5,294.9 Goodwill: Convenience Stores & Foodservice
Operating
921.1 921.1 918.8 918.8 Goodwill: Europe & Australia
Operating
719.1 716.5 700.8 729.9 Goodwill: Asia & Latin America
Operating
287.0 287.1 312.4 285.0 Goodwill: Joint Ventures
Operating
401.5 406.2 408.7 425.8 Other intangible assets: Brands and other indefinite-lived intangibles
Operating
4,262.1 4,147.5 4,161.1 6,818.7 Other intangible assets: Franchise agreements, customer relationships, and other
Operating
544.0 536.9 524.8 811.7 Other intangible assets: Accumulated amortization
Operating
(129.1) (145.8) (155.5) (185.3)
Other assets: Investments in and advances to joint ventures
Operating
530.6 518.9 505.3 499.6 Other assets: Exchangable note with related party
Financial
30.7 12.7 - - Other assets: Life insurance
Operating
26.6 26.3 25.6 26.9 Other assets: Miscellaneous
Operating
85.1 102.9 110.1 106.6 Defined benefit pension plans: Plan assets
Financial
5,758.5 5,539.9 5,925.2 6,177.4 Other postretirement benefit plans: Plan assets
Financial
582.8 602.4 694.8 726.1 Total assets
30,081.3 29,897.0 30,036.3 38,461.5 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
(1,684.0) (2,046.5) (2,119.8) (2,746.2)
Current portion of long-term debt
Financial
(1,000.4) (1,103.4) (604.7) (1,600.1)
Notes payable: US commercial paper
Financial
(432.0) - (954.7) (1,213.5)
Notes payable: Financial institutions
Financial
(183.8) (269.8) (279.4) (336.3)
Other current liabilities: Accrued trade and consumer promotions
Operating
(564.7) (563.7) (482.6) (499.6)
Other current liabilities: Accrued payroll
Operating
(361.8) (386.4) (326.6) (347.0)
Other current liabilities: Dividend payable
Financial
(27.9) (23.8) (21.5) (17.5)
Other current liabilities: Accrued taxes
Operating
(95.7) (187.3) (101.9) (139.6)
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
Other current liabilities: Accrued interest, including interest rate swaps
Financial
(91.8) (90.4) (83.8) (107.7)
Other current liabilities: Grain contracts
Operating
(7.8) (5.5) (5.6) (1.2)
Other current liabilities: Restructuring and other exit costs reserve
Operating
(120.8) (76.6) (85.0) (66.8)
Other current liabilities: Derivative payable
Operating
(122.9) (35.6) (18.1) (8.3)
Other current liabilities: Miscellaneous
Operating
(271.5) (302.5) (291.0) (302.9)
Long-term debt
Financial
(7,575.3) (7,057.7) (7,642.9) (12,668.7)
Deferred tax liabilities: Brands
Operating
(1,346.3) (1,311.7) (1,310.1) (1,498.7)
Deferred tax liabilities: Fixed assets
Operating
(446.5) (476.3) (484.5) (329.5)
Deferred tax liabilities: Intangible assets
Operating
(208.4) (221.8) (238.6) (255.1)
Deferred tax liabilities: Tax lease transactions
Operating
(50.8) (48.0) (45.8) (26.0)
Deferred tax liabilities: Inventories
Operating
(59.7) (53.0) (60.0) (38.8)
Deferred tax liabilities: Stock, partnership, and miscellaneous investments
Financial
(472.5) (476.0) (479.4) (317.1)
Deferred tax liabilities: Unrealized hedges
Operating
- (22.6) (45.4) (28.5)
Deferred tax liabilities: Other
Operating
(14.2) (21.2) (29.0) (30.9)
Other noncurrent liabilities: Accrued compensation and benefits, including pensio
Financial
(176.2) (164.9) (180.3) (178.5)
Other noncurrent liabilities: Accrued taxes
Operating
(202.5) (204.0) (162.3) (265.3)
Other noncurrent liabilities: Miscellaneous
Operating
(90.9) (128.6) (111.1) (76.3)
Defined benefit pension plans: Benefit obligation
Financial
(6,252.1) (6,448.5) (6,458.6) (6,416.0)
Other postretirement benefit plans: Benefit obligation
Financial
(1,079.6) (1,028.9) (951.4) (871.8)
Postemployment benefit plans: Benefit obligation
Financial
(146.6) (164.1) (134.5) (126.7)
Capitalized lease liability
Financial
(364.5) (365.1) (459.4) (509.9)
Stock-based compensation liability (NFL)
Financial
(912.4) (908.1) (508.3) - Redeemable interest
Financial
(778.90) (845.60) (910.90) (776.20)
Total liabilities
(25,142.5)
(25,037.6)
(25,587.2)
(31,800.6)
Shareholders' equity
Common stock - $0.10 par value
Equity
(75.5)
(75.5)
(75.5)
(75.5)
Additional paid-in capital
Equity
(1,296.7)
(1,177.0)
(1,120.9)
(1,202.5)
Retained earnings
Equity
(11,990.8)
(12,616.5)
(13,138.9)
(14,459.6)
RE adjustment for inventory
Equity
(139.2)
(142.5)
(165.2)
(168.4)
RE adjustment for stock-based compensation
Equity
593.1 590.3 401.5 0.0 Common stock in treasury, at cost
Equity
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
Equity
2,310.7 2,612.2 2,244.5 2,429.0 Noncontrolling interests
Financial
(396.0)
(376.9)
(357.6)
(351.3)
Total shareholders' equity
(4,938.9)
(4,859.4)
(4,449.1)
(6,660.8)
Total liabilities and shareholders' equity
(30,081.3)
(29,897.0)
(30,036.3)
(38,461.5)
Sanity checks:
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Common Shareholders' Equity:
Common stock - $0.10 par value
(75.5)
(75.5)
(75.5)
(75.5)
Additional paid-in capital
(1,296.7)
(1,177.0)
(1,120.9)
(1,202.5)
Retained earnings
(11,990.8)
(12,616.5)
(13,138.9)
(14,459.6)
RE adjustment for inventory
(139.2)
(142.5)
(165.2)
(168.4)
RE adjustment for stock-based compensation
593.1 590.3 401.5 0.0 Common stock in treasury, at cost
6,055.6 6,326.6 7,762.9 7,167.5 Accumulated other comprehensive income/(loss)
2,310.7 2,612.2 2,244.5 2,429.0 (4,542.9)
(4,482.5)
(4,091.5)
(6,309.5)
Free cash flows to equity holders
Cash dividends declared
1,071.7 1,135.1 1,139.7 Shares purchased
606.7 1,651.5 601.6 Shares issued
0.0 0.0 (969.9)
Stock compensation plans
(289.4)
(218.8)
(130.1)
Unearned compensation related to stock unit awards
63.3 78.5 58.1 Earned compensation
(84.8)
(94.9)
(77.0)
Increase (decrease) in redemption value of redeemable interest
91.5 75.9 (159.7)
Acquisition of interest in subsidiary
3.4 0.2 0.0 1,462.4 2,627.5 462.7 Clean surplus relation:
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
Beginning shareholders' equity
(4,542.9)
(4,482.5)
(4,091.5)
Comprehensive (income) loss attributable to GIS
(1,402.0)
(2,236.6)
(2,680.7)
Free cash flows to equity holders
1,462.4 2,627.5 462.7 Ending shareholders' equity
(4,542.9)
(4,482.5)
(4,091.5)
(6,309.5)
Checks:
Balance sheet in balance
0.0
0.0
0.0
0.0
Common shareholders' equity from BS Expanded
(4,996.7) (4,930.2) (4,327.9) (6,141.1)
Adjustment for inventory
(139.2) (142.5) (165.2) (168.4)
Adjustment for leases
- - - - Adjustment for options
593.1 590.3 401.5 - Adjusted common shareholders' equity
(4,542.9) (4,482.5) (4,091.5) (6,309.5)
Matches above
0.0
0.0
0.0
0.0
Shareholders' equity balance
0.0
0.0
0.0
0.0
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
General Mills
From
Amounts in millions
Expanded
Net sales - North America retail
Operating
Net sales - Convenience stores & foodservice
Operating
Net sales - Europe & Australia
Operating
Net sales - Asia & Latin America
Operating
Cost of sales
Operating
Gross profit
Advertising expense
Operating
Research expense
Operating
Depreciation on capitalized leases
Defined benefit pension plans: Service cost
Operating
Defined benefit pension plans: Interest cost
Financial
Defined benefit pension plans: Expected return on plan assets
Financial
Defined benefit pension plans: Amortization of losses
Financial
Defined benefit pension plans: Amortization of prior service cost
Financial
Defined benefit pension plans: Other adjustments
Financial
Defined benefit pension plans: Settlements or curtailment losses
Financial
Other postretirement benefit plans: Service cost
Operating
Other postretirement benefit plans: Interest cost
Financial
Other postretirement benefit plans: Expected return on plan assets
Financial
Other postretirement benefit plans: Amortization of losses
Financial
Other postretirement benefit plans: Amortization of prior service cost
Financial
Other postretirement benefit plans: Other adjustments
Financial
Other postretirement benefit plans: Settlements or curtailment losses
Financial
Postemployment benefit plans: Service cost
Operating
Postemployment benefit plans: Interest cost
Financial
Postemployment benefit plans: Amortization of losses
Financial
Postemployment benefit plans: Amortization of prior service cost
Financial
Postemployment benefit plans: Other adjustments
Financial
Postemployment benefit plans: Settlements or curtailment losses
Financial
Defined contribution plan expense
Operating
Other selling, general, and administrative expenses
Operating
Divestitures (loss) gain
Operating
Restructuring, impairment, and other exit costs
Operating
Operating profit
Interest expense
Financial
Capitalized interest
Financial
Interest income
Financial
Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
Financial stock-based compensation expense, net of tax
After-tax earnings from joint ventures
Operating
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
Net earnings, including earnings attributable to redeemable and noncontrolling interests
Net earnings attributable to redeemable and noncontrolling interests
Financial
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
Net actuarial income (loss)
Financial
Other fair value changes: Securities
Financial
Other fair value changes: Hedge deriviatives
Operating
Reclassification to earnings: Securities
Financial
Reclassification to earnings: Hedge deriviatives
Operating
Reclassification to earnings: Amortization of losses and prior service costs
Financial
Other comprehensive income attributable to noncontrolling interests, net
Financial
Comprehensive income attributable to General Mills
Check:
Comprehensive income attrib to GIS from IS Expanded
Adjustment for inventory
Adjustment for leases
Adjustment for options
Adjusted comprehensive income attrib to GIS
Matches above
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
Assigned
5/31/2015
5/29/2016
5/28/2017
5/27/2018
11,612.1 10,936.6 10,196.9 10,115.4 1,995.1 1,923.8 1,870.0 1,930.2 2,126.5 1,998.0 1,824.5 1,984.6 1,896.6 1,704.7 1,728.4 1,710.2 (10,728.5) (10,066.2) (10,308.8)
5,834.6 5,553.6 5,431.6 (754.4) (623.8) (575.9)
(222.1) (218.2) (219.1)
Operating
(176.0) (104.7) (171.9)
(134.6) (119.7) (102.9)
(267.8) (216.5) (217.9)
496.9 486.7 480.2 (189.8) (190.2) (177.0)
(4.7) (2.5) (1.9)
(5.0) (3.1) - (13.1) (3.8) - (19.0) (12.5) (11.6)
(44.1) (32.2) (30.1)
46.2 48.5 52.2 (6.6) (2.5) (0.8)
5.4 5.4 5.4 (2.3) (1.3) - 1.0 0.9 - (7.6) (8.8) (8.6)
(3.9) (2.6) (2.3)
(0.7) (1.7) (0.8)
(2.5) (0.6) (0.6)
(10.7) (1.3) (6.7)
- 1.4 - (61.2) (54.1) (49.2)
(1,729.2) (1,730.7) (1,695.6)
148.2 (13.5) - (151.4) (182.6) (165.6)
2,725.6 2,569.6 2,530.9 (332.7) (320.1) (407.0)
7.7 4.6 4.1 8.1 7.0 11.7 2,408.7 2,261.1 2,139.7 (757.0) (622.4) (58.2)
Financial
2.8 188.7 401.5 88.4 85.0 84.7
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
1,742.9 1,912.5 2,567.8 (39.4) (43.6) (32.0)
1,703.5 1,868.9 2,535.8 (108.7) 6.3 (37.0)
(325.9) 197.9 140.1 0.1 0.8 1.2 16.0 53.3 (50.8)
- - (5.1)
(9.5) (25.7) 17.4 128.6 122.5 117.6 (2.1) 12.6 (38.5)
1,402.0 2,236.6 2,680.7 1,395.9 2,025.2 2,275.9 3.3 22.6 3.2 - - - 2.8 188.7 401.5 1,402.0 2,236.6 2,680.7 - - -
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
General Mills
From Amounts in millions
Adjusted
5/31/2015 5/29/2016 5/28/2017 5/27/2018
Assets
Cash and cash equivalents
Split
334.2 331.3 312.4 314.8 Receivables: Customers
Operating
1,412.0 1,390.4 1,454.4 1,712.6 Receivables: Allowance for doubtful accounts
Operating
(25.3)
(29.6)
(24.3)
(28.4)
Inventories: Raw materials and packaging
Operating
390.8 397.3 395.4 400.0 Inventories: Finished goods
Operating
1,268.6 1,163.1 1,224.3 1,364.2 Inventories: Grain
Operating
95.7 72.6 73.0 91.2 Inventories: Excess of FIFO over LIFO cost
Operating
0.0 0.0 0.0 0.0 Deferred tax assets: Accrued liabilities
Operating
98.0 89.9 70.0 47.2 Deferred tax assets: Compensation and employee benefits
Operating
536.2 491.5 419.2 210.2 Deferred tax assets: Unrealized hedges
Operating
0.8 0.0 0.0 0.0 Deferred tax assets: Pension
Financial
Deferred tax assets: Tax credit carryforwards
Operating
5.6 4.5 18.4 7.4 Deferred tax assets: Stock, partnership, and miscellaneous investments
Financial
Deferred tax assets: Capital losses
Operating
6.1 14.5 29.8 12.9 Deferred tax assets: Net operating losses
Operating
89.3 97.9 109.5 161.2 Deferred tax assets: Other
Operating
74.5 84.1 85.6 52.9 Deferred tax assets: Valuation allowance
Operating
(215.4)
(227.0)
(231.8)
(176.0)
Deferred tax assets: Stock-based compensation
Financial
Prepaid expenses and other current assets: Other receivables
Operating
148.8 159.3 163.7 174.4 Prepaid expenses and other current assets: Prepaid expenses
Operating
169.3 177.9 168.9 165.6 Prepaid expenses and other current assets: Derivative receivables, primarily commodity-related
Operating
80.9 44.6 35.0 40.5 Prepaid expenses and other current assets: Grain contracts
Operating
3.3 1.8 2.7 7.1 Prepaid expenses and other current assets: Miscellaneous
Operating
21.5 15.4 11.3 10.7 Land, buildings, and equipment: Land
Operating
96.0 92.9 79.8 77.7 Land, buildings, and equipment: Buildings
Operating
2,272.7 2,236.0 2,249.2 2,396.3 Land, buildings, and equipment: Buildings under capital lease
Operating
0.3 0.3 0.3 0.3 Land, buildings, and equipment: Equipment
Operating
6,091.1 5,945.6 6,095.9 6,236.6 Land, buildings, and equipment: Equipment under capital lease
Operating
9.8 3.0 3.0 5.8 Land, buildings, and equipment: Capitalized software
Operating
499.0 523.0 545.4 593.6 Land, buildings, and equipment: Construction in progress
Operating
622.2 702.7 553.0 692.9 Land, buildings, and equipment: Accumulated depreciation
Operating
(5,807.8)
(5,759.9)
(5,838.9)
(5,956.0)
Capitalized lease asset
Operating
364.5 365.1 459.4 509.9 Goodwill: North America Retail
Operating
6,546.2 6,410.3 6,406.5 6,410.6 Goodwill: Pet
Operating
0.0 0.0 0.0 5,294.9 Goodwill: Convenience Stores & Foodservice
Operating
921.1 921.1 918.8 918.8 Goodwill: Europe & Australia
Operating
719.1 716.5 700.8 729.9 Goodwill: Asia & Latin America
Operating
287.0 287.1 312.4 285.0 Goodwill: Joint Ventures
Operating
401.5 406.2 408.7 425.8 Other intangible assets: Brands and other indefinite-lived intangibles
Operating
4,262.1 4,147.5 4,161.1 6,818.7 Other intangible assets: Franchise agreements, customer relationships, and other
Operating
544.0 536.9 524.8 811.7 Other intangible assets: Accumulated amortization
Operating
(129.1)
(145.8)
(155.5)
(185.3)
Other assets: Investments in and advances to joint ventures
Operating
530.6 518.9 505.3 499.6 Other assets: Exchangable note with related party
Financial
Other assets: Life insurance
Operating
26.6 26.3 25.6 26.9 Other assets: Miscellaneous
Operating
85.1 102.9 110.1 106.6 Defined benefit pension plans: Plan assets
Financial
Other postretirement benefit plans: Plan assets
Financial
Total operating assets
22,836.9 22,316.1 22,383.2 31,268.8 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
(1,684.0)
(2,046.5)
(2,119.8)
(2,746.2)
Current portion of long-term debt
Financial
Notes payable: US commercial paper
Financial
Notes payable: Financial institutions
Financial
Other current liabilities: Accrued trade and consumer promotions
Operating
(564.7)
(563.7)
(482.6)
(499.6)
Other current liabilities: Accrued payroll
Operating
(361.8)
(386.4)
(326.6)
(347.0)
Other current liabilities: Dividend payable
Financial
Other current liabilities: Accrued taxes
Operating
(95.7)
(187.3)
(101.9)
(139.6)
Other current liabilities: Accrued interest, including interest rate swaps
Financial
Other current liabilities: Grain contracts
Operating
(7.8)
(5.5)
(5.6)
(1.2)
Other current liabilities: Restructuring and other exit costs reserve
Operating
(120.8)
(76.6)
(85.0)
(66.8)
Other current liabilities: Derivative payable
Operating
(122.9)
(35.6)
(18.1)
(8.3)
Other current liabilities: Miscellaneous
Operating
(271.5)
(302.5)
(291.0)
(302.9)
Long-term debt
Financial
Deferred tax liabilities: Brands
Operating
(1,346.3)
(1,311.7)
(1,310.1)
(1,498.7)
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
Deferred tax liabilities: Fixed assets
Operating
(446.5)
(476.3)
(484.5)
(329.5)
Deferred tax liabilities: Intangible assets
Operating
(208.4)
(221.8)
(238.6)
(255.1)
Deferred tax liabilities: Tax lease transactions
Operating
(50.8)
(48.0)
(45.8)
(26.0)
Deferred tax liabilities: Inventories
Operating
(59.7)
(53.0)
(60.0)
(38.8)
Deferred tax liabilities: Stock, partnership, and miscellaneous investments
Financial
Deferred tax liabilities: Unrealized hedges
Operating
0.0 (22.6)
(45.4)
(28.5)
Deferred tax liabilities: Other
Operating
(14.2)
(21.2)
(29.0)
(30.9)
Other noncurrent liabilities: Accrued compensation and benefits, including pensions
Financial
Other noncurrent liabilities: Accrued taxes
Operating
(202.5)
(204.0)
(162.3)
(265.3)
Other noncurrent liabilities: Miscellaneous
Operating
(90.9)
(128.6)
(111.1)
(76.3)
Defined benefit pension plans: Benefit obligation
Financial
Other postretirement benefit plans: Benefit obligation
Financial
Postemployment benefit plans: Benefit obligation
Financial
Capitalized lease liability
Financial
Stock-based compensation liability (NFL)
Financial
Redeemable interest
Financial
Total liabilities
Shareholders' equity
Common stock - $0.10 par value
Equity
Additional paid-in capital
Equity
Retained earnings
Equity
RE adjustment for inventory
Equity
RE adjustment for stock-based compensation
Equity
Common stock in treasury, at cost
Equity
Accumulated other comprehensive income/(loss)
Equity
Noncontrolling interests
Financial
Total shareholders' equity
Total liabilities and shareholders' equity
(5,648.5)
(6,091.3)
(5,917.4)
(6,660.7)
Net Operating Assets
17,188.4 16,224.8 16,465.8 24,608.1 5/31/2015 5/29/2016 5/28/2017 5/27/2018
Assets
Cash and cash equivalents
Split
0.0 432.4 453.7 84.2 Receivables: Customers
Operating
Receivables: Allowance for doubtful accounts
Operating
Inventories: Raw materials and packaging
Operating
Inventories: Finished goods
Operating
Inventories: Grain
Operating
Inventories: Excess of FIFO over LIFO cost
Operating
Deferred tax assets: Accrued liabilities
Operating
Deferred tax assets: Compensation and employee benefits
Operating
Deferred tax assets: Unrealized hedges
Operating
Deferred tax assets: Pension
Financial
169.0 322.0 196.3 57.1 Deferred tax assets: Tax credit carryforwards
Operating
Deferred tax assets: Stock, partnership, and miscellaneous investments
Financial
384.1 353.6 276.4 147.9 Deferred tax assets: Capital losses
Operating
Deferred tax assets: Net operating losses
Operating
Deferred tax assets: Other
Operating
Deferred tax assets: Valuation allowance
Operating
Deferred tax assets: Stock-based compensation
Financial
319.4 317.8 106.7 0.0 Prepaid expenses and other current assets: Other receivables
Operating
Prepaid expenses and other current assets: Prepaid expenses
Operating
Prepaid expenses and other current assets: Derivative receivables, primarily commodity-related
Operating
Prepaid expenses and other current assets: Grain contracts
Operating
Prepaid expenses and other current assets: Miscellaneous
Operating
Land, buildings, and equipment: Land
Operating
Land, buildings, and equipment: Buildings
Operating
Land, buildings, and equipment: Buildings under capital lease
Operating
Land, buildings, and equipment: Equipment
Operating
Land, buildings, and equipment: Equipment under capital lease
Operating
Land, buildings, and equipment: Capitalized software
Operating
Land, buildings, and equipment: Construction in progress
Operating
Land, buildings, and equipment: Accumulated depreciation
Operating
Capitalized lease asset
Operating
Goodwill: North America Retail
Operating
Goodwill: Pet
Operating
Goodwill: Convenience Stores & Foodservice
Operating
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
Goodwill: Europe & Australia
Operating
Goodwill: Asia & Latin America
Operating
Goodwill: Joint Ventures
Operating
Other intangible assets: Brands and other indefinite-lived intangibles
Operating
Other intangible assets: Franchise agreements, customer relationships, and other
Operating
Other intangible assets: Accumulated amortization
Operating
Other assets: Investments in and advances to joint ventures
Operating
Other assets: Exchangable note with related party
Financial
30.7 12.7 0.0 0.0 Other assets: Life insurance
Operating
Other assets: Miscellaneous
Operating
Defined benefit pension plans: Plan assets
Financial
5,758.5 5,539.9 5,925.2 6,177.4 Other postretirement benefit plans: Plan assets
Financial
582.8 602.4 694.8 726.1 Total assets
7,244.5 7,580.9 7,653.1 7,192.7 Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
Operating
Current portion of long-term debt
Financial
(1,000.4)
(1,103.4)
(604.7)
(1,600.1)
Notes payable: US commercial paper
Financial
(432.0)
0.0 (954.7)
(1,213.5)
Notes payable: Financial institutions
Financial
(183.8)
(269.8)
(279.4)
(336.3)
Other current liabilities: Accrued trade and consumer promotions
Operating
Other current liabilities: Accrued payroll
Operating
Other current liabilities: Dividend payable
Financial
(27.9)
(23.8)
(21.5)
(17.5)
Other current liabilities: Accrued taxes
Operating
Other current liabilities: Accrued interest, including interest rate swaps
Financial
(91.8)
(90.4)
(83.8)
(107.7)
Other current liabilities: Grain contracts
Operating
Other current liabilities: Restructuring and other exit costs reserve
Operating
Other current liabilities: Derivative payable
Operating
Other current liabilities: Miscellaneous
Operating
Long-term debt
Financial
(7,575.3)
(7,057.7)
(7,642.9)
(12,668.7)
Deferred tax liabilities: Brands
Operating
Deferred tax liabilities: Fixed assets
Operating
Deferred tax liabilities: Intangible assets
Operating
Deferred tax liabilities: Tax lease transactions
Operating
Deferred tax liabilities: Inventories
Operating
Deferred tax liabilities: Stock, partnership, and miscellaneous investments
Financial
(472.5)
(476.0)
(479.4)
(317.1)
Deferred tax liabilities: Unrealized hedges
Operating
Deferred tax liabilities: Other
Operating
Other noncurrent liabilities: Accrued compensation and benefits, including pensions
Financial
(176.2)
(164.9)
(180.3)
(178.5)
Other noncurrent liabilities: Accrued taxes
Operating
Other noncurrent liabilities: Miscellaneous
Operating
Defined benefit pension plans: Benefit obligation
Financial
(6,252.1)
(6,448.5)
(6,458.6)
(6,416.0)
Other postretirement benefit plans: Benefit obligation
Financial
(1,079.6)
(1,028.9)
(951.4)
(871.8)
Postemployment benefit plans: Benefit obligation
Financial
(146.6)
(164.1)
(134.5)
(126.7)
Capitalized lease liability
Financial
(364.5)
(365.1)
(459.4)
(509.9)
Stock-based compensation liability (NFL)
Financial
(912.4)
(908.1)
(508.3)
0.0 Redeemable interest
Financial
(778.9)
(845.6)
(910.9)
(776.2)
Total liabilities
Shareholders' equity
Common stock - $0.10 par value
Equity
Additional paid-in capital
Equity
Retained earnings
Equity
RE adjustment for inventory
Equity
RE adjustment for stock-based compensation
Equity
Common stock in treasury, at cost
Equity
Accumulated other comprehensive income/(loss)
Equity
Noncontrolling interests
Financial
(396.0)
(376.9)
(357.6)
(351.3)
Total shareholders' equity
Total liabilities and shareholders' equity
(19,890.0)
(19,323.2)
(20,027.4)
(25,491.3)
Net Financial Liabilities
(12,645.5)
(11,742.4)
(12,374.2)
(18,298.6)
Check:
Net Operating Assets
17,188.4 16,224.8 16,465.8 24,608.1 Net Financial Liabilities
(12,645.5)
(11,742.4)
(12,374.2)
(18,298.6)
Common Shareholders Equity
4,542.9 4,482.5 4,091.5 6,309.5 CSE matches BS Adjusted
0.0 0.0 (0.0)
0.0
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
General Mills
From Amounts in millions
Adjusted
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Net sales - North America retail
Operating
11,612.1 10,936.6 10,196.9 10,115.4 Net sales - Convenience stores & foodservice
Operating
1,995.1 1,923.8 1,870.0 1,930.2 Net sales - Europe & Australia
Operating
2,126.5 1,998.0 1,824.5 1,984.6 Net sales - Asia & Latin America
Operating
1,896.6 1,704.7 1,728.4 1,710.2 Cost of sales
Operating
(10,728.5) (10,066.2) (10,308.8)
Gross profit
Advertising expense
Operating
(754.4) (623.8) (575.9)
Research expense
Operating
(222.1) (218.2) (219.1)
Depreciation on capitalized leases
Operating
(176.0) (104.7) (171.9)
Defined benefit pension plans: Service cost
Operating
(134.6) (119.7) (102.9)
Defined benefit pension plans: Interest cost
Financial
Defined benefit pension plans: Expected return on plan assets
Financial
Defined benefit pension plans: Amortization of losses
Financial
Defined benefit pension plans: Amortization of prior service cost
Financial
Defined benefit pension plans: Other adjustments
Financial
Defined benefit pension plans: Settlements or curtailment losses
Financial
Other postretirement benefit plans: Service cost
Operating
(19.0) (12.5) (11.6)
Other postretirement benefit plans: Interest cost
Financial
Other postretirement benefit plans: Expected return on plan assets
Financial
Other postretirement benefit plans: Amortization of losses
Financial
Other postretirement benefit plans: Amortization of prior service cost
Financial
Other postretirement benefit plans: Other adjustments
Financial
Other postretirement benefit plans: Settlements or curtailment losses
Financial
Postemployment benefit plans: Service cost
Operating
(7.6) (8.8) (8.6)
Postemployment benefit plans: Interest cost
Financial
Postemployment benefit plans: Amortization of losses
Financial
Postemployment benefit plans: Amortization of prior service cost
Financial
Postemployment benefit plans: Other adjustments
Financial
Postemployment benefit plans: Settlements or curtailment losses
Financial
Defined contribution plan expense
Operating
(61.2) (54.1) (49.2)
Other selling, general, and administrative expenses
Operating
(1,729.2) (1,730.7) (1,695.6)
Divestitures (loss) gain
Operating
148.2 (13.5) - Restructuring, impairment, and other exit costs
Operating
(151.4) (182.6) (165.6)
Operating profit
Interest expense
Financial
Capitalized interest
Financial
Interest income
Financial
Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
(868.5) (700.7) (143.9)
Financial stock-based compensation expense, net of tax
Financial
After-tax earnings from joint ventures
Operating
88.4 85.0 84.7 Net earnings, including earnings attributable to redeemable and noncontrolling interests
Net earnings attributable to redeemable and noncontrolling interests
Financial
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
(108.7) 6.3 (37.0)
Net actuarial income (loss)
Financial
Other fair value changes: Securities
Financial
Other fair value changes: Hedge deriviatives
Operating
16.0 53.3 (50.8)
Reclassification to earnings: Securities
Financial
Reclassification to earnings: Hedge deriviatives
Operating
(9.5) (25.7) 17.4 Reclassification to earnings: Amortization of losses and prior service costs
Financial
Other comprehensive income attributable to noncontrolling interests, net
Financial
Comprehensive income attributable to General Mills
NOPAT
1,845.0 1,903.2 2,301.6 5/31/2015
5/29/2016
5/28/2017
5/27/2018
Net sales - North America retail
Operating
Net sales - Convenience stores & foodservice
Operating
Net sales - Europe & Australia
Operating
Net sales - Asia & Latin America
Operating
Cost of sales
Operating
Gross profit
Advertising expense
Operating
Research expense
Operating
Depreciation on capitalized leases
Operating
Defined benefit pension plans: Service cost
Operating
Defined benefit pension plans: Interest cost
Financial
(267.8) (216.5) (217.9)
Defined benefit pension plans: Expected return on plan assets
Financial
496.9 486.7 480.2 Defined benefit pension plans: Amortization of losses
Financial
(189.8) (190.2) (177.0)
Defined benefit pension plans: Amortization of prior service cost
Financial
(4.7) (2.5) (1.9)
Defined benefit pension plans: Other adjustments
Financial
(5.0) (3.1) - Defined benefit pension plans: Settlements or curtailment losses
Financial
(13.1) (3.8) - Other postretirement benefit plans: Service cost
Operating
Other postretirement benefit plans: Interest cost
Financial
(44.1) (32.2) (30.1)
Other postretirement benefit plans: Expected return on plan assets
Financial
46.2 48.5 52.2 Other postretirement benefit plans: Amortization of losses
Financial
(6.6) (2.5) (0.8)
Other postretirement benefit plans: Amortization of prior service cost
Financial
5.4 5.4 5.4 Other postretirement benefit plans: Other adjustments
Financial
(2.3) (1.3) - Other postretirement benefit plans: Settlements or curtailment losses
Financial
1.0 0.9 - Postemployment benefit plans: Service cost
Operating
Postemployment benefit plans: Interest cost
Financial
(3.9) (2.6) (2.3)
Postemployment benefit plans: Amortization of losses
Financial
(0.7) (1.7) (0.8)
Postemployment benefit plans: Amortization of prior service cost
Financial
(2.5) (0.6) (0.6)
Postemployment benefit plans: Other adjustments
Financial
(10.7) (1.3) (6.7)
Postemployment benefit plans: Settlements or curtailment losses
Financial
- 1.4 - Defined contribution plan expense
Operating
Other selling, general, and administrative expenses
Operating
Divestitures (loss) gain
Operating
Restructuring, impairment, and other exit costs
Operating
Operating profit
Interest expense
Financial
(332.7) (320.1) (407.0)
Capitalized interest
Financial
7.7 4.6 4.1 Interest income
Financial
8.1 7.0 11.7 Earnings before income taxes and after-tax earnings from joint ventures
Income taxes
Split
111.5 78.4 85.7 Financial stock-based compensation expense, net of tax
Financial
2.8 188.7 401.5 After-tax earnings from joint ventures
Operating
Net earnings, including earnings attributable to redeemable and noncontrolling interests
Net earnings attributable to redeemable and noncontrolling interests
Financial
(39.4) (43.6) (32.0)
Net earnings attributable to General Mills
Comprehensive income items:
Foreign currency translation
Operating
Net actuarial income (loss)
Financial
(325.9) 197.9 140.1 Other fair value changes: Securities
Financial
0.1 0.8 1.2 Other fair value changes: Hedge deriviatives
Operating
Reclassification to earnings: Securities
Financial
- - (5.1)
Reclassification to earnings: Hedge deriviatives
Operating
Reclassification to earnings: Amortization of losses and prior service costs
Financial
128.6 122.5 117.6 Other comprehensive income attributable to noncontrolling interests, net
Financial
(2.1) 12.6 (38.5)
Comprehensive income attributable to General Mills
FEAT
(443.0) 333.4 379.0 Check:
Comprehensive Income attributable to GIS from above
1,402.0 2,236.6 2,680.7 Difference from comprehensive income attrib to GIS from IS Adjusted
0.00 - -
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
General Mills
5/31/2015
5/29/2016
5/28/2017
5/27/2018
Sales
17,630.3 16,563.1 15,619.8 15,740.4 Sales growth
-6.05%
-5.70%
0.77%
NOPAT
1,845.0 1,903.2 2,301.6 NOA
17,188.4 16,224.8 16,465.8 24,608.1 16,706.6 16,345.3 20,536.9 RNOA
11.04%
11.64%
11.21%
11.04%
11.64%
11.21%
FEAT
443.0 (333.4) (379.0)
NFL
12,645.5 11,742.4 12,374.2 18,298.6 12,194.0 12,058.3 15,336.4 RNFL
3.63%
-2.76%
-2.47%
3.63%
-2.76%
-2.47%
NOPAT
1,845.0 1,903.2 2,301.6 Sales
17,630.3 16,563.1 15,619.8 15,740.4 11.14%
12.18%
14.62%
Sales
17,630.3 16,563.1 15,619.8 15,740.4 17,188.4 16,224.8 16,465.8 17,188.4 16,224.8 16,465.8 24,608.1 0.991 0.956 0.766 0.991 0.956 0.766 NET SALES
$ 16,563.1 $ 15,619.8 $ 15,740.4 Cost of sales
(10,728.5) (10,066.2) (10,308.8)
Advertising expense
(754.4) (623.8) (575.9)
Research expense
(222.1) (218.2) (219.1)
Depreciation on capitalized leases
(176.0) (104.7) (171.9)
Defined benefit pension plans: Service cost
(134.6) (119.7) (102.9)
Other postretirement benefit plans: Service cost
(19.0) (12.5) (11.6)
Postemployment benefit plans: Service cost
(7.6) (8.8) (8.6)
Defined contribution plan expense
(61.2) (54.1) (49.2)
Other selling, general, and administrative expenses
(1,729.2) (1,730.7) (1,695.6)
Provision for income taxes
(868.5) (700.7) (143.9)
$ 1,862.0 $ 1,980.4 $ 2,452.9 Sales
17,630.3 16,563.1 15,619.8 15,740.4 NOPAT from Sales
1,862.0 1,980.4 2,452.9 Average NOA
52/53 week adjusted RNOA
Average NFL
52/53 week adjusted RNFL
Operating PM
Beginning NOA
Ending NOA
Operating ATO
52/53 week adjusted ATO
NOPAT
from Sales
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
11.24%
12.68%
15.58%
Check:
RNOA
11.04%
11.64%
11.21%
PM x ATO
11.04%
11.64%
11.21%
Difference
0.000
0.000
0.000
Operating PM
from Sales
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
General Mills
5/29/2016 5/28/2017 5/27/2018
Net sales - North America retail
66.03%
65.28%
64.26%
Net sales - Convenience stores & foodservice
11.61%
11.97%
12.26%
Net sales - Europe & Australia
12.06%
11.68%
12.61%
Net sales - Asia & Latin America
10.29%
11.07%
10.87%
100.00%
100.00%
100.00%
Cost of sales
(64.77)%
(64.45)%
(65.49)%
Gross profit
35.23%
35.55%
34.51%
Advertising expense
(4.55)%
(3.99)%
(3.66)%
Research expense
(1.34)%
(1.40)%
(1.39)%
Depreciation on capitalized leases
(1.06)%
(0.67)%
(1.09)%
Defined benefit pension plans: Service cost
(0.81)%
(0.77)%
(0.65)%
Other postretirement benefit plans: Service cost
(0.11)%
(0.08)%
(0.07)%
Postemployment benefit plans: Service cost
(0.05)%
(0.06)%
(0.05)%
Defined contribution plan expense
(0.37)%
(0.35)%
(0.31)%
Other selling, general, and administrative expenses
(10.44)%
(11.08)%
(10.77)%
Divestitures (loss) gain
0.89%
(0.09)%
0.00%
Restructuring, impairment, and other exit costs
(0.91)%
(1.17)%
(1.05)%
Income taxes
(5.24)%
(4.49)%
(0.91)%
After-tax earnings from joint ventures
0.53%
0.54%
0.54%
Foreign currency translation
(0.66)%
0.04%
(0.24)%
Other fair value changes: Hedge derivatives
0.10%
0.34%
(0.32)%
Reclassification to earnings: Hedge derivatives
(0.06)%
(0.16)%
0.11%
Operating PM
11.14%
12.18%
14.62%
Check: Same as Operating PM on Analyzing
0.00%
0.00%
0.00%
Excluding taxes
16.38%
16.67%
15.54%
Excluding taxes, foreign currency, and hedges
16.94%
16.29%
16.09%
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
General Mills
Total Sales
Assets
Cash and cash equivalents
Receivables: Customers
Receivables: Allowance for doubtful accounts
Inventories: Raw materials and packaging
Inventories: Finished goods
Inventories: Grain
Inventories: Excess of FIFO over LIFO cost
Deferred tax assets: Accrued liabilities
Deferred tax assets: Compensation and employee benefits
Deferred tax assets: Unrealized hedges
Deferred tax assets: Tax credit carryforwards
Deferred tax assets: Capital losses
Deferred tax assets: Net operating losses
Deferred tax assets: Other
Deferred tax assets: Valuation allowance
Prepaid expenses and other current assets: Other receivables
Prepaid expenses and other current assets: Prepaid expenses
Prepaid expenses and other current assets: Derivative receivables, primarily commodity-related
Prepaid expenses and other current assets: Grain contracts
Prepaid expenses and other current assets: Miscellaneous
Land, buildings, and equipment: Land
Land, buildings, and equipment: Buildings
Land, buildings, and equipment: Buildings under capital lease
Land, buildings, and equipment: Equipment
Land, buildings, and equipment: Equipment under capital lease
Land, buildings, and equipment: Capitalized software
Land, buildings, and equipment: Construction in progress
Land, buildings, and equipment: Accumulated depreciation
Capitalized lease asset
Goodwill: North America Retail
Goodwill: Pet
Goodwill: Convenience Stores & Foodservice
Goodwill: Europe & Australia
Goodwill: Asia & Latin America
Goodwill: Joint Ventures
Other intangible assets: Brands and other indefinite-lived intangibles
Other intangible assets: Franchise agreements, customer relationships, and other
Other intangible assets: Accumulated amortization
Other assets: Investments in and advances to joint ventures
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
Other assets: Life insurance
Other assets: Miscellaneous
Liabilities and Shareholders' Equity
Accounts payable
Other current liabilities: Accrued trade and consumer promotions
Other current liabilities: Accrued payroll
Other current liabilities: Accrued taxes
Other current liabilities: Grain contracts
Other current liabilities: Restructuring and other exit costs reserve
Other current liabilities: Derivative payable
Other current liabilities: Miscellaneous
Deferred tax liabilities: Brands
Deferred tax liabilities: Fixed assets
Deferred tax liabilities: Intangible assets
Deferred tax liabilities: Tax lease transactions
Deferred tax liabilities: Inventories
Deferred tax liabilities: Unrealized hedges
Deferred tax liabilities: Other
Other noncurrent liabilities: Accrued taxes
Other noncurrent liabilities: Miscellaneous
Inverse of Operating ATO
Operating ATO
Exclude Goodwill, Pet, and Brands
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
$ 16,563.1 $ 15,619.8 $ 15,740.4 5/29/2016
5/28/2017
5/27/2018
0.020 0.021 0.020 0.085 0.091 0.101 (0.002)
(0.002)
(0.002)
0.024 0.025 0.025 0.073 0.076 0.082 0.005 0.005 0.005 0.000 0.000 0.000 0.006 0.005 0.004 0.031 0.029 0.020 0.000 0.000 0.000 0.000 0.001 0.001 0.001 0.001 0.001 0.006 0.007 0.009 0.005 0.005 0.004 (0.013)
(0.015)
(0.013)
0.009 0.010 0.011 0.010 0.011 0.011 0.004 0.003 0.002 0.000 0.000 0.000 0.001 0.001 0.001 0.006 0.006 0.005 0.136 0.144 0.148 0.000 0.000 0.000 0.363 0.385 0.392 0.000 0.000 0.000 0.031 0.034 0.036 0.040 0.040 0.040 (0.349)
(0.371)
(0.375)
0.022 0.026 0.031 0.391 0.410 0.407 0.000 0.000 0.168 0.056 0.059 0.058 0.043 0.045 0.045 0.017 0.019 0.019 0.024 0.026 0.027 0.254 0.266 0.349 0.033 0.034 0.042 (0.008)
(0.010)
(0.011)
0.032 0.033 0.032
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
0.002 0.002 0.002 0.006 0.007 0.007 1.363 1.431 1.704 (0.113)
(0.133)
(0.155)
(0.034)
(0.033)
(0.031)
(0.023)
(0.023)
(0.021)
(0.009)
(0.009)
(0.008)
(0.000)
(0.000)
(0.000)
(0.006)
(0.005)
(0.005)
(0.005)
(0.002)
(0.001)
(0.017)
(0.019)
(0.019)
(0.080)
(0.084)
(0.089)
(0.028)
(0.031)
(0.026)
(0.013)
(0.015)
(0.016)
(0.003)
(0.003)
(0.002)
(0.003)
(0.004)
(0.003)
(0.001)
(0.002)
(0.002)
(0.001)
(0.002)
(0.002)
(0.012)
(0.012)
(0.014)
(0.007)
(0.008)
(0.006)
(0.354)
(0.384)
(0.400)
1.009 1.046 1.305 0.991 0.956 0.766 1.325 1.281 1.269
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
53-week Adjustment
0.9811321
1
1
1
0.35%
Actual
Forecasts
5/31/2015 5/29/2016 5/28/2017 5/27/2018 5/26/2019
Sales growth -4.25%
-5.70%
0.77%
9.78%
Total Sales
17,630.3 16,563.1 15,619.8 15,740.4 17,224.4 Total Sales (53-week adjusted forecasts)
17,630.3 16,563.1 15,619.8 15,740.4 17,279.5 -4.25%
-5.70%
0.77%
9.43%
North America Retail
11,612.1 10,936.6 10,196.9 10,115.4 10,115.4 Contributions from organic volume growth
-2.0%
-9.0%
0.0%
-1.0%
Organic net price realization and mix
1.0%
4.0%
-1.0%
1.0%
Organic net sales growth
-1.0%
-5.0%
-1.0%
0.0%
Foreign currency exchange
-1.0%
0.0%
0.0%
Acquisitions and divestitures
-3.0%
-2.0%
0.0%
Other unclassified
-0.8%
0.2%
0.2%
Convenience Stores & Foodservice
1,995.1 1,923.8 1,870.0 1,930.2 1,978.5 Contributions from organic volume growth
-1.0%
0.0%
1.0%
1.0%
Organic net price realization and mix
-1.0%
-3.0%
2.0%
1.5%
Organic net sales growth
-2.0%
-3.0%
3.0%
2.5%
Foreign currency exchange
0.0%
0.0%
0.0%
Acquisitions and divestitures
0.0%
0.0%
0.0%
Other unclassified
-1.6%
0.2%
0.2%
Europe & Australia
2,126.5 1,998.0 1,824.5 1,984.6 2,024.3 Contributions from organic volume growth
6.0%
-7.0%
-1.0%
-1.0%
Organic net price realization and mix
-2.0%
3.0%
3.0%
3.0%
Organic net sales growth
4.0%
-4.0%
2.0%
2.0%
Foreign currency exchange
-9.0%
-5.0%
7.0%
Acquisitions and divestitures
0.0%
0.0%
0.0%
Other unclassified
-1.0%
0.3%
-0.2%
Asia & Latin America
1,896.6 1,704.7 1,728.4 1,710.2 1,710.2
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
Contributions from organic volume growth
3.0%
-2.0%
-10.0%
-4.0%
Organic net price realization and mix
4.0%
5.0%
8.0%
4.0%
Organic net sales growth
7.0%
3.0%
-2.0%
0.0%
Foreign currency exchange
-16.0%
0.0%
1.0%
Acquisitions and divestitures
0.0%
-2.0%
0.0%
Other unclassified
-1.1%
0.4%
-0.1%
Pet
1,153.1 1,317.0 1,396.0 Contributions from organic volume growth
0.0%
0.0%
3.0%
Organic net price realization and mix
0.0%
0.0%
3.0%
Organic net sales growth
0.0%
0.0%
6.0%
Foreign currency exchange
0.0%
0.0%
Acquisitions and divestitures
0.0%
0.0%
Other unclassified
0.0%
14.2%
Note: 2017 and 2018 Pet sales estimated as excess sales from proforma disclosures
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
0.35%
0.35%
0.35%
0.35%
0.35%
0.35%
0.35%
Terminal
5/31/2020 5/30/2021 5/29/2022 5/28/2023 5/26/2024 5/25/2025
5/31/2026
1.46%
1.62%
1.65%
1.60%
1.55%
1.55%
1.55%
17,415.7 17,637.2 17,866.5 18,089.8 18,306.9 18,526.6 18,748.9 17,531.9 17,816.2 18,110.2 18,400.0 18,685.2 18,974.8 19,268.9 1.11%
1.27%
1.30%
1.25%
1.20%
1.20%
1.20%
10,145.7 10,196.5 -0.5%
0.0%
0.8%
0.5%
0.3%
0.5%
2,014.1 2,046.3 0.8%
0.8%
1.0%
0.8%
1.8%
1.6%
2,062.8 2,108.1 -0.8%
-0.3%
2.7%
2.5%
1.9%
2.2%
1,727.3 1,761.8 terminal assumption
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
-2.0%
0.0%
3.0%
2.0%
1.0%
2.0%
1,465.8 1,524.5 2.5%
2.0%
2.5%
2.0%
5.0%
4.0%
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
Actual
5/29/2016 5/28/2017 5/27/2018
Profit margin
11.14%
12.18%
14.62%
Net sales
100.00%
100.00%
100.00%
Cost of sales
(64.77)%
(64.45)%
(65.49)%
Gross profit
35.23%
35.55%
34.51%
Advertising expense
(4.55)%
(3.99)%
(3.66)%
Research expense
(1.34)%
(1.40)%
(1.39)%
Depreciation on capitalized leases
(1.06)%
(0.67)%
(1.09)%
Defined benefit pension plans: Service cost
(0.81)%
(0.77)%
(0.65)%
Other postretirement benefit plans: Service cost
(0.11)%
(0.08)%
(0.07)%
Postemployment benefit plans: Service cost
(0.05)%
(0.06)%
(0.05)%
Defined contribution plan expense
(0.37)%
(0.35)%
(0.31)%
Other selling, general, and administrative expenses
(10.44)%
(11.08)%
(10.77)%
Divestitures (loss) gain
0.89%
(0.09)%
0.00%
Restructuring, impairment, and other exit costs
(0.91)%
(1.17)%
(1.05)%
Income taxes
(5.24)%
(4.49)%
(0.91)%
After-tax earnings from joint ventures
0.53%
0.54%
0.54%
Foreign currency translation
(0.66)%
0.04%
(0.24)%
Other fair value changes: Hedge deriviatives
0.10%
0.34%
(0.32)%
Reclassification to earnings: Hedge deriviatives
(0.06)%
(0.16)%
0.11%
Operating PM
11.14%
12.18%
14.62%
Check: For historical, same Operating PM as Analyzing
0.00%
0.00%
0.00%
Implied effective tax rate
31.8%
28.2%
5.9%
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
Forecasts
Terminal
5/26/2019 5/31/2020 5/30/2021 5/29/2022 5/28/2023 5/26/2024 5/25/2025
5/31/2026
12.32%
12.32%
12.45%
12.62%
12.62%
12.62%
12.62%
12.62%
100.00%
100.00%
100.00%
100.00%
100.00%
(65.50)%
(65.40)%
(65.30)%
(65.20)%
(65.20)%
34.50%
34.60%
34.70%
34.80%
34.80%
(3.80)%
(3.90)%
(3.90)%
(3.85)%
(3.85)%
(1.40)%
(1.40)%
(1.42)%
(1.45)%
(1.45)%
(0.60)%
(0.60)%
(0.60)%
(0.60)%
(0.60)%
(0.65)%
(0.65)%
(0.60)%
(0.60)%
(0.60)%
(0.08)%
(0.08)%
(0.08)%
(0.08)%
(0.08)%
(0.05)%
(0.05)%
(0.05)%
(0.05)%
(0.05)%
(0.30)%
(0.30)%
(0.30)%
(0.30)%
(0.30)%
(11.60)%
(11.55)%
(11.55)%
(11.50)%
(11.50)%
0.00%
0.00%
0.00%
0.00%
0.00%
(1.10)%
(1.10)%
(1.05)%
(1.05)%
(1.05)%
(3.10)%
(3.15)%
(3.20)%
(3.20)%
(3.20)%
looks close to an average of the pri
0.50%
0.50%
0.50%
0.50%
0.50%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
12.32%
12.32%
12.45%
12.62%
12.62%
20.8%
21.0%
21.1%
20.9%
20.9%
sanity check: looks reasonable
terminal assumption
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
ior years
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
Asset turnover
Weeks in year
Total Sales (53-week adjusted forecasts)
Inverse of OPERATING ASSET TURNOVERS (ATO)
Cash and cash equivalents
Receivables: Customers
Receivables: Allowance for doubtful accounts
Inventories: Raw materials and packaging
Inventories: Finished goods
Inventories: Grain
Inventories: Excess of FIFO over LIFO cost
Deferred tax assets: Accrued liabilities
Deferred tax assets: Compensation and employee benefits
Deferred tax assets: Unrealized hedges
Deferred tax assets: Tax credit carryforwards
Deferred tax assets: Capital losses
Deferred tax assets: Net operating losses
Deferred tax assets: Other
Deferred tax assets: Valuation allowance
Prepaid expenses and other current assets: Other receivables
Prepaid expenses and other current assets: Prepaid expenses
Prepaid expenses and other current assets: Derivative receivables, primarily commodity-related
Prepaid expenses and other current assets: Grain contracts
Prepaid expenses and other current assets: Miscellaneous
Land, buildings, and equipment: Land
Land, buildings, and equipment: Buildings
Land, buildings, and equipment: Buildings under capital lease
Land, buildings, and equipment: Equipment
Land, buildings, and equipment: Equipment under capital lease
Land, buildings, and equipment: Capitalized software
Land, buildings, and equipment: Construction in progress
Land, buildings, and equipment: Accumulated depreciation
Capitalized lease asset
Goodwill: North America Retail
Goodwill: Pet
Goodwill: Convenience Stores & Foodservice
Goodwill: Europe & Australia
Goodwill: Asia & Latin America
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
Goodwill: Joint Ventures
Other intangible assets: Brands and other indefinite-lived intangibles
Other intangible assets: Franchise agreements, customer relationships, and other
Other intangible assets: Accumulated amortization
Other assets: Investments in and advances to joint ventures
Other assets: Life insurance
Other assets: Miscellaneous
Accounts payable
Other current liabilities: Accrued trade and consumer promotions
Other current liabilities: Accrued payroll
Other current liabilities: Accrued taxes
Other current liabilities: Grain contracts
Other current liabilities: Restructuring and other exit costs reserve
Other current liabilities: Derivative payable
Other current liabilities: Miscellaneous
Deferred tax liabilities: Brands
Deferred tax liabilities: Fixed assets
Deferred tax liabilities: Intangible assets
Deferred tax liabilities: Tax lease transactions
Deferred tax liabilities: Inventories
Deferred tax liabilities: Unrealized hedges
Deferred tax liabilities: Other
Other noncurrent liabilities: Accrued taxes
Other noncurrent liabilities: Miscellaneous
Check: For historical, same Operating ATO as Analyzing
RNOA
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
Actual
Implied
Forecasts
5/31/2015
5/29/2016
5/28/2017
5/27/2018
5/26/2019
5/31/2020
5/30/2021
5/29/2022
5/28/2023
0.991 0.956 0.766 0.702 0.706 0.696 0.684 0.684 52
52
52
52
17,630.3 16,563.1 15,619.8 15,740.4 17,279.5 17,531.9 17,816.2 18,110.2 0.020 0.021 0.020 0.018 0.020 0.020 0.020 0.085 0.091 0.101 0.099 0.110 0.110 0.120 (0.002)
(0.002)
(0.002)
(0.002)
(0.002)
(0.002)
(0.002)
0.024 0.025 0.025 0.023 0.025 0.025 0.025 0.073 0.076 0.082 0.079 0.088 0.090 0.092 0.005 0.005 0.005 0.005 0.006 0.006 0.006 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.006 0.005 0.004 0.003 0.004 0.004 0.004 0.031 0.029 0.020 0.012 0.027 0.026 0.026 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.001 0.000 0.001 0.001 0.001 0.001 0.001 0.001 0.001 0.002 0.002 0.002 0.006 0.007 0.009 0.009 0.010 0.010 0.010 0.005 0.005 0.004 0.003 0.006 0.006 0.006 (0.013)
(0.015)
(0.013)
(0.010)
(0.010)
(0.010)
(0.010)
0.009 0.010 0.011 0.010 0.010 0.010 0.010 0.010 0.011 0.011 0.010 0.011 0.012 0.012 0.004 0.003 0.002 0.002 0.004 0.004 0.004 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.001 0.001 0.001 0.001 0.001 0.001 0.006 0.006 0.005 0.004 0.004 0.004 0.004 0.136 0.144 0.148 0.139 0.152 0.154 0.154 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.363 0.385 0.392 0.361 0.400 0.410 0.420 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.031 0.034 0.036 0.034 0.039 0.039 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 (0.349)
(0.371)
(0.375)
(0.345)
(0.375)
(0.380)
(0.380)
0.022 0.026 0.031 0.030 0.030 0.031 0.031 0.391 0.410 0.407 0.371 0.400 0.400 0.400 0.000 0.000 0.168 0.306 0.300 0.300 0.300 0.056 0.059 0.058 0.053 0.060 0.060 0.060 0.043 0.045 0.045 0.042 0.045 0.045 0.045 0.017 0.019 0.019 0.016 0.020 0.020 0.020
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
0.024 0.026 0.027 0.025 0.027 0.027 0.028 0.254 0.266 0.349 0.395 0.280 0.290 0.295 0.033 0.034 0.042 0.047 0.034 0.035 0.035 (0.008)
(0.010)
(0.011)
(0.011)
(0.010)
(0.010)
(0.010)
0.032 0.033 0.032 0.029 0.033 0.035 0.035 0.002 0.002 0.002 0.002 0.002 0.002 0.002 0.006 0.007 0.007 0.006 0.007 0.008 0.008 1.363 1.431 1.704 1.810 1.801 1.825 1.854 (0.113)
(0.133)
(0.155)
(0.159)
(0.140)
(0.141)
(0.142)
(0.034)
(0.033)
(0.031)
(0.029)
(0.030)
(0.030)
(0.030)
(0.023)
(0.023)
(0.021)
(0.020)
(0.020)
(0.020)
(0.020)
(0.009)
(0.009)
(0.008)
(0.008)
(0.008)
(0.008)
(0.008)
(0.000)
(0.000)
(0.000)
(0.000)
0.000 0.000 0.000 (0.006)
(0.005)
(0.005)
(0.004)
(0.006)
(0.006)
(0.006)
(0.005)
(0.002)
(0.001)
(0.000)
0.000 0.000 0.000 (0.017)
(0.019)
(0.019)
(0.018)
(0.020)
(0.021)
(0.021)
(0.080)
(0.084)
(0.089)
(0.087)
(0.086)
(0.086)
(0.088)
(0.028)
(0.031)
(0.026)
(0.019)
(0.031)
(0.031)
(0.031)
(0.013)
(0.015)
(0.016)
(0.015)
(0.015)
(0.015)
(0.015)
(0.003)
(0.003)
(0.002)
(0.002)
(0.003)
(0.003)
(0.003)
(0.003)
(0.004)
(0.003)
(0.002)
(0.004)
(0.004)
(0.004)
(0.001)
(0.002)
(0.002)
(0.002)
(0.003)
(0.004)
(0.004)
(0.001)
(0.002)
(0.002)
(0.002)
(0.002)
(0.002)
(0.002)
(0.012)
(0.012)
(0.014)
(0.015)
(0.011)
(0.011)
(0.011)
(0.007)
(0.008)
(0.006)
(0.004)
(0.007)
(0.007)
(0.007)
(0.354)
(0.384)
(0.400)
(0.385)
(0.386)
(0.389)
(0.392)
1.009 1.046 1.305 1.424 1.415 1.436 1.462 0.991 0.956 0.766 0.702 0.706 0.696 0.684 - - - 11.0%
11.6%
11.2%
8.7%
8.7%
8.7%
8.6%
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
Terminal
5/26/2024
5/25/2025
5/31/2026
0.684 0.684 0.684 terminal assumption
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
Amounts in millions
5/31/2015
5/29/2016
5/28/2017
Cost of operating capital
4.74%
5.44%
Cost of debt estimate 1:
Unadjusted FEAT
436.2 (98.4)
Unadjusted beginning NFL
10,366.4 9,221.0 Unadjusted ending NFL
10,366.4 9,221.0 10,296.5 Cost of financial liabilities capital after tax
4.45%
-1.01%
Implied cost of financial liabilities before current tax
6.85%
-1.55%
Cost of debt estimate 2:
Unadjusted interest expense
319.6 306.7 Interest bearing debt
9,191.5 8,430.9 9,481.7 Pretax borrowing rate
3.63%
3.42%
Cost of debt estimate 3:
Long-term debt average rate
3.58%
3.25%
Chosen value
3.60%
3.20%
(rounded to nearest 0.10%)
Cost of equity capital
Beta
0.550 0.661 Risk-free rate
2.33%
2.97%
Market risk premium
6.00%
6.00%
5.60%
6.90%
Book value of NFL
11,742.4 12,374.2 Fair value of long-term debt
8,629.0 8,547.0 Book value of long-term debt
8,161.1 8,247.6 Adjustment
467.9 299.4 Estimated fair value of NFL 12,210.3 12,673.6
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
Common Equity
Common shares outstanding
597,020,906 577,099,679 Market price per share at May 1
57.51 43.74 Market capitalization
34,334.7 25,242.3 Market value of operating
46,544.9 37,916.0 Cost of operating capital
4.74%
5.44%
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
5/27/2018
4.95%
80.5 10,296.5 16,861.9 0.59%
0.84%
389.5 15,818.6 3.08%
3.61%
3.30%
0.640 Estimated
2.50%
Also can check the daily market yield on U.S. 6.00%
Assumed
6.34%
18,298.6 14,169.7 Per footnote 7
14,268.8 (99.1)
18,199.5 http://www.federalreserve.gov/data
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
598,600,000 Per 10-K or 10-Q
51.31 Per Yahoo! Finance
30,714.2 Recalculated
48,913.6 4.95%
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
Treasury securities at 10-year constant maturity, per Federal Reserve on May 1, 20XX+1
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
General Mills
Actual
Forecasts
Year Ending
5/27/2018
5/26/2019
5/31/2020
Assumptions:
Sales growth
9.78%
1.46%
Profit margin
12.32%
12.32%
Asset turnover ratio
0.702
0.706
WACC
4.95%
Amounts in millions
Forecasts
5/27/2018
5/26/2019
5/31/2020
Sales
$ 15,740.4 $ 17,279.5 $ 17,531.9 NOPAT
$ 2,128.8 $ 2,159.9 NOA
$ 24,608.1 $ 24,815.5 $ 25,590.9 Forecasts (amounts in millions)
Sales
$ 15,740.4 $ 17,279.5 $ 17,531.9 NOPAT
$ 2,128.8 $ 2,159.9 $ 31.1 NOA
$ 24,608.1 $ 24,815.5 $ 25,590.9 $ 207.4 $ 775.4 FCF
$ 1,921.4 $ 1,384.6 ROPI
$ 910.5 $ 931.3 Growth in FCF
-27.94%
Growth in ROPI
2.29%
Discounted Cash Flow Model
Year Ending
5/27/2018
5/26/2019
5/31/2020
Forecasted sales
17,279.5 17,531.9 2,128.8 2,159.9 24,608.1 24,815.5 25,590.9 207.4 775.4 1,921.4 1,384.6 -27.94%
1.0495
1.1015
Present value of free cash flow from operations
1,830.8 1,257.0 Sum of present value of free cash flows
7,265.8 Continuing value
Capitalized
Change in NOPAT
Change in NOA
NOPAT
(Sales X PM
)
NOA
(Sales / ATO
)
∆
NOA
FCF
(
NOPAT
–∆
NOA
)
Growth in FCF
Discount factor (1 + r
WACC
)
t
FCF in terminal year
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
Present value of continuing value
44,671.8 Operating value
51,937.6 Residual Operating Income Model
Year Ending
5/27/2018
5/26/2019
5/31/2020
Forecasted sales
15,740.4
17,279.5
17,531.9
2,128.8
2,159.9
24,608.1
24,815.5
25,590.9
910.5
931.3
2.29%
1.0495
1.1015
867.5 845.5 4,116.3 Continuing value
Capitalized
Present value of continuing value
23,213.2 Operating value
51,937.6 NOPAT
(Sales X PM
)
NOA
(Sales / ATO
)
ROPI
(
NOPAT
t – r
WACC ∙
NOA
t
-1
)
Growth in ROPI
Discount factor (1 + r
WACC
)
t
Present value of ROPI
t
Sum of present value of ROPI
t
ROPI at horizon
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
5/30/2021
5/29/2022
5/28/2023
5/26/2024
5/25/2025
5/31/2026
1.62%
1.65%
1.60%
1.55%
1.55%
1.55%
12.45%
12.62%
12.62%
12.62%
12.62%
12.62%
0.696
0.684
0.684
0.684
0.684
0.684
5/30/2021
5/29/2022
5/28/2023
5/26/2024
5/25/2025
$ 17,816.2 $ 18,110.2 $ 18,400.0 $ 18,685.2 $ 18,974.8 $ 19,268.9 $ 2,218.1 $ 2,285.5 $ 2,322.1 $ 2,358.1 $ 2,394.6 $ 2,431.7 $ 26,482.7 $ 26,906.4 $ 27,323.5 $ 27,747.0 $ 28,177.1 $ 17,816.2 $ 18,110.2 $ 18,400.0 $ 18,685.2 $ 18,974.8 $ 19,268.9 $ 2,218.1 $ 2,285.5 $ 2,322.1 $ 2,358.1 $ 2,394.6 $ 2,431.7 $ 58.2 $ 67.4 $ 36.6 $ 36.0 $ 36.6 $ 37.1 $ 26,482.7 $ 26,906.4 $ 27,323.5 $ 27,747.0 $ 28,177.1 $ 891.8 $ 423.7 $ 417.0 $ 423.5 $ 430.1 $ 1,326.3 $ 1,861.8 $ 1,905.0 $ 1,934.6 $ 1,964.5 $ 951.1 $ 974.3 $ 989.9 $ 1,005.3 $ 1,020.9 -4.21%
40.38%
2.32%
1.55%
1.55%
2.13%
2.44%
1.60%
1.55%
1.55%
5/30/2021
5/29/2022
5/28/2023
5/26/2024
17,816.2 18,110.2 18,400.0 18,685.2 2,218.1 2,285.5 2,322.1 2,358.1 26,482.7 26,906.4 27,323.5 27,747.0 891.8 423.7 417.0 423.5 1,326.3 1,861.8 1,905.0 1,934.6 -4.21%
40.38%
2.32%
1.55%
1.1560
1.2132
1.2733
1,147.3 1,534.6 1,496.1 1,934.6 56,881.1
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
5/30/2021
5/29/2022
5/28/2023
5/26/2024
17,816.2
18,110.2
18,400.0
18,685.2
2,218.1
2,285.5
2,322.1
2,358.1
26,482.7
26,906.4
27,323.5
27,747.0
951.1
974.3
989.9
1,005.3
2.13%
2.44%
1.60%
1.55%
1.1560
1.2132
1.2733
822.7 803.1 777.4 1,005.3 29,557.6
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
Reminder that valuation date is May 1, 2019
Valuation from Mods 10-12 Full-Information Forecasts
51,937.6 Mid-year adjustment (1+r)^0.5
1.0245
53,207.8 Adjustment to May 1 (1+r)^(11/12)
1.0453
Value of operations
NFL elements:
10-K Value
Cash and cash equivalents
84.2 Deferred tax assets: Pension
57.1 Deferred tax assets: Stock, partnership, and miscellaneous investments
147.9 Defined benefit pension plans: Plan assets
6,177.4 Other postretirement benefit plans: Plan assets
726.1 Current portion of long-term debt
(1,600.1)
Notes payable: US commercial paper
(1,213.5)
Notes payable: Financial institutions
(336.3)
Other current liabilities: Dividend payable
(17.5)
Other current liabilities: Accrued interest, including interest rate swaps
(107.7)
Long-term debt
(12,668.7)
Long-term debt FV adjustment
99.1 Deferred tax liabilities: Stock, partnership, and miscellaneous investments
(317.1)
Other noncurrent liabilities: Accrued compensation and benefits, including pensions
(178.5)
Defined benefit pension plans: Benefit obligation
(6,416.0)
Other postretirement benefit plans: Benefit obligation
(871.8)
Postemployment benefit plans: Benefit obligation
(126.7)
Capitalized lease liability
(509.9)
Redeemable interest
(776.2)
Noncontrolling interests
(351.3)
(18,199.5)
Estimated value of NFL
Estimated value of common equity
Shares outstanding
598,790,681 Estimated value per share
64.24
Closing price on May 1
51.31 Sensitivity Analysis
Term. SG
Our Forecast
1.55%
Worst Case
1.25%
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
Best Case
1.85%
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
55,617.7 Update
84.2 Assume unchanged
57.1 Assume unchanged
147.9 Assume unchanged
6,177.4 Assume unchanged
726.1 Assume unchanged
(1,407.2)
Per 10-Q balance sheet
(1,804.9)
Per 10-Q Note 7
(166.4)
Per 10-Q Note 7
(17.5)
Assume unchanged
(107.7)
Assume unchanged
(11,642.6)
Per 10-Q balance sheet
89.0 Per 10-Q, page 14
(317.1)
Assume unchanged
(178.5)
Assume unchanged
(6,416.0)
Assume unchanged
(871.8)
Assume unchanged
(126.7)
Assume unchanged
(509.9)
Assume unchanged
(548.9)
Per 10-Q balance sheet
(319.0)
Per 10-Q balance sheet
(17,152.5)
(17,152.5)
38,465.3 Per latest 10-Q
Term. PM
Term. ATO
WACC
Value Per Share
12.62%
0.684
4.95%
$ 64.24 12.00%
0.670
5.25%
$ 49.04
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
12.95%
0.700
4.65%
$ 83.21
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
Base Assumptions
Sales Growth
1.20%
WACC
4.95%
Terminal Sales Growth Rate (prior to 53-we
64.24
0.90%
1.00%
1.10%
1.20%
4.50%
WACC
4.75%
5.00%
5.25%
5.50%
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
eek adjustment)
1.30%
Calculate Equity Value per share across numerous combinations of assumptions
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
Baghiben
arrow_forward
Balance Sheet for Bearcat Hathaway, 2022
2021
2022
Cash
Accounts
Receivable
Inventory
Current Assets
Accum.Depreciation
Net Fixed Assets
Gross Fixed Assets $16,251,665 $20,567,330
Less
$7,460,897 $10,117,819
Total Assets
O 11.58%
O 44.90%
O 8.37%
$5,268,485 $10,268,485
O 4.35%
$2,574,230 $2,314,672
O 6.02%
$529,062 $696,685
$8,371,777 $13,279,842
Total Liabilities
and Equity
What is the common size value for 2022 Notes Payable?
$8,790,768 $10,449,511
$17,162,545 $23,729,353
Current
Liabilities
2021
Accounts
Payable
Notes Payable $1,033,110 $1,987,233
2022
$1,673,992 $2,438,271
$2,707,102 $4,425,504
Long Term Debt $9,242,830 $11,468,302
Total Liabilities $11,949,932 $15,893,806
Common Stock
($0.50 par)
$1,300,000 $1,600,000
Capital Surplus $1,148,120 $1,800,969
Retained
$2,764,493 $4,434,578
Earnings
$17,162,545 $23,729,353
arrow_forward
Calculate the current ratio current assets/current liabilities for Castle rock construction round to one decimal place. The current ratio 2:1
arrow_forward
Loans and
borrowings
Deferred taxek
liability
14,130
10,220-
1,010
960-
15,140
11,180
Current
Liabilities
Trade
payable
Current tax
1,260
1,140
1,040
920
payable
Interest
payable
980-
740k
3,280
40,190
2,800
32,960
Total Equity
and
Liabilities
2019
£'000
2018
£'000
Sales
Cost of sales
Distribution costse
Administration expenses
Gain on disposal of PPE
22,000
(11,800)
(3,100)
(1,630)
280
16,000
(8,200)
(2,600)
(1,420)
Interest expensee a
Тах еexpensee
(1,140)
(1,820)
(760)
(1,240)
Net profit
2,790
1,780
1.
The company disposal of PPE during the year with a book value of £1,000,000.
2. Depreciation of property, plant and equipment for the year was £650,000.4
The intangibles were acquired for cash towards the end of the year and were not sub ject to
any amortisation in the current period.e
3.
Prepare the statement of cash flows using the indirect method.
arrow_forward
3M
CONSOLIDATED BALANCE SHEETS
(In millions)
ASSETS
Dec 31, 2019
Dec 31, 2018
Cash & cash equivalents
$ 2,353
$ 2,853
Accounts receivable, net allowances of $161 and $95
4,791
5,020
Inventories
4,134
4,366
Prepaid expenses
704
741
Other current assets
989
729
Total current assets
12,971
13,709
Property, plant and equipment, net
9,333
8,738
erating lease right-of-use assets
858
Goodwill
13,444
10,051
Other intangible assets, net
6,379
2,657
Other long-term assets
1,674
1,345
Total assets
$ 44,659
$36,500
LIABILITIES & STOCKHOLDERS’ EQUITY
Short-term borrowings and current portion of long-term debt
Accounts payable
$ 2,795
$ 1,211
2,228
2,266
Accrued salaries
702
749
Accrued income taxes
194
243
Current operating lease liabilities
247
Other current liabilities
3,056
2,775
Total current liabilities
9,222
7,244
Long-term debt
Pension and postretirement benefits
17,518
13,411
3,911
2,987
Long-term operating lease liabilities
Other long-term liabilities
б07
3,275
3,010
Total liabilities…
arrow_forward
vvk.2
arrow_forward
Northrend Clothiers reported the following selected items at July 31, 2024 (last year's-2023-amounts also given as needed):
(Click the icon to view the financial data.)
Compute Northrend's (a) acid-test ratio, (b) accounts receivable turnover ratio, and (c) days' sales in receivables for the year ending July 31, 2024. Evaluate each ratio value as strong or weak. Northrend sells
on terms of net 30. (Round days' sales in receivables to a whole number.) (Ignore leap-years, using a 365-day where needed.)
(a) Compute Northrend's acid-test ratio. (Round your final answer to two decimal places. Abbreviation used: Avg. = Average; Invest. = Investment, Liab. = Liabilities; Merch. = Merchandise, Receiv. = Receivable;
Rev. Revenue.)
+
+
+
)+
)+
= Acid-test ratio
arrow_forward
Balance Sheet for Bearcat Hathaway, 2022
2021
2022
Cash
Accounts.
Receivable
$5,268,485 $10,268,485
Inventory
$529,062 $696,685
Current Assets $8,371,777 $13,279,842
Less
$2,574,230 $2,314,672
Gross Fixed Assets $16,251,665 $20,567,330
Accum.Depreciation
Total Assets
$7,460,897 $10,117,819
Accounts
Payable
Notes.
Payable
Current
Liabilities
Calculate the net working capital in 2022.
Long Termi
Debt
Total
Liabilities,
None of these options are correct
$10,572,740
$5,664,675
$8,854,338
$3,946,273
Total
$17,162,545 $23,729,353 Liabilities
and Equity
Capital
Surplus
Retained.
Earnings
2021
2022
$1,673,992 $2,438,271
Common
Net Fixed Assets $8,790,768 $10,449,511 Stock ($0.50 $1,300,000 $1,600,000
par)
$1,033,110 $1,987,233
$2,707,102 $4,425,504
$9,242,830 $11,468,302
$11,949,932 $15,893,806
$1,148,120 $1,800,969
$2,764,493 $4,434,578
$17,162,545 $23,729,353
arrow_forward
Please calculate the verticle and horizontal analysis of the balance sheet.
Consolidated Balance Sheets (USD $)
12/31/2020
Vertical Analysis
12/31/2019
Vertical Analysis
Horizontal Analysis
In Millions, unless otherwise specified
Current Assets:
Cash and Cash Equivalents
$1,723
$1,929
Receivables, net
1,484
1,398
Merchandise Inventories
11,079
11,057
Other Current Assets
1,016
895
Total Current Assets
15,302
15,279
Property and Equipment, at cost
38,513
39,064
Less Accumulated Depreciation and Amortization
15,793
15,716
Net Property and Equipment
22,720
23,348
Goodwill
1,353
1,289
Other Assets
571
602
Total Assets
39,946
40,518
Current Liabilities:
Short-Term Debt
290
0
Accounts Payable
5,807
5,797
Accrued Salaries and Related Expenses
1,391
1,428
Sales Taxes Payable
434
396
Deferred Revenue
1,468…
arrow_forward
Assets
Liabilities and Owners' Equity
2020
2021
2020
2021
Current Assets
Current liabilities
Cash
$32,653
$39,350
Accounts Payable
$34,886
$44,285
Accounts Receivable
$16,911
$28,877
Notes Payable
$18,058
$16,848
Inventory
$34,495
$44,336
Other
$18,871
$25,619
Total
$84,059
$112,563
Total
$71,815
$86,752
Long term debt
$110,000
$140,000
Fixed Assets
Owners' Equity
Net plant and equipment
$441,099
$502,872
Common stock
$55,000
$55,000
Accumulated retained earnings
$288,343
$333,683
Total
$343,343
$388,683
Total Assets
$525,158
$615,435
Total liabilities and owners' equity
$525,158
$615,435
Income statement for 2021:
Sales
$531,750
COGS
$377,294
Depreciation
$46,686
EBIT
$107,770
Interest paid…
arrow_forward
Financial information of ABC Company for the year ended December 31, 2021.
Description
Debit
Credit
Cash on hand
40,000.00
Cash in bank
900,000.00
Petty cash fund
10,000.00
BSP Treasury bill, purchased on December 1, 2021 and due March 1, 2022
150,000.00
Financial assets at fair value
200,000.00
Financial assets at amortized cost
3,000,000.00
Investment in associate at equity method
1,000,000.00
Accounts receivable
580,000.00
Trade Notes receivable
100,000.00
Accrued interest on notes receivable
10,000.00
Advances to employees, collectible currently
30,000.00
Merchandise Inventory
1,500,000.00
Store supplies
50,000.00
Office supplies unused
30,000.00
Prepaid insurance
20,000.00
Land
1,500,000.00
Building
4,500,000.00
Equipment
1,000,000.00…
arrow_forward
Sh11
arrow_forward
Current Attempt in Progress
XYZ provided the following financial information:
XYZBalance SheetAs of 12/31/19
Assets:
Liabilities and Equity:
Cash and marketable securities
$27,476
Accounts payable and accruals
$154,860
Accounts receivable
$143,519
Short-term notes payable
$21,255
Inventory
$212,379
Total current liabilities
$176,115
Total current assets
$383,374
Long term debt
$155,510
Net plant and equipment
$602,704
Total liabilities
$331,625
Goodwill and other assets
$42,422
Common stock
$312,719
Retained earnings
$384,156
Total assets
$1,028,500
Total liabilities and equity
$1,028,500
In addition, it was reported that the firm had a net income of:
$158,402
and net sales of:
$4,272,431
Calculate the following ratios for this firm (Use 365 days for calculation. Round answers to 2 decimal places, e.g.…
arrow_forward
React Corporation
Comparative Statements of Financial Position
December 31, 2025 and 2024
2025
2024
Assets
Current Assets
Cash & Cash Equivalent
106,789
102,375
Trade & Other Receivables
327,611
277,467
Inventory
331,863
297,654
Prepaid Expenses
101,565
114,813
Total Current Assets
870,828
792,309
Noncurrent Assets
Property, Plant & Equipment
Intangibles
135,754
166,481
Total Noncurrent Assets
7,500
7,500
TOTAL ASSETS
143,254
173,981
1,014,082
966,290
Liabilities and Shareholders’ Equity
Current Liabilities
Trade & Other Payables
Unearned Revenues
238,000
208,703
Notes Payables - current
107,508
82,456
Total Current Liabilities
45,000
45,000…
arrow_forward
Balance Sheet as at As at 30/9/16 As at 30/9/15 $ $ Assets Current assets- Cash 8,200 9,400 Accounts Receivable 107,000 103,500 Inventory 82,700 71,300 Non-current assets less accumulated depreciation 242,600 245,700 Total assets 440,500 429,900 Liabilities and Owners' equity Current liabilities 117,000 120,000 Loan (repayable in 2019) 152,000 150,000 Total liabilities 269,000 270,000 Owners' equity 171,500 159,900 Total Liabilities and Owners' equity 440,500 429,900 Summarised Income Statement of Bishan Enterprise for the year ended 30 September 2016 $ Sales 990,000 Cost of goods sold 580,000 Gross profit 410,000 Operating expenses 350,000 Net profit 60,000 · Note - The owner withdrew $48,400 during 2016. Required: Calculate…
arrow_forward
Carla Vista Co. has these comparative balance sheet data:
CARLA VISTA CO.Balance SheetsDecember 31
2022
2021
Cash
$ 16,140
$ 32,280
Accounts receivable (net)
75,320
64,560
Inventory
64,560
53,800
Plant assets (net)
215,200
193,680
$371,220
$344,320
Accounts payable
$ 53,800
$ 64,560
Mortgage payable (15%)
107,600
107,600
Common stock, $10 par
150,640
129,120
Retained earnings
59,180
43,040
$371,220
$344,320
Additional information for 2022:
1.
Net income was $32,500.
2.
Sales on account were $392,900. Sales returns and allowances amounted to $27,300.
3.
Cost of goods sold was $217,300.
4.
Net cash provided by operating activities was $57,200.
5.
Capital expenditures were $30,000, and cash dividends were $19,000.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
please help me
arrow_forward
6
arrow_forward
Help | System Announcements
Balance Sheet
As of 12/31/19
Assets:
Liabilities and Equity:
Cash and marketable securities
$28,987
Accounts payable and accruals
$154,807
Accounts receivable
$142,845
Short-term notes payable
$21,639
Inventory
$212,722
Total current liabilities
$176,446
Total current assets
$384,554
Long term debt
$155,510
Net plant and equipment
$602,309
Total liabilities
$331,956
Goodwill and cther assets
$42,422
Common stock
$314,932
Retained earnings
$382,397
Total assets
$1,029,285
Total liabilities and equity
$1,029,285
In addition, it was reported that the firm had a net income of:
$158,531
and net sales of:
$4,338,283
Calculate the following ratios for this firm (Use 365 days for calculation. Round answers to 2 decimal places, e.g. 52.75.):
Current Ratio
times
Quick Ratio
times
Average Collection Period
days
Total Asset Turnever
times
Fixed Asset Turnover
times
Question
arrow_forward
Calculate average receivable turnover
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
- Baghibenarrow_forwardBalance Sheet for Bearcat Hathaway, 2022 2021 2022 Cash Accounts Receivable Inventory Current Assets Accum.Depreciation Net Fixed Assets Gross Fixed Assets $16,251,665 $20,567,330 Less $7,460,897 $10,117,819 Total Assets O 11.58% O 44.90% O 8.37% $5,268,485 $10,268,485 O 4.35% $2,574,230 $2,314,672 O 6.02% $529,062 $696,685 $8,371,777 $13,279,842 Total Liabilities and Equity What is the common size value for 2022 Notes Payable? $8,790,768 $10,449,511 $17,162,545 $23,729,353 Current Liabilities 2021 Accounts Payable Notes Payable $1,033,110 $1,987,233 2022 $1,673,992 $2,438,271 $2,707,102 $4,425,504 Long Term Debt $9,242,830 $11,468,302 Total Liabilities $11,949,932 $15,893,806 Common Stock ($0.50 par) $1,300,000 $1,600,000 Capital Surplus $1,148,120 $1,800,969 Retained $2,764,493 $4,434,578 Earnings $17,162,545 $23,729,353arrow_forwardCalculate the current ratio current assets/current liabilities for Castle rock construction round to one decimal place. The current ratio 2:1arrow_forward
- Loans and borrowings Deferred taxek liability 14,130 10,220- 1,010 960- 15,140 11,180 Current Liabilities Trade payable Current tax 1,260 1,140 1,040 920 payable Interest payable 980- 740k 3,280 40,190 2,800 32,960 Total Equity and Liabilities 2019 £'000 2018 £'000 Sales Cost of sales Distribution costse Administration expenses Gain on disposal of PPE 22,000 (11,800) (3,100) (1,630) 280 16,000 (8,200) (2,600) (1,420) Interest expensee a Тах еexpensee (1,140) (1,820) (760) (1,240) Net profit 2,790 1,780 1. The company disposal of PPE during the year with a book value of £1,000,000. 2. Depreciation of property, plant and equipment for the year was £650,000.4 The intangibles were acquired for cash towards the end of the year and were not sub ject to any amortisation in the current period.e 3. Prepare the statement of cash flows using the indirect method.arrow_forward3M CONSOLIDATED BALANCE SHEETS (In millions) ASSETS Dec 31, 2019 Dec 31, 2018 Cash & cash equivalents $ 2,353 $ 2,853 Accounts receivable, net allowances of $161 and $95 4,791 5,020 Inventories 4,134 4,366 Prepaid expenses 704 741 Other current assets 989 729 Total current assets 12,971 13,709 Property, plant and equipment, net 9,333 8,738 erating lease right-of-use assets 858 Goodwill 13,444 10,051 Other intangible assets, net 6,379 2,657 Other long-term assets 1,674 1,345 Total assets $ 44,659 $36,500 LIABILITIES & STOCKHOLDERS’ EQUITY Short-term borrowings and current portion of long-term debt Accounts payable $ 2,795 $ 1,211 2,228 2,266 Accrued salaries 702 749 Accrued income taxes 194 243 Current operating lease liabilities 247 Other current liabilities 3,056 2,775 Total current liabilities 9,222 7,244 Long-term debt Pension and postretirement benefits 17,518 13,411 3,911 2,987 Long-term operating lease liabilities Other long-term liabilities б07 3,275 3,010 Total liabilities…arrow_forwardvvk.2arrow_forward
- Northrend Clothiers reported the following selected items at July 31, 2024 (last year's-2023-amounts also given as needed): (Click the icon to view the financial data.) Compute Northrend's (a) acid-test ratio, (b) accounts receivable turnover ratio, and (c) days' sales in receivables for the year ending July 31, 2024. Evaluate each ratio value as strong or weak. Northrend sells on terms of net 30. (Round days' sales in receivables to a whole number.) (Ignore leap-years, using a 365-day where needed.) (a) Compute Northrend's acid-test ratio. (Round your final answer to two decimal places. Abbreviation used: Avg. = Average; Invest. = Investment, Liab. = Liabilities; Merch. = Merchandise, Receiv. = Receivable; Rev. Revenue.) + + + )+ )+ = Acid-test ratioarrow_forwardBalance Sheet for Bearcat Hathaway, 2022 2021 2022 Cash Accounts. Receivable $5,268,485 $10,268,485 Inventory $529,062 $696,685 Current Assets $8,371,777 $13,279,842 Less $2,574,230 $2,314,672 Gross Fixed Assets $16,251,665 $20,567,330 Accum.Depreciation Total Assets $7,460,897 $10,117,819 Accounts Payable Notes. Payable Current Liabilities Calculate the net working capital in 2022. Long Termi Debt Total Liabilities, None of these options are correct $10,572,740 $5,664,675 $8,854,338 $3,946,273 Total $17,162,545 $23,729,353 Liabilities and Equity Capital Surplus Retained. Earnings 2021 2022 $1,673,992 $2,438,271 Common Net Fixed Assets $8,790,768 $10,449,511 Stock ($0.50 $1,300,000 $1,600,000 par) $1,033,110 $1,987,233 $2,707,102 $4,425,504 $9,242,830 $11,468,302 $11,949,932 $15,893,806 $1,148,120 $1,800,969 $2,764,493 $4,434,578 $17,162,545 $23,729,353arrow_forwardPlease calculate the verticle and horizontal analysis of the balance sheet. Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at cost 38,513 39,064 Less Accumulated Depreciation and Amortization 15,793 15,716 Net Property and Equipment 22,720 23,348 Goodwill 1,353 1,289 Other Assets 571 602 Total Assets 39,946 40,518 Current Liabilities: Short-Term Debt 290 0 Accounts Payable 5,807 5,797 Accrued Salaries and Related Expenses 1,391 1,428 Sales Taxes Payable 434 396 Deferred Revenue 1,468…arrow_forward
- Assets Liabilities and Owners' Equity 2020 2021 2020 2021 Current Assets Current liabilities Cash $32,653 $39,350 Accounts Payable $34,886 $44,285 Accounts Receivable $16,911 $28,877 Notes Payable $18,058 $16,848 Inventory $34,495 $44,336 Other $18,871 $25,619 Total $84,059 $112,563 Total $71,815 $86,752 Long term debt $110,000 $140,000 Fixed Assets Owners' Equity Net plant and equipment $441,099 $502,872 Common stock $55,000 $55,000 Accumulated retained earnings $288,343 $333,683 Total $343,343 $388,683 Total Assets $525,158 $615,435 Total liabilities and owners' equity $525,158 $615,435 Income statement for 2021: Sales $531,750 COGS $377,294 Depreciation $46,686 EBIT $107,770 Interest paid…arrow_forwardFinancial information of ABC Company for the year ended December 31, 2021. Description Debit Credit Cash on hand 40,000.00 Cash in bank 900,000.00 Petty cash fund 10,000.00 BSP Treasury bill, purchased on December 1, 2021 and due March 1, 2022 150,000.00 Financial assets at fair value 200,000.00 Financial assets at amortized cost 3,000,000.00 Investment in associate at equity method 1,000,000.00 Accounts receivable 580,000.00 Trade Notes receivable 100,000.00 Accrued interest on notes receivable 10,000.00 Advances to employees, collectible currently 30,000.00 Merchandise Inventory 1,500,000.00 Store supplies 50,000.00 Office supplies unused 30,000.00 Prepaid insurance 20,000.00 Land 1,500,000.00 Building 4,500,000.00 Equipment 1,000,000.00…arrow_forwardSh11arrow_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