Question

In: Finance

Sales                                         &nbs

Sales                                           153,000

Costs                                            81,900

Other Expenses                        5,200

Depreciation                           10,900

Interest Expense                      8,400

Taxes                                            16,330

Dividends                                    7,200

New Equity                                 2,600

Redeemed LT Debt                 3,900

What is the operating cash flow?

What is the cash flow to creditors?

What is the cash flow to stockholders?

If net fixed assets increased by $20,250 during the year, what was the addition to NWC?

Solutions

Expert Solution

a. The operating cash flow is computed by using the below formula:

= EBIT - taxes + Depreciation
The Income Statement is presented as follows:

EBIT is computed as follows:

= Sales - Costs - Other Expenses - Depreciation

= $153,000 - $ 81,900 - $ 5,200 - $ 10,900

= $ 55,000
So the operating cash flow will be

= $ 55,000 - $ 16,330 + $ 10,900

= $ 49,570

b. The cash flow to creditors is computed as shown below:

Cash flow to creditors = Interest paid – Net new borrowing
Cash flow to creditors = $ 8,400 – (–$ 3,900)
Cash flow to creditors = $ 12,300

c. Cash flow to stockholders is computed as follows:

Cash flow to stockholders = Dividends paid – Net new equity
Cash flow to stockholders = $ 7,200 – $ 2,600
Cash flow to stockholders = $ 4,600

d. The addition to NWC is computed as follows:

Cash flow from assets is computed by using the below formula:

= Cash flow to creditors + Cash flow to stockholders
= $ 12,300 + $ 4,600
Cash flow from assets = $ 16,900

Net capital spending is computed by using the below formula:

= Depreciation + Increase in fixed assets
= $ 10,900 + $ 20,250
= $ 31,150

We will use the below mentioned equation in order to find the change in net working capital

Cash flow from assets = OCF – Change in NWC – Net capital spending
$ 16,900 = $ 49,570 – Change in NWC – $ 31,150
Change in NWC = $ 1,520

Feel free to ask in case of any query relating to this question


Related Solutions

Complete below. Sales                                      &nbs
Complete below. Sales                                           153,000 Costs                                          81,900 Other Expenses                        5,200 Depreciation                         10,900 Interest Expense                      8,400 Taxes                                          16,330 Dividends                                    7,200 New Equity                                 2,600 Redeemed LT Debt                 3,900 What is the operating cash flow? What is the cash flow to creditors? What is the cash flow to stockholders? If net fixed assets increased by $20,250 during the year, what was the addition to NWC?
Varney Company makes rolling suitcases. Its sales budget for four months is: Sales Month                           &nbs
Varney Company makes rolling suitcases. Its sales budget for four months is: Sales Month                                                                  R March                                                              15,000 April                                                                20,000 May                                                                40,000 June                                                               60,000 Varney's policy is that ending inventory of finished suitcases should equal 30% of the next month's sales. Beginning inventory (March 1) is 5,300 suitcases. Each suitcase required 1.5 meters of ballistic nylon. The ending inventory policy for nylon is that 20% of the following month's production needs must be on hand. On March 1, Varney had 10,450...
Jane Company expects the following sales in the next few months:                         Month      &nbs
Jane Company expects the following sales in the next few months:                         Month                         Units               Selling Price                         July                              50,000             $ 8.10                         August                        80,000             $ 8.10                         September                   40,000             $ 8.60                         October                       30,000             $ 8.60 Jane expects to collect 60 % of sales in the month of sale, 30 % in the following month, 5 % in the next month, with 5 % remaining uncollected. Prepare a schedule of cash receipts for September and October.
BALANCE SHEET & IS ITEMS 2017      2018          (thousands of US dollars) Sales                &nbs
BALANCE SHEET & IS ITEMS 2017      2018          (thousands of US dollars) Sales                         4,166       4,490 (NOTE: the firm Cash                          2,150       2,198   plans on a 34% Interest (expense)              274         316   marginal corp. Other Expenses                  340         280   tax rate for Inventory                     5,060       5,200   all revenues) Net Fixed Assets             18,030      18,460                   Depreciation                    590         590                Cost of Goods Sold            1,410       1,602 SE(includes paid-in surplus) ?????       ????? Retained Earnings            11,256      11,128 (ALSO:30,000 CBC Accounts Payable              2,258       2,190   common equity    Short-Term Notes Payable        416         390   shares (10%...
Beginning inventory, purchases, and sales data for product A are as follows: Sept 1                        Inventory    &nbs
Beginning inventory, purchases, and sales data for product A are as follows: Sept 1                        Inventory      240 units at $70 Sept 10                      Sale                180 units Sept 15                      Purchase       280 units at $72 Sept 20                      Sale                220 units Sept 24                      Sale                90 units Sept 30                      Purchase       300 units at $75 Determine the number of units sold and the cost of units sold AND the quantity remaining in ending inventory and the cost of ending inventory. All units were sold...
Company X has the following income statement for the month ending September. Sales                            &nbs
Company X has the following income statement for the month ending September. Sales                                                                42,000 Cost of Goods Sold:                                           Beginning Inventory                                         6,000 Purchases                                                        37,800 Cost of Goods Available for sale                    43,800 Less: Ending Inventory                                  (14,400) Cost of Goods Sold                                        29,400              Gross Profit                                                    12,600 Operating Expenses                                        10,500 Operating Profit                                              2,100 Sales are made on credit and collected as follows: 60 per cent in the month after the sale is made and 35 per cent in the second month after the sale Purchases and Operating Expenses are paid as follows: 80 per...
      TASK                                    &nbs
      TASK                                                            1. Choose any Omani organization and write briefly about its corporate social responsibility activities or strategies.(400-500 words). If you are part of the decision making body of this organization, what type of new activity (towards social responsibility) you would like to add?            (5+5=10 Marks) 2. Compare between Omnipotent view of management and symbolic view of management.                                                                        3. Describe workplace spirituality. Identify its characteristics of a spiritual organization and its benefits.                                                                                                                          (1+2+2=5 Marks) 4. Explain workers compensation. How to...
Year                          A               &nbs
Year                          A                            B                                 0                              -8,000                    -8,000                                  1                              4,500                     1,900                                 2                              4,200                     3,000                                3                              1,800                     4,000                                 4                              1,600                     5,000 Which project would you select if you used the payback, NPV and IRR methods using a 15% discount rate and why?
Year                          A               &nbs
Year                          A                          B                 0                              -75,000                  -75,000                 1                              40,000                 10,000                 2                              27,000                 15,200                 3                              20,000                 67,967 By how much should the cost of capital (discount rate) for the losing project (based on NPV) be increased or decreased in order for it to be selected over the winning project (based on NPV)?
Name:                                         &nbs
Name:                                                                                                          . A manager of a local clothing retail store wants to make a sales and promotion plan for next month. In order to evaluate the effectiveness of the plan, the manager identifies all the costs and other relevant information and conducts Break-even analysis. Here are the identified costs and other related information. Monthly rent fees: $2,500 Wages for the hired employees (Monthly): $6,000 Utility fees (Monthly): $700 Other operation costs (Monthly): $1,000 Purchase price per unit: $78   (The manager...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT