I have to come up with some numbers for a report I am writing on a stock…


I possess to after up delay some aggregate for a noise I am answerableness on a hoard. I am obscure to revere the advenient hues and distribute cost for Molson Coors (stock: TAP). I demand to put conjointly a Discounted Cash Flow (DCF) pattern to revere the advenient cost of the hoard. Please see fast for the updated muniment. I possess true modificonducive the years referenced (2010A, 2011,2012,2013). You get to-boot demand a WACC to do this, which I was conducive to get from www.thatswacc.com (7.83%, to-boot ascititious to the fast) The confessor granted us delay an Excel cat's-paw we could use to form the pattern (attached). Not permanent if you insufficiency to use it, or if you possess your own manner. Lastly, you possess to form some assumptions to form this achievement - and I would affect to be a keep-akeep-apart of this. Can you email me when you demand to form assumptions for enlargement? Each year should be 10% to 15% I apprehend, but possibly you get discover differently???Will you rudiment this in when achievementing on the DCF and EPS reveres? I apprehend each year should possess subordinately meliorate enlargement - but I would affect to heed what you apprehend: bigwig affect 10%, 13% and 15%?? Please to-boot furnish me delay a soon muniment to draft your assumptions. I get demand to exhibit this to my assort, so I get demand to comprehend what you did.
Document Preview:

Sheet1 BALANCE_SHEETS CASH_FLOW_STATEMENTS Credit_Statistics DEBT_SCHEDULE INCOME_STATEMENTS opcase OPERATING_ASSUMPTIONS Scenario_Analysis Summary_Financial_Results VALUATION_ANALYSIS WORKING_CAPITAL_ASSUMPTIONS Historical Projected OPERATING ASSUMPTIONS Revenue Growth Cost of Goods Sold: COGS (Excl. Depn.) % Sales Depreciation Total COGS EBITDA Margin Operating Profit (EBIT) % of Sales Amortization Total SG&A Expense SG&A Expense (Excl. Amt.) SG&A Expense: Total Capital Expenditures INCOME STATEMENTS Gross Profit EBIT Interest & Other Expense / (Income): Revolver Term Loan Sr. Sub. Notes Total Interest Expense Financing Costs Amortization Pretax Income Net Income Shares Outstanding Hues per Distribute (EPS) EBITDA Reconciliation: Plus: Depreciation Plus: Amortization EBITDA Less: Total COGS Less: Total SG&A BALANCE SHEETS ASSETS: Accounts Receivable Inventory Prepaid Expenses Current Assets PP&E - Gross Less: Accum. Depn. Net PP&E Intangibles Cap. Financing Costs Total Assets LIABILITIES & EQUITY: Accounts Payable Accrued Expenses Current Liabilities Revolver Term Loan Sr. Sub. Notes Total Debt Other Liabilities Total Liabilities Common Equity Liabilities & Equity Check Rate Less: Interest Income Less: Inafter Taxes Required Cash Excess Cash Total Cash WORKING CAPITAL ASSUMPTIONS Sales Total COGS Current Assets Accounts Receivable Inventory Prepaid Expenses Current Assets Current Liabilities Accounts Payable Accrued Expenses Current Liabilities Net Cash Impact Net Launched Capital Cash (Used by) / Generated from Work. Cap. Ratios A/R % of Sales Days Receivable Inventory % of COGS Inventory Turns Prepaid % of COGS Accts Payconducive % of COGS Accrued % of COGS Required Cash % of COGS CASH FLOW STATEMENTS Operating Activities: Financing Costs...