Experiential Company Study Guide
FINC350
Fall 2014
Excel file due by 11:59pm, Thursday, 12/18/14
With this project, you are going to build on the spreadsheet that you started in class. The style you choose for your charts/graphs is totally up to you – just choose something that you think is easily analyzed visually.
Excel file details
1) You will want to build separate tabs for baseline data to save in original form for your company. Download the Excel financial data from Capital IQ on Canvas.
2) Assess the liquidity position of each company using the following ratios – (1) current, quick ratio (together in one graph) (2) AR turnover in days, inventory turnover in days, and operating cycle (together in one graph). Create a graph of the ratio of the allowance for doubtful accounts to gross accounts receivable for each company over 2009-2013 together in one graph. Analyze any trends. This step should be in a single tab labeled “liquidity.”
3) Assess the solvency of each company by graphing the (1) times interest earned, fixed charge coverage ratio (together in one graph), and (2) debt ratio of each company. This step should be in a single tab labeled “solvency.”
4) Create a “profitability” tab where you will create graphs for: (1) Gross profit margin, operating profit margin, and net profit margin (together in one graph), and (2) total asset turnover and (3) return on assets.
5) Create graphs using your Capital IQ data for your company that compare (1) the basic and diluted EPS over time (together in one graph), (2) a single graph for your company showing the P/E ratio over time, and (3) a single graph showing the dividend payout ratio over time. This step
