This detailed course shows you how build a Cash Flow Valuation Model using Excel and Yahoo! Finance data. You are taught in detail how to build a Discounted Cash Flow Model using Yahoo! Finance fundamental stock data. The course also shows you how to import cash flow data automatically into Excel from Yahoo! Finance using a Web Query.
The Course is delivered in HTML format for easy viewing on a web browser, and includes all formulas, worksheet structures, screenshots, images, and in-depth financial descriptions behind every component to enable you to model and value a public company's cash flows. This model can be used for any public company available on Yahoo! Finance and any currency. It's truly a fantastic value!

What You Get: A TREMENDOUS 4-IN-1 VALUE!

- An Course showing you how to build and operate the model PLUS Further Resources to do your own research
- Detailed instructions on building the Discounted Cash Flow Model in in Excel

- Instructions on how to import Cash Flow data from Yahoo! Finance into Excel automatically for your favorite stocks

- Lifelong access to the course materials!



Benefits

- Learn to integrate Excel and Yahoo! Finance automatically into a highly useful public company valuation tool

- Acquire unique knowledge for any Excel modeling project

- Save money by eliminating data costs- Replicate the Model to enable valuation of multiple stocks at once
- Automatically import quarterly Cash Flow Statement, Income Statement and Balance Sheet data directly from Yahoo! Finance
- Find out about other key resources for extending the model, calculating discount factors, valuing companies, increasing your Excel knowledge, and accessing other FREE Excel tools on the Internet



Technical Requirements

- MS Excel for Windows

- 5.4Mb disk space for course materials (detailed instructions and images)

- An Internet connection

- Internet Explorer or other Internet browser
- FREE WinZip software (to unzip the files once you download them)

• Mini Finance Calculator 3.2
  Mini Finance Calculator is a easy-to-use Finance calculator.It give you the ability to calculate the time value of money, interest rates, cash flow, and depreciation....

• InvestmentCode 2010
  InvestmentCode is a comprehensive suite of investment calculators and modelling templates developed by ConnectCode

• Financial Advisor for Excel (Full) 4.2.4
  Discounted Cash Flows, Borrowing, Business Profitability, Financial Planning, Investing, Bonds, Cost of Capital, Options, Valuation and more in this powerful financial toolbox!!! Financial Advisor for Excel has 73 financial calculators that will...

• Financial Advisor for Excel (Standard) 2.3
  Borrowing, business profitability, discounted cash flows, financial planning, investing, bonds, cost of capital, options, valuation and more in this financial toolbox!!! //n//nFinancial Advisor for Excel is the Swiss Army Tool of financial calculators: loans, NPV, bonds, etc

• Financial Advisor for Excel (Full Access 2.3
  Borrowing, business profitability, discounted cash flows, financial planning, investing, bonds, cost of capital, options, valuation and more in this financial toolbox!!!//n//nFinancial Advisor for Excel is the Swiss Army Tool of financial calculators: loans, NPV, bonds, etc. It's a powerful tool that consists of 73 different financial calculators....

• Simple Oil Field NPV Simulation Tool 0.1.3
  Oil companies and other stakeholders may need to assess the value of new fields or prospects even when very little hard data exists

• Residential Real Estate Excel Model v1
  This is the single most important tool you will ever use in your real estate investing! A professional pre-built Excel spreadsheet that calculates and details the profitability of any residential real estate investment. Input the detailed property...

• Discounted Cash Flow Analysis Calculator 1.5.0
  Discounted Cash Flow Analysis Calculator performs a quick analysis of 14 cash flow series with 5 different discount rates per series

• Discounted Cash Flow Analysis Calculator 2.1
  Discounted Cash Flow Analysis Calculator helps you with capital budgeting by simultaneously evaluating the cash flow series of 14 projects against 5 different discount rates per...