Answered step by step
Verified Expert Solution
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 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 |
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started