Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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%

  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 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

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

Finance Of International Trade

Authors: Eric Bishop

1st Edition

0750659084, 978-0750659086

More Books

Students also viewed these Finance questions

Question

Explain the key components of an assessment center (AC).

Answered: 1 week ago