Financial Statement Analysis 1. Given the balance sheet and income statement on the accompanying spreadsheet, calculate the following ratios: 2016 2017 2018 2019 Current ratio Cash on hand Days in AIR Avg payment period Equity financing Times interest earned Cash flow to debt Total asset tumover Current asset turnover Fixed asset turnover Total margin Return on Equity Return on Asset Finlain the Homework 7 Tanvon Health Inc 2016 2017 2018 Income Statement 2019 6 Operating Revenue 8 Non-operating Revenue 9 Total Revenue 10 $477,050,513 46,224,948 $523,275,461 $511,256,300 63,246,170 $574,502,470 $558,318,572 89,297,336 $647,615,908 $561,483,299 99,068,209 $660,551,508 11 Expenses 12 Salaries and Wages 13 Fringe Benefits 74 Supplies 15 Lease 16 Information Technology 17 Depreciation 18 Interest 19 Other 20 Total Expenses 21. $198,457,616 48,064,237 48,175,810 40,419,807 18,188,560 51,297,583 28,264,456 120,716,699 $553,584,768 $222,614,230 48,064,237 37,871,064 40,419,807 18,188,560 51,297,583 28,264,456 132,302,939 $579,022,876 $234,705,059 59,474,808 38,504,945 39,043,322 19,802,431 58,480,314 25,927,328 151 747 507 $627,685,714 $229,593,187 52,147,549 28,345,990 36,760,940 22,389,511 71,513,962 26,756,370 167,239,923 $634,747,432 22 Profit -$30,309,307 -$4,520,406 $19,930,194 $25,804,076 2016 2017 2018 2019 24 Balance Sheet 25 26 Cash 27 Accounts Receivable $332,069,348 42,377,759 12,751,667 $489,205,269 58,162,040 14,809,503 $444,025,775 50,136,237 16,139,581 $604,840,109 42,072,486 13,330,327 28 Inventory 29 Propert, Plant & Fouinment 29 2 $553,584,768 $579,022,876 $627,685,714 Total Expenses $634,747,432 -$30,309,307 -$4,520,406 $19,930,194 $25,804,076 22 Profit 23 2016 2017 2018 2019 24 Balance Sheet 25 $332,069,348 $489,205,269 $444,025,775 $604,840,109 42,377,759 58,162,040 50,136,237 42,072,486 12,751,667 14,809,503 16,139,581 13,330,327 638,365,587 657,564,480 715,810,262 734,536,383 234,659,871 224,569,789 245,903,919 362,589.744 $1,260,224,232 $1,444,311,081 $1,472,015,774 $1,757,369,049 26 Cash 27 Accounts Receivable 28 Inventory 29 Propert, Plant & Equipment 30 Investments 31 Total Assets 32 33 Accounts Payable 34 Long Term Debt 35 Total Liabilities 36 37 Equity 38 39 40 $434,884,278 $382,108,428 $384,026,716 $434,884,278 506,968,516 739,310,809 745 167,020 953,858,657 $941,852,794 $1,121,419,237 $1,129,193,736 $1,388,742,935 $318,371,438 $322,891,844 $342,822,038 $368,626,114 2.81% 45 120.00% 100.00%