Financial Modeling of Siemens AG:
This course is very useful for the people who are into financial modeling domain – including students and professionals. This course gives a brief idea about the revenue and cost drivers, forecasting the future financials and the stock price recommendation.
This course gives a career prospect to the students who are planning to get a financial analyst job in any brokerage and KPOs. Also it boosts sector expertise of the seasoned professionals who are already working in the financial service domain.
The course is structured to building a financial model from the scratch. In the first section, we go step by step about how to prepare a financial model, starting from data punching to forecasting the future numbers. Also, we talk about sector and economic research reports and their components.
Materials included in the course are company financials, which are taken from the company websites. Apart from that, we have explained the steps in Microsoft power point and used Microsoft excel for building the financial model.
Course Objective:
- To study steps of building financial model
- To enhance the sector expertise
Target Customers:
- Students
- Professionals
- Financial analysts
- Anyone who wants to learn financial modeling and report writing on real estate sector
Pre-Requisites:
- Basic knowledge of financial accounting, ratios
- Concepts of financial management, valuation methodologies
- Basic knowledge on Microsoft excel and word
Section 1 Introduction
1 Introduction to Financial Modeling
2 Course Outline
Section 2 Framework and Prerequisites
3 What is Financial Modeling
4 Framework of the Model
5 Prerequisites
6 Prerequisites Continues
Section 3 Requirements
7 Model Requirements
8 More on Requirements
Section 4 Defining the Need
9 Defining the Need
10 Defining the Need Continues
11 Defining the User
12 Bottom Up Curses Top Down
13 Defining the Macro Environment
14 Impact of Brexit
15 Defining the Sector
16 About the Company
17 Understanding Accounting Equations
Section 5 Starting the Case Study
18 Starting the case study
19 More on Starting Case Study
Section 6 Populating the Historical
20 Populating the Historical
21 Populating the Historical Continues
Section 7 Projecting Income Statement
22 Projecting Income Statement
23 More on Projecting Income Statement
24 Key Data on Siemens
Section 8 Working Capital Schedule
25 Working Capital Schedule
26 Working Capital Schedule Continues
27 Property, Plant and Equipment
28 Understand Intangible Assets
29 Depreciation Schedule
30 Long Term Debt
31 Long Term Debt Continues
32 Equity Schedule
Section 9 Cash Flow Statement
33 Working on Cash Flow Statement
34 More on Cash Flow Statement
35 Short Term Debt
36 Interest Income
Section 10 Calculation
37 Basic Shares Calculation
38 Basic Shares Calculation Continues
Section 11 Checking Errors and Breaking Circularity
39 Checking Errors
40 More on Checking Errors
41 Breaking Circularity
42 Identify Line Items
Section 12 Ratio Analysis
43 Ratio Analysis
44 Ratio Analysis Continues
Section 13 Sensitivity Tables and Scenario Analysis
45 Sensitivity Tables
46 More on Sensitivity Tables
47 Scenario Analysis
48 Scenario Analysis Continues
49 Indexing
Section 14 DCF
50 DCF Introduction
51 Best Practices
52 More on Best Practices
53 Common Mistakes
54 Common Interview questions
55 Common Interview questions Continues
56 PDF,PPT and Excel
