7 B 9 10 1 2 3 24 es 26 27 28 29 30 31 32 33 34 Discounted Cash Flow Valuation Discount (n) Sales YOY EBITDA Margin D&A % of sales EBIT Margin Capex Capex/D&A Chg. Working Capital Working capital % of sales Pre-tax Profit (EBT) Margin Tax Tax Rate Net income Free Cash Flow Discounted FCF Past-> FY-4 Input Here Input Here Calculate Here Calculate Here Calculate Here Calculate Here Input Here Calculate Here Y Input Here Calculate Here Input Here Calculate Here Input Here Calculate Here Input Here Calculate Here Calculate Here Calculate Here. FY-3 Calculate Here FY-2 FY-1 + 1.00 Future-> FYO Calculate Here Assumptions Here Calculate Here 2.00 FYI 8.00 FY2 Calculate Here Assumptions Here Calculate Here Assumptions Here Calculate Here Assumptions Here Calculate Here Assumptions Here Calculate Here Assumptions Here Calculate Here Assumptions Here Calculate Here 4.00 FY3 Y Y 5.00 FY4 Capitalization (FYO) Net Debt Total Equity Total Capitalization WACC Risk free rate Market risk premium Beta Cost of Equity Wtd. Cost