Question

Question 1 The income statement and additional data of Bayleaf Travel Products Pty Ltd are as...

Question 1

The income statement and additional data of Bayleaf Travel Products Pty Ltd are as follows:

Income statement for the year ended 31 December 2016

Revenue:                                                                  R231 300

Service revenue                   R225 000

Dividend revenue                R6 300                     

Expenses:                                                                            R184 700

Cost of goods sold               R100 000

Salary expense                    R52 000

Depreciation expense         R23 000

Advertising expense           R2 300

Interest expense                  R2 400

Income tax expense                        R5 000

Net income                                                                           R46 600

Additional data

- Acquisition of PPE was R170 000. Of this amount, R140 000 was paid in cash and R30 000 by signing a note payable.

- Proceeds from sale of land totaled R48 000.

- Proceeds from issuance of shares totaled R31 000.

- Payment of long-term note payable was R16 000.

- Payment of dividends was R10 000

From the balance sheet:

Balance sheet as at 31 December

                                          2016

                  2015

Current assets

Cash

R32 000

R13 300

Accounts receivable

R41 000

R57 000

Inventory

R48 000

R87 000

Prepaid expenses

R9 100

R8 200

Current liabilities

Accounts payable

R32 000

R17 000

Accrued liabilities

R14 000

R43 000

Requirements

a) Prepare Bayleaf’s statement of cash flow for the year ended 31 December 2016, using the indirect method.

b) Evaluate Bayleaf’s cash flows for the year ended 31 December 2016, including its free cash flow and cash realisation ratio. In your evaluation, review all three categories of cash flows and give the reason for your evaluation

c) When analysing the cash flow patterns of a company, what other three important indicators of the health of a company’s cash flows do you look at?

Homework Answers

Answer #1
Cash Flow Statement of Bay Leaf - Indirect Method
Profit after Tax       46,600
Add: Provision for Tax         5,000
Add Non Cash/\non operating expenses
Depreciation Expense       23,000
Interest Expense         2,400
Less Non Cash/Non Operating Income
Dividend Revenue       (6,300)
Net Cash Operating Profit      70,700
Changes in Working Capital
Decrease in Accounts receivable       16,000
Decrease in Inventory       39,000
Increase in Prepaid Expenses          (900)
Increase in Accounts Payable       15,000
Decrease in Accrued Liablities      (40,000)
     29,100
Net Cash Flow from Operating Activity      99,800
Dividends Received         6,300
Proceeds from Sale of Land       48,000
Acquisation of PPE    (170,000)
Net Cash flow from Investing Activity (115,700)
Proceeds from Issuance of Shares       31,000
Dividend Payment      (10,000)
Interest expense       (2,400)
Net cash flow for Notes Payable       16,000
Net Cash flow from Financing Activity      34,600
Total Cash flows       18,700
Add : Opening Cash flow       13,300
Net Closing Cash      32,000
Closing Cash and Cash Equivalents      32,000

B)

During the year Net Cash flows from Operating activity - R 70,700

During the year Net Cash flows from Investing activity - (R 115,700)

During the year Net Cash flows from Financing activity - R 34,600

There was investments during the year, also all funds from financing are not fully utilised

C) Other Three Important indicators are

Debt Equity Ratio

Interest Coverage Ratio

Capital Gearing Ratio

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities)...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANY Income Statement For Year Ended December 31, 2017 Sales revenue $142,200 Expenses Cost of goods sold 57,000 Depreciation expense 19,500 Salaries expense 33,000 Rent expense 10,500 Insurance expense 5,300 Interest expense 5,100 Utilities expense 4,300 Net income $7,500    LANSING COMPANY Selected Balance Sheet Accounts At December 31 2017 2016 Accounts receivable $7,100 $8,800 Inventory...
Randolph Ltd has a tax expense of £77,000 in the Income Statement for the year ended...
Randolph Ltd has a tax expense of £77,000 in the Income Statement for the year ended 31 December 2019. In the Statement of Financial Position, tax payable was £70,000 for the year ended 31 December 2018 and £79,800 for the year ended 31 December 2019. What amount will appear as tax paid in the Statement of cash flows for the year ended 31 December 2019? a. £79,800 b. £77,000 c. £70,000 d. £67,200
The financial statements of Simon Co. include the following items (amounts in thousands): Income Statement For...
The financial statements of Simon Co. include the following items (amounts in thousands): Income Statement For the Year Ended December 31, 2017 Net income $ 473 Depreciation and amortization expense 336 At December 31 Balance Sheets 2017 2016 Accounts receivable $ 143 $ 186 Inventory 163 135 Accounts payable 33 136 Income taxes payable 73 31 Required: a. Calculate the net cash flow provided (used) by operations for Simon Co. for the year ended December 31, 2017. (Enter your answer...
Sheridan Company’s income statement contained the condensed information below. Sheridan Company Income Statement For the Year...
Sheridan Company’s income statement contained the condensed information below. Sheridan Company Income Statement For the Year Ended December 31, 2022 Service revenue $582,000 Operating expenses, excluding depreciation $368,400 Depreciation expense 33,000 Loss on disposal of plant assets 9,600 411,000 Income before income taxes 171,000 Income tax expense 33,600 Net income $137,400 Sheridan Company’s balance sheets contained the following comparative data at December 31. 2022 2021 Accounts receivable $42,000 $36,000 Accounts payable 24,600 19,200 Income taxes payable 7,800 4,200 Accounts payable...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and 2017are shown. Terry Company                                                                    Income Statement        For the year Ended December 31, 2017    Sales                                                 $ 390,000    Cost of Goods Sold                            235,000                                                                                _______      Gross Profit                                                        $ 155,000    Wages Expenses                              $ 63,000    Depreciation Expense                        14,000    Other Operating Expenses                  26,000    Income Tax Expense                           17,000    120,000                                                                                 ______    ________      Net Income                                                          $ 35,000                                                  ...
The income statement and selected balance sheet information for Direct Products Company for the year ended...
The income statement and selected balance sheet information for Direct Products Company for the year ended December 31 are presented below. Income Statement   Sales Revenue $ 45,600   Expenses:        Cost of Goods Sold 19,500        Depreciation Expense 1,700        Salaries and Wages Expense 8,700        Rent Expense 4,200        Insurance Expense 1,750        Interest Expense 1,650        Utilities Expense 1,250   Net Income $ 6,850 Selected Balance Sheet Accounts Ending Balances Beginning Balances   Accounts Receivable $ 575     $ 610       Inventory 860     705       Accounts Payable...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year Ended December 31 Sales $ 2,465,000 Cost of goods sold 1,207,850 Gross profit 1,257,150 Operating expenses Salaries expense $ 337,705 Depreciation expense 59,160 Rent expense 66,555 Amortization expenses—Patents 7,395 Utilities expense 27,115 497,930 759,220 Gain on sale of equipment 9,860 Net income $ 769,080 Accounts receivable $ 22,550 increase Accounts payable $ 12,275 decrease Inventory 29,750 increase Salaries payable 2,200 decrease Prepare the operating...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 133,200 Expenses Cost of goods sold 54,000 Depreciation expense 18,000 Salaries expense 30,000 Rent expense 10,200 Insurance expense 5,000 Interest expense 4,800 Utilities expense 4,000 Net income $ 7,200    LANSING COMPANY Selected Balance Sheet Accounts At December 31 Current Year Prior Year Accounts receivable $ 6,800...
The condensed financial data of Freshest Farmers Ltd follow. FRESHEST FARMERS LTD Statement of financial position...
The condensed financial data of Freshest Farmers Ltd follow. FRESHEST FARMERS LTD Statement of financial position as at 31 March 2016 2016 2015 Assets Cash $147 000 $57 600 Accounts receivable 136 200 49 500 Inventories 168 750 154 275 Prepaid expenses 27 600 24 000 Investments 162 000 141 000 Plant and machinery 405 000 363 750 Accumulated depreciation   (75 000)   (78 000)) Total $971 550 $712 125 Liabilities and equity Accounts payable $138 000 $100 950 Accrued expenses...
Using the data for Gronk, Inc. provided below prepare a Statement of Cash Flows for fiscal...
Using the data for Gronk, Inc. provided below prepare a Statement of Cash Flows for fiscal year 2016 in proper format. Gronk, Inc List of Items for Statement of Cash Flows Statement December 31, 2016 (thousands of dollars) Cash and Cash Equivalents, January 1, 2016         66,200 Cash and Cash Equivalents, December 31, 2016                -   increase in accrued expenses           2,300 decrease in prepaid expenses             960 increase in inventories         21,350 decrease in income taxes payable           3,500...