The first column is the current year and the second is the prior year I need to create an income statement, balance sheet, and a cash flow statement with the following information: Account Current Year Prior Year Cash 3,422,928 3,773,862 Balance sheet Accrued compensation and related liabilities 4,248,791 2,656,831 Balance sheet Accounts and notes receivable 52,966,361 48,883,616 Balance sheet Prepaid expenses and other current assets 13,956 33,094 Balance sheet Inventory 1,461,138 1,397,898 Balance sheet Accounts payable 2,080,892 2,657,082 Balance sheet Payable to thirdparty payors 400,083 321,196 Balance sheet Notes and loans payable 5,142,900 Balance sheet Other deferred credits 40,598 Balance sheet Intercompany payables 782 7,210 Balance sheet Bonds payable 7,040,952 8,539,836 Balance sheet Pledges and other receivables 7,043,254 1,386,264 Balance sheet Construction in progress 1,400,434 2,032,344 Balance sheet Equipment 27,614,701 24,861,028 Balance sheet Land improvements 4,284,122 4,284,122 Balance sheet Unrestricted Fund Balance 35,632,865 28,111,550 Balance sheet Buildings and Improvements 38,658,121 35,224,180 Balance sheet Limited use investments 5,142,901 Balance sheet Less allowance for uncollectible receivables and thirdparty contractual withholds -39,086,187 -35,376,597 Balance sheet Intercompany receivables 25,257 6,478 Balance sheet Other noncurrent liabilities 316,402 290,393 Balance sheet Other accrued expenses 232,581 269,772 Balance sheets Change - Purchase of Plant, Property and Equipment and ConstructionInProgress (6,551,104) (7,511,920) Cash flow Change in Intercompany Payables (6,428) (1,057,285) Cash flow Change in Other Accrued Expenses (37,191) 52,757 Cash flow Change - Principal Payments On LongTerm Debt (1,472,875) (89,055) Cash flow Change in Assets Whose Use is Limited (5,142,901) Cash flow Change - Other current liabilities 172,819 Cash flow Change in Intercompany Receivables (18,779) (6,478) Cash flow Change in Accrued Compensation and Related Liabilities 1,591,960 192,205 Cash flow Change in Inventory (63,240) 341,011 Cash flow Change in Prepaid Expenses and Other Current Assets 19,138 (20,288) Cash flow Change in Accounts and Notes Receivable, Net of Allowance for Uncollectible Receivables and ThirdParty Contractual Withholds (373,155) (2,185,739) Cash flow Change in Deferred Credits 40,598 Cash flow Change - Proceeds from Issuance of ShortTerm Notes and Loans 5,142,900 Cash flow Change in Other Current Liabilities 172,819 Cash flow Change in Accounts Payable (576,190) 546,890 Cash flow Change in Pledges and Other Receivables (5,656,990) 2,371,944 Cash flow Change in Payable to ThirdParty Payors 78,887 54,035 Cash flow Purchased Inpatient Expenses 3,671,254 3,266,987 Income statement Purchased Outpatient Expenses 1,275,399 740,870 Income statement Daily Hospital Expenses 13,823,701 11,774,335 Income statement Contractual Adjustments County Indigent Programs Managed Care 89,029 Income statement Contractual Adjustments Other Third Parties Traditional 9,230,282 6,917,141 Income statement Contractual Adjustments Medicare Managed Care 36,840,646 34,438,542 Income statement Contractual - Administrative Adjustments 58,347 Income statement Contractual Adjustments Medicaid Traditional 15,975,595 14,045,441 Income statement Contractual Adjustments Other Third Parties Managed Care 66,919,480 55,975,915 Income statement Contractual Adjustments Medicare Traditional 91,226,630 80,836,904 Income statement Policy Discounts 679,885 Income statement Contractual Adjustments Medicaid Managed Care 56,195,984 54,018,557 Income statement Education Expenses 163,651 376,699 Income statement Ancillary Services - Revenues 267,470,473 257,984,067 Income statement Ancillary Expenses 38,968,446 37,644,961 Income statement Charity Discounts Other 4,073,176 1,264,042 Income statement Unassigned Costs 3,498,540 3,584,145 Income statement Administrative Expenses 23,110,691 18,830,455 Income statement Capitation Premium Revenue Medicare (credit balance) 7,461,384 6,254,259 Income statement Provision for Bad Debts 4,455,202 2,431,937 Income statement Revenue - Daily Hospital Services 58,160,346 46,135,149 Income statement Capitation Premium Revenue Other Third Parties (credit balance) 9,201,863 2,022,696 Income statement Other Deductions from Revenue 1,681,308 5,576,806 Income statement General Expenses 19,047,952 14,388,704 Income statement Fiscal Expenses 3,698,688 2,101,829 Income statement Ambulatory Expenses 8,564,631 7,240,177 Income statement Ambulatory Services - Revenues 80,338,006 57,610,075 Income statement Research Expenses 94,588 71,154 Income statement Total Other Operating Revenue 1,136,055 960,564 Income statement Net Non-operating Revenue and Expense 12,420 60,811 Income statement Current Year Prior Year Depreciation & Amortization (cash flow) $4,091,948 $3,896,495 Intercompany (Cash Flow) ($12,027,773) ($11,899,796) Less accumulated depreciation & amortization (balance sheet) ($47,637,321) ($44,137,099) and Income Statement Premium revenue not included in formula for net operating revenues Depreciation was included on income statement and info was provided only for cash flow statement, need to remove from income statement Expenses corrected data below: Administrative Expenses 17,823,107 18,830,455 Deferred credits are non-current liabilities for current year Change in Other current liabilities should only be listed once - Change in Other Current Liabilities 172,819 for current year