Finance & Accounting

Financial Modelling and Investment Appraisal

This course equips professionals with essential skills in financial modelling and investment appraisal. Participants will learn to construct robust financial models, evaluate investment opportunities, and make informed financial decisions, enhancing their analytical capabilities and strategic insight in finance-related roles.

5 days Classroom or live online English

Smart Horizon Certified - Global Leadership Consultants

Take the course details with you.

Download the full standard outline: why attend, methodology, objectives, audience, competencies, the daily outline and current plans.

Download course PDF

Why attend

From knowledge to real-world impact.

Financial modelling and investment appraisal are critical for informed decision-making in finance. Professionals often face challenges in accurately forecasting financial performance and assessing project viability. This course addresses these issues by providing practical skills to build financial models that reflect real-world scenarios, enabling participants to analyse cash flows, assess risks, and justify investment choices effectively. By mastering these techniques, attendees will be better positioned to support their organisations in navigating complex financial landscapes, optimising investment strategies, and enhancing overall financial performance through data-driven insights and robust analysis.

Participants will engage in hands-on exercises that simulate actual financial situations, allowing them to apply theoretical knowledge to practical tasks. They will learn to evaluate investment opportunities using various appraisal methods, including NPV and IRR, and develop the ability to communicate their findings persuasively to stakeholders. By mastering financial modelling techniques and investment appraisal methods, attendees will enhance their ability to analyse financial data, justify investment decisions, and contribute to their organisation's financial strategy. This course prepares professionals to tackle complex financial challenges effectively, ensuring they can make sound investment recommendations that align with organisational goals.

Workplace challenges

Professional Problems This Course Is Designed to Solve

The programme explores practical approaches to the following challenges. Results depend on how the learning is applied in your organisation.

Financial models with unclear assumptions or inconsistent structure.
Investment decisions that overlook sensitivity and uncertainty.
Difficulty communicating model results and appraisal trade-offs.

Course methodology

How you will learn.

The course employs a blend of interactive workshops, case studies, and practical exercises to build financial modelling and investment appraisal skills. Participants will work on real-life scenarios, using spreadsheet software to create financial models and conduct investment analyses. Specific exercises will include building dynamic models, performing sensitivity analyses, and presenting findings to peers. Outputs will include detailed financial models, investment appraisal reports, and presentations that demonstrate their analytical findings and recommendations. This hands-on approach ensures that participants not only learn theoretical concepts but also apply them in a practical context, enhancing their confidence and competence in financial decision-making, while fostering collaboration and critical thinking.

Course objectives

What you'll take away.

By the end of this course, participants will be able to:

Construct a comprehensive financial model for a hypothetical project, demonstrating key assumptions and calculations.
Evaluate investment opportunities using Net Present Value (NPV) and Internal Rate of Return (IRR) methods, providing clear recommendations.
Analyse sensitivity and scenario analyses to assess the impact of variable changes on financial outcomes.
Justify investment decisions based on quantitative analysis and qualitative factors, preparing a persuasive presentation.
Compare different investment appraisal techniques, identifying their advantages and limitations in various contexts.
Assess the financial health of a project using key performance indicators (KPIs) derived from the financial model.

Target audience

Who should attend.

This course is suitable for:

Financial Analysts: Enhance skills in financial modelling for investment analysis.
Investment Managers: Improve decision-making capabilities through rigorous appraisal techniques.
Business Development Managers: Assess project viability and investment opportunities effectively.
Corporate Finance Professionals: Strengthen financial forecasting and modelling competencies.

Target competencies

Capabilities you will build.

Participants will develop competencies in:

Developing accurate financial models for diverse scenarios.
Conducting thorough investment appraisals using multiple techniques.
Interpreting financial data to inform strategic decisions.
Communicating complex financial concepts clearly to stakeholders.
Applying sensitivity analysis to evaluate risk in financial projections.
Utilising KPIs to monitor project performance and viability.

Course outline

Your learning journey.

A focused, practical outline with time to explore, apply and reflect.

Day 1Foundations of Financial Modelling

Applied activity: Participants will create a basic financial model for a fictional startup, including revenue projections and cost estimates. They will identify key assumptions and structure the model appropriately, ensuring clarity and accuracy in their calculations.

Output: A foundational financial model spreadsheet with key assumptions, calculations, and a summary of findings.

09:00–09:54Introduction to financial modelling concepts and best practices in finance.
09:54–10:48Overview of financial statements and their interrelationships for modelling.
10:48–11:00Key assumptions in financial modelling: revenue, costs, and capital structure.
11:00–11:30Coffee break
11:30–12:12Key assumptions in financial modelling: revenue, costs, and capital structure. (continued)
12:12–13:06Building a basic financial model structure in spreadsheet software, including inputs and outputs.
13:06–14:00Introduction to Excel functions and tools for financial modelling, focusing on practical applications.

Day 2Investment Appraisal Techniques

Applied activity: Participants will evaluate a proposed investment project using NPV and IRR methods, considering various cost scenarios and revenue projections. They will analyse the results and prepare a summary of their findings and recommendations for stakeholders.

Output: An investment appraisal report with calculations, recommendations, and a clear rationale for the investment decision.

09:00–09:54Understanding investment appraisal: purpose and importance in project evaluation.
09:54–10:48Detailed exploration of NPV and IRR calculations, including practical examples.
10:48–11:00Comparative analysis of payback period and profitability index for investment decisions.
11:00–11:30Coffee break
11:30–12:12Comparative analysis of payback period and profitability index for investment decisions. (continued)
12:12–13:06Introduction to risk assessment in investment decisions, including qualitative and quantitative factors.
13:06–14:00Real-world case studies of investment appraisal applications to reinforce learning.

Day 3Advanced Financial Modelling Techniques

Applied activity: Participants will enhance their financial model by incorporating sensitivity analysis to assess the impact of changes in key assumptions on project viability. They will document their findings and prepare to present the results to their peers.

Output: An updated financial model with sensitivity analysis results, documentation, and a summary of key insights.

09:00–09:54Incorporating advanced Excel functions for financial modelling, including lookups and data tables.
09:54–10:48Building dynamic models with scenario and sensitivity analysis to assess risk.
10:48–11:00Integrating financial statements into a cohesive model for comprehensive analysis.
11:00–11:30Coffee break
11:30–12:12Integrating financial statements into a cohesive model for comprehensive analysis. (continued)
12:12–13:06Forecasting cash flows and understanding working capital requirements for projects.
13:06–14:00Best practices for model documentation and version control to ensure accuracy and reliability.

Day 4Evaluating Investment Risks and Returns

Applied activity: Participants will conduct a risk assessment for their financial model, using Monte Carlo simulations to evaluate potential outcomes and risks associated with the investment. They will prepare a report summarising their findings and recommendations for risk mitigation.

Output: A risk assessment report detailing findings, recommendations, and strategies for managing identified risks.

09:00–09:54Identifying and quantifying investment risks in financial models, including market and operational risks.
09:54–10:48Using Monte Carlo simulations for risk assessment and understanding variability in outcomes.
10:48–11:00Understanding the role of qualitative factors in investment decisions and their implications.
11:00–11:30Coffee break
11:30–12:12Understanding the role of qualitative factors in investment decisions and their implications. (continued)
12:12–13:06Developing a risk management framework for projects to mitigate potential issues.
13:06–14:00Case studies on risk evaluation in investment projects to illustrate best practices.

Day 5Integrated Financial Analysis and Decision Making

Applied activity: Participants will work in teams to present a comprehensive investment analysis, integrating their financial models and appraisal techniques. They will justify their recommendations to a panel of stakeholders, simulating a real-world investment decision-making environment.

Output: A presentation and detailed investment analysis report, including financial models and justifications for investment decisions.

09:00–09:54Combining financial modelling and investment appraisal for comprehensive analysis of projects.
09:54–10:48Preparing and delivering effective presentations of financial findings to stakeholders.
10:48–11:00Utilising feedback to refine financial models and appraisals for continuous improvement.
11:00–11:30Coffee break
11:30–12:12Utilising feedback to refine financial models and appraisals for continuous improvement. (continued)
12:12–13:06Collaborative decision-making in investment scenarios, emphasising teamwork and communication skills.
13:06–14:00Final project: integrating all learned skills into a cohesive analysis and presentation.

The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.

Dates & venues

Find a session that works for you.

Confirmed dates accept registration requests. Tentative dates are enquiry only.

Good to know

A few things to know.

How is the course delivered?

Our classroom programmes combine facilitated discussion, case studies, exercises and reflection. The precise format will be confirmed before enrolment.

Can you deliver this programme for our team?

Yes, you can enquire about a tailored programme. Share your goals, group size and preferred dates with our learning team.

Will I receive a certificate?

Participants who complete the programme receive a Smart Horizon certificate of attendance. Smart Horizon programmes are not externally accredited and do not award a professional qualification, licence or designation. Where a course title or outline refers to a professional certification (for example, AACE International's Certified Cost Professional), the programme supports learning and preparation only; the credential itself is awarded solely by the relevant professional body under its own application and examination requirements.

What should I confirm before booking travel?

Please confirm the session, exact venue, accessibility arrangements, fees and any visa requirements with the team before arranging travel. Tentative dates are not confirmed sessions.

Keep exploring

Your next horizon awaits.

All courses

The full course agenda and dates are available above. Use the session links in Dates & venues to choose a session. Registration and quotation forms require JavaScript; you can also contact our learning team directly.