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

Pabst Pabst Brewing Company: Pabst ProForma Pro Forma Assumptions: 0% Growth in bbl sales volume 4% Growth rate of per barrel net revenue and GS & A expense $8.98 GS & A expense base = $...

1 answer below »
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 = $ XXXXXXXXXXactual);
            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
    Net revenue
l    $56.22
    Sales
    Gross profit
    GS & A
l
    GS & A expenses
    EBIT
    EBIAT
    Net fixed assets    110,197
    Change in net fixed assets
    Net workng assets    9,375
    Change in net working assets
    Free cash flow
    Discount Rate        13%    17%
    PV of FCF 85-94
    PV of Terminal Value
    Total PV
    Debt        $82,502    $82,502
    Value of Equity
    Number of shares        6,300    6,300
    Value per share
&L&"Helvetica"&12&BPabstProForma
Heileman
    
    Pabst Brewing Company: Heileman 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;
            21.00%    Gross Margin (Gross profit to sales ratio)
            41%    Tax rate
                Net fixed assets constant through 1989 then increases with sales
            1.50%    Net working assets as percent of net sales
            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
    Net revenue
l    $56.22
    Sales
    Gross profit
    GS & A
l
    GS & A expenses
    EBIT
    EBIAT
    Net fixed assets    110,197
    Change in net fixed assets
    Net working assets    9,375
    Change in net working assets
    Free cash flow
    Discount Rate        13%    17%
    PV of FCF 85-94
    PV of Terminal Value
    Total PV
    Debt        $82,502    $82,502
    Value of Equity
    Number of shares        6,300    6,300
    Value per share
&L&"Helvetica"&12&BPabstProForma
S&P
    
    Pabst Brewing Company: S&P ProForma
            Pro Forma Assumptions:
            -11%    Growth in
l sales volume
            4%    Growth rate of per ba
el net revenue and GS & A expense
            $5.21    GS & A expense base = $ XXXXXXXXXXactual minus $3.77 in saved advertising);
            18.22%    Gross Margin (Gross profit to sales ratio)
            41%    Tax rate
            15%    Net fixed assets as percent of net sales
            1.50%    Net working assets as percent of net sales
            -9.25%    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    12,816    11,406    10,152    9,035    8,041    7,157    6,369    5,669    5,045    4,490
    Net revenue
l    $56.22
    Sales
    Gross profit
    GS & A
l
    GS & A expenses
    EBIT
    EBIAT
    Net fixed assets    110,197
    Change in net fixed assets
    Net working assets    9,375
    Change in net working assets
    Free cash flow
    Discount Rate        13%    17%
    PV of FCF 85-94
    PV of Terminal Value
    Total PV
    Debt        $82,502    $82,502
    Value of Equity
    Number of shares        6,300    6,300
    Value per share
&L&"Helvetica"&12&BPabstProForma
Answered Same Day May 13, 2021

Solution

Shakeel answered on May 19 2021
157 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