Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Homework Assignment # 1: Tulane University A.B. Freeman School of Business Finance Exam Pabst Blue Ribbon Beer Pabst Brewing Company was established in 1844 in Milwaukee, WI. The company emphasized...

1 answer below »
Homework Assignment # 1:
Tulane University
A.B. Freeman School of Business
Finance Exam
Pabst Blue Ri
on Bee
Pabst Brewing Company was established in 1844 in Milwaukee, WI.
The company emphasized premium quality, and entered its product regularly in regional and national tasting competitions. In 1882, as a marketing ploy, the company began tying a blue silk ri
on around the neck of each bottle of its
ew to identify the beer as “award winning.” In 1893, Pabst’s “Select” beer (by then colloquially called Blue Ri
on by customers), did win the title of America’s Best Beer at the World’s Columbian Exposition in Chicago, beating out archrival Budweiser. The beer proved so popular that in 1902, Pabst had to order ten million yards of blue ri
on to satisfy demand.
Despite its illustrious beginning, Pabst began to languish in the 1960s, losing ground to larger competitors. In the early 1980’s, Pabst sought to boost its sales volume by discounting the price of its flagship beer. Unfortunately, the market interpreted the price cut as evidence of lowered quality, and sales volume did not increase as expected. Pabst was financially weakened as a result. Pabst came under additional pressure as the
ewing industry consolidated its assets into the hands of a few large players. In an effort to adapt to this trend, Pabst bought Olympia Brewing of Tumwater, WA in XXXXXXXXXXBy 1984, Pabst’s share price had been beaten down to $6.31, and the company became the target of a takeover battle.
Pabst management faced a grim choice. They could continue to run Pabst under the existing strategy, or they could sell out to one of two bidders:
1. Heileman Brewing Company proposed to purchase Pabst and reinvigorate the
and.
2. Paul Kalmanowitz, through his company S&P, proposed to purchase Pabst, spend almost no money on advertising expenses or other marketing, and “harvest” the company by letting sales volume decline.
These contrasting strategies lead to different forecasts of free cash flow and possibly different values for Pabst’s assets. In the workbook associated with this exam, I have provided you with templates for valuing Pabst under each of the three scenarios. The worksheets ta
ed “Pabst,” “Heileman,” and “S&P” present pro-forma templates and assumptions associated with each of the three strategies. Your assignment is to complete the spreadsheets based on the assumptions given and a
ive at a value per share for Pabst’s common stock under each of the three scenarios. Specifically,
(1) Assuming a WACC of 13%, what is Pabst’s value under each of the three scenarios?
(2) How do these values change if the WACC is 17% instead?
(3) Interpret your results.
Here’s a couple of “hints”:
1. Don’t change the green shaded cells on the spreadsheets. You only need to complete the yellow shaded portions. Don’t hard code numbers in the yellow areas; use only formulas.
2. In computing free cash flow, notice that the change in net fixed assets equals to CAPEX minus Depreciation, so subtracting the change in net fixed assets is the same thing as adding Depreciation and subtracting CAPEX.
3. GS & A expense means “General, Selling, and Administrative” expense. Mostly marketing and advertising and corporate overhead costs.
4. EBIAT is EBIT times (1 – tax rate). That is, net operating profit after taxes on EBIT.
5. To compute terminal value as a cash flow appearing in 1994, multiply free cash flow in 1994 by one plus the terminal growth rate and divide that by the discount rate minus the terminal growth rate. You will need to discount this value back to the present to get the present value of the terminal value.
� At that time, the company was called Best Brewery after its founder, Jacob Best.
Answered Same Day May 23, 2021

Solution

Shakeel answered on May 26 2021
165 Votes
Pabst
    
    Pabst Brewing Company: Pabst ProForma
            Pro Forma Assumptions:
            0%    Growth in
l sales volume
            4%    Growth rate of per ba
el net revenue and GS & A expense
            $8.98    GS & A expense base = $8.98 (1984 actual);
            18.22%    Gross Margin (Gross profit to sales ratio)
            41%    Tax rate
            0%    Growth in Net Fixed Assets
            0%    Growth in Net working assets
            4.00%    Perpetuity growth rate for terminal value calculation
        Initial    Pro Forma
    Year    1984    1985    1986    1987    1988    1989    1990    1991    1992    1993    1994
    Sales (MM Bbl)    14,400    14,400    14,400    14,400    14,400    14,400    14,400    14,400    14,400    14,400    14,400
    Net revenue
l    $56.22    $58.47    $60.81    $63.24    $65.77    $68.40    $71.14    $73.98    $76.94    $80.02    $83.22
    Sales        $841,951    $875,629    $910,654    $947,080    $984,963    $1,024,362    $1,065,336    $1,107,950    $1,152,268    $1,198,358
    Gross profit        $153,403    $159,540    $165,921    $172,558    $179,460    $186,639    $194,104    $201,868    $209,943    $218,341
    GS & A
l        $8.98    $8.98    $8.98    $8.98    $8.98    $8.98    $8.98    $8.98    $8.98    $8.98
    GS & A expenses        $129,312    $129,312    $129,312    $129,312    $129,312    $129,312    $129,312    $129,312    $129,312    $129,312
    EBIT        $24,091    $30,228    $36,609    $43,246    $50,148    $57,327    $64,792    $72,556    $80,631    $89,029
    EBIAT        $14,214    $17,834    $21,599    $25,515    $29,588    $33,823    $38,227    $42,808    $47,572    $52,527
    Net fixed assets    110,197    $110,197    $110,197    $110,197    $110,197    $110,197    $110,197    $110,197    $110,197    $110,197    $110,197
    Change in net fixed assets        $0    $0    $0    $0    $0    $0    $0    $0    $0    $0
    Net workng assets    9,375    $9,375    $9,375    $9,375    $9,375    $9,375    $9,375    $9,375    $9,375    $9,375    $9,375
    Change in net working assets        $0    $0    $0    $0    $0    $0    $0    $0    $0    $0
    Free cash flow        $14,214    $17,834    $21,599    $25,515    $29,588    $33,823    $38,227    $42,808    $47,572    $52,527
    Discount Rate        13%    17%
    PV of FCF 85-94        $153,130    $126,395
    PV of Terminal Value        $178,809    $87,421
    Total PV        $331,939    $213,815
    Debt        $82,502    $82,502
    Value of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here