Answer To: 1. Determine the annual incremental free cash flow associated with each expansion plan relative to...
Ashish answered on Nov 02 2020
Solution
Constants
Current Monthly Capacity 25000 Solution-1
Whole Sale Price/Case $80.00 Proposal 1
Gross Profit Margin 55.00% 0 1 2 3 4 5 6 7
%NWC of annual revenue 15.00% Revenur $ - 0 $ (12,000,000.00) $ 24,000,000.00 $ 24,000,000.00 $ 24,000,000.00 $ 24,000,000.00 $ 24,000,000.00 $ - 0
Tax Rate 40.00% COGS $ - 0 $ (5,400,000.00) $ 10,800,000.00 $ 10,800,000.00 $ 10,800,000.00 $ 10,800,000.00 $ 10,800,000.00 $ - 0
Straight Line Depreciation Gross Profit $ - 0 $ (6,600,000.00) $ 13,200,000.00 $ 13,200,000.00 $ 13,200,000.00 $ 13,200,000.00 $ 13,200,000.00 $ - 0
Debt 0 SGA $ - 0 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ 1,000,000.00 $ - 0
Shares Outstanding 2000000 D&E $ 3,900,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Share Price $75.00 Dep $ - 0 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ - 0
Dividend this Year $3.00 EBIT $ (3,900,000.00) $ (8,200,000.00) $ 11,600,000.00 $ 11,600,000.00 $ 11,600,000.00 $ 11,600,000.00 $ 11,600,000.00 $ - 0
Dividend Growth Rate 8.00% Taxes $ (1,560,000.00) $ (3,280,000.00) $ 4,640,000.00 $ 4,640,000.00 $ 4,640,000.00 $ 4,640,000.00 $ 4,640,000.00 $ - 0
Sales Revenue $24,000,000.00 Inc Earnings $ (2,340,000.00) $ (4,920,000.00) $ 6,960,000.00 $ 6,960,000.00 $ 6,960,000.00 $ 6,960,000.00 $ 6,960,000.00 $ - 0
EBIT $13,200,000.00
Increase in NWC $3,600,000.00 Dep $ - 0 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00 $ - 0
Cost of Equity 12.00% Cap Ex $ 3,600,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ ...