Calculating Cash Flow

Cash is the lifeblood of business and understandingto turn this information into the required format
how the statement of cash flows works isto have an official looking statement. Well, if you
essential for every aspiring Richard Branson ortake a look at my sample Cash Flows Statement
Mark Zuckerman. Putting together your cash flowyou will see that the first line is net income, and
statement can be tricky for the newbie but iswhat is net income but part of the change in
actually very easily mastered with this simpleretained earnings? If you read my earlier post on
hack.retained earnings you will remember that the
The Indirect Methodchange in retained earnings is comprised of net
The Philosophy of the indirect method is that cashincome plus capital contributions less distributions.
flows should be in essence driven by profits so,So your net income, the first line on your
to calculate the indirect method of cash flows,statement, less your distributions or plus your
you start with your profits and then makecontributions in the investing section will equal your
adjustments for everything that are not profitsnumber for the change in retained earnings on the
until you get to your change in cash flows. Whenbalance sheet you worked on in the paragraph
you think about it, this is very intellectuallyabove. And so it is down the line, every line on
satisfying. After all, our main obsession is withyour cash flow statement must either alone or in
profits, and rightly so. However, profits don't keepaggregate with another line equal a line in the
the employees coming back and the lights on,change column that you just calculated on your
cash does. So by closely examining all the uses ofbalance sheet. This is brilliant stuff kids and I wish
cash we can see where our cash is going andmy accounting professor would have explained to
locate any potential problems; which makes theme this way. Actually, maybe he did but I sat
indirect method of calculating cash flows a fast,next to this really cute mamacita that day; I could
efficient, and very powerful weapon in yourbe a moron like that.
arsenal of business management for maximumThe Challenges
profits!The next big challenge on your statement of cash
The Hackflows will be the change in fixed assets, which will
Debits equal Credits and the balance sheet mustbe a component of plus depreciation expense less
balance, or assets = liabilities plus equity, got that?any new assets purchased plus any assets sold
That's all the accounting you need to know forplus or minus the gain or plus the loss on that sale.
this exercise. Now take this a step further.The key is, when you add up those factors they
Download your comparative balance sheet intomust equal that line for the change in fixed
Excel, you know, it's the assets = liabilities plusassets. If not you're forgetting one component so
equity page. Comparative means that we showreview the equation in the first sentence of this
two periods, usually year ends, side by side. Now,paragraph and figure it out.
in the immediate column to the right make a totalAfter fixed assets the next most complicated line
subtracting the current periods assets from theis the change in notes payable or debt. The
prior periods and copy it all the way down, exceptformula is that new monies borrowed minus debt
in the totals cells. Now move down to the liabilitiespayments plus interest expense will equal your
and equity section and do the opposite,change in debt. This is important because all three
subtracting the prior period from the currentcomponents will go on a different line on your
period. We do the opposite because creditsstatement of cash flows, but their sum must
(liabilities and equity) have the opposite value (-)equal the change that you calculated on your
from assets (+), but that's really not important atbalance sheet or you're doing it wrong and you
the moment. Now sum the new column thatneed to review.
represents the change in the balance sheet. If youOther than that everything else pretty much
did the exercise right then the sum should bematches line for line between your balance sheet
zero. If you're not getting zero that means thatcalculation and the statement of cash flows. Just
you forgot to reverse the formula for the liabilitiesplug in the numbers and voila! your change in cash
and equity section or you included subtotal rows inflows will equal the amount that you calculated on
your new column. Pretty frickin' cool, huh? Butline one of your balance sheet! If for some reason
that's not the coolest part. Now redo your sum toit doesn't just go back over and make sure that
exclude the difference in cash, usually the first line.you can reconcile each line for the changes that
The sum of all the other changes must beyou calculated on your balance sheet to the cash
exactly opposite any single change, or in otherflows statement. If you can't you must be
words the sum of every other change equals themissing a line.
change in cash flows times negative one!! Flippin'Finished, Miller Time!
mindblowin' stuff! And the basis of the IndirectWhen you're done patting yourself on the back
Statement of Cash Flows.for a job well done then it is time to get down to
Putting This Into the Statement of Cash Flowsthe really important business, what all this
You're 80% of the way there and, if you aremadness means to you and your business and
only doing this to understand your business andhow the statement of cash flows can help you
not to make a real, bona fide, according-to-GAAPrun your business better. Alas, that is the source
cash flow statement then skip over the rest ofof another article as I'm tired and turning in for
this post and head to the next. The next step isthe night; so stay posted!