Answer To: Pabst Pabst Brewing Company: Pabst ProForma Pro Forma Assumptions: 0%Growth in bbl sales volume...
Shakeel answered on May 19 2021
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...