Corporate Finance Modeling Information
What is included
FINANCIAL STATEMENTS ANALYSIS
- Balance sheet, Income statement and Cash flow statement presentation
- A checklists for accurate statements preparation
- Calculation and analysis of liquidity, profitability, structure and efficiency ratio numbers
- Horisontal and vertical analysis and more
FINANCIAL PROJECTIONS
- Revenue, COGS and gross profit projection models
- Headcount and salaries projections
- Overhead costs projections (fixed and variable) based on different assumptions
- Net working capital planning (Account receivable, Inventory and Account payable)
- Projection of debt and interest expenses
- CAPEX projections
- 3 Statements projection with related financial analysis and more
CASH FLOW MANAGEMENT
- Direct vs indirect cash flow method presentation
- Monthly and annually cash flow planning model
- Weekly cash flow forecast model
- Cash KPIs and drivers
- The concept of cash conversion cycle
- Initiatives for cash flow improvement through net working capital optimization
EBITDA
- EBITDA concept explained (when to use, how to calculate, related KPIs)
- Calculation of EBITDA adjustments
- EBITDA controversies
- Tips to improve EBITDA margin
BUSINESS VALUATION
- WACC calculation explained
- Application of discounted cash flow method (free cash flow, discounting factor, terminal value, enterprise value, equity value)
- How to make valuation by (adjusted) EBITDA multiple
- Application method of comparable companies
MATERIALS
- PDF Guide with 150+ pages
- Excel model with 20+ cross-linked sheets of essential corporate finance calculations, projections and valuations (incl. various assumptions, accuracy validations and consistency checks)
- Excel model for weekly cash flow forecast
- Excel model for simple 3 statements monthly and annually planning with visuals
- Excel templates of 6 functional Profit and Loss account (per industries)
- Excel model for EBITDA adjustments
Here’s what you’ll learn
- Build a comprehensive finance model for sustainable growth
- Identify key ares for improvement of financial performance by analysis of financial statements
- Understand and manage KPIs and ratio numbers
- Create a precise forecast and projection of financial statements
- Improve cash flow and net working capital by understanding and planning different factors
- Apply different scenario of revenue, COGS and gross profit forecast
- Perform realistic headcount, salaries, OPEX and CAPEX planning
- Apply different methods in company valuation such as DCF, comparable companies method and valuation by EBITDA multiple
Who is this course for?
- Finance and accounting professionals with responsibility of finance management, budgeting, forecasting and cash flow optimization
- Finance advisors responsible for M&As and business valuations
- Business owners and investors who want to level up a financial health of the company and discover its full earning potential
About Author
- Bojan Radojicic, Senior Partner in international finance and tax firm WTS
- 17+ Years in consulting industry
- Expertise: Corporate finance, IFRS, Valuations, M&A
- Main clients: Heineken, Mercedes Benz, Adecco, New Yorker, Continental, Siemens
Education and professional development
- Master’s degree in Economics, Faculty of Economics, University of Belgrade
- Specialist studies on transfer pricing, Faculty of Law, University of Belgrade
- Acquires professional expertise through active involvement at international tax and finance conferences in world’s leading countries (USA, Germany, Singapore)
- 60.000 followers on LinkedIn
More courses from the same author: Bojan Radojicic
Salepage: Corporate Finance Modeling – Bojan Radojicic