This preview shows page 1. Sign up to view the full content.
Unformatted text preview: P/E Above = Qualitative analysis or Short answer required ROE Above = Goal Seek or Solver cell Dividend Yield Above = Crystal Ball Input LTD to Equity Below = Crystal Ball Output Price to Book Net Profit Margin Above Price to Cash Flow Above b. Estimated cost of equity 11.3700% Estimated growth rate 0.142344 DCF Estimate of Share Price $(79.46) c. Imputed growth rate 8.72% Impute growth rate 8.97% Return on Equity % Dividend Yield % Long-term Debt to Equity Price to Book Value Net Profit Margin Price To Free Cash Flow Emerson Comparison to Industry Below -- But higher than all comparison firms--probably an outlier is driving the industry average. using projected dividends using historical dividend yields...
View Full Document
- Spring '12