Question
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
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% |
- 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 A/R ________ ________ ______ ______
Avg. payment period ________ ________ ______ ______
Equity financing ________ ________ ______ ______
Times interest earned ________ ________ ______ ______
Cash flow to debt ________ ________ ______ ______
Total asset turnover ________ ________ ______ ______
Current asset turnover ________ ________ ______ ______
Fixed asset turnover ________ ________ ______ ______
Total margin ________ ________ ______ ______
Return on Equity ________ ________ ______ ______
Return on Asset ________ ________ ______ ______
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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