Question

In: Finance

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?

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

jeff jeffy answered 5 days ago

Complete the horizontal analysis below: Year 2 &nbs

Complete the horizontal analysis below: Year 2 Year 1 Amount Change Percentage Change $88, 338 $92,147 ??? ??? A. ($3,809), 4.1% B. $3,809, 4.1% C. $180,485, 51.1% D. $8,300, 15% E. None of these

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?

Complete the following table: Ppm Grams &nbs

Complete the following table: Ppm Grams Air Volume (l) Mol. Wt. (g) _______ 0.02542 75 339 2 0.00228 300 _____ 1000 7.164 _____ 146 0.002 _____ 2650 254

Complete the following balance sheet using the information: &nbs

Complete the following balance sheet using the information: Cash Accounts Receivables Inventory ________ Current Assets _________ Net Fixed Assets $1,000,000 _________ Total $1,300,000 ========= Current Ratio = 3.0 Inventory Turnover = 10.0 Debt Ratio = 30% Accounts Payables $100,000 Long-term Debt Total Liabilities Common Equity ________ Total $1,300,000 ========= Total Asset Turnover = 0.5 Average Collection Period = 45 days Gross Profit Margin = 30%

Worksheet complete through the Trial Balance. March Journal Entries 1-Mar Accounts Receivable 3450 Sales Revenue &nbs

Worksheet complete through the Trial Balance. March Journal Entries 1-Mar Accounts Receivable 3450 Sales Revenue 3,450 Cost of Goods Sold 1450 Inventory 1,450 3-Mar Inventory 2800 Accounts Payable 2,800 15-Mar Accounts Receivable 3750 Sales Revenue 3,750 Cost of Goods Sold 1950 Inventory 1,950 20-Mar Inventory 2000 Accounts Payable 2,000 24-Mar Accounts Receivable 4900 Sales Revenue 4,900 Cost of Goods Sold 2600 Inventory 2,600 #NAME? PARTIALLY ADJUSTED TRIAL BALANCE March 31 2018...

You are given the table below which contains sales figures for three industries. Firm Industry1 Industry2 &nbs

You are given the table below which contains sales figures for three industries. Firm Industry1 Industry2 Industry3 A $450 $800 $200 B $200 $50 $200 C $150 $25 $200 D $100 $25 $200 E $50 $20 $200 All Others 5X$10 2X$40 $0 Figures in millions of current dollars. Note that, 5X$10 in all others category for Industry 1 means 5 firms each having 10 (millions of) dollars sales figures. All others category in Industry2 should be similarly interpreted a) Compute...

. Which of the following is NOT CORRECT about a randomized complete block experiment? (a) &nbs

. Which of the following is NOT CORRECT about a randomized complete block experiment? (a) Every block is randomized separately from every other block. (b) Every treatment must appear at least once in every block. (c) Blocking is used to remove the effects of another factor (not of interest) from the comparison of levels of the primary factor. (d) The ANOVA table will have another line in it for the contribution to the variability from blocks. (e) Blocks should contain ...

Use the following information to answer the questions below. NUT &nbs

Use the following information to answer the questions below. NUT 250 Exports 500 Net increase in foreign ownership of U.S.based nonreserve assets 400 Net increase in U.S. government’s foreign assets 30 Net increase in U.S. private assets 250 Investment income received in the U.S. 200 Net increase in U.S. ownership of official reserve assets 20 Imports 600 Net increase in foreign ownership of U.S. reserve assets 100 Investment income paid abroad by the U.S. 300 What is the current account...

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.