Question

In: Accounting

Problem 9-A F) Statement of Cash Flows report with a run date of 12/31/-. Provide a...

Problem 9-A

F)

Statement of Cash Flows report with a run date of 12/31/-. Provide a narrative analyisis of this report.

Mike Bokman
Casey Corporation
Statement of Cash Flows
For Year Ended 12/31/18
Cash Flows from Operating Activities
Notes Receivable 50,382.00
Accounts Receivable 588,700.50
Merchandise Inventory 84,500.00
Notes Payable 14,500.00
Sales 121,995.00
Sales Discounts -7,154.01
Cost of Merchandise Sold -84,500.00
Interest Income 843
--------------
Total Cash Received 769,266.49
Merchandise Inventory -4,242.00
Store Supplies 2,115.32
Office Supplies 1,173.24
Prepaid Insurance 5,250.00
Accounts Payable 515,050.00
Notes Payable 14,260.00
Sales Salaries Expense 74,000.94
Advertising Expense 13,750.00
Misc. Selling Expense 850
Office Salaries Expense 20,310.61
Utilities Expense 8,991.47
Misc. General Expense 400
Interest Expense 10,349.80
Corporate Income Tax 26,800.00
--------------
Total Cash Paid 689,059.38
--------------
Net Cash Flow from Operating Activities 80,207.11
Cash Flows from Investing Activities
Store Equipment 3,400.00
--------------
Total Cash Received 3,400.00
Office Equipment 3,100.00
--------------
Total Cash Paid 3,100.00
--------------
Net Cash Flow from Investing Activities 300
Cash Flows from Financing Activities
Mortgage Note Payable 4,290.20
Dividends 20,000.00
--------------
Total Cash Paid 24,290.20
--------------
Net Cash Flow from Financing Activities -24,290.20
--------------
Net Increase in Cash 56,216.91
Cash at Beginning of Year 67,534.52
--------------
Cash at End of Year 123,751.43
==============

Solutions

Expert Solution

Ans.:- Narrative Analysis of Statement of Cash Flows Report:-

Note:- There are two methods to prepare a statement of cash flow are 1.) Direct Method & 2.) In-direct Method and above report prepared on the basis of Direct Method.

Step-1= Analysis of Cash Flow From Operating Activities as follows:-

1.) As i told you that above statemnet is prepared on the basis of direct method so know lets talk about what is direct Method?

2.) In direct method such transactions are consider like sales, purchases, account receivable, notes receivable, notes payable, interest income etc.

3.) In this method we will add all such transaction from which we earned money like sales (after considering all discounts) and receivables from debtors, interest income as above statement.

4.) And we will deduct from such cash all expenses which are necessary to earned that money which is called matching concept. Likes Notes payables, purchases, actual tax piad, salaries, office expenses etc.

5.) As per above discussion if i simplify this so while preparing statement of cash flow we will consider only cash transaction whether it is income or expense;

6.) And eliminate all non-cash transaction while preparing cash flow statement.

Step-2= Analysis of Cash Flow From Investing Activities as follows:-

1.) In this activity we will consider sale and purchases related to fixed assets and investment.

2.) In this if there are sales transactions then we add such transaction and if there is purchases of any assets then we deduct from it and we will consider only net amount.

3.) In investing activities we will consider only investing amount whether we received or pay such amount.

Step-3= Analysis of Cash Flow From Financing Activities as follows:-

1.) In this activities we will consider such transactions from where we will finance amount for our company.

2.) Such as long term loans, Issue of share, deposit accepted etc. and as such amount in this activities.

3.) And we will deduct amount like redemption of debentures, dividend paid, interest paid, buy back of shares etc.

4.) By netting off above transactions we will get cash flow from/ used in financing activities.

And at last by netting of all the three activities we will get net cash flow from/used in activities. And this amount we will add or deduct from opening cash balance and we will get closing balance of cash at the end of year.


Related Solutions

Income Statement (vertical) report with a run date of 12/31/-. Provide a narrative analysis of this...
Income Statement (vertical) report with a run date of 12/31/-. Provide a narrative analysis of this report in a manner similar to that done in the chapter. Use your own words based on the information provided in this report. Casey Corporation Income Stmt. Vertical Analysis For Years Ended 12/31/17 and 12/31/18 Current Current Previous Previous Amount Percent Amount Percent Operating Revenue Sales 869,695.50 101.91 836,490.00 101.16 Sales Returns & Allow. -9,150.00 -1.07 -6,000.00 -0.73 Sales Discounts -7,154.01 -0.84 -3,595.00 -0.43...
Problem #1 Statement of Cash Flows The following Statement of Cash Flows was prepared for the...
Problem #1 Statement of Cash Flows The following Statement of Cash Flows was prepared for the Baines Corporation. Walker Corporation Statement of Sources and Uses of Cash Year Ended December 31, 2017 Sources of cash                       Net income $111,000                         Depreciation and depletion                                                                               70,000                         Increase in long-term debt 179,000                         Changes in current receivables and inventories,                         less current liabilities 14,000 $374,000 Uses of cash                       Cash dividends $ 60,000                         Expenditure for property, plant, and equipment 214,000...
ALL THE INFORMATION I HAVE IS STATED BELOW! 1.Statement of Cash Flows. Assets 31/12/2017 31/12/2016 Cash...
ALL THE INFORMATION I HAVE IS STATED BELOW! 1.Statement of Cash Flows. Assets 31/12/2017 31/12/2016 Cash $81,000 $54,000 Accounts receivable, net $79,500 $85,500 Inventory $241,500 $184,500 Land $270,000 $427,500 Building $450,000 $450,000 Accumulated depreciation—building ($112,500) ($90,000) Equipment $2,347,500 $1,350,000 Accumulated depreciation—equipment ($265,500) ($211,500) Total of Assets $3,091,500 $2,250,000 Liabilities & Equity Accounts payable $303,000 $225,000 Bonds payable $675,000 $0 Capital stock, $10 par $1,875,000 $1,875,000 Retained earnings $238,500 $150,000 Total of Liabilities & Equity $3,091,500 $2,250,000 Additional Data: 1. Net...
.Statement of Cash Flows. Assets 31/12/2017 31/12/2016 Cash 81000 121500 Accounts receivable, net 79500 119250 Inventory...
.Statement of Cash Flows. Assets 31/12/2017 31/12/2016 Cash 81000 121500 Accounts receivable, net 79500 119250 Inventory 241500 362250 Land 270000 405000 Building 450000 675000 Accumulated depreciation—building -112500 -168750 Equipment 2347500 3521250 Accumulated depreciation—equipment -265500 -398250 Total of Assets 3091500 4637250 Liabilities & Equity Accounts payable 303000 454500 Bonds payable 675000 1012500 Capital stock, $10 par 1875000 2812500 Retained earnings 238500 357750 Total of Liabilities & Equity 3091500 4637250 Additional Data: 1. Net income for the year amounted to $163,500. 2....
a1. The purpose of a statement of cash flows is to a. report a firm’s cash...
a1. The purpose of a statement of cash flows is to a. report a firm’s cash inflows and outflows during a period of time b. help the analyst assess a firm’s ability to generate cash for dividends and investments c. help the analyst identify a firm’s needs for external financing d. help the analyst understand the difference between net income and net cash flow from operating activities e. all of the above 2. Cash budgeting can lower the cost of...
Problem 23-9 Novak Corporation has contracted with you to prepare a statement of cash flows. The...
Problem 23-9 Novak Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Cash $38,600 $13,000 Accounts receivable 12,200 10,000 Inventory 11,900 9,900 Equity investments –0– 3,000 Buildings –0– 29,800 Equipment 40,000 20,000 Copyrights 5,100 5,200      Totals $107,800 $90,900 Allowance for doubtful accounts $2,900 $4,500 Accumulated depreciation—equipment 2,000 4,500 Accumulated depreciation—buildings –0– 5,900 Accounts payable 5,100 4,000 Dividends payable –0– 4,900 Notes payable, short-term (nontrade) 2,900 4,000...
Problem 23-9 Sunland Corporation has contracted with you to prepare a statement of cash flows. The...
Problem 23-9 Sunland Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Cash $38,900 $12,800 Accounts receivable 12,200 9,900 Inventory 11,800 10,000 Equity investments –0– 3,100 Buildings –0– 29,600 Equipment 40,400 20,200 Copyrights 5,000 5,200      Totals $108,300 $90,800 Allowance for doubtful accounts $3,000 $4,600 Accumulated depreciation—equipment 2,000 4,500 Accumulated depreciation—buildings –0– 5,900 Accounts payable 5,000 4,000 Dividends payable –0– 4,900 Notes payable, short-term (nontrade) 3,000 4,000...
Instruction: Only prepare the statement of Cash flows for the year ending 12/31/2018 The trial balances...
Instruction: Only prepare the statement of Cash flows for the year ending 12/31/2018 The trial balances for the beginning of the year and End of the year, as well as Additional information, are provided below. The name of the company is: Rockford Plumbing Supply, Inc. Final (Ending) Trial Balance - 12/31/2018 Account Name Debit Credit 101 Cash 431,794 105 Petty Cash 150 112 Accounts Receivable 464,550 113 Allowance for Doubtful Accounts 40,178 115 Notes Receivable 0 120 Inventory 569,671 126...
Which of the following sections on a statement of cash flows is used to report the...
Which of the following sections on a statement of cash flows is used to report the cash flow effects of transactions involving a company's stock? a.Financing Activities b.Operating Activities c.Investing Activities d.Profit Activities Moore Industries began operations on January 2, 2017, with an investment of $50,000 by each of its two stockholders. Net income for its first year of business was $240,000. Moore Industries paid a total of $100,000 in dividends to its stockholders during the year. Read the information...
12.  Problem 3.12 (Statement of Cash Flows) eBook Hampton Industries had $70,000 in cash at year-end 2018...
12.  Problem 3.12 (Statement of Cash Flows) eBook Hampton Industries had $70,000 in cash at year-end 2018 and $28,000 in cash at year-end 2019. The firm invested in property, plant, and equipment totaling $300,000 — the majority having a useful life greater than 20 years and falling under the alternative depreciation system. Cash flow from financing activities totaled +$210,000. Round your answers to the nearest dollar, if necessary. What was the cash flow from operating activities? Cash outflow, if any, should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT