Faculty of Economic and Business Sciences

Financial Modeling
for decision making

Module 1: Operational Funding Requirements Model

The Working Capital Requirements (WCR) model analyzes the relationships between the main accounts in the financial statements. It is a complementary approach to analysis using financial ratios.

  • Definition of the NOF Model
  • Interrelationship between operating accounts and company results.
  • Impact of business decisions on the operational need for funds.

Module 2: Self-Sustaining Growth Model

A practical application of the Net Working Capital Model is determining the funding needs to finance company growth. This module develops an initial model that allows for the analysis of this need.

  • Self-sustaining growth model.
  • Low or high scale growth.
  • Special cases and adjustments to the NOF model

Module 3: Introduction to Financial Modeling

Financial models allow us to quantify our expectations about a company's future performance. Through this module, participants will learn to create a model in Microsoft Excel from scratch.

  • Basic concepts of financial modeling.
  • Methods for projecting income.
  • Financial model for the projection of Financial Statements.

Module 4: Modeling for business valuation

There are different methods for valuing a company, such as Discounted Cash Flow and the use of multiples. Participants will learn to create financial models using these methodologies to calculate a company's value. They will also learn to incorporate risk analysis into their models.

  • Reasons to value a company.
  • Difference between price and value.
  • Methodologies for business valuation.
  • WACC: theory and calculation.
  • Discounted Cash Flow Model in Excel.
  • Multiples model in Excel.
  • Risk analysis: sensitivity and scenarios.
  • Valuation by the “sum of the parts” (SOTP).

Module 5: Monte Carlo Simulation

Monte Carlo Simulation is a methodology that allows us to create numerous (hundreds, thousands, etc.) scenarios through modeling the random behavior of one or more variables.

  • Basics of Monte Carlo simulation.
  • Practical application in Microsoft Excel.

Module 6: Startup Valuation

The startup ecosystem in Peru has experienced significant and rapid growth in recent years. According to data from the Peruvian Seed Capital Association (PECAP), investment in innovative ventures in 2020 grew by more than 1001% compared to 2019. Therefore, it is important for participants to learn the methodologies for valuing startups.

  • Venture Capital Firms.
  • Startup valuation models.

Module 7: Financial Models for Real Estate

Real estate projects require significant investment flows, making a proper evaluation essential. Participants will learn not only how to calculate the profitability of a real estate project but also how to structure its financing.

  • Analysis of a real estate project in Excel: assumptions and development of the model.
  • Project financing plan.

*One class hour is equivalent to 45 minutes.

The University of Piura reserves the right to postpone, reschedule, or cancel the program if the minimum number of participants is not met. Special sessions and exams may be scheduled outside of regular class hours, after prior notification to the students.