Build your career with our industry-related courses. call us now at +65 9730 4250
All Categories
Public Training
E-learning
Home
About Us
Contact Us
FAQs
Public Training
IBF Courses
Corporate Valuation Techniques Applications
Other Services
E-Learning
In-House Training
Customized Training
X
Try for free
Financial Modeling in Excel
Curriculum
14 Sections
33 Lessons
8 Hours
Expanse all sections
Collapse all sections
Introduction to Financial Modeling
6
2.1
Basic of Financial Modeling
2.2
Industry and Historical Information Analysis
2.3
Best Practices to Build Financial Model
2.4
Basics Of Financial Statements
2.5
Step by step Approach to Build Financial Model
2.6
The layout of the Financial Model
Financial Statement Concept
6
3.1
Concept-Revenues
3.2
Concept-Expenses
3.3
Concept-CAPEX and Fixed Assets
3.4
Concept-Financing -Debt and Equity
3.5
Concept-Working Capital
3.6
Concept-Linking Income Statement, Balance Sheet and Cashflow Statement
Layout of the Financial Model
2
4.1
Introduction to Layout
4.2
Inputs and Assumptions Sheet
Background of the Company and Past Financials
2
5.1
Background of the Company
5.2
Past Financial Statement Analysis
Revenue Model
2
6.1
Part A – Revenue Model
6.2
Part B – Revenue Model
Expenses Model
3
7.1
Part A – Expenses Model
7.2
Part B – Expenses Model
7.3
Part C – Expenses Model
Fixed Asset Schedule
1
8.1
Fixed Assets Model
Financing Schedule
2
9.1
Debt Financing Model
9.2
Equity and Preference Capital Model
Working Capital Schedule
2
10.1
Components of cash and non-cash working capital
10.2
Forecasting working capital requirements
Building Financial Statements
3
11.1
Projected Income Statement
11.2
Projected Balance Sheet
11.3
Projected Cash flow Statement
Establish scenario and Sensitivity Analysis
1
12.1
Scenario and Sensitivity Analysis
Ratio Analysis
1
13.1
Ratio Analysis
Valuation Analysis
1
14.3
Part A-F – Various methods of valuation – DCF, Multiples, Comparables, etc
Investment and Exit Analysis
1
15.1
Investment and Exit Analysis
This content is protected, please
login
and
enroll
in the course to view this content!
course/financial-modeling-in-excel/lessons/components-of-cash-and-non-cash-working-capital
WhatsApp us
Modal title
Main Content