Financial Modeling in Excel - DCF Model of Big Books Corp

- Description
- Curriculum
- FAQ
- Reviews
Any one interested in a career in Finance and Financial Analyst Industry, This course is a must. Many students and professionals assume that their chances of making an Analyst career in Finance Industry are bleak if they are not from the top tier colleges. However, we have seen industry trends where skilled students and professionals from lesser known universities and companies making into big financial firms and organizations. Universities are very limited in their curriculum as they are mostly restricted to focus on theoretical aspects than actual practical know-how. Financial Analyst Training involves analyzing companies’ financials in detailed manner. Analysis is conducted through a composite of financial records, news and interviews with company insiders. It is also known as securities research or Fundamental Analysis. It consist of the sell side research i.e. when research done by analyst are provided to their clients and also buy side research i.e. when analyst do research and use it to invest their firm’s money. The work within Financial Analysis mainly revolves around Financial Modeling Techniques, forecasting, valuations like DCF and Relative Valuations (estimate growth rate and valuations for companies in future). Financial modeling involves designing and building calculations to assist in decision-making. Learning how to build models with complexity in an accurate, robust, and transparent way is an essential skill in the modern workplace. The goal isn’t to teach you how to memorize Excel Models but to actually learn the skills to generate your own reports with a clear idea of how to structure a financial report so it has maximum flexibility. And by the end of this course, you will learn how to build effective, robust, flexible financial models. In this you will learn the following:
- Valuations in details
- Financial Modeling where in we will study in details the balance sheet, income statements, cash flow, projections etc along with the financial model in practical.
-
3Segment Wise Revenue CalculationsVideo lesson
-
4Revenue Forecasting - Notebook SegmentVideo lesson
-
5Purpose of Buiding a Financial ModelVideo lesson
-
6Calculating the Total Revenue from All SegmentsVideo lesson
-
7Calculating Cost of SalesVideo lesson
-
8Calculating SG and A ExpensesVideo lesson
-
9Linking Revenue and ExpensesVideo lesson
-
10Depreciation and Gross PPEVideo lesson
-
11Understanding Capital ExpenditureVideo lesson
-
12Calculating Segment wise CapexVideo lesson
-
13Depreciation InputsVideo lesson
-
14Depreciation Calculation - Machinery and EquipmentsVideo lesson
-
15Depreciation Calculations ContinuedVideo lesson
-
16Amortization CalculationsVideo lesson
-
17Linking Depreciation and AmortizationVideo lesson
-
18Building the Cash Flow StatementVideo lesson
-
24Share Repurchase ForecastVideo lesson
-
25Share Repurchase Forecast ContinuedVideo lesson
-
26Shares OutstandingVideo lesson
-
27Other Assets and LiabilitiesVideo lesson
-
28Forecasting DebtVideo lesson
-
29Interest Expense and Interest IncomeVideo lesson
-
30Completing the Missing LinksVideo lesson
-
31Checking the DashboardVideo lesson
-
32DCF Analysis OverviewVideo lesson
-
33Free Cash Flow to the FirmVideo lesson
-
34Free Cash Flow to the Firm ContinuedVideo lesson
-
35Free Cash Flow to EquityVideo lesson
-
36Net Operating Profit After TaxVideo lesson
-
37Complete Equity BusinessVideo lesson
-
38Building the DCF ModelVideo lesson
-
39Risk-free Rate and BetaVideo lesson
-
40Cost of Capital CalculationVideo lesson
-
41WACC CalculationVideo lesson
-
42Beta CalculationVideo lesson
-
43Understanding the WACC ConceptVideo lesson
-
44NPV of Explicit PeriodVideo lesson
-
45Enterprise ValueVideo lesson
-
46Share Price- Forecast 1 and 2Video lesson
-
47Share Price- Forecast 1 and 2 ContinuedVideo lesson

External Links May Contain Affiliate Links read more