Answered step by step
Verified Expert Solution
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 |
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started