Question

The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000...

The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000 and paid $10,000 in taxes in 2017. Following are the Company’s balance sheets for 2016 and 2017.

C&B CASTILLO COMPANY

                                                            2016                    2017

Cash                                                    $50,000              $5,000

Accounts Receivables                         200,000           300,000   

Inventories                                          400,000           480,000

Total Current Assets                         650,000           785,000

Gross Fixed Assets                             450,000           570,000

Accumulated Depreciation                -100,000           -140,000

Net Fixed Assets                                 350,000             430,000

Total Assets                               $1,000,000        $1,215,000

Accounts Payable                             $130,000          $170,000    

Accruals                                                50,000              40,000

Bank Loan                                            90,000           110,000

Total Current Liabilities                   270,000           320,000

Long-Term Debt                                 300,000           425,000

Common Stock                                   150,000           150,000

Paid-in-Capital                                   200,000           200,000

Retained Earnings                                 80,000           120,000

Total Liabilities & Equity           $1,000,000       $1,215,000

  1. Calculate Castillo’s cash flow from operating activities for 2017.

  1. Calculate Castillo’s cash flow from investing activities for 2017.

  1. Calculate Castillo’s cash flow from financing activities for 2017.
  1. Prepare a formal statement of cash flows for 2017.
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Req a.
Cash flows from Operating activities
Net Income for the year 60,000
Adjustment required for reconciliation
Depreciation 40,000
Increase in Accounts receivable -1,00,000
Incease in Inventories -80,000
Increase in Accounts payable 40,000
Decrease in Accruals -10,000
Net cash used in Operating activities -50,000
Req b.
Cash flows from Investing activities
Purchase of Fixed Assets -1,20,000
Net cash used in Investing activities -1,20,000
Req c
Cash Flows from Financing activities
Borrowing from Bank Loan-Current 20,000
Issuance of Long term debt 1,25,000
Dividend paid (80,000 +60,000-120,000) -20,000
Net cash provided from Financing activities 1,25,000
Req d.
CASH FLOW STATEMENT
Cash flows from Operating activities
Net Income for the year 60,000
Adjustment required for reconciliation
Depreciation 40,000
Increase in Accounts receivable -1,00,000
Incease in Inventories -80,000
Increase in Accounts payable 40,000
Decrease in Accruals -10,000
Net cash used in Operating activities -50,000
Cash flows from Investing activities
Purchase of Fixed Assets -1,20,000
Net cash used in Investing activities -1,20,000
Cash Flows from Financing activities
Borrowing from Bank Loan-Current 20,000
Issuance of Long term debt 1,25,000
Dividend paid (80,000 +60,000-120,000) -20,000
Net cash provided from Financing activities 1,25,000
Net decrease in cash -45,000
Beginning balance of cash 50,000
Ending balance of cash 5,000
Add a comment
Know the answer?
Add Answer to:
The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Help with #8 please? quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets...

    Help with #8 please? quarter ending December 31, 2017. B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2017. C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, Novem ber, and December 2017. D. Describe your findings and indicate the maximum amount of bank borrowing that is needed & Cash Conversion Cycle Two years of financial statement data for the Munich Export Corpor shown below. A. Calculate...

  • Balance Sheet                                        2012  &

    Balance Sheet                                        2012                 2013              Cash                                                   $50,000           $50,000 Accounts Receivables                         200,000           300,000    Inventories                                          450,000           570,000             Total Current Assets                         700,000           920,000 Fixed Assets, Net                                300,000           380,000             Total Assets                               $1,000,000       $1,300,000 Accounts Payable                               130,000          $180,000     Accruals                                                50,000              70,000 Bank Loan                                            90,000              90,000             Total Current Liabilities                   270,000           340,000 Long-Term Debt                                 400,000           550,000 Common Stock ($.05 par)...

  • 4. Suppose the Robinson Company had a cost of goods sold of $1,000,000 in 2016 and...

    4. Suppose the Robinson Company had a cost of goods sold of $1,000,000 in 2016 and $1,200,000 in 2017. a. Calculate the inventory turnover for each year. Comment on your findings. b. What would have been the amount of inventories in 2017 if the 2016 turnover ratio had been maintained? Cash and marketable securities Accounts receivable 2017 $50,000 350,000 500,000 $900,000 $250,000 Inventories 2016 $50,000 300,000 350,000 $700,000 $200,000 0 150,000 $350,000 Total current assets Accounts payable Bank loan Accruals...

  • At the end of 2015, the Carillon Project has $125,000 in accumulated depreciation and $100,000 in...

    At the end of 2015, the Carillon Project has $125,000 in accumulated depreciation and $100,000 in retained earnings. Sales Notes Payable Tax Rate Gross Fixed Assets Total Current Liabilities Interest Expense Cash Accounts Payable COGS Total Current Assets Total Liabilities Net Income General, Selling and Administrative Expenses Accounts Receivable Addition to Retained Earnings 2016 $350,000 20,000 40% $750,000 130,000 20,000 20,000 80.000 40% of Sales 130,000 300,000 36,000 10% of Sales 2017 $450,000 50,000 40% $1,100,000 170,000 30,000 30,000 60.000...

  • operating activities ✓ Net cash flow from operating activities, $225,000 PR 13-2A Statement of cash flows-indirect...

    operating activities ✓ Net cash flow from operating activities, $225,000 PR 13-2A Statement of cash flows-indirect method Obj. 2, 3, 4,5 the comparative balance sheet of Yellow Dog Enterprises Inc. at December 31, 2018 and 2017 is as follows: Dec. 31, 20Y8 Dec 31, 2017 Assets Cash.**** SHOW ME HOW TCL TEMPLATE $ 80,000 275,000 510,000 15,000 1,070,000 (200,000) $1,750,000 $100,000 300,000 400,000 10,000 750,000 (160,000) $1,400,000 Accounts receivable (net)..... Inventories... Prepaid expenses ...... Equipment..... Accumulated depreciation equipment.. Total assets....

  • The independent cases are listed below includes all balance sheet accounts related to operating activities: Net...

    The independent cases are listed below includes all balance sheet accounts related to operating activities: Net income Depreciation expense Accounts receivable increase (decrease) Inventory increase (decrease) Accounts payable increase (decrease) Accrued liabilities increase (decrease) Case A $310, 689 40,000 100,000 (50,000) (50,000) 60,000 Case B $ 15,000 150,000 (200,000) 35,000 120, (220,000) Case C $420,000 80,000 (20,000) 50,000 70,000 (40,000) Show the operating activities section of cash flows for each of the given cases. (Amounts to minus sign.) Case A...

  • Statement of Cash Flows Demonstration Problem The following comparative balance sheets are for Dells Corporation as...

    Statement of Cash Flows Demonstration Problem The following comparative balance sheets are for Dells Corporation as of June 30, 2010, and June 30, 2017. Also provided is the statement of income and retained earnings for the year ended June 30, 2018, with additional data. Dells Company Comparative Balance Sheet June 30, 2018 and 2017 Assets 2018 2017 Increase/Decrease) Current Assets: Cash $30,000M $80,000 - L (550,000) — K Accounts Receivable, net 160,000 100,000 60,000 Merchandise Inventory 100,000 30,000 Prepaid Rent...

  • Income Statement Year Ended 12/31/18 Balance Sheet Sales Cost of Goods Sold Operating Expenses Depreciation Expense100,000...

    Income Statement Year Ended 12/31/18 Balance Sheet Sales Cost of Goods Sold Operating Expenses Depreciation Expense100,000 EBIT Interest Expense EBT Taxes Net Income 12/31/2018 12/31/2017 $60,000$45,000 880,000650,000 200,000Less Acc'd Depreciation 450,000350,000 350,000 $395,000 $1.400,000 Current Assets 750,000 Gross Fixed Assets Fixed Assets 430,000 $490,000 50,000 Total Assets 50,000 00,000 Current Liabilities 120,000Long-term Debt $35,000 330,000 5,000 $50,000 270,000 5,000 70,000 $395,000 180,000 Common Stock Retained Earnings Total Liabilities & Equity $490.000 110 $395.000 a) Prepare the 2018 common-sized income statement...

  • The comparative balance sheets for Spicer Company as of December 31 are presented below Spicer Company...

    The comparative balance sheets for Spicer Company as of December 31 are presented below Spicer Company Comparative Balance Sheets December 31 Assets Cash Accounts receivable Inventory Prepaid expenses Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation-equipment Total 2017 2016 $ 45,000 58,000 142,000 21,000 130,000 200,000 (40,000 ) 155,000 68,000 50,000 151,450 15,280 145,000 200,000 (60,000) 225,000 (45,000) (35,000) $749,730 $676,000 Liabilities and Stockholders Equity Accounts payable Bonds payable Common stock, $1 par Retained earnings Total $ 36,000 300,000 160,000 180,000...

  • For the year ended Dec 31, 2018, Omni Company reported net income of $88,650; depreciation expense...

    For the year ended Dec 31, 2018, Omni Company reported net income of $88,650; depreciation expense increased of $13,200, and recognized $9,600 loss on disposal of equipment. (Filling amount is 2points each; filing account is 1 point each) In addition, current operating assets and liabilities from the company’s comparative balance sheet were as follows: ______________________________Dec 31, 2018 Dec 31, 2017 Accounts Receivable $6,700 $4,900 Inventory $12,300 $4,500 Accounts Payable $7,700 $5,200 Based upon above information, please generate cash flows from...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT