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
Introduction to Financial Modeling
Basic of Financial Modeling
Industry and Historical Information Analysis
Best Practices to Build Financial Model
Basics Of Financial Statements
Step by step Approach to Build Financial Model
The layout of the Financial Model
Financial Statement Concept
Concept-Revenues
Concept-Expenses
Concept-CAPEX and Fixed Assets
Concept-Financing -Debt and Equity
Concept-Working Capital
Concept-Linking Income Statement, Balance Sheet and Cashflow Statement
Layout of the Financial Model
Introduction to Layout
Inputs and Assumptions Sheet
Background of the Company and Past Financials
Background of the Company
Past Financial Statement Analysis
Revenue Model
Part A – Revenue Model
Part B – Revenue Model
Expenses Model
Part A – Expenses Model
Part B – Expenses Model
Part C – Expenses Model
Fixed Asset Schedule
Fixed Assets Model
Financing Schedule
Debt Financing Model
Equity and Preference Capital Model
Working Capital Schedule
Components of cash and non-cash working capital
Forecasting working capital requirements
Building Financial Statements
Projected Income Statement
Projected Balance Sheet
Projected Cash flow Statement
Establish scenario and Sensitivity Analysis
Scenario and Sensitivity Analysis
Ratio Analysis
Ratio Analysis
Valuation Analysis
Part A-F – Various methods of valuation – DCF, Multiples, Comparables, etc
Investment and Exit Analysis
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/projected-balance-sheet
WhatsApp us
Modal title
Main Content