Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with the cash flow statement. Please show me what to do. Please show all work. Assets Expenses Soen 2 3. Cach $
I need help with the cash flow statement. Please show me what to do. Please show all work.
Assets Expenses Soen 2 3. Cach $ 400,000 4 Prepaid Insurance $ 25,000 5 Accounts Receivable $ 600,000 6 Inventory $ 125,000 7 Plant & Equipment $ 250,000 9 Inventory $ 2,500 10 Labor $ 5,000 11 Interest $ 4.500 12 Insurance $ 5,000 13 Depreciation $ 25,000 15 Accounts Payable $ 350,000 16 Wages Payable $ 50,000 17 Mortgage Poyable 450,000 19 Unrestricted $ 350,000 20 Temporarily Restricted $ 150,000 21 Permanently Restricted 50,000 23 Patient Service Revenue $ 30,000 24 Revenue contributions donatione $ 15,000 25 Revenues non-patient cervicali che parking skal 5.000 26 27 1. Complete the Journal Entries and Corresponding Toccount 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 of December 31 2017 by 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 methods 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 2017 31 by utilizing the income Statement Template 32 Hist: Is your income statencat ese the numbers from your Double Declining Balance Depreciation 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 Statencat 35 36 Net Assets Revenge 1 1- Complete the Journal Entries and Corresponding T account records that are provided to you in "Journal Entries" woksheet 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 by 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 methods of 0 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 2017 by utilizing the Income Statement Template 32 Hint: In your income statement use the numbers from your Double Declining Balance Depreciation 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 utilizing the 33 Statement of the Cash Flow Template 34 Hint: Please use the direct method for your Cash Flow Statement 35 36 Student Info Instructions Journal Entries Not-for-Profit Ledger Balance Sheet T Ready X D E G H KL M N 0 PG IR T U A Pregadrana Acour Recova opeles KO cng Accounts Payude Mortgage Payed Cash Amanery Recled 8 turare 8 Decreion 18 y Restricted Urrestricted Labor Share Shertory ginning Balance Revenue $4.00 25 0095 1250 50 10 0 1350 $450 1350 05 12 ol 3 12 13 05 IM 15 55 ol 16 $100 100 17 $100 NI GE 145 BA -10 12 12 Sing Balance 1287 51204 152 3534 5301 10 35 12 134 544 1440 1350 11,464 $350 $150 350 $100 Student Info instructions Journal Entries Not-for-Profit Ledger Balance Sheet Template Inco Arial 14 AA Wrap Text Ge llllll Paste BIU a-A- lili E Merge & Center $ Clipboard Font Alignment FB fx ab E AutoSave Oft EX L19 fo B E 1 2 Happy HOSPITAL Balance Sheet As of December 31, 2017 3 4 5 ASSETS 6 7 Current Assets 8 Cash 9 Prepaid Insurance 10 Accounts Receivable 11 Inventory $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 13 14 15 Fixed Assets 16 Plant & Equipment $301,000 Net Assets Unrestricted Temporarily Restricted Permanently Restricted Total Net Assets 7 $373,000 $150,000 $50,000 $573,000 18 19 20 21 TOTAL ASSETS 22 $1,407,000 TOTAL LIABILITIES & NET ASSETS $1,407,000 23 24 Student Info Instructions Journal Entries Not-for-profit Ledger BalanceShee Ready 0O Clipboard Font Alignment utoSave Off E2B fx et BB fx @abe E 011 A B 2 Operating Statement 3 For the Year Ending December 31, 2017 4 5 Revenues 6 Less Expenses 7 Inventory $100,000 $77,000 8 Intrest $5,000 $35,000 $3,000 $34,000 9 Insurance 10 Depreciation 11 NET INCOME $23,000 12 13 14 4 Instructions Journal Entries Not-for-Profit Ledger Balance Sheet Read F11 B D 1 A NAME OF YOUR HOSPITAL Statement of Cash Flows For the Year Ending December 31, 2016 2 3 4 5 Cash Flows from Operating Activities 6 7 8 9 10 11 Net Cash from Operating Activities 12 13 Cash Flows from Investing Activities 15 Net Cash Used for Investing Activities 16 17 18 19 Net Cash from Financing Activities 20 21 NET INCREASE/(DECREASE) IN CASH 22 CASH, BEGINNING OF YEAR 23 CASH, END OF YEAR 24 Not-for-Profit Ledger Balance Sheet Template Income Staten Read 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