You just need to calculate 16 ratios for two companies and compare them: Colgene Corporation and Gilead Sciences, Inc.
The instructions are attached
Required Ratios for Final Project Submission
- Earnings per Share of Common Stock
- Current Ratio
- Gross (Profit) Margin Percentage
- Rate of Return (Net Profit Margin) on Sales
- Inventory Turnover
- Days’ Inventory Outstanding (DIO)
- Accounts Receivable Turnover
- Days’ Sales Outstanding (DSO)
- Asset Turnover
- Rate of Return on Total Assets (ROA)
- Debt Ratio
- Times-Interest-Earned Ratio
- Dividend Yield [For
the purposes of this ratio, use Yahoo Finance to look up current
dividend per share and stock price; just note the date that you looked
up this information.] - Rate of Return on Common Stockholders’ Equity (ROE)
- Free cash flow
- Price-Earnings Ratio (Multiple) [For
the purpose of this ratio, look up the market price per share as of
December 30, 2016 for Celgene Corporation and for Gilead Sciences, Inc..]
The excel file is a template for you
Note:
The Excel files uploaded as the assignment submission should not
include any unnecessary numbers or information (such as previous years’
ratios, ratios that were not specifically asked for in the project,
etc.).
0 comments