Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with my statement of cash flowsheet. I feel like I am not doing it correctly. I don't know where I'm going wrong.
I need help with my statement of cash flowsheet. I feel like I am not doing it correctly. I don't know where I'm going wrong. Please help and show work and explain why.
What is not visible?
Assets NO Expenses ST Liabilities + Net Assets Revenue Prepad Insurance Account Recovacie Part & Equipment KA Depreciation all opowily Restricted 18 Accounts Payable can Permanent Restricted Morto Payable 8 tourance 8 verest Unrestricted 13 Wagas Payable 8 Lacor Revenue ning Balance 14.00 125 1600 30 3450 135.0 150 05 18 2 130 ol 1 33 14 ol 9 100 1100 7 1100 -1100 8 10 3 10 574 - $10 2 5 - 12 Balance 1281 552 $534 $173 $301 $5 $0 $35 13 134 OSCS 44 $440 $350 $150 550 $100 4 Not-for-Profit Ledger BalanceSheet Template Income Statement Cashflow Statement depr File Home Insert Draw Page Layout Formulas Data Review View Help X 14 lil General Paste $ 9 Arial - A 2 Wrap Text BIU a A. Merge & Center - Font Alignment 2- B fx e a EX Clipboard NE AutoSave Off L19 B D 1 Happy HOSPITAL Balance Sheet As of December 31, 2017 2 3 4 5 ASSETS 6 7 Current Assets 8 Cash 9 Prepaid Insurance 10 Accounts Receivable 11 Inventory 12 $287,000 $52,000 $594.000 $173,000 LIABILITIES & NET ASSETS Liabilities Current liabilities Accounts Payable Wages Payable Long-term liabilities Mortgage Payable Total Liabilities $350,000 $44,000 $440,000 $834,000 $301,000 14 15 Fixed Assets 16 Plant & Equipment 17 18 19 20 21 TOTAL ASSETS 22 23 Net Assets Unrestricted Temporarily Restricted Permanently Restricted Total Net Assets $373,000 $150.000 $50,000 $573,000 $1,407,000 TOTAL LIABILITIES & NET ASSETS $1,407,000 Not-for-Profit Ledger Balance Sheet Template Income Statement CashFlow Staten Ready F ORE a 3 E File Home Insert Draw Page Layout Formulas Data Review View X Arial 10 - AM Paste BIU HA 28 Wrap Text Merge & Center Clipboard AutoSave Font Alignment 2D fx B VG ab Ee Ex OH 013 X > fax B D 2 E 3 Cash 4 400,000 Prepaid Insurance 5 $ 25,000 Accounts Receivable $ 600,000 Inventory $ 7 125,000 Plant & Equipment 250,000 9 Inventory $ 2,500 10 Labor $ 5,000 Interest $ 4,500 12 & Insurance $ 5,000 13 Depreciation $ 25,000 15 Accounts Payable $ 350,000 16 Wages Payable 50,000 17 Mortgage Payable $ 450.000 19 Unrestricted S 350,000 20 Temporarily Restricted S 150.000 21 Permanently Restricted $ 50,000 23 Patient Service Revenue $ 30,000 24 Revenue - contributions donations $ 15,000 25 Revenue-non-patient services (gift shop, parking etc. S 5.000 26 27 1. Complete the Journal Entries and Corresponding T account records that are provided to you in "Journal Entri Instructions Journal Entries Not-for-profit Ledger BalanceSheet Template Ready O Sias Liabilities 25 Revenue-non-patient services (gift shop, parking etc.) 5,000 26 27 1- Complete the Journal Entries and Corresponding T account records that are provided to you in "Journal Entries woksheet 28 2-By using the Information provided to you fill out Not-for-Profit Ledger including the beginning and ending balances 3- By using the information provided to you and information that you generated in the ledger, prepare your balancesheet as of December 31 2017 29 utilizing the Balance Sheet Template 4- By using the information provided to you and the information that you generated calculate your depreciation expense by using 3 different metho 30 of depreciation methods - Use the Depreciation template provided to you 5- By using the information provided to you and information that you generated in the ledger, prepare your Income Statement as of December 31 31 by utilizing the Income Statement Template 32 Hint: In your income statement use the numbers from your Double Declining Balance Dep:ciation calculation 6- By using the information provided to you and information that you generated, prepare your Cash Flow statement as of December 31 2017 by 33 utilizing the Statement of the Cash Flow Template 34 Hint: Please use the direct method for your Cash Flow Statement 35 36 37 4 Instructions Journal Entries Not-for-Profit Ledger BalanceSheet Template Income Statement Ready Chop Clipboard Font Alignment AutoSave Off 2 fx st D105 X fx 34000 B D E F 1 Journal Entries 2 These are the transactions that took place during Fiscal Year 2017 3 Create a journal entry and a T-Account entry for each of the following transactions: 4 5 1.550,000 worth of medical inventories purchased by check 6 Credit 7 8 9 Accounts Inventory Cash Debit $50,000 $50,000 10 11 12 2. A ten-year fire insurance policy was purchased from the insurance company for $30,000. 13 14 15 Accounts Debit Credit 16 Prepaid Insurance $30,000 17 Cash $30,000 18 19 20 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Templa Read Paste BIU a.A- Til IMI IMI Merge & Center Clipboard Font Alignment AutoSave Ott - fx B 8 H29 fx A B D E F Debit 22 23 24 25 26 27 28 Accounts Inventory Accounts Receivable Credit $3,000 $3,000 Pa 29 4. Puchased a new CT image machine for $ 80,000 and paid $ 5,000 for transportation 30 31 32 Accounts Debit Credit 33 Plant and Equipment $85,000 34 Cash $85,000 35 36 37 38 5. Patient discharged who used $5,000 of inventory. 39 40 41 Accounts Debit Credit DA Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Templa Ready 1 -- - - Clipboard Font Alignment AutoSave OM BB fx H29 X fx G B D E F 37 38 5. Patient discharged who used $5,000 of inventory. 39 40 41 Accounts Debit Credit 42 Inventory $5,000 43 Inventory Expense $5,000 44 45 46 47 6. Bills are submitted to insurance companies in the amount of $100,000 for services 48 rendered to patients: 49 50 51 Accounts Debit Credit 52 Account Receivable $100,000 53 Patient Service Revenue $100,000 54 55 56 4 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Temp Ready Clipboard Font Alignment AutoSave Ott O fx B 6abc E H29 fx A B D E G 56 7.Cash payments of $100,000 are received for services previously provided and billed: 57 58 59 60 Accounts Debit Credit 61 Accounts Receivable $100,000 62 Cash $100,000 63 64 65 66 67 8. The seller paid $3,000 for defected medical inventories 68 69 70 Accounts Debit Credit 71 Accounts Receivable $3,000 72 Cash $3,000 73 74 75 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Templa Read O SE c D G 68 Accou Debit 70 71 72 Accounts Accounts Receivable Cash Credit $3,000 $3,000 73 74 75 3. Wages due to employees that had been previously recorded as a liability are now paid 76 in cach in the amount of $6,000 77 78 79 Accounts Debit Credit 80 Wages Payable $6,000 81 Cash $6.000 Wages $6,000 Page 10. At year of end annual Mortgage payment made $10,000 principle, $35,000 interest 85 Cash 87 Debit Accounts Cash Instrest Expande Mortgage Payable Credit $45,000 $35.000 $10,000 91 11. End of year adjustment - One year insurance used: Prepaid Insur Debit 96 Accounts Propold Insurance Ice Expo Credit $3,000 97 $3,000 101 4 Instructions Journal Entries Not-for-Profit L Read o Et a 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