Faculty of Economic and Business Sciences

Financial Modeling
for decision making

The program

In increasingly dynamic environments, business managers need flexible tools that require the proper application of financial principles to make informed decisions. Economic uncertainty and recessionary contexts demand that professionals go beyond basic analysis: they need to build models that allow them to anticipate scenarios, assess risks, and support strategic decisions with precision.

He Specialized Program in Financial Modeling for Decision Making The University of Piura offers participants the opportunity to apply key financial concepts by creating dynamic models in Microsoft Excel. Through this hands-on approach, they will be able to optimize business management and accurately evaluate investment decisions.

It is designed for finance professionals—managers, coordinators, analysts, and assistants—as well as business owners and consultants interested in strengthening their financial management. It is also highly valuable for professionals in other areas (marketing, production, HR, accounting, legal, and auditing) who make decisions with financial impact.

At the end of the program, participants will have developed concrete skills to build financial models from scratch, value companies and startups, apply Monte Carlo simulations, and evaluate real estate projects—all in Excel. They will also receive a Certificate of Specialization in Financial Modeling for Decision Making awarded by the University of Piura, strengthening their professional profile and differentiating them in the labor market.

Goals

General:

Develop dynamic financial models and make informed strategic decisions to face contexts of uncertainty and economic recession.

Specifics:

  • Analyze the company's financial situation through the study of its financial statements and main performance indicators.
  • Identify the main methodologies for business valuation, considering financial and market factors.
  • Design dynamic financial models in Microsoft Excel that incorporate uncertainty variables to improve the accuracy of the analysis.
  • Recognize and apply more specialized financial models (startups, Real Estate, Monte Carlo Simulation).
Teaching methodology

The methodology combines theory and practice to offer a comprehensive learning experience. Each session begins with an explanation of key financial concepts, followed by guided, real-time model building in Microsoft Excel. Case-based learning is used, employing real-world scenarios. Interactive, synchronous online sessions allow for active participation, real-time Q&A, and collaborative work. All classes are recorded so participants can reinforce the material at their own pace.

Mode

The program takes place in synchronous virtual modality, through interactive online sessions. Classes are held on Friday from 7:00 pm to 10:15 pm. and the Saturdays from 9:00 am to 12:15 pm., The course consists of two 90-minute blocks with a 15-minute break per session. Classes will be recorded so participants can review them as needed.

Certification
  • Specialized Program Certificate issued by UDEP: It will be awarded to participants who have passed the program with a minimum grade of twelve (12) and meet a minimum of 80% class attendance.
  • Certificate of participation: This certificate will be awarded to participants who do not pass the program but have a minimum of 80% class attendance. It will only be issued by UDEP.

 

*All certificates will be issued electronically and sent via email. This program does not lead to an academic degree.

Participant profile

The program is designed for those working in finance, such as managers, coordinators, analysts, and assistants, as well as independent professionals. It is also suitable for business owners and consultants interested in financial management.