Active TopicsActive Topics  Display List of Forum MembersMemberlist  CalendarCalendar  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin

Equity Valuation Techniques
 The Equity Desk Forum :Market Strategies :Equity Valuation Techniques
Message Icon Topic: Free Cash flow. Is this the only thing? Post Reply Post New Topic
<< Prev Page  of 9 Next >>
Author Message
rkgautam
Senior Member
Senior Member


Joined: 03/Jan/2011
Location: India
Online Status: Offline
Posts: 233
Quote rkgautam Replybullet Posted: 24/Aug/2011 at 11:50pm
Originally posted by datta.supratik

Basantji,What do you exactly mean by free cash flow? How do we calculate that from balance sheet. Is it cash and cash equivalents end of the year? And I hope that a part of this will be distributed right?~Supratik


Free cash flow could be calculated as:

EBIT*(1-t) + Depreciation - Change in Working Capital - Capex

you should be able to find EBIT, t (tax rate), depreciation in the income statement

working capital is defined as current assets - current liabilities, both of which could be found in balance sheet. since, we are interested in change in working capital, you will have to take the data for both the years, current year and the previous year.

capex could be taken from the balance sheet or from investing cash flows.

Please note this will give you free cash flow to the firm, which when discounted at WACC will give you Enterprise Value. This is related to Equity value as:

Enterprise value = Equity value + Net debt (which is essentially Debt - Cash)

To calculate free cash flow to equity, you will have to add new debt and subtract debt repayment from free cash flow to the firm. Free cash flow to equity when discounted at Re will give you Equity value.

Now, while a firm may show an increase in profits consistently, it is of a little value to its shareholders if the free cash flows are not going up or if there is no free cash at all or negative free cash flows (doesn't happen with good companies, but not uncommon with companies that go burst). But please note, free cash flows could be low/negative because of several reasons (various combinations of the components which are used for calculating free cash flows). So, one may try to fool the investors with P&L, but one cannot fool investors with free cash flows. EBITDA has similar characteristics, because it stays away from the effects of capital structure (% of debt and equity, thus different interest income and thus different profit) and depreciation & amortization (which at times could be arbitrary). That's one of the main reasons why PE investors (or those who think along the same lines) give so much of importance to DCF (discounted cash flows) or EBITDA.

Another thing: One of the main drawbacks of using tools such as RoCE and RoE is that they measure return against the book value of assets in the business, which when depreciated might continue to give high(er) RoCE/RoE even though cash flows could tell a different story. In the process, older businesses (something like Hawkins I assume) with depreciated assets are likely to have higher RoCE than newer, possibly better businesses. Cash flows are affected by inflation and take latest values into consideration, but the book value (of assets) does not, and hence cash flows provide a clearer picture about the company.

Edited by rkgautam - 24/Aug/2011 at 12:21pm
IP IP Logged
LearningToFly
Senior Member
Senior Member
Avatar

Joined: 22/Feb/2010
Online Status: Offline
Posts: 490
Quote LearningToFly Replybullet Posted: 24/Aug/2011 at 11:22am
Datta,
Free cash flow is the money that had come to the company in any financial year. Free cash flow can be of two types; namely Free cash flow to the firm and free cash flow to the equity. Let's calculate free cash flow to the firm:

1. take EBIT from income statement. Call it A.
2. Add depreciation and amortixation expenses from income statement and add it to A. Call it B
3. Take taxes from income statement and subtract it from B. Call it C
4. Now find out the capital expenses from balance sheet by subtracting net fixed assets of last year from net fixed assets of this year. Subtract this number from C. Call it D.
5. Now find out the net change in net working capital. You can find this out again in balance sheet by first calculating working capital of last year and working capital of this year. Subtract the last year working capital from this years. Whatever number you get, subtract that from D. Call it E.
E is your free cash flow to the firm.

To calculate working capital subtract current liabilities from current assets found in balance sheet. Some people exclude cash and cash equivalents in current assets. Choice is yours.

To get free cash flow to equity, replace EBIT with net profit. and do the same except step 3.


Originally posted by datta.supratik

Basantji,

What do you exactly mean by free cash flow? How do we calculate that from balance sheet. Is it cash and cash equivalents end of the year?
And I hope that a part of this will be distributed right?

~Supratik
Success... at all cost.
IP IP Logged
bobdylan
Senior Member
Senior Member
Avatar

Joined: 15/Jun/2011
Location: India
Online Status: Offline
Posts: 114
Quote bobdylan Replybullet Posted: 25/Aug/2011 at 7:50pm

lets have an imaginary balance sheet

shareholders equity             2010       2011

share capital                      100000      100000
reserves/surplus                   20000       25000
 
debt(long term)                    20000        25000
gross block                          150000      175000
accumulated depreciation     75000         78000
 
current assests                    100000       125000
(cash,inventory,debtors)
 
current liabilities                    70000          90000
(creditors,provisions etc)
working capital                      30000         35000
c.asset-c.liability
 capex(2011)=gross block(2011)-gross block(2010)
=175000-150000=25000(assuming no sale of assets)
change in working capial=35000-30000
=5000(u have spent extra cash in maintaining inventory,debtors etc)
assuming  free cash flow from operations is 50000
free cash flow is 50000-capex(25000)-change in wc(5000)
20000(for year 2011)
tried my best,seniors can correct/add on/
 
 
IP IP Logged
Jaspreet
Groupie
Groupie


Joined: 10/Jul/2011
Location: India
Online Status: Offline
Posts: 47
Quote Jaspreet Replybullet Posted: 25/Aug/2011 at 8:17pm
Originally posted by bobdylan

lets have an imaginary balance sheet


shareholders equity             2010       2011


share capital                      100000      100000

reserves/surplus                   20000       25000

 

debt(long term)                    20000        25000

gross block                          150000      175000

accumulated depreciation     75000         78000

 

current assests                    100000       125000

(cash,inventory,debtors)

 

current liabilities                    70000          90000

(creditors,provisions etc)

working capital                      30000         35000

c.asset-c.liability

 capex(2011)=gross block(2011)-gross block(2010)

=175000-150000=25000(assuming no sale of assets)

change in working capial=35000-30000

=5000(u have spent extra cash in maintaining inventory,debtors etc)

assuming  free cash flow from operations is 50000

free cash flow is 50000-capex(25000)-change in wc(5000)

20000(for year 2011)

tried my best,seniors can correct/add on/

 

 


Ok, let me give it a shot. Looking at balance sheet of Mayur Uniquoters here ... http://www.moneycontrol.com/financials/mayuruniquoters/balance-sheet/MU

FCF = CFO - capex - change in WC
CFO Mar 11 = 17.24
Capex = 48.48 - 37.75 = 10.73
Working capital, am assuming is the same as Capital work in progress.
Then change in WC = 4.41-1.06 = 3.35

So now FCF = 17.24 - 10.73 - 3.35 = 3.16
Right?
IP IP Logged
Jaspreet
Groupie
Groupie


Joined: 10/Jul/2011
Location: India
Online Status: Offline
Posts: 47
Quote Jaspreet Replybullet Posted: 25/Aug/2011 at 9:04pm
Originally posted by bobdylan

lets have an imaginary balance sheet


shareholders equity             2010       2011


share capital                      100000      100000

reserves/surplus                   20000       25000

 

debt(long term)                    20000        25000

gross block                          150000      175000

accumulated depreciation     75000         78000

 

current assests                    100000       125000

(cash,inventory,debtors)

 

current liabilities                    70000          90000

(creditors,provisions etc)

working capital                      30000         35000

c.asset-c.liability

 capex(2011)=gross block(2011)-gross block(2010)

=175000-150000=25000(assuming no sale of assets)

change in working capial=35000-30000

=5000(u have spent extra cash in maintaining inventory,debtors etc)

assuming  free cash flow from operations is 50000

free cash flow is 50000-capex(25000)-change in wc(5000)

20000(for year 2011)

tried my best,seniors can correct/add on/

 

 


Ok, let me give it a shot. Looking at balance sheet of Mayur Uniquoters here ... http://www.moneycontrol.com/financials/mayuruniquoters/balance-sheet/MU

FCF = CFO - capex - change in WC
CFO Mar 11 = 17.24
Capex = 48.48 - 37.75 = 10.73
Working capital, am assuming is the same as Capital work in progress.
Then change in WC = 4.41-1.06 = 3.35

So now FCF = 17.24 - 10.73 - 3.35 = 3.16
Right?
IP IP Logged
Jaspreet
Groupie
Groupie


Joined: 10/Jul/2011
Location: India
Online Status: Offline
Posts: 47
Quote Jaspreet Replybullet Posted: 25/Aug/2011 at 12:17pm
Originally posted by LearningToFly


Datta,Free cash flow is the money that had come to the company in any financial year. Free cash flow can be of two types; namely Free cash flow to the firm and free cash flow to the equity. Let's calculate free cash flow to the firm:1. take EBIT from income statement. Call it A.2. Add depreciation and amortixation expenses from income statement and add it to A. Call it B3. Take taxes from income statement and subtract it from B. Call it C4. Now find out the capital expenses from balance sheet by subtracting net fixed assets of last year from net fixed assets of this year. Subtract this number from C. Call it D.5. Now find out the net change in net working capital. You can find this out again in balance sheet by first calculating working capital of last year and working capital of this year. Subtract the last year working capital from this years. Whatever number you get, subtract that from D. Call it E. E is your free cash flow to the firm.To calculate working capital subtract current liabilities from current assets found in balance sheet. Some people exclude cash and cash equivalents in current assets. Choice is yours. To get free cash flow to equity, replace EBIT with net profit. and do the same except step 3.
Originally posted by datta.supratik

Basantji,What do you exactly mean by free cash flow? How do we calculate that from balance sheet. Is it cash and cash equivalents end of the year? And I hope that a part of this will be distributed right?~Supratik



Ok now this is starting to get really murky. Big mumbo jumbo. First up, is Mr Gautam, LeanringToFly and BobDylan all saying the same thing? Bobdylan seems to have given a pretty simplistic method.
Second, can someone calculate it using a live data please?
Thanks and would really appreciate your efforts!
IP IP Logged
datta.supratik
Senior Member
Senior Member


Joined: 23/Apr/2010
Location: India
Online Status: Offline
Posts: 235
Quote datta.supratik Replybullet Posted: 27/Aug/2011 at 9:08pm
Thanks ALL,

It is now clear. That was a lot of effort with elaborate explanations.
It has been really helpful for me.

Thanks a lot again. 
Love TEDies!!

~Supratik

IP IP Logged
bobdylan
Senior Member
Senior Member
Avatar

Joined: 15/Jun/2011
Location: India
Online Status: Offline
Posts: 114
Quote bobdylan Replybullet Posted: 27/Aug/2011 at 12:31pm
Since Jaspreet wanted to do a live data,lam attempting Mayur uniquoters link which he has provided
capex calculation is ok-48.48-37.75=10.73
you have picked the wrong term for net working capital which is further down under the heading net current assets,now find the difference between the 2 years,ideally the cash component must be removed from both years,but for simplicity we take it.
diff=33.01-22.21=10.8(extra cash spent for WC)
 
now the term cash from operations,im not exactly sure of the term used in money control site and how they have calculated it,but we can do it from basics.Now go the P&L account.
depreciation=2.67
PBIT=39.27
CFO=PBIT(1-T)+depreciation,T-tax rate is 33%
=39.27(1-0.33)+2.67
=28.98
Free cash flow=CFO-NWC-capex
28.98-10.8-10.73
=7.45
one can try by removing the cash and fixed deposit(cash equivalent components) to get the exact answer.
 
IP IP Logged
<< Prev Page  of 9 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.141 seconds.
Bookmark this Page

Join Theequitydesk.com Today!

It’s easy to Join and it’s free.

Here's why members would love to be a part of theequitydesk.com

  • Equity Desk focuses on why to buy shares and invest in share rather than what to buy.
  • Live discussion forum wherein members can discuss the current Indian share Market trend, BSE Sensex or the Nifty Index.
  • Have huge cache of information on Indian and World Share Market.
  • Analysis of Indian stock market, Global events, Investing insights, portfolio management strategies and thoughts,
  • Meet investors from round the globe check their investing strategies share experiences and learn for their experiences on stocks and shares, evaluate opinions on investing in India.

Register now while it’s free!

Already a member? Close this window and log in.

Join Us           Close