A Complete Financial Analyst Course Udemy Free Download
What you'll learn:
- 22+ hour complete financial analyst course!
- #1 Best Selling Investing Course on Udemy!
- How to pick stocks.
- Become an expert in Excel for financial analysts (no prior Excel knowledge is required).
- How to manage a portfolio.
- How an IPO works.
- How to build financial models.
- How to get hired and promoted as a financial analyst.
- How risk management works.
- How to use technical analysis.
- How to value companies.
- Use and create Excel based templates developed by Chris to help you create financial statements from scratch (meaning income statements, balance sheets, cash flow statements and more).
- Use and create Excel based templates developed by Chris to help you value companies using several different valuation methodologies, including P/E, P/R and Discounted Cash Flow (DCF).
- Use and create Excel based templates developed by Chris to help you manage a portfolio.
- How Monetary Policy works.
- How Fiscal Policy works.
- How interest rates are changed and why this is crucial to understand for successful financial analysts.
- How to pitch long and short ideas to portfolio managers.
- How to find great venture capital investment ideas.
- How to come up with mutual fund investment ideas (longs – meaning buys) using an easy to understand top down and bottoms up research process.
- How to come up with hedge fund investment ideas (longs and shorts) using an easy to understand top down and bottoms up research process.
- Identify crucial catalysts (timed events) in order to know when the optimal time is to buy or short a stock.
- Understand how investment banks (the ‘Sell Side’) can help you be more successful in a hedge fund or mutual fund career.
- Analyze and understand an income statement (even if you have no experience with income statements).
- Analyze and understand a balance sheet (even if you have no experience with balance sheets).
- Analyze and understand a cash flow statement (even if you have no experience with cash flow statements).
- Understand and use modeling best practices so you can create financial models.
- Know where to get data in order to build a financial model (in depth understanding of identifying and using/navigating the best free websites and sources to build your financial model)!
- Create a financial model (projecting the future) for an income statement.
- Other valuation methodologies, including EV/Sales, EV/EBITDA, P/B, EV/FCF, etc.
- Create a financial model (projecting the future) for a balance sheet.
- Create a financial model (projecting the future) for a cash flow statement.
- Understand valuation best practices so you can create target prices based on your financial models.
- How to use Discounted Cash Flow (DCF) and how to create the Weighted Average Cost of Capital and Terminal values in order to pick target prices.
- How to use P/E in order to pick target prices.
- How to use P/R in order to pick target prices.
- Come up with a target price based on an average of several different valuation methodologies.
- Learn about 14 different Financial Analyst jobs and how they overlap and work together (including Investment Banking, Venture Capital, Private Equity, Private Wealth Management etc.).
- Investment Banking: Understand from a high level perspective what an Investment Bank is as well as what the role/job is of an Investment Banking Financial Analyst, including the pros and cons.
- Venture Capital: Understand from a high level perspective what a Venture Capital firm is as well as what the role/job is of a Venture Capital Financial Analyst, including the pros and cons.
- Private Equity: Understand from a high level perspective what a Private Equity firm is as well as what the role/job is of a Private Equity Financial Analyst, including the pros and cons.
- Private Wealth Management: Understand from a high level perspective what a Private Wealth Management firm is as well as what the role/job is of a Private Wealth Management Financial Analyst, including the pros and cons.
- Sell Side Research Analyst: Understand from a high level perspective what a Sell Side Research Analyst’s firm is as well as what the role/job is of a Sell Side Research Financial Analyst, including the pros and cons.
- Sales Trader: Understand from a high level perspective what a Sales Trader’s firm is as well as what the role/job is of a Sales Trader Financial Analyst, including the pros and cons.
- Buy Side Trader: Understand from a high level perspective what a Buy Side Trader’s firm is as well as what the role/job is of a Buy Side Trader Financial Analyst, including the pros and cons.
- Mutual Fund: Understand from a high level perspective what a Mutual Fund is as well as what the role/job is of a Mutual Fund Financial Analyst, including the pros and cons.
- Sell Side Trader: Understand from a high level perspective what a Sell Side Trader’s firm is as well as what the role/job is of a Sell Side Trader Financial Analyst, including the pros and cons.
- Large Non Finance Company: Understand from a high level perspective what a Large Non Finance Company firm is as well as what the role/job is of a Large Non Finance Company Financial Analyst, including the pros and cons.
- Equity Capital Markets: Understand from a high level perspective what an Equity Capital Markets’ firm is as well as what the role/job is of a Equity Capital Markets Financial Analyst, including the pros and cons.
- Hedge Fund: Understand from a high level perspective what a Hedge Fund is as well as what the role/job is of a Hedge Fund Financial Analyst, including the pros and cons.
- Equity Sales: Understand from a high level perspective what an Equity Sales’ firm is as well as what the role/job is of an Equity Sales Financial Analyst, including the pros and cons.
- Tech / Artificial Intelligence: Understand from a high level perspective what a Tech / Artificial Intelligence’s firm is as well as what the role/job is of a Tech / Artificial Intelligence Financial Analyst, including the pros and cons.
- Learn what finance role you are most passionate about pursuing.
Requirements::
- Anyone can take this course (no prior knowledge of finance or Excel is required)! I recommend having the latest version of Excel if you want to complete all of the Excel exercises (the Windows and Mac versions of Excel both work with all downloadable files in this course).
Description:
OVERVIEW - Updated October 2021.
Financial Modeling is an essential skill for accounting and finance professional. It is very much in demand in the job market and is highly valued by employers.
Our Financial Modeling training takes you from basics to professional level. This sixteen hours training is based on practical exercises
The course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and Finance
DETAILED CONTENT
1. Introduction to Excel
2. Useful tips and tools for your work in Excel
3. Keyboard shortcuts in Excel
4. Excel's key functions and functionalities made easy
5. Update! SUMIFS
6. Financial functions in Excel
7. Microsoft Excel's Pivot Tables
8. Building a complete P&L in Excel - Case Study
9. Introduction to Excel charts
10. Profit and Loss - Case Study
11. Statement of Financial Position - Case Study
12. Statement of Cash Flows - Case Study
13. Financial modeling fundamentals
14. Introduction to Company Valuation and Introduction to Mergers & Acquisitions
15. Learn how to build a Discounted Cash Flow model in Excel - NPV and IRR
16. Investment Appraisal - Case Study
17. Business Valuation - Case Study
18. Capital Budgeting - The theory
19. Capital Budgeting - Case Study
20. Impact of interest rates and exchange rates on NPV
21. Sensitivity Analysis in Capital Budgeting
PREREQUISITES
1. Participants are expected to have basic knowledge of MS Excel. This could be measured as an MS Excel user for more than one year.
2. Basic knowledge of financial accounting.
3. Microsoft Office 2013 or later installed on your computer.
Who this course is for:
- Accounting and Finance professionals as well as accounting and finance students.
Course Details:
- 16 hours on-demand video
- 9 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion