I need to construct an income statement (and analysis of income statement), balance sheet (with analysis), cash flow statement (and analysis), current raio, days cash on hand, days in patient account ratios, average age of plant, debt to assets ratio, debt to capitalization ratio, total profit margin, operating margin, return on assets, return on equity, Du Point Analysis, and KPI dashboard with the following information.

Here is the benchmark informaton: Ellison, A. & Cohen, J.K. (2017, May 3). 230 hospital benchmarks I 2017. Becker's Hospital Review. Retrieved from: https://www.beckershospitalreview.com/lists/230-hospital-benchmarks-2017.html

Account Current Year Prior Year

Other deffered credits 40,598

Cash 3,422,928 3,773,862

Education Expenses 163,651 376,699

Accrued compensation and related liabilities 4,248,791 2,656,831

Pledges and other recievables 7,043,254 1,386,264

Daily Hospital Expenses 13,823,701 11,774,335

Ancillary Services-Revenues 267,470,473 257,984,067

Purchased Inpatient Expenses 3,671,254 3,266,987

Contractual Adjustments- County Indigent Programs- Managed Care 89,029

Construction in Progress 1,400,434 2,032,344

Contractual Adjustments- Other Third Parties- Traditional 9,230,282 6,917,141

Change- Ourchases of Plant, Property, and Equipment and Construction in Progress (6,551,104) (7,511,920)

Equipment 27,614,701 24,861,028

Charity Discounts- other 4,073,176 1,264,042

Contractual Adjustments- Medicare-Managed Care 36,840,646 34,438,542

Change in Intercompany Payables (6,428) (1,057,285)

Unassigned Costs 3,498,540 3,584,145

Land improvements 4,284,122 4,284,122

Change in Other Accrued Expenses (37,191) 52,757

Contractual-Administrative Adjustments 58,347

Accounts and notes recievable 52,966,361 48,883,616

Administrative Expenses 23,110,691 18,830,455

Contractual adjustments- medicaid-traditional 15,975,595 14,045,441

contractual adjustments- other third parties-managed care 66,919,480 55,975,915

contractual adjustments- medicare- traditional 91,226,630 80,836,904

prepaid expenses and other current assets 13,956 33,094

inventory 1,461,138 1,397,898

change- principal payments on long-term debt (1,472,875) (89,055)

Unrestricted fund balance 35,632,865 28,111,550

Change in Assets Whose Use is Limited (5,142,901)

Change- Other current liabilties 172,819

Capitation Premium Revenue- Medicare (credit balance) 7,461,384 6,254,259

Change in Intercompany Recievables (18,779) (6,478)

Provision for Bad Debts 4,455,202 2,431,937

Revenue- Daily Hospital Services 58,160,346 46,135,149

Capitation Premium Revenue- Other third parties (credit balance) 9,201,863 2,022,696

Change in Accrued Copensation and Related Liabilities 1,591,960 192,205

Policy Discounts 679,885

Intercompany Payables 782 7,210

Change in Inventory (63,240) 341,011

Change in Prepaid Expenses and other Current Assets 19,138 (20,288)

Change in Accounts and Notes receivable, net of allowance for Uncollectible recieables and third party contractual withholds (373,155) (2,185,739)

Accounts Payable 2,080,892) 2,657,082

Change in deferred credits 40, 598

Other Deductions from Revenues 1,681,308 5,576,806

General Expenses 19,047,952 14,388,704

Change- Proceeds from Issuance of Short- Term Notes and Loans 5,142,900

Buildings and Improvements 38,658,121 35,224,180

Purchased Outpatient expenses 1,275,399 740,870

Limited Use Investments 5,142,901

Fiscal Expenses 3,698,688 2,101,829

Change in Other Current Liabilities 172,819

Other Accrued Expenses 232,581 269,772

Payable to third-party payors 400,083 321,196

Change in Accounts Payable (576,190) 546,890

Less allowance for uncollectible receivables and third party contractual witholds -39,086,187 -35,376,597

Notes and loans payable 5,142,900

Intercompany receivables 25,257 6,478

Contractual Adjustments- Medicaid- Managed Care 56,195,984 54,018,557

Ambulatory Expenses 8,564,631 7,240,177

Change in Pledges and Other Receivables (5,656,900) 2,371,944

Other non-current liabilities 316,402 290,393

Ambulatory Services- Revenues 80,338,006 57,610,075

Research Expenses 94,588 71,154

Bonds payable 7,040,952 8,539,836

Change in Payable to Third party payors 78,887 54,035

Total other operating revenue 1,136,055 960,564

Net Non operating revenue 12,420 60,811

Other assets 0 484,680

Ancillary Expenses 38,968,446 37,644,961