Accounting Policies and Procedures
Next: 16 - 20 Nov 2026 · Istanbul
Istanbul, Vienna, Geneva +4 more
Professional training course · F01
Financial Analysis Modeling and Forecasting
Financial professionals are often asked to provide analysis and projections of finances to help management make decisions. By attending this course, you will be able to…
- 5 daysClassroom
- 13Upcoming dates
- 7Cities
- £2,850Fees from
Course overview
Why Attend
Financial professionals are often asked to provide analysis and projections of finances to help management make decisions. By attending this course, you will be able to prepare and build financial analysis models effectively, understand and analyze the time value of money, and prepare forecasted financial statements.
Course Methodology
The course is a hands-on workshop that applies MS Excel to model financial analysis and forecasting through different exercises and case studies.
Course Objectives
By the end of the course, participants will be able to:
- Use financial ratio analysis to interpret organizational financial performance and position
- Calculate financial ratios related to the cash flow statement
- Utilize Microsoft Excel in the time value of money calculations
- Apply MS Excel modeling tools and functions such as spinner, list box, option button, etc.
- Forecast and build models for the three main financial statements
Target Audience
Financial controllers, analysts, finance and accounting managers, supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create financial forecast models in their organizations.
Target Competencies
- Understanding and performing financial analysis
- Performing vertical, horizontal, and trend analysis
- Financial forecasting
- Modeling financial statements
- Applying Excel functions and tools
Course outline
-
1Day 1: Financial Analysis Techniques
- Vertical analysis and strategy
- Horizontal, trend analysis, and growth
-
2Day 2: Liquidity analysis & Asset management and activity ratios and more
- Liquidity analysis
- Current, quick, and cash ratios, defensive interval, and cash conversion cycle
- Asset management and activity ratios
- Total and fixed assets turnover
- Solvency analysis
- Debt, equity, and times interest earned ratios
- Profitability analysis
- Profit margin, gross margin, return on assets, return on equity, EBITDA
- Market and valuation
- Price earnings and earnings-per-share ratios
- DuPont analysis: The three-step and five-step models
- Limitation of ratio analysis
- Cash flow statement: Interpretation and ratio analysis
- Cash flow categories: Operating, investing, and financing
- Cash flow pattern; the cash cow
-
3Day 3: Cash-flow-related ratios & Financial calculations in MS Excel
- Cash-flow-related ratios
- Quality of earnings
- Financial management
- Mandatory cash flow
- Discretionary cash flow
- Financial calculations in MS Excel
- Time value of money:
- Present Value (PV) and Net Present Value (NPV)
- Internal Rate of Return (IRR) and Multiple IRR (MIRR)
- Using XNPV and XIRR
- Effective yields and returns
-
4Day 4: Model construction techniques using Excel & Modeling projected financial statements
- Model construction techniques using Excel
- Data tables
- Goal seek
- Spinner data modeling
- List box data modeling
- Option box data modeling
- Modeling projected financial statements
- Micro and macro factors
-
5Day 5: Forecasting sales
- Estimating market demand
- Estimating company demand
- Developing sales forecast
- Forecasting cost of sales
- Forecasting operating expenses
- Forecasting key assets and liabilities accounts
- Modeling the income statement
- Modeling the balance sheet
- Modeling the cash flow statement
Dates and fees
Questions
Frequently asked questions
How long is the Financial Analysis Modeling and Forecasting course?
The course runs over 5 days of classroom training, usually Monday to Friday.
When is the next Financial Analysis Modeling and Forecasting course?
The next public date is 21 - 25 Dec 2026 in Barcelona. There are 13 upcoming dates in total.
Where is this course held?
Upcoming sessions run in Barcelona, Amsterdam, London, Istanbul, Vienna, Paris, Frankfurt.
How much does the course cost?
Fees start from £2,850 + VAT per delegate, depending on the city. Fees include tuition and course materials.
Do participants receive a certificate?
Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.
Can this course be delivered in-house for our team?
Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.
Course information last updated 14 November 2026.
Related
More Accounting and Finance courses
Accounts Payable: Accounting and Management Best Practices
Next: 16 - 20 Nov 2026 · Rome
Rome, Munich, Barcelona +2 more
Activity-Based Costing and Profitability Analysis
Next: 7 - 11 Dec 2026 · Frankfurt
Frankfurt, London, Barcelona +9 more