Finance Class
Sheet1
| Team: | |||||||||||||
| Compiler | Who will be the Compiler/Project Lead ? | 2015 | 2014 | 2013 | |||||||||
| 1 | Student A | Liquidity | Current Ratio | 0.97 | 0.51 | 0.51 | |||||||
| 2 | Student A | Liquidity | Quick Ratio | 0.28 | 0.12 | 0.13 | |||||||
| 3 | Student B | Activity Ratios | Accounts Receivable Turnover | 71.65 | 71.33 | 69.25 | |||||||
| 4 | Student B | Activity Ratios | Inventory Turnover | 8.09 | 7.98 | 8.04 | |||||||
| 5 | Student B | Activity Ratios | Accounts Payable Turnover | 6.23 | 6.26 | 5.96 | |||||||
| 6 | Student C | Profitability Returns | Return on Equity % | 0.20 | 0.21 | 0.23 | |||||||
| 7 | Student C | Profitability Returns | Return on Assets% | 0.08 | 0.08 | 0.09 | |||||||
| 8 | Student C | Profitability Returns | Net Profit Margin % | 0.03 | 0.03 | 0.04 | |||||||
| 9 | Student C | Profitability Returns | Operating Profit Margin | 0.03 | 0.03 | 0.04 | |||||||
| 10 | Student D | Financing | Debt to Equity % | ||||||||||
| 11 | Student D | Financing | Debt to Assets % | ||||||||||
| 12 | Student D | Financing | Times Interest Earned | ||||||||||
| 13 | Student E | Market Value | Earnings per Share $ | 1.16 | 1.15 | 1.23 | |||||||
| 14 | Student E | Market Value | Price to Earnings ratio | 8.62 | 7.83 | 6.5 | |||||||
| Price per share | $ 10.00 | $ 9.00 | $ 8.00 | ||||||||||
| 2015 | 2014 | 2013 | |||||||||||
| 14,000,000 shares outstanding each year |
Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments in the final document - see the "Project Outline" document.
Assign Ratios to respective students, i.e. Student A, Student B, etc.: also need a compiler. This Excel spreadsheet needs to be completed and embedded in the final write up.
WalMart Analysis: This worksheet will support the findings presented in the final document: Compiler-Leader: Please embed in the final write up