Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Tanvon Health Inc
Income Statement2011201220132014
Operating Revenue$477,050,513$511,256,300$568,318,572$548,483,299
Non-operating Revenue46,224,94863,246,17089,297,33699,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 Benefits48,064,23748,064,23759,474,80852,147,549
Supplies48,175,81037,871,06438,504,94528,345,990
Lease40,419,80740,419,80739,043,32236,760,940
Information Technology18,188,56018,188,56019,802,43122,389,511
Depreciation51,297,58351,297,58358,480,31471,513,962
Interest28,264,45628,264,45625,927,32826,756,370
Other120,716,699132,302,939151,747,507167,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,01420122013$2,014
Cash$332,069,348$489,205,269$454,025,775$604,840,109
Accounts Receivable42,377,75958,162,04050,136,23742,072,486
Inventory12,751,66714,809,50316,139,58113,330,327
Propert, Plant & Equipment638,365,587657,564,480715,810,262734,536,383
Investments234,659,871224,569,789245,903,919362,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 Debt506,968,516739,310,809745,167,020956,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

Financial Statement Analysis 1. 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 Eamed Cash Flow Coverage Total Asset Turnover Current Asset Turnover Fixed Asset Turnover Total Margin Return on Equity 2. Explain the calculated results, why did the ratio increase or decrease, for the following ratios: 1) Days Cash on Hand 2) Times Interest Earned 3) Total Asset Turnover Create four run charts for 1) profitability including total margin, ROE, and ROA, 2) turnover ratios including TAT, CAT, and FAT, 3) days in AR, and 4) debt to equity ratio. 3. 4. Comment on the change in the financial condition of this organization based on your analysis and provide any specific operating recommendations, as needed, to improve it's financial performance.

Step by Step Solution

3.38 Rating (176 Votes )

There are 3 Steps involved in it

Step: 1

The comparisons will be made between 2011 and 2014 a The rise in days cash on hand is primarily due ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management A Strategic Emphasis

Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins

7th edition

77733770, 978-0077733773

More Books

Students also viewed these Accounting questions