Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Was the treatment influenced by being novel or disruptive?

Answered: 1 week ago

Question

L A -r- P[N]

Answered: 1 week ago

Question

16.2 Explain three trends in the labour movement in Canada.

Answered: 1 week ago