Excel with Yahoo! Finance – Building a Cash Flow Valuation Model
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)
Related Products
XeCheck 8 Personal Finance (Premier)
We all know times are tough, that is why you need XeCheck 8 Personal finance software.
XeCheck 8 gives you the tools to maximize your savings and plan for your future.
Download statements & balances from over 6000+ US and International Banks, Creditcards, Brokerages, Credit Unions and other financial institutions.
XeCheck supports over 190 currencies, and over 18 types of accounts including (checking, savings, credit card, loans, investment, 401(k), etc).
XeChecks bill payment tools allow you to schedule, pay or track any bill. XeCheck interacts with many banks ONLINE BILL PAYMENT and TRANSFERS systems. This allows you to reduce or eliminate late payment penalties; You get timely reminders when bills are coming due. Easy step by step instructions let you get started quickly.
Manage your investment, retirement accounts, mutual funds, 401k with ease. Create customized investment reports or use XeCheck’s charts and get a snapshot of how well your investments are doing. You can even compare individual securities against market indices.
Maximize your tax returns. We’ve made tax time a whole lot easier by allowing you to track your tax related transactions. Run schedules A, B, and D, reports to help you stay on top of your investment tax situations throughout the year. For you budding real-estate tycoons, you can even track your rental property income, expenses and export schedule E data.
Use XeCheck’s loan and credit affordability calculators to see how much loan or credit you qualify for before you start shopping around for one. You can even access certain software features using voice commands in XeCheck Premier.
Personal Finance Scorecard for Excel
Improve performance with Personal Finance Scorecard for Excel scorecard
XeCheck 8 Personal Finance (Deluxe)
XeCheck 8 Personal finance software makes it easy for you to manage your finance.
With over 6,000 US and International Banks, Credit Unions, Creditcards and Brokerages participating, downloading your banking and investment statements directly into XeCheck is easier then ever.
XeCheck supports over 130 currencies, and over 18 types of accounts (checking, savings, credit card, loans, investment, 401(k), etc).
XeChecks bill payment tools allow you to schedule, pay or track any bill. XeCheck interacts with many banks ONLINE BILL PAYMENT and TRANSFERS systems. This allows you to reduce or eliminate late payment penalties; You get timely reminders when bills are coming due. Easy step by step instructions let you get started quickly.
Budgets: Let XeCheck’s budgeting wizard walk you through the process. XeCheck can even generate budgets based on your past transactions or bills.
Balance your checkbook: XeCheck gives you all your transactions, account balances, so balancing your checkbook is now easier than ever. You can also print checks.
Export your tax data. We’ve made tax time easier by allowing you to print or export your tax related transactions to tax preparation software such as TurboTax and TaxCut; this means you won’t loose those charitable donations or tax deductible expenses by forgetting them.
Manage your investment portfolio. Manage your investment, retirement, mutual fund, or 401(k) accounts, individual stocks, bonds or CDs. Create customized reports for each investment, or use XeCheck’s charts and graphs to give you a snapshot of how well your investments are doing. Compare individual securities against market indices to see what you should sell or keep.
Customizable home pages allow you to set which information you see when you start XeCheck.
