Question: For the given income statement, retained earning statement, and balance sheets, calculate the sources/uses of funds and fill in the entries in the cash flow




For the given income statement, retained earning statement, and balance sheets, calculate the sources/uses of funds and fill in the entries in the cash flow statement below. 2018 Income Statement $(000) Revenue 3000 Warranty/ Bad Debt 40 Net Revenue 2960 COGS 1480 Contribution Margin 1480 SG&A (incl depreciation) 1200 Operating Income 280 Other Income 40 Net Income 320 2018 Retained Earnings Statement $(000) Retained Earnings, start of year 1400 Net Earnings for the year 320 Less: Dividend Paid 100 Retained Earnings, end of year 1620 Notes: 1. Calculate the required quantities to answer each of the blanks. 2. Express your quantities in your answer in thousands ($000). 3. Please answer all the blanks and type in "0" where you think there is no actual value. Balance Sheet $(000) End 2017 End 2018 Current Assets: Cash 100 Receivables Inventory Prepaid Expenses Fixed Assets: Fixed Assets at Cost Less Acc. Depreciation Goodwill & Intangibles Total Assets Current Liabilities: S.T. Credit Line Accounts Payable Accrued Expenses Cur. Por. of L.T. Debt 240 100 20 460 4000 800 3200 0 3660 20 100 20 100 240 80 200 180 20 480 4600 900 3700 0 4180 40 80 20 100 240 source of funds use of funds E Long Term Liabilities: Long Term Debt Shareholders Equity: 820 Capital Shares 1200 Retained Earnings Tot. Liab. and Eq. Sources/Uses of funds 1400 3660 720 1600 1620 4180 Statement of Cash Flow $(000) Operating Activities: Net Earnings for the Year Depreciation Changes in NCWC Subtotal: Investing Activities: Additions to Fixed Assets Additions to Goodwill and Intangibles Subtotal: 2018 Financing Activities: Dividends Net New Long Term Borrowings Net New Capital Shares Subtotal: Total Funds Flow Net cash on hand, start of year Net cash on hand, end of year Change in Cash Position: For the given income statement, retained earning statement, and balance sheets, calculate the sources/uses of funds and fill in the entries in the cash flow statement below. 2018 Income Statement $(000) Revenue 3000 Warranty/ Bad Debt 40 Net Revenue 2960 COGS 1480 Contribution Margin 1480 SG&A (incl depreciation) 1200 Operating Income 280 Other Income 40 Net Income 320 2018 Retained Earnings Statement $(000) Retained Earnings, start of year 1400 Net Earnings for the year 320 Less: Dividend Paid 100 Retained Earnings, end of year 1620 Notes: 1. Calculate the required quantities to answer each of the blanks. 2. Express your quantities in your answer in thousands ($000). 3. Please answer all the blanks and type in "0" where you think there is no actual value. Balance Sheet $(000) End 2017 End 2018 Current Assets: Cash 100 Receivables Inventory Prepaid Expenses Fixed Assets: Fixed Assets at Cost Less Acc. Depreciation Goodwill & Intangibles Total Assets Current Liabilities: S.T. Credit Line Accounts Payable Accrued Expenses Cur. Por. of L.T. Debt 240 100 20 460 4000 800 3200 0 3660 20 100 20 100 240 80 200 180 20 480 4600 900 3700 0 4180 40 80 20 100 240 source of funds use of funds E Long Term Liabilities: Long Term Debt Shareholders Equity: 820 Capital Shares 1200 Retained Earnings Tot. Liab. and Eq. Sources/Uses of funds 1400 3660 720 1600 1620 4180 Statement of Cash Flow $(000) Operating Activities: Net Earnings for the Year Depreciation Changes in NCWC Subtotal: Investing Activities: Additions to Fixed Assets Additions to Goodwill and Intangibles Subtotal: 2018 Financing Activities: Dividends Net New Long Term Borrowings Net New Capital Shares Subtotal: Total Funds Flow Net cash on hand, start of year Net cash on hand, end of year Change in Cash Position
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
