Urgent 2

Urgent 7 hours

Company sleected

STOCK TICKER-WEN

Stock TickerWENCompany Name Wendys CoStock market where it tradesNASDAQ-GSStock Price20.85 USDDate/Time stock price was observed1/24 @ 10:28 PMDividend Yield 1.33%EPS (TTM).46State where this company is based Columbus, Ohio U.SCEO NameTodd A. PenegorSector according to YahooConsumer cyclicalIndustry according to YahooRestaurantCompetitor 1McDonalds (MCD)Competitor 2Papa Johns (PZZA

standardized
XOM

USD USD USD USD USD USD USD USD USD

Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified

Yes Yes Yes Yes Yes Yes Yes Yes Yes

Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

– – – – – –

3177000 3657000 3705000 4658000 4913000 9923000 13068000

394000

875000

645000

& Accrued Exps

Accounts Payable

4168000 5011000 4402000 1146000

9482000 14501000 14170000 5952000 846000

348691000 330314000 336758000 349493000 346808000 333795000 331052000 302510000 233323000 228052000

Report Date

12/31/2016 12/31/2015 12/31/2014 12/31/2013 12/31/2012 12/31/2011 12/31/2010 12/31/2009 12/31/2008
Currency USD USD USD USD USD USD USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

0 0 0 0 0 0 0 0 0 0

-601000 -453000 -311000 -286000 -9000 -327000 -247000 -259000 -548000 -673000

Minority Interests

1146000 938000

0 0 0 0 0 0 0 0 0 0

41060000

0 0 0 0 0 0 0 0 0 0

19710000 7840000 16150000

32580000 44880000 41060000 30460000 19280000 45220000

4.63 1.88 3.85 7.6 7.37 9.7 8.43 6.24 3.99 8.78

4256000 4177000 4196000 4282000 4419000 4628000

4.63 1.88 3.85 7.6 7.37 9.7

4.63 1.88 3.85 7.6 7.37 9.7 8.42 6.22 3.98 8.69

4979000

Report Date 12/31/2017 12/31/2016 12/31/2015 12/31/2014 12/31/2013 12/31/2012 12/31/2011 12/31/2010 12/31/2009 12/31/2008
Currency USD USD USD USD USD USD USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

407831000 412444000 408384000 387432000 365727000 330939000

276937000 265680000

414540000 407831000 412444000 408384000 387432000 365727000 330939000 298899000 276937000 265680000

Net Income

627000

490000

– – – – – –

60000

848000

157000

0 0 0

204000 -16000

-113000

314000

520000

-48000

3657000 3705000

10693000 31437000

3177000 3657000 3705000 4616000 4644000 9582000 12664000 7825000 10693000 31437000

19893000 22308000 18048000 17297000 17182000 15888000 15583000 14760000 11917000 12379000

-15402000 -16163000 -26490000 -32952000 -33669000 -34271000 -30975000 -26871000 -22491000 -19318000

1.1

– – – – – – –

0.911

1.1 1.333 1.417 2.973 3.947

5.9

100 100 100 100 100 100 100 100 100 100

2.538

0.832

4.39

100 100 100 100 100 100 100 100 100 100

2.3

97.7

100 100 100 100 100 100 100 100 100 100

15.5

-0.2

-0.068

0 0 0 0 0 0 0 0 0 0

-0.2 -0.116 -0.069 -0.002 -0.068 -0.051 -0.068 -0.176 -0.141

0 0 0 0 0 0 0 0 0 0

3.468

7.894

0 0 0 0 0 0 0 0 0 0

8.066 3.468 6.006 7.894 7.434 9.306 8.441 7.948 6.208 9.473

																																														Exxon Mobil Corp (NYS: XOM)
Exchange rate used is that of the Year End reported date
Standardized Annual Balance Sheet
						Report Date		12/31/2																												0	12/31/2016	12/31/2015	12/31/2014	12/31/2013	12/31/2012	12/31/2011	12/31/2010	12/31/2009	12/31/2008
					Currency																														USD
					Audit Status																														Not Qualified
					Consolidated																														Yes
					Scale																														Thousands
Cash & Equivalents			3177000				3657000				3705000		4658000		4913000		9923000		13068000	8453000			10693000			31437000
Short Term Investments																				–	2000	169000	570000
Cash & Equivs & ST Investments	8455000	10862000	32007000
Receivables (ST)	25597000			21					19	28009000	33152000	34987000	38642000	32284000			27	24702000
Inventories	16992000	15080000	16245000	16678000	16135000	14542000	15024000	12976000	11553000	11646000
Other Current Assets	1368000	1285000	2798000	3565000	5108000	5008000	6229000	5269000	5175000	391																								100
Total Current Assets	47134000	41416000	42623000	52910000	59308000	644	60000	72963000	58984000	55235000	72266000
Gross Property Plant & Equip	477185000	453915000	447337000	446789000	434517000	409	314000	393995000	373	938000	305906000	270845000
Accumulated Depreciation	224555000	209691000	195732000	194121000	190867000	182365000	179331000	174390000	166790000	149499000
Net Property Plant & Equip	252630000	244224000	251605000	252668000	243650000	226949000	214664000	199548000	139116000	121346000
Long Term Investments	30048000	25659000	25135000	25421000	25852000	24759000	24593000	26052000	22996000	20984000
Other Assets	18879000	19015000	17395000	18494000	17998000	17	627000	18832000	17926000	15976000	13456000
	Total Assets			348691000			330314000			336758000			349493000			346808000			333795000			331052000			302510000			233323000		228052000
	Accounts Payable	31343000	26445000	27773000	35638000	41498000	44614000	51514000	44584000	36296000	33091000
28032000	23792000	24836000	32348000	37615000	40484000	44391000	37806000	30375000	27225000
Accrued Expenses	3311000	2653000	2937000	3290000	3883000	4130000	7123000	6778000	5921000	5866000
Current Debt	17930000	13830000	18762000	17468000	15808000	3653000	7711000	2787000	2476000	2400000
Related Parties (ST Liab)	5453000	4748000	4639000	6589000	6587000	6114000	5553000	5450000		4979000	3552000
Other Current Liabilities	3045000	2615000	2802000	4938000	7831000	9758000	12727000	9812000	8310000	10057000
Total Current Liabilities	57771000	47638000	53976000	64633000	71724000	64139000	77505000	62633000	52061000	49100000
LT Debt & Leases	24406000	28932000	19925000	11653000	6891000	7928000	9322000	12227000	7129000	7025000
Pensions & OPEB	21132000	20680000	22647000	25802000	20646000	25267000	24994000	19367000	17942000	20729000
Deferred LT Liabilities	26893000	34041000	36818000	39230000	40530000	37570000	36618000	35150000	23148000	19726000
	Minority Interests	6812000	6505000	5999000	6665000	6492000	5797000	6348000	5840000	4823000	4558000
Other Liabilities	23989000	25193000	26582000	27111000	26522000	27231000	21869000	20454000	17651000	13949000
	Total Liabilities		161003000		162989000		165947000		175094000		172805000		167932000		176656000		155671000		122754000		115087000
Common Share Capital	14656000	12	157000	11612000	10792000	10077000	9653000	9512000	9371000	5503000	5314000
Retained Earnings		414540000			407831000			412444000			408384000			387432000			365727000			330939000	298954000			276937000			265680000
Accum Other Comprehensive Income	-16262000	-22239000	-23511000	-18957000	-10725000	-12184000		4168000		5011000		4402000			1146000
Treasury Stock	225246000	230424000	229734000	225820000	212781000	197333000	176932000	156608000	166410000	148098000
For Curr Trans (BS)	–	9482000	–	14501000	–	14170000	–	5952000	–	846000	2410000
Other Equity	-2410000	-17459000	-1	490000	-14265000	-12223000
	Total Equity		187688000		167325000		170811000		174399000		174003000		165863000		154396000		146839000		110569000		112965000
Total Liabilities & Equity
Standardized Annual Income Statement
				12/31/2017
Affiliates Revenue	5380000	4806000	7644000	13323000	13927000	15010000	15289000	10677000	7143000	11081000
Other Revenue	238983000	221288000	261238000	398616000	424328000	467285000	471140000	372544000	303443000	466278000
	Total Revenue		244363000		226094000		268882000		411939000		438255000		482295000		486429000		383221000		310586000		477359000
Direct Costs	162345000	157188000	188268000	296173000	315270000	336079000	340305000	262298000	211769000	321867000
Gross Profit	82018000	68906000	80614000	115766000	122985000	146216000	146124000	120923000	98817000	155492000
Selling General & Admin				41060000	36709000	38766000	44884000	46107000	49435000	54956000	50801000	49554000	57592000
Depreciation & Amortization		19893000		22308000		18048000		17297000		17182000		15888000		15583000		14760000		11917000		12379000
Other Operating Expense	1790000	1467000	1523000	1669000	1976000	1840000	2081000	2144000	2021000	1451000
Total Indirect Operating Costs	62743000	60484000	58337000	63850000	65265000	67163000	72620000	67705000	63492000	71422000
Operating Income	19275000	8422000	22277000	51916000	57720000	79053000	73504000	53218000	35325000	84070000
Interest Income		-601000		-453000		-311000		-286000		-9000		-327000		-247000		-259000		-548000		-673000
Other Non-Operating Income
Total Non-Operating Income
Earnings Before Tax	18674000	7969000	21966000	51630000	57711000	78726000	73257000	52959000	34777000	83397000
Taxation	-1174000	-406000	5415000	18015000	24263000	31045000	31051000	21561000	15119000	36530000
138000	535000	401000	1095000	868000	2801000	378000	1647000
Extraordinary Items
Accounting Changes
	Net Income			19710000			7840000			16150000		32	520000			32580000			44880000			30460000			19280000			45220000
Preference Dividends & Similar
	Net Income to Common	32520000
Average Shares Basic		4256000		4177000		4196000		4282000		4419000		4628000	4870000	4885000	4832000	5149000
EPS Net Basic				4.63				1.88				3.85				7.6				7.37				9.7					8.4		6.24	3.99	8.78
EPS Continuing Basic
Average Shares Diluted	4875000	4897000	4	848000	5203000
EPS Net Diluted		8.42		6.22		3.98		8.69
EPS Continuing Diluted
Shares Outstanding	4239000	4148000	4156000	4201000	4335000	4502000	4734000	4727000	4976000
Standardized Annual Retained Earnings
Retained Earnings at Start		298899000	228518000
Retained Earnings at End
Standardized Annual Cash Flows
19848000	8375000	16551000	33615000	33448000	47681000	42206000	31398000	19658000	46867000
Adjustments from Inc to Cash	11638000	15313000	17072000	17256000	15836000	6183000	13003000	13488000	9955000	10936000
Change in Working Capital	-649000	-1392000	-3113000	-4932000	-4720000	-1012000	3845000	-1159000	1432000
Other Operating Cash Flows	-771000	-214000	-166000	-823000	350000	1679000	1148000	-318000		-16000
Cash Flow from Operations	30066000	22082000	30344000	45116000	44914000	56170000	55345000	48413000	28438000	59725000
Purchase of Pty Plant & Equip		-15402000		-16163000		-26490000		-32952000		-33669000		-34271000		-30975000		-26871000		-22491000		-19318000
Purchase of Investments	-5507000	-1417000	-607000	-1631000	-4435000	-972000	-5340000	-1254000	-2768000	-4608000
Disposal of Investments	1674000	155000	571000	1868000
Other Investing Cash Flows	5179000	5177000	3273000	7608000	3903000	9642000	12476000	3766000	2269000	6559000
Cash Flow from Investing	-15730000	-12403000	-23824000	-26975000	-34201000	-25601000	-22165000	-24	204000	-22419000	-15499000
Change in ST Debt	-1108000	-7773000	1253000	1304000	11272000	-3756000	1521000	-1129000	-310000	-414000
Change in LT Debt	12066000	8002000	5662000	332000	436000	-5081000		-113000
Change in Equity	-747000	-971000	-4032000	-13038000	-15900000	-20745000	-20871000	-11928000	-18714000	-34648000
Payment of Dividends	-13185000	-12615000	-12260000	-11816000	-11179000	-10419000	-9326000	-8779000	-8303000	-8433000
Other Financing Cash Flows	-150000	-1000	-7000	-419000
Cash Flow from Financing	-15130000	-9293000	-7037000	-17888000	-15476000	-33868000	-28256000	-26924000	-27283000	-44027000
Effect of Exchange Rate	-434000	-394000	-281000	-175000	217000	-85000	-153000	-2743000
Change in Cash		-48000	-911000	-28000	-4938000	-3082000	4839000	-2868000	-20744000	-2544000
Opening Cash		4616000		4644000		9582000		12664000		7825000	33981000
Closing Cash
Depn & Amortn (CF)
Net Purch of Pty Plant & Equip
Standardized Annual CS Balance Sheet
Cash & Equivalents %TA		0.911					1.1			1.33		1.417		2.973		3.947	2.794					4.5	13.785
Short Term Investments %TA	0.001	0.072	0.25
Cash & Equivs & ST Investments %TA	1.107	2.795	4.655	14.035
Receivables (ST) %TA	7.341	6.477		5.9	8.014					9.55	10.482	11.672	10.672	1		1.84	1	0.832
Inventories %TA	4.873	4.565	4.824	4.772	4.652	4.357	4.538	4.289	4.952					5.1
Other Current Assets %TA	0.392			0.38	0.831	1.02		1.47	1.5	1.882			1.7	2.218	1.715
Total Current Assets %TA	13.517	1	2.538	12.657	15.139	17.101	19.311	22.04	19.498	23.673	3				1.68
Gross Property Plant & Equip %TA	136.85	137.419	13		2.8	127.839	125.29	122.624	119.013	123.612	131.108	118.765
Accumulated Depreciation %TA	6	4.39	63.482	58.122	5		5.5	55.035	54.634	54.17	57.648	71.485	65.555
Net Property Plant & Equip %TA	72.451	73.937	74.714	72.296	70.255	67.991	64.843	65.964	5		9.62	53.21
LT Investments %TA	8.617	7.768	7.464	7.274	7.454	7.417			7.42	8.612	9.856	9.201
Other Assets %TA	5.414	5.757	5.165	5.292	5.19	5.281	5.689	5.926	6.847
Total Assets as 100%
Accounts Payable & Accrued Exps %TA	8.989	8.006	8.247	10.197	1	1.96	13.366		15.5	14.738	15.556	14.51
Accounts Payable %TA	8.039	7.203	7.375	9.256	10.846					12.1	13.409	1		2.49	1		3.01	11.938
Accrued Expenses %TA					0.95		0.80	0.872	0.941			1.12			1.2	2.152			2.24	2.572
Current Debt %TA	5.142					4.18	5.571	4.998	4.558			1.09		2.3	0.921	1.061			1.05
Other Current Liabilities %TA	0.873	0.792	1.413	2.258	2.923	3.844	3.244	3.562	4.41
Total Current Liabilities %TA	16.568			14.4	16.028	18.493	2	0.68	19.215	23.412	2	0.70	22.313	21.53
LT Debt & Lease %TA	6.999	8.759			5.91	3.334	1.987	2.375	2.816	4.042	3.055	3.08
Pensions & OPEB %TA	6.06			6.26	6.725	7.383	5.953	7.57	7.55	6.402	7.69					9.09
Deferred LT Liabilities %TA	7.713	10.306	1	0.93	1	1.22	11.687	11.255	11.061	11.619	9.921	8.65
Minority Interests %TA	1.954	1.969					1.78	1.907					1.87	1.737					1.91	1.931		2.06		1.99
Other Liabilities %TA	6.88	7.627			7.894	7.757	7.647	8.158	6.606	6.761	7.565					6.1
Total Liabilities %TA	46.174	4		9.34	49.278	50.099	49.827	50.31	53.362	51.46	5				2.61	50.465
Common Share Capital %TA	4.203	3.68	3.448	3.088	2.906	2.892	2.873	3.098	2.359	2.33
Retained Earnings %TA	118.885	12		3.468	122.475	116.85	111.714	109.566	99.966	98.825	118.693	116.5
Accum Other Comprehens Income %TA	-4.664	-6.733	-6.982	–				5.42	-3.092	–				3.65	1.259	1.656	1.887					0.5
Other Equity %TA	2.719	4.208	1.703	0.244	-0.722	-5.274	-4.925	-6.114	-5.36
Total Equity %TA	53.826	50.656	50.722	49.901	50.173	49.69	46.638	48.54	47.389	49.535
Total Liabilities & Equity %TA
Standardized Annual CS Income Statement
Affiliates Revenue %TR	2.202					2.12	2.843			3.23	3.178	3.112	3.143	2.786	2.321
Other Revenue %TR		97.7	97.874	97.157	96.766	96.822	96.888	96.857	9		7.21	97.679
Total Revenue (100% TR)
Direct Costs %TR	66.436	69.523	70.019	71.897	71.938	69.683	69.96	6		8.44	68.184	67.427
Gross Profit %TR	33.564	30.477	29.981	28.103	28.062	30.317	30.04	31.554	31.816			32.57
Selling General & Admin %TR	16.803	16.236	14.417	10.896	10.521	10.25	11.298	13.256	15.955	12.065
Depreciation & Amortization %TR	8.141	9.867	6.712	4.199	3.921	3.294	3.204	3.852	3.837	2.593
Other Operating Expense %TR					0.73	0.649			0.56	0.405	0.451	0.382	0.428	0.559	0.651	0.304
Total Indirect Operating Costs %TR	25.676	26.752	21.696	14.892	13.926	14.929			17.66	20.443	14.962
Operating Income %TR	7.888	3.725	8.285	12.603	13.17	16.391	15.111	13.887	11.374	17.611
Interest Income %TR			-0.2		-0.116		-0.069		-0.002				-0.068		-0.051		-0.176		-0.141
Other Non-Operating Income %TR
Total Non-Operating Income %TR	-0.246
Earnings Before Tax %TR	7.642	3.525	8.169			12.5	1				3.16	16.323	15.06	1		3.81	11.197	17.47
Taxation %TR	-0.48	-0.18			2.01	4.373	5.536	6.437	6.383					5.62	4.868	7.653
Minority Interests %TR	0.056	0.237	0.149	0.266	0.198	0.581	0.236	0.245	0.122	0.345
Extraordinary Items %TR
Accounting Changes %TR
Net Income %TR		8.066		6.006						7.43		9.306		8.441				7.94		6.208		9.473
Preference Dividends & Similar %TR
Net Income to Common %TR

Charts

https://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.XOM.NYS

https://finance.yahoo.com/quote/XOM/chart?p=XOM#

Reuters raw

XOM VALUATION RATIOS

VALUATION RATIOS

Company industry sector Company industry sector

P/E Ratio (TTM)

33.66 17.13 P/E Ratio (TTM) 9.34 33.66 17.13

P/E High – Last 5 Yrs.

27.94 P/E High – Last 5 Yrs.

31.13 27.94

12.1 P/E Low – Last 5 Yrs.

14.55 12.1 P/E Low – Last 5 Yrs.

14.55 12.1

Beta 1.13 1.31 1.01 Beta

1.31 1.01

1.12

Price to Sales (TTM) 1.1 1.16 1.08 Price to Sales (TTM) 0.38 1.16 1.08

1.87 3.04

Price to Book (MRQ) 1.01 3.04 3.45 Price to Book (MRQ) 1.84 3.04 3.45

1.87 3.16 3.65 Price to Tangible Book (MRQ) 1.05 3.16 3.65 Price to Tangible Book (MRQ) 2.24 3.16 3.65

8.4 Price to Cash Flow (TTM)

15.87 8.4

0.5

% Owned Institutions

0.5 0.37 % Owned Institutions

0.5 0.37

DIVIDENDS

Company industry sector Company industry sector Company industry sector

3.81 1.91

Dividend Yield

1.91 4.85 Dividend Yield 2.8 1.91 4.85

2.49 2.12 2.61 Dividend Yield – 5 Year Avg 3.23 2.12 2.61 Dividend Yield – 5 Year Avg

2.12 2.61

Dividend 5 Year Growth Rate 9.62 83.05 29.43 Dividend 5 Year Growth Rate — 83.05 29.43

Payout Ratio(TTM)

6.94 30.87 Payout Ratio(TTM)

6.94 30.87

GROWTH RATES

Company industry sector Company industry sector Company industry sector

Sales (MRQ) vs Qtr. 1 Yr. Ago

-18.49 -10.1 Sales (MRQ) vs Qtr. 1 Yr. Ago

-18.49 -10.1

Sales (TTM) vs TTM 1 Yr. Ago

-15.76 -11.09 Sales (TTM) vs TTM 1 Yr. Ago

-15.76 -11.09

5.5

Sales – 5 Yr. Growth Rate

16.63 12.32 Sales – 5 Yr. Growth Rate 7.42 16.63 12.32

EPS (MRQ) vs Qtr. 1 Yr. Ago

-71.15 -21.86 EPS (MRQ) vs Qtr. 1 Yr. Ago

-71.15 -21.86

— — EPS (TTM) vs TTM 1 Yr. Ago

— —

EPS – 5 Yr. Growth Rate

13.67 3.07 EPS – 5 Yr. Growth Rate

13.67 3.07

7.94 1.78 5.42 Capital Spending – 5 Yr. Growth Rate

1.78 5.42 Capital Spending – 5 Yr. Growth Rate 8.92 1.78 5.42

FINANCIAL STRENGTH

Company industry sector Company industry sector Company industry sector

0.56

Quick Ratio (MRQ) 1.09 0.82 1.32 Quick Ratio (MRQ) 1.2 0.82 1.32

Current Ratio (MRQ) 1.32 0.97 1.57 Current Ratio (MRQ) 1.7 0.97 1.57

LT Debt to Equity (MRQ)

46.45 187.63 LT Debt to Equity (MRQ)

46.45 187.63

Total Debt to Equity (MRQ)

67.72 203.44 Total Debt to Equity (MRQ)

67.72 203.44

— 8.41

Interest Coverage (TTM) — 8.41 15.46 Interest Coverage (TTM) — 8.41 15.46

PROFITABILITY RATIOS

Company industry sector Company industry sector Company industry sector

Gross Margin (TTM)

24.28 Gross Margin (TTM)

15.32 24.28

Gross Margin – 5 Yr. Avg.

9.23 24.22 Gross Margin – 5 Yr. Avg.

9.23 24.22

12.5 — — EBITD Margin (TTM)

— — EBITD Margin (TTM)

— —

6.1

EBITD – 5 Yr. Avg

6.1 20.19 EBITD – 5 Yr. Avg

6.1 20.19

6.26 6.58

Operating Margin (TTM)

6.58 8.02 Operating Margin (TTM)

6.58 8.02

4.18 Operating Margin – 5 Yr. Avg. 14.4 -29.09 4.18 Operating Margin – 5 Yr. Avg.

-29.09 4.18

5.1 Pre-Tax Margin (TTM)

6.91 5.1 Pre-Tax Margin (TTM) 5.87 6.91 5.1

3.73 Pre-Tax Margin – 5 Yr. Avg. 17.66

3.73 Pre-Tax Margin – 5 Yr. Avg. 3.01 -29.63 3.73

7.21 5.38 1.68 Net Profit Margin (TTM)

5.38 1.68 Net Profit Margin (TTM)

5.38 1.68

Net Profit Margin – 5 Yr. Avg.

-30.67 -0.82 Net Profit Margin – 5 Yr. Avg.

-30.67 -0.82

Effective Tax Rate (TTM)

19 30.88 Effective Tax Rate (TTM)

19 30.88

Effective Tax Rate – 5 Yr. Avg.

21.28 27.37 Effective Tax Rate – 5 Yr. Avg. 32.57 21.28 27.37

EFFICIENCY

Company industry sector Company industry sector Company industry sector

Revenue/Employee (TTM)

5,220,742,431 2,754,984,379 Revenue/Employee (TTM)

5,220,742,431 2,754,984,379

Net Income/Employee (TTM)

277,340,663 80,213,075 Net Income/Employee (TTM)

277,340,663 80,213,075

4.5 5.62 Receivable Turnover (TTM) 8.44 4.5 5.62 Receivable Turnover (TTM)

4.5 5.62

10.39 9.09 Inventory Turnover (TTM)

10.39 9.09

0.82 0.95 0.73 Asset Turnover (TTM)

0.95 0.73 Asset Turnover (TTM)

0.95 0.73

ENT EFFECTIVENESS

MANAGEMENT EFFECTIVENESS

Company industry sector Company industry sector Company industry sector

5.91

Return on Assets (TTM) 3.27 3.95 5.04 Return on Assets (TTM) 9.63 3.95 5.04

5.32 8.95 Return on Assets – 5 Yr. Avg.

5.32 8.95

7.43

Return on Investment (TTM)

7.43 8.22 Return on Investment (TTM)

7.43 8.22

9.55

Return on Investment – 5 Yr. Avg.

9.55 12.81 Return on Investment – 5 Yr. Avg.

9.55 12.81

Return on Equity (TTM)

10.58 11.16 Return on Equity (TTM) 21 10.58 11.16

23.16

Return on Equity – 5 Yr. Avg.

14.09 15.34 Return on Equity – 5 Yr. Avg.

14.09 15.34

VALUATION RATIOS		CVX		PSX.N
																						Company	industry	sector
P/E Ratio (TTM)		16.18				33.66				17.13		18.15
P/E High – Last 5 Yrs.	1				3.73			3		1.13				27.94		1	1.26	31.13	1	3.04
P/E Low – Last 5 Yrs.				8.92				14.55		7.92		8.3
Beta		0.88				1.31						1.01		1.45
Price to Sales (TTM)				1.16				1.08
Price to Book (MRQ)				3.45
Price to Tangible Book (MRQ)
Price to Cash Flow (TTM)		8.33			1		5.87						5.38	15.87		7.31
% Owned Institutions		50.77				0.37		62.65		74.02
DIVIDENDS
Dividend Yield				4.85		5.12
Dividend Yield – 5 Year Avg																					—
Dividend 5 Year Growth Rate		10.22				83.05				29.43
Payout Ratio(TTM)		59.98				6.94				30.87		69.34		24.35
GROWTH RATES
Sales (MRQ) vs Qtr. 1 Yr. Ago	-3				6.58				-18.49				-10.1		-37.07		-36.19
Sales (TTM) vs TTM 1 Yr. Ago		-31.8				-15.76				-11.09		-32.39		-33.82
Sales – 5 Yr. Growth Rate				16.63				12.32		3.62
EPS (MRQ) vs Qtr. 1 Yr. Ago		-46.49				-71.15				-2	1.86		-63.11		38.85
EPS (TTM) vs TTM 1 Yr. Ago		-40.47		-57.62		33.51
EPS – 5 Yr. Growth Rate		13.81				13.67				3.07		14.11		61.96
Capital Spending – 5 Yr. Growth Rate		12.28
FINANCIAL STRENGTH
Quick Ratio (MRQ)						0.82						1.32
Current Ratio (MRQ)		0.86				0.97				1.57
LT Debt to Equity (MRQ)		11.62				46.45				187.63		18.91	3				8.41
Total Debt to Equity (MRQ)		20.1				67.72				203.44				23.16		38.59
Interest Coverage (TTM)				15.46
PROFITABILITY RATIOS
Gross Margin (TTM)			1				5.32				24.28		39.34	15.32	2		3.27
Gross Margin – 5 Yr. Avg.		26.39				9.23				24.22		35.72		13.85
EBITD Margin (TTM)		18.93		5.05
EBITD – 5 Yr. Avg		14.22				20.19		20.89		2.16
Operating Margin (TTM)				8.02		4.64		3.97
Operating Margin – 5 Yr. Avg.						10.39				-29.09		1.21
Pre-Tax Margin (TTM)		9.91				6.91		8.66
Pre-Tax Margin – 5 Yr. Avg.		14.94			-2		9.63	-29.63
Net Profit Margin (TTM)		6.09		4.26
Net Profit Margin – 5 Yr. Avg.						8.95				-30.67				-0.82		10.37		2.03
Effective Tax Rate (TTM)		27.24				30.88		29.74		27.4
Effective Tax Rate – 5 Yr. Avg.		40.07				21.28				27.37		41.29
EFFICIENCY
Revenue/Employee (TTM)		3,777,132				5,220,742,431				2,754,984,379		2,218,269		8,003,215
Net Income/Employee (TTM)		272,284				277,340,663				80,213,075		135,039		340,857
Receivable Turnover (TTM)		10.71		16.05
Inventory Turnover (TTM)		1	2.09		12.29		17.09
Asset Turnover (TTM)		0.54		2.26
MANAG		EM
Return on Assets (TTM)				3.95				5.04
Return on Assets – 5 Yr. Avg.		11.73		10.34		7.48
Return on Investment (TTM)		7.33				8.22		3.76		12.7
Return on Investment – 5 Yr. Avg.		15.18				12.81		12.16		10.16
Return on Equity (TTM)		11.35				10.58				11.16		5.56
Return on Equity – 5 Yr. Avg.				14.09				15.34		17.74		14.84

Ratios arranged

VALUATION RATIOS XOM CVX PSX.N
Company Company Company industry sector

P/E Ratio (TTM) 16.18 18.15 9.34 33.66 17.13

P/E High – Last 5 Yrs.

11.26

31.13 27.94

P/E Low – Last 5 Yrs. 8.92 7.92 8.3 14.55 12.1
Beta 0.88 1.13 1.45 1.31 1.01
Price to Sales (TTM) 1.12 1.1 0.38 1.16 1.08
Price to Book (MRQ) 1.87 1.01 1.84 3.04 3.45
Price to Tangible Book (MRQ) 1.87 1.05 2.24 3.16 3.65
Price to Cash Flow (TTM) 8.33 5.38 7.31 15.87 8.4
% Owned Institutions 50.77 62.65 74.02 0.5 0.37

DIVIDENDS

Company Company Company industry sector
Dividend Yield 3.81 5.12 2.8 1.91 4.85
Dividend Yield – 5 Year Avg 2.49 3.23 — 2.12 2.61
Dividend 5 Year Growth Rate 10.22 9.62 — 83.05 29.43
Payout Ratio(TTM) 59.98 69.34 24.35 6.94 30.87

GROWTH RATES
Company Company Company industry sector

Sales (MRQ) vs Qtr. 1 Yr. Ago

-37.07 -36.19 -18.49 -10.1

Sales (TTM) vs TTM 1 Yr. Ago -31.8 -32.39 -33.82 -15.76 -11.09
Sales – 5 Yr. Growth Rate 5.5 3.62 7.42 16.63 12.32
EPS (MRQ) vs Qtr. 1 Yr. Ago -46.49 -63.11 38.85 -71.15 -21.86
EPS (TTM) vs TTM 1 Yr. Ago -40.47 -57.62 33.51 — —
EPS – 5 Yr. Growth Rate 13.81 14.11 61.96 13.67 3.07
Capital Spending – 5 Yr. Growth Rate 7.94 12.28 8.92 1.78 5.42

FINANCIAL STRENGTH
Company Company Company industry sector

Quick Ratio (MRQ) 0.56 1.09 1.2 0.82 1.32
Current Ratio (MRQ) 0.86 1.32 1.7 0.97 1.57
LT Debt to Equity (MRQ) 11.62 18.91

46.45 187.63

Total Debt to Equity (MRQ) 20.1 23.16 38.59 67.72 203.44
Interest Coverage (TTM) — — — 8.41 15.46

PROFITABILITY RATIOS
Company Company Company industry sector

Gross Margin (TTM) 27 39.34

15.32 24.28

Gross Margin – 5 Yr. Avg. 26.39 35.72 13.85 9.23 24.22
EBITD Margin (TTM) 12.5 18.93 5.05 — —
EBITD – 5 Yr. Avg 14.22 20.89 2.16 6.1 20.19
Operating Margin (TTM) 6.26 4.64 3.97 6.58 8.02
Operating Margin – 5 Yr. Avg. 10.39 14.4 1.21 -29.09 4.18
Pre-Tax Margin (TTM) 9.91 8.66 5.87 6.91 5.1
Pre-Tax Margin – 5 Yr. Avg. 14.94 17.66 3.01 -29.63 3.73
Net Profit Margin (TTM) 7.21 6.09 4.26 5.38 1.68
Net Profit Margin – 5 Yr. Avg. 8.95 10.37 2.03 -30.67 -0.82
Effective Tax Rate (TTM) 27.24 29.74 27.4 19 30.88
Effective Tax Rate – 5 Yr. Avg. 40.07 41.29 32.57 21.28 27.37

EFFICIENCY
Company Company Company industry sector

Revenue/Employee (TTM) 3,777,132 2,218,269 8,003,215 5,220,742,431 2,754,984,379
Net Income/Employee (TTM) 272,284 135,039 340,857 277,340,663 80,213,075
Receivable Turnover (TTM) 10.71 8.44 16.05 4.5 5.62
Inventory Turnover (TTM) 12.09 12.29 17.09 10.39 9.09
Asset Turnover (TTM) 0.82 0.54 2.26 0.95 0.73

MANAGEMENT EFFECTIVENESS
Company Company Company industry sector

Return on Assets (TTM) 5.91 3.27 9.63 3.95 5.04
Return on Assets – 5 Yr. Avg. 11.73 10.34 7.48 5.32 8.95
Return on Investment (TTM) 7.33 3.76 12.7 7.43 8.22
Return on Investment – 5 Yr. Avg. 15.18 12.16 10.16 9.55 12.81
Return on Equity (TTM) 11.35 5.56 21 10.58 11.16
Return on Equity – 5 Yr. Avg. 23.16 17.74 14.84 14.09 15.34

Make sure the industry and sector numbers are the same for your 3 companies
If they aren’t, then keep those for your company, and erase the industry and sector of the competitors
13.73	13.04
-36.58
38.41
23.27

DuPont

Report Date 12/31/2017 12/31/2016 12/31/2015 12/31/2014 12/31/2013 12/31/2012 12/31/2011 12/31/2010 12/31/2009 12/31/2008

Growth rate

Total Revenue 244363000 226094000 268882000 411939000 438255000 482295000 486429000 383221000 310586000 477359000

Net Income to Common 19710000 7840000 16150000 32520000 32580000 44880000 41060000 30460000 19280000 45220000

Total Assets 348691000 330314000 336758000 349493000 346808000 333795000 331052000 302510000 233323000 228052000

Total Liabilities 161003000 162989000 165947000 175094000 172805000 167932000 176656000 155671000 122754000 115087000
Total Equity 187688000 167325000 170811000 174399000 174003000 165863000 154396000 146839000 110569000 112965000

7.9%

0.70 0.68 0.80

1.26

1.47

1.33 2.09

9.3%

EM 1.86

1.97

1.99 2.01

2.06

9.5%

PM 6.6% 7.4%
TAT 0.93 1.22
ROA

EM 1.96 2.01
ROE 12.4%

	Growth rate
5 yrs	9 yrs
-13%	-7%
-1	5%	-9%
0.9%
	PM	8.1%	3.5%	6.0%		7.9%		7.4%		9.3%	8.4%	6.2%	9.5%
	TAT	1.18	1.44	1.27
	ROA	5.7%	2.4%	4.8%	9.4%	13.4%		12.4%	10.1%	8.3%	19.8%
	1.97	2.00	2.14	2.11	2.02
	ROE	10.5%	4.7%	18.6%	18.7%	27.1%	2	6.6%	20.7%	17.4%	40.0%
5 year Avg	10 yr Avg
6.3%	9.6%
19.4%

FINC 3304: Business Finance

Work the Web project : Part 2 (due 2/

4/21)

Instructor: Dr. Nazif Durmaz

Work the Web Part-2, Instructions :

You will use some of the techniques discussed in Chapter-3 to do a basic financial analysis of the firm you are
studying.

You will need to use/submit two files for this assignment : one Word file and one Excel file. The XL file will include
the data needed for the Work the Web parts. The WW2 report (Word file) will include the following :

• Basic company information collected in WW1
• Trend analysis of profitability
• Ratio analysis vs competitors
• DuPont Analysis

Please find the attached XL file (SampleWW2.xlsx).
Please refer to this sample file so you understand what you must do for your company.

Data collection

To start WW2 you will need to obtain historical data that will be used in WW2, WW3 and WW4. Even if you
don’t use all the items in this report, make sure you save them in an Excel file that can be used later.

For the exercises use one of the freely available Financial Websites ;

• CSIMarket https://csimarket.com/
• Macrotrends https://www.macrotrends.net/
• Zacks Investment Research https://www.zacks.com/
• Reuters.com https://www.reuters.com/finance
• MSN Money https://www.msn.com/en-us/money
• Yahoo ! Finance https://finance.yahoo.com/

or any other financial website you prefer or can locate your company’s data , copy and paste balance
sheet and income statements for the last 3 to 5 years. Include BS and IS in the same sheet in Excel. Make sure the
columns align. Check how many years are provided in each website and then decide your source.

Trend analysis

ROA and ROE are two of the most important variables that measure the performance of a company. For example ;
you may go to the MSN website and get the 10 year chart of ROA and ROE for your company. You can use the
link below and then click on the Management Effectiveness tab http://www.msn.com/en-us/money/stockdetails/
analysis/fi-126.1.XOM.NYS

Once you include the information on your report, add your comments describing the trend. Is there a trend that
you can see ? Is it improving or deteriorating ? Is there an especially bad year ? If there is, try to explain it.

Another performance measure that investors care about is the stock price. Go to your favorite financial website and
copy/paste a chart of the stock prices over the last 5 years (or 10 years if available). Compare to the previous chart.
Do you see a relationship between profitability and stock prices ? Describe the trend. Is it increasing or decreasing ?
Is there an especially bad year ? If there is, try to explain it.

https://csimarket.com/

https://www.macrotrends.net/

https://www.zacks.com/

https://www.reuters.com/finance

https://www.msn.com/en-us/money

https://finance.yahoo.com/

http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.XOM.NYS

– Work the Web project : Part 2 2

Ratio analysis

Visit one of the financial websites provided in Data Collection section that provides financial ratios for your
company, industry, and sector. For instance ; you may go to this page http://www.reuters.com/finance/stocks/
financialHighlights?symbol=XOM (input the ticker for your own company) and copy the 7 categories of financial
ratios that Reuters reports for Company, Industry and Sector. Start with valuation ratios. Please ignore the data
shown in ”Revenue & Earnings per share”. Repeat the process for the two competitors that you identified in WW1.

Copy the ratios into a new tab in Excel so the rows for your company and the 2 competitors match. Then rearrange
the columns so you can see next to each other the values for your company, your competitor 1, your competitor 2,
industry and sector.

Once you have them next to each other, you’ll start comparing the numbers trying to find where your company
performs better and where your company show worse performance than competitors.

As a minimum, you must find one overall weakness and one overall strength as suggested by this comparison. It is
not necessary to comment each of the financial ratios, only those that are perceived as strengths or weaknesses. You
can report strengths or weaknesses in each financial ratio category but it is not necessary.

Du Pont analysis

You will copy key data you got in Excel into a new sheet. The specific rows you need are :
spacing

◦ Sales
◦ Net Income
◦ Assets
◦ Debt
◦ Equity
Based on these five rows of data you will calculate the 5 ratios involved in the Du Pont analysis for each of the

years for which you have information ;
spacing

◦ Profit Margin
◦ Total assets turnover
◦ Return on Assets
◦ Equity Multiplier
◦ Return on Equity
Once you have all the ratios for all the years with data, compare the components of ROA and ROE against industry

level and make an overall assessment of the performance of the company. Is the company doing well or not so well ?
Need to monitor PM TAT or EM ? Include any recommendations that you believe are needed.

http://www.reuters.com/finance/stocks/financialHighlights?symbol=XOM

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Urgent 2 ”

Get high-quality paper

NEW! AI matching with writer