Question: 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,
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.
| Tanvon Health Inc | ||||
| Income Statement | 2016 | 2017 | 2018 | 2019 |
| Operating Revenue | $477,050,513 | $511,256,300 | $558,318,572 | $561,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 | $647,615,908 | $660,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 | $19,930,194 | $25,804,076 |
| Balance Sheet | 2016 | 2017 | 2018 | 2019 |
| Cash | $332,069,348 | $489,205,269 | $444,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,472,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 | 953,858,657 |
| Total Liabilities | $941,852,794 | $1,121,419,237 | $1,129,193,736 | $1,388,742,935 |
| Equity | $318,371,438 | $322,891,844 | $342,822,038 | $368,626,114 |
| 2.81% |
Comment on the change in the financial condition of this organization based on your analysis and provide specific recommendations to improve financial performance.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
