Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me create the 2023 pro forma financial statements (Statement of Cash Flows, Balance Sheet, Income Statement) for The Boston Beer Company assuming the

Please help me create the 2023 pro forma financial statements (Statement of Cash Flows, Balance Sheet, Income Statement) for The Boston Beer Company assuming the trends will continue for 2023.

The Boston Beer Company Projected Comprehensive Income Statement Sheet for the year ended December 31, 2023 (in Thousands)
2023 (Projected) 2022 2021
Revenue $ 2,222,667 $ 2,196,650
Less excise taxes 132,333 139,028
Net revenue 2,090,334 2,057,622
Cost of goods sold 1,228,348 1,259,830
Gross profit 861,986 797,792
Operating expenses:
Advertising, promotional, and selling expenses 578,400 606,994
General and administrative expenses 157,534 133,624
Contract termination costs and other 5,379 30,678
Impairment of intangible asset 27,100 -
Impairment of brewery assets 2,782 18,499
Total operating expenses 771,195 789,795
Operating income 90,791 7,997
Other income (expense):
Interest income (expense), net 2,561 (110)
Other (expense) income, net (1,916) (978)
Total other income (expense), net 645 (1,088)
Income before income tax provision (benefit) 91,436 6,909
Income tax provision (benefit) 24,173 (7,644)
Net income $ 67,263 $ 14,553
Net income per common share - basic $ 5.46 $ 1.19
Net income per common share - diluted $ 5.44 $ 1.17
Weighted-average number of common shares - basic 12,317 12,280
Weighted-average number of common shares - diluted 12,345 12,436
Net income $ 67,263 $ 14,553
Other comprehensive (loss) income:
Foreign currency translation adjustment (269) (32)
Defined benefit plans liability adjustment 253 90
Total other comprehensive (loss) income, net of tax 16 58
Comprehensive income $ 67,247 $ 14,611
The Boston Beer Company Projected Comprehensive Balance Sheet for the year ended December 31, 2023 (in Thousands)
2023 (Projected) 2022 2021
Assets
Current Assets:
Cash and cash equivalents $ 180,560 $ 26,853
Restricted cash - 39,468
Accounts receivable 56,672 55,022
Inventories 148,450 149,118
Prepaid expenses and other current assets 27,461 21,462
Income tax receivable 10,126 53,418
Total current assets 423,269 345,341
Property, plant, and equipment, net 667,909 664,815
Operating right-of-use assets 43,768 52,774
Goodwill 112,529 112,529
Intangible assets 76,324 103,677
Third-party production prepayments 61,339 88,294
Other assets 35,635 19,354
Total assets $ 1,420,773 $ 1,386,784
Liabilities and Stockholders' Equity
Current Liabilities:
Accounts payable $ 84,248 $ 85,920
Accrued expenses and other current liabilities 111,153 161,552
Current operating lease liabilities 8,866 7,634
Total current liabilities 204,267 255,106
Deferred income taxes, net 96,592 87,495
Non-current operating lease liabilities 45,274 53,849
Other liabilities 6,091 6,925
Total liabilities 352,224 403,375
Commitments and Contingencies(See Note N)
Stockholders' Equity:
Class A Common Stock, $0.01par value; 22,700,000shares authorized; 10,238,009 102 102
and 10,183,801issued and outstanding as of December 31, 2022 and
December 25, 2021, respectively
Class B Common Stock, $0.01par value; 4,200,000shares authorized; 2,068,000 21 21
issued and outstanding at December 31, 2022 and December 25, 2021
Additional paid-in capital 629,515 611,622
Accumulated other comprehensive loss (210) (194)
Retained earnings 439,121 371,858
Total stockholders' equity 1,068,549 983,409
Total liabilities and stockholders' equity $ 1,420,773 $ 1,386,784
The Boston Beer Company Consolidated Statement of Cash Flows for the year ended December 31, 2023 (in Millions)
2023 (Projected) 2022 2021
Cash flows provided by operating activities:
Net income $ 67,263 $ 14,553
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization 81,356 72,096
Impairment of intangible asset 27,100 -
Impairment of brewery assets 2,782 18,499
Gain on sale of property, plant, and equipment (237) (217)
Change in right-of-use assets 7,972 8,018
Other non-cash expense (income) 326 (182)
Stock-based compensation expense 13,988 18,615
Deferred income taxes 9,097 (5,225)
Changes in operating assets and liabilities:
Accounts receivable (2,042) 23,071
Inventories 131 (21,224)
Prepaid expenses, income tax receivable, and other current assets 38,652 (49,073)
Third-party production prepayments 26,955 (16,635)
Other assets (14,031) (5,699)
Accounts payable (2,219) (27,361)
Accrued expenses and other current liabilities (50,358) 38,894
Change in operating lease liabilities (6,516) (8,229)
Other liabilities (274) (3,604)
Net cash provided by operating activities 199,945 56,297
Cash flows used in investing activities:
Purchases of property, plant, and equipment (90,582) (147,919)
Proceeds from sale of property, plant, and equipment 2,076 1,157
Other investing activities - 145
Net cash used in investing activities (88,506) (146,617)
Cash flows provided by (used in) financing activities:
Proceeds from exercise of stock options and sale of investment shares 7,946 10,465
Net cash paid on note payable and finance leases (1,672) (1,570)
Cash borrowed on line of credit 30,000 -
Cash paid on line of credit (30,000) -
Payment of tax withholding on stock-based payment awards and investment shares (3,474) (15,536)
Net cash provided by (used in) financing activities 2,800 (6,641)
Change in cash and cash equivalents 114,239 (96,961)
Cash and cash equivalents and restricted cash at beginning of period 66,321 163,282
Cash and cash equivalents and restricted cash at end of period $ 180,560 $ 66,321
Supplemental disclosure of cash flow information:
Income taxes paid $ 16,980 $ 53,889
Income taxes refunded $ 45,124 $ 12,668
Cash paid for amounts included in measurement of lease liabilities
Operating cash flows for operating leases $ 8,510 $ 10,495
Operating cash flows for finance leases $ 71 $ 121
Financing cash flows for finance leases $ 1,598 $ 1,499
Right-of-use-assets obtained in exchange for operating lease obligations $ (827) $ 2,309
Right-of-use-assets obtained in exchange for finance lease obligations $ - $ 472
Change in purchase of property, plant and equipment in accounts payable and accrued expenses $ 1,045 $ 15,824
Supplemental disclosure of cash, cash equivalents and restricted cash 2023 (Projected) 2022 2021
Cash and cash equivalents $ 180,560 $ 26,853
Restricted cash - 39,468
Total cash, cash equivalents and restricted cash shown in the statements of cash flows $ - $ 180,560 $ 66,321

I do not need every row calculated just the totals for each sections.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Accounting Volume 1 Financial Accounting

Authors: Mitchell Franklin, Patty Graybeal, Dixon Cooper, OpenStax

1st Edition

1593995946, 978-1593995942

More Books

Students also viewed these Accounting questions

Question

Write the answers in scientific notation. If K (2.410) (1.91011)

Answered: 1 week ago

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago

Question

What is the relationship between the FASB and SEC in detail?

Answered: 1 week ago