Financial Statement Analysis

Given the balance sheet and income statement on the accompanying spreadsheet, calculate the following ratios:

2011 2012 2013 2014

Current Ratio ________ ________ ________ ________

Days Cash on Hand ________ ________ ______ ______

Days in A/R ________ ________ ______ ______

Debt Ratio ________ ________ ______ ______

Debt to Equity ________ ________ ______ ______

Times Interest Earned ________ ________ ______ ______

Cash Flow Coverage ________ ________ ______ ______

Total Asset Turnover ________ ________ ______ ______

Current Asset Turnover ________ ________ ______ ______

Fixed Asset Turnover ________ ________ ______ ______

Total Margin ________ ________ ______ ______

Return on Equity ________ ________ ______ ______

Tanvon Health Inc
Income Statement	2011	2012	2013	2014
Operating Revenue	$477,050,513	$511,256,300	$568,318,572	$548,483,299
Non-operating Revenue	46,224,948	63,246,170	89,297,336	99,068,209
Total Revenue	$523,275,461	$574,502,470	$657,615,908	$647,551,508
Expenses
Salaries and Wages	$198,457,616	$222,614,230	$234,705,059	$229,593,187
Fringe Benefits	48,064,237	48,064,237	59,474,808	52,147,549
Supplies	48,175,810	37,871,064	38,504,945	28,345,990
Lease	40,419,807	40,419,807	39,043,322	36,760,940
Information Technology	18,188,560	18,188,560	19,802,431	22,389,511
Depreciation	51,297,583	51,297,583	58,480,314	71,513,962
Interest	28,264,456	28,264,456	25,927,328	26,756,370
Other	120,716,699	132,302,939	151,747,507	167,239,923
Total Expenses	$553,584,768	$579,022,876	$627,685,714	$634,747,432
Profit	-$30,309,307	-$4,520,406	$29,930,194	$12,804,076
Balance Sheet	$2,014	2012	2013	$2,014
Cash	$332,069,348	$489,205,269	$454,025,775	$604,840,109
Accounts Receivable	42,377,759	58,162,040	50,136,237	42,072,486
Inventory	12,751,667	14,809,503	16,139,581	13,330,327
Propert, Plant & Equipment	638,365,587	657,564,480	715,810,262	734,536,383
Investments	234,659,871	224,569,789	245,903,919	362,589,744
Total Assets	$1,260,224,232	$1,444,311,081	$1,482,015,774	$1,757,369,049
Accounts Payable	$434,884,278	$382,108,428	$384,026,716	$434,884,278
Long Term Debt	506,968,516	739,310,809	745,167,020	956,858,657
Total Liabilities	$941,852,794	$1,121,419,237	$1,129,193,736	$1,391,742,935
Equity	$318,371,438	$322,891,844	$352,822,038	$365,626,114