Cash Flow Valuation - Key Steps
Cash flow valuation Excel worksheets are used by individual and professional investors to value companies, approximate their long run upside, and calculate profit variability. This short article talks about the task and some things to look for in this type of model.
If you are employing an Excel tool or pre-built software, the first thing is finding the background data needed to understand the company's past financial success or failure. This will likely take some digging. The typical sources are Yahoo!, Thomson, the SEC EDGAR, stock exchanges, or news providers like the Financial Times. Where possible it's best to get your data in Excel or flat file format so that it can be changed. Be certain the complete fiscal reports are available for the past 2 to 5 years. These must be quarterly when possible.
Here is where the heavy cash flow valuation labor begins. Bring the info into Excel or your software and arrange it into multiple sheets. Create a new sheet for your cash flow valuation financial model, with sections for earnings before interest taxes depreciation and amortization, changes, Cash from Operations, Investing, and Funding Activities. Lay out your quarterly or yearly calendar headings at the top for about 5-8 periods, ending at a final exit cell at the end. You now have the layout set up for your estimation spreadsheet.
Link in the earnings before interest taxes and depreciation/amortization data to the EBITDA line in the Statement of Income if it exists, or compute it by linking to the appropriate Income Statement lines. Within your additions and subtractions section, go ahead and back out any items you don't think will reoccur or add back in charges or income you think need to be in EBITDA. This is commonly done for one-time revenues or expenses and deferred income or expenses or pure mystery line items. Now, back out your depreciation and amortization costs to acquire earnings befor interest and taxes and apply the common company blended taxation percent without these two costs. Finally, add depreciation in again to arrive at your cash flow from operating activities.
The next phase in your cash flow valuation model is cash from investments. Take out cash expenditures for brand new investments in short or long-term assets and intellectual property. Include cash received for sale of assets. Execute any adjustments as appropriate, and net the total. Repeat this for the financing cash section. Take out cash paid for loans, stock buybacks, along with other financing sources. Add to cash for new debt issued, share sales, and the like. Adjust and add up to obtain a total.
Including cash from operating, investing and finnancing activities gives your free cash flow. This is may be different than the company's standard public financial statements. Now that you have this, project these numbers into future periods based on your research and estimates. Give a final exit value for the final period. Lastly, applying a discount factor, do a cash flow valuation to acquire your DCF valuation.
Article Source: FxTradingStock.com
About the Author
If you would like to see a cool cash flow valuation tool you can use without having to bulid your own, go to http://www.financial-edu.com/cash-flow-valuation-model-for-excel.php
by: Edie Rodriguez
Total views: 26
Word Count: 508
Date: Tue, 28 Dec 2010
Publish/Share this article
To use this article on your site click here to get the HTML code
Rating: Not yet rated
Login to vote
Related Articles
How to Invest in 2011 and Beyond Without a ClueWhat Is Forex Trading?
Quick Way To Trade In Shares
ATM Calendar Spreads, Are You Aware Of The Hidden Gotchas?
Emini Day Trading Requirements
The Coming Death Of The Dollar
Fantastic Fundraising Suggestions
Winning Big In The Share Market
