Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Financial Modeling for Business Analysts and Consultants

Introduction :
What the course will be about
About me
Difference between financial model and business model


Modeling of Profit & Loss Account :
Profit and loss intro
Sales
Materials and Energy
External services
Taxes & Payments
Payroll
Other Costs


Capex and Depreciation :
Modeling Capex and depreciation - introduction
Intangibles - modeling of gross value, net value and depreciation
Machinery - modeling of gross value, net value and depreciation
Adding depreciation to the P&L


Working Capital :
Introduction to Working Capital
Inventory of materials, WIP and finished goods
Receivables
Liabilities
Corporate tax and final working capital estimation


Debt :
Introduction to debt modeling
Old loans
New loan
Interest paid and interest earned


Equity :
Introduction to Equity
Equity modeling


Balance sheet modeling :
Introduction to Balance sheet modeling
Fixed assets
Current Assets
Own capital
Current liabilities
Balance sheet - summary


Cash flow modeling :
Cash Flow introduction
Operational cash flows
Investment cash flows
Cash flow from financial activities
Shareholders influence on Cash Flow
Final Cash Flow


Analyses of the Financial Model :
Introduction to Analyses
Profit & Loss analyses
Cash Flow analyses
Possible improvements to be further analysed


Business Modeling - examples :
Introduction to business modeling
Difference between financial model and business model
Mechanics of business model for a consulting firm
The business model of a consulting firm in Excel - Capacity and revenues
The business model of a consulting firm in Excel - costs and profit & loss
E-commerce Introduction
E-commerce business model
Business model of a restaurant in Excel - basic model
Business model of a restaurant in Excel - advanced model


Conclusions :
Bonus Lecture: 60% off for all my courses

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396