Finance Class

Finance Course

2

>Sheet

1 1

0.51

2 Student A Liquidity

3

5

4 Student B Activity Ratios

5 Student B Activity Ratios

6

7 Student C Profitability Returns

0.08

8 Student C Profitability Returns

0.03

9 Student C Profitability Returns

0.03 0.03 0.04

Student D Financing

12 Student D Financing

13

Student E Market Value

																																																																			Team:
Compiler	Who will be the Compiler/Project Lead ?	201	5	201 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	4	201	3
	Student A		Liquidity	Current Ratio	0.	9	7		0.51
Quick Ratio	0.2	8	0.	12	0.	13
		Student B			Activity Ratios	Accounts Receivable Turnover	71.	6	71.33	69.25
Inventory Turnover	8.09	7.98	8.04
Accounts Payable Turnover	6.23	6.26	5.96
			Student C				Profitability Returns	Return on Equity %	0.20	0.21	0.23
Return on Assets%		0.08	0.09
Net Profit Margin %				0.03		0.04
Operating Profit Margin
10			Student D			Financing	Debt to Equity %
11	Debt to Assets %
Times Interest Earned
	Student E		Market Value	Earnings per Share $	1.16	1.15	1.23
14	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

Sheet2

Sheet3