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.98GS & A expense base = $...

1 answer below »
Need help with this.


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.98GS & 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 InitialPro Forma Year19841985198619871988198919901991199219931994 Sales (MM Bbl)14,400 Net revenue/bbl$56.22 Sales Gross profit GS & A /bbl GS & A expenses EBIT EBIAT Net fixed assets110,197 Change in net fixed assets Net workng assets9,375 Change in net working assets Free cash flow Discount Rate13%17% PV of FCF 85-94 PV of Terminal Value Total PV Debt$82,502$82,502 Value of Equity Number of shares6,3006,300 Value per share &L&"Helvetica"&12&BPabstProForma Heileman Pabst Brewing Company: Heileman ProForma Pro Forma Assumptions: 0%Growth in bbl sales volume 4%Growth rate of per barrel net revenue and GS & A expense $8.98GS & 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 InitialPro Forma Year19841985198619871988198919901991199219931994 Sales (MM Bbl)14,400 Net revenue/bbl$56.22 Sales Gross profit GS & A /bbl GS & A expenses EBIT EBIAT Net fixed assets110,197 Change in net fixed assets Net working assets9,375 Change in net working assets Free cash flow Discount Rate13%17% PV of FCF 85-94 PV of Terminal Value Total PV Debt$82,502$82,502 Value of Equity Number of shares6,3006,300 Value per share &L&"Helvetica"&12&BPabstProForma S&P Pabst Brewing Company: S&P ProForma Pro Forma Assumptions: -11%Growth in bbl sales volume 4%Growth rate of per barrel net revenue and GS & A expense $5.21GS & A expense base = $5.21 (1984 actual 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 InitialPro Forma Year19841985198619871988198919901991199219931994 Sales (MM Bbl)14,40012,81611,40610,1529,0358,0417,1576,3695,6695,0454,490 Net revenue/bbl$56.22 Sales Gross profit GS & A /bbl GS & A expenses EBIT EBIAT Net fixed assets110,197 Change in net fixed assets Net working assets9,375 Change in net working assets Free cash flow Discount Rate13%17% PV of FCF 85-94 PV of Terminal Value Total PV Debt$82,502$82,502 Value of Equity Number of shares6,3006,300 Value per share &L&"Helvetica"&12&BPabstProForma
Answered Same DayMay 13, 2021

Answer To: Pabst Pabst Brewing Company: Pabst ProForma Pro Forma Assumptions: 0%Growth in bbl sales volume...

Shakeel answered on May 19 2021
154 Votes
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 = $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/bbl    $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 /bbl        $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