Pleas me balance my ledger, and the rest.

ne Insert Draw Page Layout Formulas Data Review View Help U? tu lill- Illustrations Hi Get Add-ins My Add-ins - ommended Table vot Tables Recommended Charts Pivot Chart 3D Map Tours Line Column W La ables Add-ins Charts Sparklines 15 hese are the transactions that took place during Fiscal Year 2020 reate a journal entry and a T-Account entry for each of the following transactions: $400.000,00 worth of MR Machine is purchased with Cash Credit Accounts Plant and Machine Cash Debat $400,000.00 $400,000.00 575,000.00 worth of Inventory is purchased by Cash Credit Accounts Inventory Cash Debat $75,000.00 $75,000 $30.000 Fire Insurance is purchased by Cash for 5 year Credit Accounts Prepaid Insurance Cash Debit 530,000 $30,000 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Template Income Statement Cashflows mp Fall,202 IMRA LAssignment question. Compatibility Mode - Saved Insert Draw Home Page Layout Formulas Data Review View Help Get Add-ins L? alb Illustrations PivotChart le Recommended Table Pivot Tables My Add-ins - Recommended Charts 3D Map Tours Line Column Wind Loss Tables Add-ins Charts Sparklines - XB3 e O, - fx36 5* f G H 4 Wages due to employees that had been previously recorded as a lability are now paid in Cash $200 000 Accounts Debit Credit $200,000.00 Wages Payable 5200,000.00 A patient discharged who used 5100 000 worth of Inventory Debit Accounts Inventory Inventory Expenses Credit $100,000 $100,000 6. mited to insurance in the amount of $400.000 services rendered to pabents Accounts Accounts Recievable Patient Service Revenue Debit $400.000 Credit $400,000 Instructions Journal Entries Not-for-profit Ledger Balance Sheet Template Income Statement CashFlow State 3 OP (2021_MRA LAssignment question. Compatibility Mode - Saved. Formulas Data Review View Help Draw Page Layout ome Insert L? albo ti tali Get Add-ins My Add-ins Illustrations PivotChart ecommended Table Pivot Tables Recommended Charts Charts 3D Map Line Column Wind Loss Sparklines Tours Tables Add-ins * B3 On f G D B 5150 000 cash is received for services previously provided and bled Credit Accounts Cash Accounts Recievable Debit $150 000 $150.000 Cash Al year end annual mortgage payment made by Principle payment $15,000 Interest payment $35.000 Accounts Debi Credit $50,000 Interest payment interest $15.000 $35.000 End of year insurance aument insurance used Credit Accounts Insurance Expenses Prepaid Insurance Debit 56,000 56.000 Instructions Journal Entries Not-for-profit Ledger Balance Sheet Template Income Statement CashFlow State a ll_2021_MRA LAssignment_question. Compatibility Mode - Saved. Home Insert Draw Page Layout Formulas Data Review View Help t PivotChart Slice Et Get Add-ins Recommended Table ustations Recommended My Add-ins - Pivot Tables Charts Tables Add-ins Charts Om F 2 CD PGEBE 3D Line Column Wind Map Loss Tours Sparklines D X RED G End of year insurance astment year Insurance used Accounts Insurance Expenses Prepaid insurance Debit $6,000 Credit $5,000 MR Machine purchased for 5400.000 at the beginning of the year Please use End of year adjustment - One year depreciation of Useful 10 years Straighting Depreciation 40.000 Accounts Pin and Equipment Depreciation Expense Debit Credit 540,000 $40.000 11 Right before the year end you received a pledge of $350.000 designated to be construction of Women and Infant Center that you are planning to start budget Debt Credit 5350,000 Accounts Predge Recevable Revenue Contributions Journal Entries $350.000 Income Statement Instructions 11 Not-for-Profit Ledger BalanceSheet Template Cash Flow Statement op loot schoo schoo Pivot Tables 0 My Addins Charts Slicet Timeline Tables Line Column WIN Loss Sparklines Map Tours Add-ins Charts Filters 1 Off 150 0 P Assets KILIMINI Expenses Liabilities Net Assets Revenue Pridrun accounts Receivable pedige Receivable mentory Depreciation Accounts Payable interest Wages Payable Mortgage Payable Labor Permanently Restricted 1a Temporary Restricted Usted 3200 5500 40 0 0 0 0 Balan2800 1407 TS 0 3700 4000 1500 75 30 7 1201 (100 20 100 150 15000 35 350 350 nce 224 2.435 15,474 3.590 3,275 5,500 450 100 35 6 40 2.500 3.280 1,185 4.000 2,500 1.500 390 15.355 Instructions Journal Entries Not-for-Profit Ledger Balancesheet Template Income Statement CashFlow Statement Deprec - a TO - Get Add-ins H? Illustrations P Recommended Table Pivot Tables My Add-ins Recommended Charts Tables Add-ins Charts OH fx * ab E X E F G D HAPPY HOSPITAL Balance Sheet As of December 31, 2020 ASSETS LIABILITIES.& NET ASSETS Current Assets Cash Prepaid Insurance Accounts Recievable inventory Pledges Recievable $2,435,000 S224,000 $3,590,000 $3,440,000 $450,000 Liabilities Current liabilities Accounts Payable Wages Payable $2,500,000 $3,280,000 Long-term liabilities Mortgage Payable $1.185,000 Fixed Assets Plant and Equipment $5,500,000 Net Assets Unrestricted Temporarily Restricted Perminantly Restricted $4,416,000 $2,500,000 $1,500,000 TOTAL ASSETS $15,639,000 TOTAL LIABILITIES & NET ASSETS $15,381,000 Instructions Journal Entries Not-for-profit Ledger BalanceSheet Template Et Get Add-ins Illustrations My Add-ins v Cable Recommended Table Pivot Tables Add-ins Tables Save Off ofx 9 4 FB X D E A B C HAPPY HOSPIAL Operating Statement For the Year Ending December 31, 2020 Revenues $390,000 Less Expenses Inventory Interest Insurance Depreciation $106,000 $25,000.00 $35,000.00 $6,000.00 $40,000.00 NET INCOME $496,000 Tables Add-ins toSave Off 2. fo 4 x Statemer HAPPY HOSPITAL Statement of Cash Flows For the Year Ending December 31, 2020 Cash Flows from Operating Activities Net Cash from Operating Activities Net Cash Used for Investing Activities Net Cash from Financing Activities NET INCREASE/DECREASE) IN CASH CASH. BEGINNING OF YEAR CASH, END OF YEAR 3 26 27 able III Listations Pivollable Recommended Pivottables My Add-ins Recommended Charts PivotChart Slicer Timeline . Line Column Wind Loss Link 3D Map " Tours Tables Add-ins Charts Sparklines Filters Links AutoSave On 2. B fx ! ih rin lil M18 f E G H 9 10 A D 2 Asset Cost: 3 Salvage Value: 4 Asset Life: 5 Depreciable Base: 6 7 8 Calculating Straight line and Accelerated Depreciation 9 Year 3 10 Annual Depreciation 11 Accumulated Depreciation 12 13 14 Calculating The Double Declining Balance Depreciation 15 Year 16 Annual Depreciation 17 Accumulated Depreciation 18 19 20 Calculating The Sum of the Years Digits Depreciation 21 Year 2. 22 Annual Depreciation 23 Accumulated Depreciation 24 25 Instructions Journal Entries Not-for-profit Ledger 6 9 10 5 6 8 9 10 Balance Sheet Template Income Statement CashFlow Statement Depreciations RE a 3 ne Insert Draw Page Layout Formulas Data Review View Help U? tu lill- Illustrations Hi Get Add-ins My Add-ins - ommended Table vot Tables Recommended Charts Pivot Chart 3D Map Tours Line Column W La ables Add-ins Charts Sparklines 15 hese are the transactions that took place during Fiscal Year 2020 reate a journal entry and a T-Account entry for each of the following transactions: $400.000,00 worth of MR Machine is purchased with Cash Credit Accounts Plant and Machine Cash Debat $400,000.00 $400,000.00 575,000.00 worth of Inventory is purchased by Cash Credit Accounts Inventory Cash Debat $75,000.00 $75,000 $30.000 Fire Insurance is purchased by Cash for 5 year Credit Accounts Prepaid Insurance Cash Debit 530,000 $30,000 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Template Income Statement Cashflows mp Fall,202 IMRA LAssignment question. Compatibility Mode - Saved Insert Draw Home Page Layout Formulas Data Review View Help Get Add-ins L? alb Illustrations PivotChart le Recommended Table Pivot Tables My Add-ins - Recommended Charts 3D Map Tours Line Column Wind Loss Tables Add-ins Charts Sparklines - XB3 e O, - fx36 5* f G H 4 Wages due to employees that had been previously recorded as a lability are now paid in Cash $200 000 Accounts Debit Credit $200,000.00 Wages Payable 5200,000.00 A patient discharged who used 5100 000 worth of Inventory Debit Accounts Inventory Inventory Expenses Credit $100,000 $100,000 6. mited to insurance in the amount of $400.000 services rendered to pabents Accounts Accounts Recievable Patient Service Revenue Debit $400.000 Credit $400,000 Instructions Journal Entries Not-for-profit Ledger Balance Sheet Template Income Statement CashFlow State 3 OP (2021_MRA LAssignment question. Compatibility Mode - Saved. Formulas Data Review View Help Draw Page Layout ome Insert L? albo ti tali Get Add-ins My Add-ins Illustrations PivotChart ecommended Table Pivot Tables Recommended Charts Charts 3D Map Line Column Wind Loss Sparklines Tours Tables Add-ins * B3 On f G D B 5150 000 cash is received for services previously provided and bled Credit Accounts Cash Accounts Recievable Debit $150 000 $150.000 Cash Al year end annual mortgage payment made by Principle payment $15,000 Interest payment $35.000 Accounts Debi Credit $50,000 Interest payment interest $15.000 $35.000 End of year insurance aument insurance used Credit Accounts Insurance Expenses Prepaid Insurance Debit 56,000 56.000 Instructions Journal Entries Not-for-profit Ledger Balance Sheet Template Income Statement CashFlow State a ll_2021_MRA LAssignment_question. Compatibility Mode - Saved. Home Insert Draw Page Layout Formulas Data Review View Help t PivotChart Slice Et Get Add-ins Recommended Table ustations Recommended My Add-ins - Pivot Tables Charts Tables Add-ins Charts Om F 2 CD PGEBE 3D Line Column Wind Map Loss Tours Sparklines D X RED G End of year insurance astment year Insurance used Accounts Insurance Expenses Prepaid insurance Debit $6,000 Credit $5,000 MR Machine purchased for 5400.000 at the beginning of the year Please use End of year adjustment - One year depreciation of Useful 10 years Straighting Depreciation 40.000 Accounts Pin and Equipment Depreciation Expense Debit Credit 540,000 $40.000 11 Right before the year end you received a pledge of $350.000 designated to be construction of Women and Infant Center that you are planning to start budget Debt Credit 5350,000 Accounts Predge Recevable Revenue Contributions Journal Entries $350.000 Income Statement Instructions 11 Not-for-Profit Ledger BalanceSheet Template Cash Flow Statement op loot schoo schoo Pivot Tables 0 My Addins Charts Slicet Timeline Tables Line Column WIN Loss Sparklines Map Tours Add-ins Charts Filters 1 Off 150 0 P Assets KILIMINI Expenses Liabilities Net Assets Revenue Pridrun accounts Receivable pedige Receivable mentory Depreciation Accounts Payable interest Wages Payable Mortgage Payable Labor Permanently Restricted 1a Temporary Restricted Usted 3200 5500 40 0 0 0 0 Balan2800 1407 TS 0 3700 4000 1500 75 30 7 1201 (100 20 100 150 15000 35 350 350 nce 224 2.435 15,474 3.590 3,275 5,500 450 100 35 6 40 2.500 3.280 1,185 4.000 2,500 1.500 390 15.355 Instructions Journal Entries Not-for-Profit Ledger Balancesheet Template Income Statement CashFlow Statement Deprec - a TO - Get Add-ins H? Illustrations P Recommended Table Pivot Tables My Add-ins Recommended Charts Tables Add-ins Charts OH fx * ab E X E F G D HAPPY HOSPITAL Balance Sheet As of December 31, 2020 ASSETS LIABILITIES.& NET ASSETS Current Assets Cash Prepaid Insurance Accounts Recievable inventory Pledges Recievable $2,435,000 S224,000 $3,590,000 $3,440,000 $450,000 Liabilities Current liabilities Accounts Payable Wages Payable $2,500,000 $3,280,000 Long-term liabilities Mortgage Payable $1.185,000 Fixed Assets Plant and Equipment $5,500,000 Net Assets Unrestricted Temporarily Restricted Perminantly Restricted $4,416,000 $2,500,000 $1,500,000 TOTAL ASSETS $15,639,000 TOTAL LIABILITIES & NET ASSETS $15,381,000 Instructions Journal Entries Not-for-profit Ledger BalanceSheet Template Et Get Add-ins Illustrations My Add-ins v Cable Recommended Table Pivot Tables Add-ins Tables Save Off ofx 9 4 FB X D E A B C HAPPY HOSPIAL Operating Statement For the Year Ending December 31, 2020 Revenues $390,000 Less Expenses Inventory Interest Insurance Depreciation $106,000 $25,000.00 $35,000.00 $6,000.00 $40,000.00 NET INCOME $496,000 Tables Add-ins toSave Off 2. fo 4 x Statemer HAPPY HOSPITAL Statement of Cash Flows For the Year Ending December 31, 2020 Cash Flows from Operating Activities Net Cash from Operating Activities Net Cash Used for Investing Activities Net Cash from Financing Activities NET INCREASE/DECREASE) IN CASH CASH. BEGINNING OF YEAR CASH, END OF YEAR 3 26 27 able III Listations Pivollable Recommended Pivottables My Add-ins Recommended Charts PivotChart Slicer Timeline . Line Column Wind Loss Link 3D Map " Tours Tables Add-ins Charts Sparklines Filters Links AutoSave On 2. B fx ! ih rin lil M18 f E G H 9 10 A D 2 Asset Cost: 3 Salvage Value: 4 Asset Life: 5 Depreciable Base: 6 7 8 Calculating Straight line and Accelerated Depreciation 9 Year 3 10 Annual Depreciation 11 Accumulated Depreciation 12 13 14 Calculating The Double Declining Balance Depreciation 15 Year 16 Annual Depreciation 17 Accumulated Depreciation 18 19 20 Calculating The Sum of the Years Digits Depreciation 21 Year 2. 22 Annual Depreciation 23 Accumulated Depreciation 24 25 Instructions Journal Entries Not-for-profit Ledger 6 9 10 5 6 8 9 10 Balance Sheet Template Income Statement CashFlow Statement Depreciations RE a 3