I need help. Please check and correct the following sheets. My numbers are causing my balance sheet to not balance and I cant find the mistake.
Are use double declining balance for the depreciation of the CT machine and came up with $160,000. The last photo shows the information for bad debt.
Help & Support $ Cash Accounts Receivable Net Inventory Assets Prepaid Expense Net Building and Equipment Land Goodwill S 793,500 500,000 179,860 26,450 216,890 211,600 317,400 s Salaries and Benefits Medical Supplies and Drugs Insurance Expenses Depreciation Interest Provision for Bad Debts Other Operating Expenses S S S $ $ S $ $ 5,819 10,580 6,000 15,000 526,453 7,000 6,348 Accounts Payable 650,000 390,000 $ Liabilities Tages Payable Mortgage Payable $ 305,700 Unrestricted Net Assets Temporarily Restricted Permanently Restricted ACA 400,000 300.000 200,000 $ Instructions Journal Entries Not-for-Profit Ledger Elculation Mode: Automatic Workbook Statistics Bi a Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx > Salaries and Benefits Medical Supplies and Drugs Insurance Expenses Depreciation Interest Provision for Bad Debts Other Operating Expenses 5 S S $ $ $ $ $ 5,819 10,580 6,000 15.000 526,453 7,000 6,348 Accounts Payable $ $ 650,000 390,000 Lisbilities Tages Payable Mortgage Payable GA 305,700 Unrestricted Net Assets Temporarily Restricted Permanently Restricted AGA 400,000 300,000 200,000 Na Patient Services Revenue Premium Revenue Revenue Other Operating Revenue Unrestricted Contribution | CON 500,000 250.000 200 20.000 $ $ INSTRUCTIONS Complete the tournal entries and correspondine Taccount records that are provided to you in Journal Entries wolc the dish Instructions Journal Entries Not-for-Profit Ledger Incom ulation Mode Automatic Workbook Statistics $ Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx These are the transactions that took place during Fiscal Ye G ENTRIES Valon Hospital purchased a new piece of medical equipment for $150,000 cash Accounts Debit Credit $150,000 Cash $150,000 Vulcan Hospital received a $750,000 donation from Mrs. EO. The donation has no restrictions, Accounts Credit Debit $750,00 Unrestricted Contributions $750,000 Vulcan Hospital purchased a 2-yeur malpractice policy for $100,000 in Ch. Instructions Journal Entries Not-for-Profit Ledger Income St fon Mode Automatic Workbook Statistics Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx These are the transactions that took place during Fiscal Year 20 G H 3750,00 Canestricted Contributions $750,000 Valore Hospital purchased a 2-year malpractice policy for $100,000 in cash. Debit Account Cash Dr Espuse Credit $100,000 $100,000 Vulcan Hospital purchased a 5-year fire insurance policy for $250,000. Accounts Debit Credit $250.000 Prepaid Expense $250,000 Instructions Journal Entries Not-for-Profit Ledger Income Statem Workbook Statistics lation Mode utomatic a Home Insert Formulas Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx These are the transactions that took place during Fiscal Year 202 H C D 5 Some pacients discharged who zased $100,000 of inventory and whose insurance company was billed $500,000. Debit Credit $100.000 Accounts inventory A Receivable Tectory Expense $500.000 $100,000 Reve $500,000 6 Cash collections from patient accounts were $820,000 Account Credit $82 Debit 5820.000 Accounts Reisable $820.000 17 Vulcan Hospital purchased a new CT scan machine for $150.000 in cash and $250.000 on credit Instructions Journal Entries Not-for-Profit Ledger Income Stateme atlon Vede Automatic Workbook Statistics a Data File Insert Formulas Review View Home ? Help Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx These are the transactions that took place during 33 D G Vila Hagital purchased a new CT son machine for $150,000 in cash and $250,000 or credit No $250 Acco Debit Credit $15.000 Ning and mert Accounts Payable S250 Hages due to employees that had been previously recorded as a liability are now paid in cash in the amount of A Debit Credit SSD Sanies and enefits Experie Site 9 Al your of end, annual mortgage payment made $100,000 principle, S100,000 ferest Dobit Credit SA SELECIO ph Instructions Journal Entries Not-for-Profit Ledger Calculation Mode: Automatic Rodok Statistics elp Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx These are the transactions that took place durir D 10 Pod of your adiument - One your fire iurance ned AD Debit Credit SS0.000 Prepaid Expense 550.000 11 End of your adjustment -- Malpractice policy insurance used: Dehit Credit Accu Pruund bispense SOLO SELO 12 End of adjustom - One year prociation of Coachine purchased by $100 the year. El instructions Journal Entries Not-for-Profit Ledger Dlation de Automatic Workbook Statistics File Home Insert Formulas Data Review View Automate Help Tell me what you want to do Open in Help Contact Feedback Keyboard What's Support Shortcuts New Help & Support MJ. These are the transactions that took place during Fiscal Year 2020 3 12 Tad of your feet Ow your doorChe pointed by 600,000 in the year. A Cayen Thema 080-ww Delhi Deding en onders Od 13 10 To The Instructions Joumal Entries Not-for-Profit Ledger Income Statement Ratia ana Balance Sheet Cash Flow Statement Calculation Modestos Workbook Statistics BELLE elp Contact Feedback Keyboard What's Support Shortcuts New Help & Support f a Sad Dec Gothill 1740 1 Access 79330150000 199.62451216193 216 5 (150.00 1 150 3 1 100 $ Purchasing Donation Archie Puche 2 0 3 1 1 C 1000 11000) Collectic Puchong 8 4 5 6 7 & 9 10 11 SO 100m 10000 1 60 Martean Auto 1 12 Debes Instructions Journal Entries Not-for-Profit Ledger Income Statement Balance Sheet Cash Flow Statement Ratio analyses + Calculation doctAuto Wookbook Static hp view View Automate Help Tell me what you want to do Open in Desktop App Accounts Perabile. Povabila Metre Pell 650.00 $ 390.00 5305720 Uretricted They spermy Red $400.00 S1300.00 $ 210.00 $ 750.00 5 500 fit Ledger Income Statement BalanceSheet Cash Flow Statement Ratio analyses + hp Contact Feedback Keyboard What's Support Shortcuts New Help & Support fx ? B C D VULCAN COMMUNITY HOSPITAL Operating Statement For the Year Ending December 31, 2020 % Amount 500,000 100% $ 0.0% $ 0.0% $ 100% S 500,000 Reventes Net Patient Services Revenue Premium Revenue Other Operating Revenue Total Revencues from Operations Orating Expenses Salaries and Benefits Medical Supplies and Drugs Insurance Depreciation Interest Provision for Bad Debts Other Operating Expenses Total Expenses from Operations Excess of Revenues Over Expenses Unrestricted Contributions Transfer to parents Net Income 30% $ 20% $ 20% S 32% 5 80% S 20% S 55% S 257% S 0% 150% $ 0% S -157% 150,000 100.000 100.000 160,000 400,000 100,000 276,450 1,286,450 750,000 786.450) Instructions Journal Entries Not-for-Profit Ledger Income si tion Model Automatic Work Statistics Course Modules S43020 CM Spring_2020_MRA ILAssignment X My account unb365-my.sharepoint.com/x/c/personal/eunder07_uab_edu/_layouts/15/Docaspx?s ParentVUE Dashboard Blazernet W OFFICE 365 School G Home Schoology 5 (PD Excel Underwood. Emily) Documents Spring_2020_MRA_II_Assignm Home Insert Formulas Data Review View Automate Help Tell me Contact Feedback Keyboard What's Support Shortcuts New Help & Support fo G ASSES Am Am Current Ass Cach Accounts Recevable Net lavory Prepaid Expense Total Current Assets 5.713,500.00 $ 80,000.00 $ 229,860.00 $ 276.450.00 $1.299,810.00 DARO MESENTASSETS Lisbilities Current liabies Accounts Payable Wages Payable Total Current Liabilities Long-term liabilities Mortgage Parable Total Long-term liabilities Total Liabilities $ 900,000.00 $ 40,000.00 $ 940,000.00 $ 205,700.00 $ 205,700.00 $1.145.700.00 Fixed Asset Ne Building and Equipment $ 456,890.00 5 211.600.00 5.668 499.00 Net Assets Unrestricted Temporarily Restricted Permanently Restricted Total Na Aisers 5 586450.000 $ 300,000.00 $ 200,000.00 S 113.550.00 Total Fixed Assets Goodwill S 1740000 TOTAL ASSETS TOTAL LIABILITIES & NET ASSETS SASTO correct 17.00 WTORE Com sure to comment Instructions Journal Entries Not-for-Profit Ledger Income Statement Balance Sheet E THE Monconi Stati a Support Shortcuts New Help & Support fx 500000 D VULCAN COMMUNITY HOSPITAL Statement of Cash Flowa For the Year Ending December 31, 2020 Cash Flows from Operating Activities Collections Payments to Sellers Payments to Employees Insurance Payments Interest Payments Net Cash from Operating Activities $ $ $ $ $ $ 820,000.00 (650,000.00) 500,000.00 100,000.00 400,000.00 1.170,000.00 Cash Flows from Investing Activities Purchase of New Equipment Net Cash Used for Investing Activities S $ 400,000.00 400,000.00 Cash Flows from Financing Activities Payment of mortgage principal Net Cash from Financing Activities S $ 100,000.00 100,000.00 S NET INCREASE DECREASE) IN CASH CASH, BEGINNING OF YEAR CASH, END OF YEAR (80.100.00 793,500.00 713,400.00 S Instructions Journal Entries Not-for-Profit Ledger Glation Mode: Automatic Workbook Statistics cel Underwood Eny Documents Spring 2020_MRA_JL Assignment Questions Surved Underwood Emily Home Insent Form Data View Automate Help Tell me what you want to do Comments Open in Desktop App X -14 General > Auto 24 4 Conditional format G mert De Format Sort Find $. % shes Clear -OA. Filter Select Fort M Listing ind of war adjustment - One year depensation att machine purchased by S400,000 in the power te for C machine is 5 years. The salvage value is $20,000 Phasellus Doutile Declinir Balaro End of your adjustment - One yeur depreciation of CT machine purchased by S400,000 in the year. Useful Me for CT machine is 5 years. The salvage value is $20,000 - Ploueuse Do 'Cost Net Bodeguipment $100.000 Depreciation $160.000 Dell Credit $160.000 Building and Deprecation Expo Sal Value Urte $100 000 Journalis for de Balance Sheet Cashow Statement Ratin Shercom O 5 of 1030 AM 17.00 hp 1 14 Times New Roman = PM General til IMI U D ab Conditional Format Paste A. A $ % A Formatting as Table alinhoard Font Alignment Number Tables fi End of year adjustment - One year depreciation of CT machine purchased by $400,000 in the year. Useful B D G H 7 Vulcan Hospital purchased a new CT scan machine for $150,000 in cash and $250,000 on credit Debit Credit $150,000 Accounts Cash Net Building and Equipment Accounts Payable $400,000 $250,000 Wages due to employees that had been previously recorded as a liability are now paid in cash in the a Cashflow State BalanceSheet Instructions Journal Entries Not-for-Profit Ledger Income Statement Calculation Moder Automatic Wordbook Statistics HCM LCH...docx a End of year adjustment - One year depreciation of CT machine purchased by $400 D F A G B PIVVVV 13 $100,000 bills couldn't collect from patients. The bills is reported as bad debt. Debit Accounts Accounts Recievable Provisions for Bad Debt Credit $100,000 $100,000 Instructions Journal Entries Not-for-Profit Ledger Income Statement Balancesh ation Mode Automatic Workbook Statistics HCM Curriculum, dock
