Question

In: Accounting

Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as...

Use the balance sheet and income statement below :
CLANCY’S DOG BISCUIT CORPORATION
Balance Sheet as of December 31, 2015 and 2014
(in millions of dollars)
  Assets 2015 2014   Liabilities and Equity 2015 2014
  Current assets:   Current liabilities:
      Cash and marketable securities $ 8 $ 8       Accrued wages and taxes $ 13 $ 7
      Accounts receivable 38 30       Accounts payable 27 25
      Inventory 41 35       Notes payable 25 23
          Total $ 87 $ 73           Total $ 65 $ 55
  Fixed assets:   Long-term debt: $ 48 $ 43
      Gross plant and equipment $ 111 $ 90   Stockholders’ equity:
      Less: Depreciation 31 25       Preferred stock (2 million shares) $ 2 $ 2
      Common stock and paid-in surplus
      Net plant and equipment $ 80 $ 65           (5 million shares) 11 11
      Other long-term assets 28 28   Retained earnings 69 55
          Total $ 108 $ 93           Total $ 82 $ 68
  Total assets $ 195 $ 166   Total liabilities and equity $ 195 $ 166
CLANCY’S DOG BISCUIT CORPORATION
Income Statement for Years Ending December 31, 2015 and 2014
(in millions of dollars)
2015 2014
  Net sales $ 108 $ 112
  Less: Cost of goods sold 54 50
  Gross profits $ 54 $ 62
  Less: Other operating expenses 8 7
  Earnings before interest, taxes depreciation,
  and amortization (EBITDA)
$ 46 $ 55
  Less: Depreciation 6 6
  Earnings before interest and taxes (EBIT) $ 40 $ 49
  Less: Interest 6 6
  Earnings before taxes (EBT) $ 34 $ 43
  Less: Taxes 16 19
  Net income $ 18 $ 24
  Less: Preferred stock dividends $ 1 $ 1
  Net income available to common stockholders $ 17 $ 23
  Less: Common stock dividends 3 3
  Addition to retained earnings $ 14 $ 20
  Per (common) share data:
     Earnings per share (EPS) $ 3.40 $ 4.60
     Dividends per share (DPS) $ 0.60 $ 0.60
     Book value per share (BVPS) $ 16.00 $ 13.20
     Market value (price) per share (MVPS) $ 16.65 $ 16.60

Prepare a statement of cash flows for Clancy’s Dog Biscuit Corporation. (Enter your answers in millions of dollars. Amounts to be deducted should be indicated with a minus sign. Leave no cells blank - be certain to enter "0" wherever required.)

Statement of Cash Flows for Year Ending December 31, 2015
(in millions of dollars)
  A. Cash flows from operating activities
        (Click to select)Net incomeNet loss $   
        Additions (sources of cash):
             (Click to select)Increase in accounts payableIncrease in accrued wages and taxesIncrease in notes payableIncrease in long-term debtDepreciation
             (Click to select)Increase in notes payableIncrease in accounts payableIncrease in accrued wages and taxesDepreciationIncrease in long-term debt
             (Click to select)DepreciationIncrease in accounts payableIncrease in notes payableIncrease in accrued wages and taxesIncrease in long-term debt
        Subtractions (uses of cash):
             (Click to select)Increase in accounts receivableIncrease fixed assetsIncrease in inventoryIncrease in notes payableIncrease in long-term debt
             (Click to select)Increase in notes payableIncrease fixed assetsIncrease in inventoryIncrease in long-term debtIncrease in accounts receivable
        Net cash flow from operating activities $
  B. Cash flows from investing activities
        Subtractions:
             (Click to select)Increase in other long-term assetsIncrease in fixed assetsIncrease in accrued wages and taxesDepreciationIncrease in accounts payable $
             (Click to select)Increase in other long-term assetsDepreciationIncrease in fixed assetsIncrease in accounts payableIncrease in accrued wages and taxes
        Net cash flow from investing activities $
  C. Cash flows from financing activities
        Additions:
             (Click to select)Increase in notes payableIncrease in accounts payableIncrease in common and preferred stockIncrease accrued wages and taxesIncrease in long-term debt $
             (Click to select)Increase accrued wages and taxesIncrease in notes payableIncrease in long-term debtIncrease in accounts payableIncrease in common and preferred stock
             (Click to select)Increase in common and preferred stockIncrease in long-term debtIncrease in notes payableIncrease accrued wages and taxesIncrease in accounts payable
        Subtractions:
             (Click to select)Preferred stock dividendsIncrease in other long-term assetsIncrease in accounts payableCommon stock dividendsIncrease accrued wages and taxes
             (Click to select)Increase accrued wages and taxesIncrease in accounts payablePreferred stock dividendsCommon stock dividendsIncrease in other long-term assets
        Net cash flow from financing activities $
  D. Net change in cash and marketable securities $

Solutions

Expert Solution

Statement of Cash Flows for Year Ending December 31, 2015
(in millions of dollars)
A. Cash flows from operating activities
Net Income Before interest & Other expenses 40
        Additions (sources of cash):
Increase in Accounts Payable 2
Increase in Accrued Wages and taxes 6
Increase in Notes Payable 2
        Subtractions (uses of cash):
Increase in Account Receivable -8
Increase in Inventory -6
Taxes -16
        Net cash flow from operating activities 20
B. Cash flows from investing activities
        Subtractions:
Purchase of Plant & Euipment -15
        Net cash flow from investing activities -15
C. Cash flows from financing activities
        Additions:
Increase in Long Term Debt 5
Interest Paid -6
        Subtractions:
Dividend to Preferred Shareholder -1
Common Stock Dividend -3
        Net cash flow from financing activities -5
D. Net change in cash and marketable securities 0
Add: Opening cash Balance 8
Closing Cash Balance 8

Related Solutions

Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) Assets 2015 2014 Liabilities and Equity 2015 2014 Current assets: Current liabilities: Cash and marketable securities $ 7 $ 7 Accrued wages and taxes $ 10 $ 9 Accounts receivable 25 20 Accounts payable 18 17 Inventory 32 25 Notes payable 16 15 Total $ 64 $ 52 Total $ 44 $ 41 Fixed...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet December 31 2021 2020 2019 Cash $ 27,500 $ 23,500 $ 18,500 Accounts receivable 50,500 50,000 48,500 Other current assets 94,500 95,500 65,000 Property, plant, and equipment (net) 530,000 471,500 401,000 $702,500 $640,500 $533,000 Current liabilities $ 71,500 $ 77,500 $ 70,000 Long-term debt 77,500 84,500 46,500 Common shares 318,000 280,000 287,000 Retained earnings 235,500 198,500 129,500 $702,500 $640,500 $533,000 SWIFTY CORPORATION Income Statement...
Use the balance sheet and income statement below to prepare a statement of cash flows for...
Use the balance sheet and income statement below to prepare a statement of cash flows for Valium’s Medical Supply Corporation. (Enter your answers in thousands. Amounts to be deducted should be indicated with a minus sign.) VALIUM’S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2018 and 2017 (in thousands of dollars) Assets 2018 2017 Liabilities and Equity 2018 2017 Current assets: Current liabilities: Cash and marketable securities $ 79 $ 78 Accrued wages and taxes $ 60 $...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a)...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a) create the Pro Forma statement for 2015 given the following assumptions: - sales increase by 20% - all items vary directly with sales (except for Notes Payable, LTD, Owners Equity) - the company is currently operating at 100% capacity - the dividend payout ratio stays at 50%             Income Statement 2015 Pro Forma 2016 Sales $3,000,000 Cost of Goods Sold 2,000,000 Depreciation 300,000 EBIT...
Condensed balance sheet and income statement data for Landwehr Corporation appear below.
Condensed balance sheet and income statement data for Landwehr Corporation appear below.   Additional information: 1. The market price of Landwehr’s common stock was $4.00, $5.00, and $8.00 for 2016, 2017, and 2018, respectively. 2. All dividends were paid in cash.   Instructions (a) Compute the following ratios for 2017 and 2018. (1) Profit margin. (2) Asset turnover. (3) Earnings per share. (Weighted-average common shares in 2018 were 32,000 and in 2017 were 31,000.) (4) Price-earnings ratio. (5) Payout ratio....
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 &...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 & 2012. Also include a 40% tax rate expense on your pretax income. 2011 2012 Sales $4,203 $4,507 Cost of Goods Sold 2,422 2,633 Depreciation 785 952 Interest 180 196 Dividends 225 250 Current Assets 2,205 2,429 Net fixed Assets 7,344 7,650 Current Liabilities 1,003 1,255 Long-Term debt 3,106 2,085
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets...
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets December 31 2018 2017 2016 Cash $ 25,000 $ 20,000 $ 18,000 Accounts receivable (net) 50,000 45,000 48,000 Other current assets 90,000 95,000 64,000 Investments 75,000 70,000 45,000 Plant and equipment (net) 400,000 370,000 358,000 Total Assets $640,000 $600,000 $533,000 Current liabilities $ 75,000 $ 80,000 $ 70,000 Long-term debt 80,000 85,000 50,000 Common stock, $10 par 340,000 310,000 300,000 Retained earnings 145,000 125,000...
An incomplete income statement and an incomplete comparative balance sheet of Deines Corporation are presented below....
An incomplete income statement and an incomplete comparative balance sheet of Deines Corporation are presented below. Additional information: 1. The accounts receivable turnover for 2017 is 10 times. 2. All sales are on account. 3. The profit margin for 2017 is 14.5%. 4. Return on assets is 22% for 2017. 5. The current ratio on December 31, 2017, is 3.0. 6. The inventory turnover for 2017 is 4.8 times. Compute the missing information given the ratios above. DEINES CORPORATION Income...
The balance sheet and income statement for Cruise Corporation are as follows:
The balance sheet and income statement for Cruise Corporation are as follows:                                                                                                                      Balance Sheet as of December 31, 2020                                                                                                                                ASSETS                                                                         LIABILITIES & EQUITY                          Cash & marketable securities $2,000             Accounts payable                    $30,000             Accounts Receivable               35,000             Taxes payable                         9,000             Inventory                                 15,000             Short-term borrowings           12,000             Total current assets                $52,000           Total current liabilities           $51,000             Net P,P & E                              $448,000         Long-term debt                       $200,000             TOTAL ASSETS                         $500,000         Total liabilities                        $251,000                                                                                     Common stock at par             $80,000                                                                                     Additional paid-in capital       $30,000                                                                                     Retained earnings                   $139,000                                                                         TOTAL LIABILITIES & EQUITY             ...
Develop a pro forma income statement and balance sheet for the company given below. Use the...
Develop a pro forma income statement and balance sheet for the company given below. Use the following assumptions in making your pro forma: Currently, fixed assets are at full capacity Each asset grows proportionally with sales Payables and accruals grow proportionally with sales 2017’s profit margin (2.52%) and dividend payout (30%) will be maintained in 2018 Sales are projected to increase by $500 million (25%) Interest payments will not change (this is not realistic, but will save you some steps)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT