GitHunt
AR

aronm88/EXCEL_Financial_Modelling

Financial modelling including P&L, Balance Sheet, Cash Flow, NPV, IRR, sensitivity snalysis

Financial model of old doughnut shop franchise

A financial model is a complex financial simulation run in an Excel file. The financial model includes three key elements of the financial statements:

  1. Income Statement
  2. Balance sheet
  3. Cash flow statement

The elements of the report allow the franchise owner, with the help of variables, to properly assess the viability of his business plan and, most importantly, to highlight the key elements of the business that will guarantee success: positive discounted cash flows (NPV) and the desired level of rates of return (IRR)

The financial model was created in 2020 based on my own assumptions and Internet research

Contributors

Created December 26, 2022
Updated February 29, 2024