Financial Forecasting and Company Valuation (DCF Method)
Not what you're looking for?
I forecasted the cash flows for DELL for the next 5 yrs (2006-2010) with the help of an online TA. I found the discounted cash flows, but what do I look for when valuing the firm? First, is the value of the firm on my Excel correct, how about the DCF? Is the price per share correct? It seems too low considering the current stock price of $41.00. Is that the correct way to calculate it? How do I know if the company is overvauled or undervalued? How do I justify the growth rate, do I look at analysts estimates on MSN Money (key ratios)? How do I know if this is a good investment based on my Excel? Please help, I need to understand the valuation of a company in order to continue on and do this for my other 6 companies. Help would be appreciated, thanks. Attached is my Excel for Dell.
Purchase this Solution
Solution Summary
This explains the steps of Financial Forecasting by company Valuation (DCF Method)
Solution Preview
I forecasted the cash flows for DELL for the next 5 yrs (2006-2010) with the help of an online TA. I found the discounted cash flows, but what do I look for when valuing the firm? First, is the value of ...
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.