Learn stock fundamental analysis main concepts from basic to expert level through a practical course with Excel.

STOCK FUNDAMENTAL ANALYSIS WITH EXCEL
Learn stock fundamental analysis main concepts from basic to expert level through a practical course with Excel.
Created by Diego Fernandez
Last updated 11/2016
English

What Will I Learn?

• Understand main financial statements: balance sheet, income statement and cash flow statement.
• Interpret financial ratios to analyze a company’s operations, investments, liquidity, solvency, and profitability.
• Comprehend investment ratios to evaluate a company’s relationship between its financials and stock price, enterprise value, and corresponding yields.
• Define a company’s cost of equity through CAPM, Fama-French factors and APT models and also its cost of capital through WACC model.
• Valuate a company’s theoretical stock price through economic value added (EVA) and discounted cash flow (DCF), models.
• Calculate a company’s stock option prices through Black & Scholes, Binomial models, and Monte Carlo Simulation method.
• Explore the wisdom of best practitioners (Graham, Lynch, Greenblatt) and Nobel prize winners (Shiller, Fama, Sharpe) among many others.

Requirements:

• Spreadsheet software such as Microsoft Excel is required.
• Practical example spreadsheet provided by the instructor.
• Prior basic spreadsheet software knowledge is recommended.

Description:

Course video lectures, content slides and Excel file constantly updated (latest: Nov 2016, audio re-editing)

Learn stock fundamental analysis through a practical course with Excel and real-world examples. It explores main concepts from basic to an expert level which will help you achieve better grades, review concepts and polish skills for your new finance career or make decisions as a DIY investor. All of this while referencing best practitioners and Nobel Prize winners.

Become a Stock Fundamental Analysis Expert in this Practical Course with Excel

• Understand main financial statements.
• Interpret financial and investment ratios.
• Define a company’s cost of equity, debt, and capital.
• Valuate a company’s theoretical stock price.
• Calculate a company’s stock option prices.
• Explore the wisdom of best practitioners and Nobel Prize winners.

Become a Stock Fundamental Analysis Expert and Put Your Knowledge into Practice

Learning fundamental equity analysis is essential for careers in finance in areas such as equity research, investment banking, private equity or venture capital. It is also indispensable for academic careers in finance or business research. And it's one of the two most common analytical techniques for DIY investors.

But as the learning process can become difficult as complexity increases, this course helps you by guiding you step by step real-world examples for greater efficiency.

Content and Overview:

This hands-on course contains 50 classes and 10 hours of content. It is designed for all levels of financial stock analysis knowledge and a basic understanding of Excel is recommended.

In the beginning, you will understand the main financial statements which are the balance sheet, the income statement and the cash flow statement. With these, you will calculate financial ratios to analyze the operations, investments, liquidity, solvency, and profitability of a company. Then you will estimate the investment ratios with stock market data such as P / E and dividend yield for valuation purposes.

After that, you will calculate the cost of a company's equity, debt, and capital with the CAPM, Fama-French, APT, and WACC models. With these, you will estimate the theoretical stock value of a company through the EVA, DCF models and make an evaluation by comparing it to its market price.

Finally, you will calculate the prices of the financial options of an action with the Black & Scholes, Binomial and Monte Carlo Simulation models.

Who is the target audience?

• Students at any knowledge level who want to learn about stock fundamental analysis.
• DIY investors also at any knowledge level who desire to learn about stock fundamental analysis and put it into practice.
• Finance interns or analysts who wish to review concepts and polish skills.
• This course is NOT aimed at investors seeking to day trade stocks or options.
• This course is NOT about “get rich quick” trading systems or magic formulas.

Tutorial Size: 1.5GB

Source: https://www.freetutorials.us/stock-fundamental-analysis-with-excel/

Download Tutorial

SHARE THIS