Q. 1.Choose any public listed company. Download its historical financial statements from yahoo finance.com for a certain period (2-3 years)

a) Perform the financial ratio analysis of this company by using at least 3 ratios from each category. Liquidity Ratios, Debt Management Ratios, Profitability Ratios

b) Make a worksheet that includes at least five key financial statistics e.g. sales, profits, debts, market capitalization, earnings, etc of the company and the compare the financial performance of company over past few (2- 3) years

Income Statement (Ford Motor Company)

Revenue	12/31/17	12/31/16	12/31/15
Total Revenue	156,776,000	151,800,000	149,558,000
Cost of Revenue	140,197,000	134,616,000	131,410,000
Gross Profit	16,579,000	17,184,000	18,148,000
Operating Expenses
Research Development	-	-	-
Selling General and Administrative	9,770,000	12,597,000	10,097,000
Non Recurring	-	-	-
Others	-	-	-
Total Operating Expenses	149,967,000	147,213,000	141,507,000
Operating Income or Loss	6,809,000	4,587,000	8,051,000
Income from Continuing Operations
Total Other Income/Expenses Net	1,339,000	2,209,000	2,201,000
Earnings Before Interest and Taxes	6,809,000	4,587,000	8,051,000
Interest Expense	-1,136,000	-899,000	-773,000
Income Before Tax	8,148,000	6,796,000	10,252,000
Income Tax Expense	520,000	2,189,000	2,881,000
Minority Interest	126,000	113,000	109,000
Net Income From Continuing Ops	7,628,000	4,607,000	7,371,000
Non-recurring Events
Discontinued Operations	-	-	-
Extraordinary Items	-	-	-
Effect Of Accounting Changes	-	-	-
Other Items	-	-	-
Net Income
Net Income	7,602,000	4,596,000	7,373,000
Preferred Stock And Other Adjustments	-	-	-
Net Income Applicable To Common Shares	7,602,000	4,596,000	7,373,000

Balance Sheet (Ford Motor Company)

Period Ending	12/31/17	12/31/16	12/31/15
Current Assets
Cash And Cash Equivalents	8,934,000	7,828,000	5,386,000
Short Term Investments	17,554,000	19,642,000	18,181,000
Net Receivables	10,599,000	11,102,000	11,042,000
Inventory	10,277,000	8,898,000	8,319,000
Other Current Assets	2,631,000	3,145,000	2,704,000
Total Current Assets	115,902,000	108,461,000	102,587,000
Long Term Investments	3,347,000	3,523,000	3,244,000
Property Plant and Equipment	36,901,000	33,692,000	32,177,000
Goodwill	75,000	50,000	6,000
Intangible Assets	213,000	198,000	124,000
Accumulated Amortization	-	-	-
Other Assets	18,426,000	14,894,000	16,154,000
Deferred Long Term Asset Charges	10,973,000	9,705,000	11,509,000
Total Assets	257,808,000	237,951,000	224,925,000
Current Liabilities
Accounts Payable	22,115,000	21,296,000	20,272,000
Short/Current Long Term Debt	154,287,000	142,970,000	132,854,000
Other Current Liabilities	18,299,000	16,277,000	16,084,000
Total Current Liabilities	94,600,000	90,281,000	82,336,000
Long Term Debt	12,575,000	13,222,000	11,060,000
Other Liabilities	24,419,000	25,086,000	23,959,000
Deferred Long Term Liability Charges	-	-	-
Minority Interest	126,000	113,000	109,000
Negative Goodwill	-	-	-
Total Liabilities	222,792,000	208,668,000	196,174,000
Stockholders' Equity
Misc. Stocks Options Warrants	-	-	-
Redeemable Preferred Stock	-	-	-
Preferred Stock	-	-	-
Common Stock	41,000	41,000	41,000
Retained Earnings	21,218,000	15,634,000	14,414,000
Treasury Stock	-8,212,000	-8,135,000	-7,234,000
Capital Surplus	21,843,000	21,630,000	21,421,000
Other Stockholder Equity	-6,959,000	-7,013,000	-6,257,000
Total Stockholder Equity	34,890,000	29,170,000	28,642,000
Net Tangible Assets	34,602,000	28,922,000	28,512,000