OBGP 3245 - Financial Modeling in Business and Project Financing

This course aims to provide students with a comprehensive understanding of financial modeling concepts, practical applications, and advanced techniques, which can be applied to various business and project financing scenarios. This course can help students develop a range of professional skills, both hard skills and soft skills that are highly valued by employers in the finance and business industries. The course covers topics such as time value of money, financial statements and ratio analysis, budgeting and forecasting, DCF analysis, sensitivity analysis, risk analysis, and financial modeling for business decision-making and project financing.

Learning Outcomes

1. Understand the fundamental concepts of financial modeling, including time value of money, financial statements, and ratio analysis.
2. Be able to create a financial model and perform a DCF analysis using Excel.
3. Be able to conduct a sensitivity analysis and to evaluate the impact of different scenarios using Excel
4. Present financial modeling results effectively using Excel and Powerpoint
Professional Skills

Hard skills:
Financial analysis and financial modeling skills: Students will learn how to analyze financial data, identify trends, and make predictions about future financial performance, how to create financial models using Excel, including Discounted Cash Flow (DCF) analysis and sensitivity analysis. Decision-making skills: Students will learn how to use financial models to make informed business decisions, including investment decisions, financing decisions, and project evaluation.

Soft skills:
IT skills: ability to use excel as a simulation tool
Communication skills: Students will learn how to effectively communicate financial information and analysis to non-technical stakeholders, such as project sponsors, investors, and senior management.
Collaboration skills: Students will learn how to work effectively in teams to create financial models and analyze financial data.
Time management skills: Students will learn how to manage their time effectively to meet deadlines and work on multiple projects simultaneously.
Attention to detail skills: Students will learn how to pay attention to detail when creating financial models, analyzing data, and presenting results.
Problem-solving skills: Students will learn how to use financial models to solve complex business problems and make informed decisions.

Olivier BEGUIN

Séminaire

English

- Attendance: 2 hours a week / 24 hours a semester
- Online learning activities: xx hours a week / xx hours a semester
- Reading and Preparation for Class: 2 hours a week / 24 hours a semester
- Research and Preparation for Group Work: 5 hours a week / 60 hours a semester
- Research and Writing for Individual Assessments: 5 hours a week / 60 hours a semester

Students must have completed an introductory course in accounting and management tools that give them knowledge of financial statements, financial analysis. Financial Skills for Project Managers at PSIA (code OBGP3245) is such a course.

Autumn and Spring 2023-2024

This course evaluation will be based on continuous assessment.
20% Take home paper (individual): paper on a theme linked to project finance
30% Case study 1 in group
40% Final case study in group, including an oral presentation of results
10% Participation

Assessments aim to measure the development of both technical skills and soft skills. Feedback will be provided to each student in class with guidance on each criteria