Need help with #5 please!
Firm: Spectrum Pharmaceuticals Inc.
the model needed to be use wasnt specified. Any model that work is acceptable.
4. Perform trend analysis for firm's growth rate in the last 5 years. Based on your findings, what is the firm's projected gr Weight: 10% 5. Develop a model to estimate stock's price using one of the models discussed in Stock Valuation - chapter 07 and comp price - Weight: 10% 6. List an event (market, industry, business) that affects your firm's stock price (positive or negative), Why? Weight: 10% Key Ratios Profitability Growth Margins % of Sales Revenue 2014-12 100.00 14.47 COGS Gross Margin SGSA Cash Flow Financial Health TTM 2016-12 100.00 100.00 - 24.47 - 75.53 83.13 82.96 96.69 85.85 25.70 25.70 -130.00-119.98 -6.77 10.21 -136.77 -109.77 Efficiency Ratios 2017-12 2016-12 100.00 100.00 36.78 24.48 63.22 75.52 65.65 59.65 51.33 40.24 21.54 17.72 -75.30 -42.08 -8.85 0.28 -84.15 48.36 R&D 2015-12 100.00 17.03 82.97 53.22 31.23 23.57 -25.06 -5.93 -30.99 Other Operating Margin Net Int Inc & Other 37.29 13.00 - 16.00 .90 EBT Margin -6.39 6.40 -23.30 Profitability TTM 2016-12 2017-12 2015-12 2015-12 2014-12 Tax Rate % Net Margin % Asset Turnover (Average) Return on Assets % Financial Leverage (Average) Return on Equity % Return on invested Capital % Interest Coverage -112.28 0.31 -34.75 -109.77 0.24 -27.33 -71.08 0.28 -19.92 1.39 -31.07 -27.49 -31.24 0.36 -11.15 1.98 21.74 -46.78 0.34 -16.12 1.82 - 30.53 21.17 -24.47 0.38 .9.24 1.25 1.38 1.92 -47.08 -43.53 -37.82 -37.82 -17.06 -15.27 - 12.63 tar.com/ration.htmit productcodes Bits Spicexch Key Ratios Profitability Growth Cash Flow Financial Health Efficiency Ratios NTM 2018-12 2017-12 2016-12 2015-12 2014-12 Cash Flow Ratios Operating Cash Flow Growth % YOY Free Cash Flow Growth % YOY Cap Ex as a % of Sales Free Cash Flow/Sales % Free Cash Flow/Net Income 10.41 -116.28 2.52 -59.60 0.54 0.36 -30.63 0.43 0.05 27.68 0.59 0.14 4.01 -0.13 0.50 -2.44 0.10 1.04 Moodys - Moody's Investors Service is a real the relative f ire Equity Detail Quote Options Profile Bond Issues Financials Key Ratios Valuation Shareholders Insiders Spectrum Pharmaceuticals Inc SPPI Financials TTM 109 2018-12 109 75.5 -131 -120.0 Export 2017-12 128 63.2 -97 -75.3 L Revenue USD Mil . Gross Margin % Operating Income USD Mil Operating Margin % Net Income USD Mil Earnings Per Share USD Dividends USD Payout Ratio % - Shares Descending 2016-12 2015-12 146 163 75.5 83.0 -62 -41 -42.1 -25.1 2014-12 187 85.5 -32 -16.9 -91 -46 -1.07 -0.96 -0.71 2.08 3.02 Book Value Per Share - USD Operating Cash Flow USD Mil Cap Spending USD Mil Free Cash Flow USD Mil Free Cash Flow Per Share - USD Working Capital USD MU INN 116 -39 -40 -0.62 -0.37 Indicates calendar year-end data information -0.50 0.22 -0.12 168 151 115 113 Equity Detail Search: SI Filings Perfi Ask Size 5 LOW Prev Close 8.40 Quote Options Profile Bond Issues Financials Key Ratios Valuation Shareholders Insiders Spectrum Pharmaceuticals Inc NASDAQ:SPPI Last Price Day Change Bid Bid Size Ask 8.53 11 8.56 8.54 10.1400 1.67% High Volume Wed Nov 20, 2010 01:00 PM USD 9.14 8.40 597,192 Open 52WK High 52WK Low 52WH (Date) 52W L (Date) Div Yield Pro Yield 8.42 14.65 6.22 12-03-2018 12-20-2018 Avg Vol Shares PIE P/B PICF EPS 0.8410 112.97 mil -6.67 4.04 8.38 -1.14 10 Ret 1W Ret 1M Ret 3M Ret BM Ret 14 Ret 0.9600 3.70 467 1.57 -35.78 -3437 SY Ret 109 Ret 15Y Ret YTD Ret 3.07 Trade Exch 5.99 2.46 NASDAQ DPS (tm) Ex-Div Date Dividend YTD Short Interest 12-18-2012 900 Mkt Cap 948.98 mil PIS Beta 337 2Y Ret 34 Ret 25 30 FYE Dec Rating -400 5. Develop a model to estimate stock's price using one of the models discussed in Stock Valuation - chapter 07 and compare to current stock price - Weight: 10% 4. Perform trend analysis for firm's growth rate in the last 5 years. Based on your findings, what is the firm's projected gr Weight: 10% 5. Develop a model to estimate stock's price using one of the models discussed in Stock Valuation - chapter 07 and comp price - Weight: 10% 6. List an event (market, industry, business) that affects your firm's stock price (positive or negative), Why? Weight: 10% Key Ratios Profitability Growth Margins % of Sales Revenue 2014-12 100.00 14.47 COGS Gross Margin SGSA Cash Flow Financial Health TTM 2016-12 100.00 100.00 - 24.47 - 75.53 83.13 82.96 96.69 85.85 25.70 25.70 -130.00-119.98 -6.77 10.21 -136.77 -109.77 Efficiency Ratios 2017-12 2016-12 100.00 100.00 36.78 24.48 63.22 75.52 65.65 59.65 51.33 40.24 21.54 17.72 -75.30 -42.08 -8.85 0.28 -84.15 48.36 R&D 2015-12 100.00 17.03 82.97 53.22 31.23 23.57 -25.06 -5.93 -30.99 Other Operating Margin Net Int Inc & Other 37.29 13.00 - 16.00 .90 EBT Margin -6.39 6.40 -23.30 Profitability TTM 2016-12 2017-12 2015-12 2015-12 2014-12 Tax Rate % Net Margin % Asset Turnover (Average) Return on Assets % Financial Leverage (Average) Return on Equity % Return on invested Capital % Interest Coverage -112.28 0.31 -34.75 -109.77 0.24 -27.33 -71.08 0.28 -19.92 1.39 -31.07 -27.49 -31.24 0.36 -11.15 1.98 21.74 -46.78 0.34 -16.12 1.82 - 30.53 21.17 -24.47 0.38 .9.24 1.25 1.38 1.92 -47.08 -43.53 -37.82 -37.82 -17.06 -15.27 - 12.63 tar.com/ration.htmit productcodes Bits Spicexch Key Ratios Profitability Growth Cash Flow Financial Health Efficiency Ratios NTM 2018-12 2017-12 2016-12 2015-12 2014-12 Cash Flow Ratios Operating Cash Flow Growth % YOY Free Cash Flow Growth % YOY Cap Ex as a % of Sales Free Cash Flow/Sales % Free Cash Flow/Net Income 10.41 -116.28 2.52 -59.60 0.54 0.36 -30.63 0.43 0.05 27.68 0.59 0.14 4.01 -0.13 0.50 -2.44 0.10 1.04 Moodys - Moody's Investors Service is a real the relative f ire Equity Detail Quote Options Profile Bond Issues Financials Key Ratios Valuation Shareholders Insiders Spectrum Pharmaceuticals Inc SPPI Financials TTM 109 2018-12 109 75.5 -131 -120.0 Export 2017-12 128 63.2 -97 -75.3 L Revenue USD Mil . Gross Margin % Operating Income USD Mil Operating Margin % Net Income USD Mil Earnings Per Share USD Dividends USD Payout Ratio % - Shares Descending 2016-12 2015-12 146 163 75.5 83.0 -62 -41 -42.1 -25.1 2014-12 187 85.5 -32 -16.9 -91 -46 -1.07 -0.96 -0.71 2.08 3.02 Book Value Per Share - USD Operating Cash Flow USD Mil Cap Spending USD Mil Free Cash Flow USD Mil Free Cash Flow Per Share - USD Working Capital USD MU INN 116 -39 -40 -0.62 -0.37 Indicates calendar year-end data information -0.50 0.22 -0.12 168 151 115 113 Equity Detail Search: SI Filings Perfi Ask Size 5 LOW Prev Close 8.40 Quote Options Profile Bond Issues Financials Key Ratios Valuation Shareholders Insiders Spectrum Pharmaceuticals Inc NASDAQ:SPPI Last Price Day Change Bid Bid Size Ask 8.53 11 8.56 8.54 10.1400 1.67% High Volume Wed Nov 20, 2010 01:00 PM USD 9.14 8.40 597,192 Open 52WK High 52WK Low 52WH (Date) 52W L (Date) Div Yield Pro Yield 8.42 14.65 6.22 12-03-2018 12-20-2018 Avg Vol Shares PIE P/B PICF EPS 0.8410 112.97 mil -6.67 4.04 8.38 -1.14 10 Ret 1W Ret 1M Ret 3M Ret BM Ret 14 Ret 0.9600 3.70 467 1.57 -35.78 -3437 SY Ret 109 Ret 15Y Ret YTD Ret 3.07 Trade Exch 5.99 2.46 NASDAQ DPS (tm) Ex-Div Date Dividend YTD Short Interest 12-18-2012 900 Mkt Cap 948.98 mil PIS Beta 337 2Y Ret 34 Ret 25 30 FYE Dec Rating -400 5. Develop a model to estimate stock's price using one of the models discussed in Stock Valuation - chapter 07 and compare to current stock price - Weight: 10%
