80.2K

Verified Solution

Link Copied!

I need to use all the data listed and create a Balance sheet, income statement and cash flow. I can not get my balance sheet to balance no matter how hard I try. I will try and upload.

	Current Year	Prior Year
Cash	$3,422,928	$3,773,862
Accounts and notes receivable	$52,966,361	$48,883,616
Pledges and other receivables	$7,043,254	$1,386,264
Intercompany receivables	$25,257	$6,478
Inventory	$1,461,138	$1,397,898
Limited use investments	$5,142,901
Prepaid expenses and other current assets	$13,956	$33,094
Less allowance for uncollectible receivables and thirdparty contractual withholds	-$39,086,187	-$35,376,597
Unrestricted Fund Balance	$35,632,865	$28,111,550
Total Current Assets	$66,622,473	$48,216,165
Net Property & Equipment
Buildings and Improvements	$38,658,121	$35,224,180
Land improvements	$4,284,122	$4,284,122
Equipment	$27,614,701	$24,861,028
Construction in progress	$1,400,434	$2,032,344
Less: Accumulated Depreciation & amortization	($47,637,321)	($44,137,099)
Property, Plant and Equipment Net	$24,320,057	$22,264,575
Other Assets	$0	$484,680
Total Assets	$96,085,431	$70,965,420
Current liabilities
Notes and loans payable	$5,142,900
Accounts payable	$2,080,892	$2,657,082
Other accrued expenses	$232,581	$269,772
Payable to thirdparty payors	$400,083	$321,196
Intercompany payables	$782	$7,210
Accrued compensation and related liabilities	$4,248,791	$2,656,831
Other noncurrent liabilities	$316,402	$290,393
Other accrued expenses	$232,581	$269,772
Other deferred credits	$40,598
Total Current Liabilities	$12,695,610	$6,472,256
Long-term liabilities
Bonds payable	$7,040,952	$8,539,836
Total liabilities	$19,736,562	$15,012,092
Total Liabilities & Equity	$76,348,869	$55,953,328

File Home Insert Page Layout Formulas Data Review View Help O Search LG X Calibri General Paste & Cut Copy ~ Format Painter Clipboard 5 14 - AA == 25 Wrap Text - O-A E Merge & Center BIU $ -% - Co For Font Alignment Number Fy E F G B39 fa C O As of December 31, 2019 3 Current Year Prior Year 4 Assets 5 & Current Assets 7 Cash $3,422,928 $3,773,862 8. Accounts and notes receivable $52,966,361 $48,883,616 $ Pledges and other receivables $7,043,254 $1,386 264 Intercompany receivables $25.252 $6,478 51,461,138 $1.397,898 1 Inventory Umited use investments SS, 142,901 13 Prepaid expenses and other current assets $13,956 533,094 54 Less allowance for uncollectible receivables and third-party contractual withholds -$ 39,086, 187 535,376,597 15 Unrestricted Fund Balance S35,632.865 528,111,550 1 Total Current Assets S66,622,473 549,216,165 17 Net Property & Equipment Buildings and improvements $38,658,121 $35,224,180 Land improvements 54,294,122 $4,284,122 20 Equipment $27,614,701 $24,861,028 Construction in progress 51,400,434 $2,032,344 Less: Accumulated Depreciation & amortization 1547.637,3211 1544,137,099 Property, plant and Equipment Net $24.320.057 522 264 575 24 Other Assets SO 5484.680 Total Assets 2 $96 085 411$20.965,420 2 Liabilities & Equity Current liabilities Notes and loans payable Accounts payable 55,142.900 Other accrued expenses 52.00,192 $2,657,052 Payable to third party payors $212.51 5269,772 $400.003 Intercompany payables S321, 196 24 Accrued compensation and related liabilities 3782 57,210 Other non-current liabilities 54,248,791 $2.656,831 Other accrued expenses $116.400 $290393 Other deferred credits $232,541 $269,772 Total Current Liabilities 540,595 $12.695,610 Bords payable Total liabilities $7,040 950 SE519 816 $19.216.552 515012093 Total Liabilities & Equity 576.3485551228 $5,472,256 Income Statement Balance Sheet Cash Flow Ratios KPI Type here to search Summary Data Sheet hp Eat! sto File Home Insert Page Layout Formulas Data Review View Help O Search LG X Calibri General Paste & Cut Copy ~ Format Painter Clipboard 5 14 - AA == 25 Wrap Text - O-A E Merge & Center BIU $ -% - Co For Font Alignment Number Fy E F G B39 fa C O As of December 31, 2019 3 Current Year Prior Year 4 Assets 5 & Current Assets 7 Cash $3,422,928 $3,773,862 8. Accounts and notes receivable $52,966,361 $48,883,616 $ Pledges and other receivables $7,043,254 $1,386 264 Intercompany receivables $25.252 $6,478 51,461,138 $1.397,898 1 Inventory Umited use investments SS, 142,901 13 Prepaid expenses and other current assets $13,956 533,094 54 Less allowance for uncollectible receivables and third-party contractual withholds -$ 39,086, 187 535,376,597 15 Unrestricted Fund Balance S35,632.865 528,111,550 1 Total Current Assets S66,622,473 549,216,165 17 Net Property & Equipment Buildings and improvements $38,658,121 $35,224,180 Land improvements 54,294,122 $4,284,122 20 Equipment $27,614,701 $24,861,028 Construction in progress 51,400,434 $2,032,344 Less: Accumulated Depreciation & amortization 1547.637,3211 1544,137,099 Property, plant and Equipment Net $24.320.057 522 264 575 24 Other Assets SO 5484.680 Total Assets 2 $96 085 411$20.965,420 2 Liabilities & Equity Current liabilities Notes and loans payable Accounts payable 55,142.900 Other accrued expenses 52.00,192 $2,657,052 Payable to third party payors $212.51 5269,772 $400.003 Intercompany payables S321, 196 24 Accrued compensation and related liabilities 3782 57,210 Other non-current liabilities 54,248,791 $2.656,831 Other accrued expenses $116.400 $290393 Other deferred credits $232,541 $269,772 Total Current Liabilities 540,595 $12.695,610 Bords payable Total liabilities $7,040 950 SE519 816 $19.216.552 515012093 Total Liabilities & Equity 576.3485551228 $5,472,256 Income Statement Balance Sheet Cash Flow Ratios KPI Type here to search Summary Data Sheet hp Eat! sto

Answer & Explanation Solved by verified expert

See Answer