Question: You ve recently been hired by B2B Consultants to provide financial

You’ve recently been hired by B2B Consultants to provide financial advisory services to small business managers. B2B’s clients often need advice on how to improve their operating cash flows and, given your accounting background, you’re frequently called upon to show them how operating cash flows would change if they were to speed up their sales of inventory and their collections of accounts receivable or delay their payment of accounts payable. Each time you’re asked to show the effects of these business decisions on the cash flows from operating activities, you get the uneasy feeling that you might inadvertently miscalculate their effects. To deal with this once and for all, you e-mail your friend Owen and ask him to prepare a template that automatically calculates the net operating cash flows from a simple comparative balance sheet.

You received his reply today.

Subject: Excel Help
Hey pal. I like your idea of working smarter, not harder. Too bad it involved me doing the thinking. Anyhow, I’ve created a spreadsheet file that contains four worksheets. The first two tabs (labeled BS and IS) are the input sheets where you would enter the numbers from each client’s comparative balance sheets and income statement. Your clients are small, so this template allows for only the usual accounts.
Also, I’ve assumed that depreciation is the only reason for a change in accumulated depreciation. If your clients’ business activities differ from these, you’ll need to contact me for more complex templates. The third worksheet calculates the operating cash flows using the indirect method and the fourth does this calculation using the direct method. I’ll attach the screenshots of each of the worksheets so you can create your own. To answer “what if” questions, all you’ll need to do is change selected amounts in the balance sheet and income statement.

Copy the account balances from the worksheets for the balance sheet and income statement into a spreadsheet file. Enter formulas into the balance sheet worksheet to compute the change in each account balance, and then enter the formulas for the statement of cash flows (indirect method only) into a third worksheet. From this third worksheet, report the net cash flow provided by (used in) operatingactivities.
View Solution:

Sale on SolutionInn
  • CreatedFebruary 27, 2015
  • Files Included
Post your question