
Publication number: ELQ-27936-1
View all versions & Certificate

Financial Modeling In a Nutshell
Financial Modeling Guide with Free Excel Model Sample
MBA Candidate | Private Equity | Venture Capital | Financial Modelling | StrategFollow 26
Description
A step-by-step guide on how to design and structure a Financial Model, including Scenario Analysis and Valuation.
I remember the first model I built in 2005. It was awful: terrible design, bad structure, calculations’ drawbacks, etc. Since that time I have made dozens of different models. There were one-page high-level models, “normal,” and complicated multi-scenario fully automated ones. They were used by large
corporations, start-ups, Private Equity Funds, and Investment companies. I have learned something since 2005 and wish to share some insights into financial modelling.
The financial model can be viewed as an attempt to forecast future business dynamics. It serves the goal of evaluating investment project or the whole firm.
The most common approach to doing it is to forecast Free Cash Flow (FCF). Quick remind - there are three different types of FCF: Free Cash Flow to Firm (Project), Free Cash Flow to Equity, and Cash Flow to Lenders, which is simply principal repayment.
Model Features:
1. Two scenarios tied to the prospective growth rate of business;
2. Growth rate reflects Occupancy rate of rooms;
3. Revenue is divided into three business segments: Rooms, Restaurant, and Other Services;
4. Costs include COGS, SG&A, Interest, and Depreciation;
5. Debt Repayment is based on annuity;
6. Two types of CAPEX: rooms-related and management software purchase;
7. Option to calculate results with or without potential acquisition;
8. Interest rate increases in case of acquisition due to increased default risk;
9. Two WACC calculation: based on firm's data and industry average;
10.Target's EBITDA normalization is based on Target's owner salary. The underlying assumption is that this expense will no longer exist after the
acquisition.
- Vladimir Baydin, PhD
This Best Practice includes
1 Word Document, 1 Excel Model Sample
Vladimir Baydin Ph.D. MB offers you this Best Practice for free!
download for free
Add to bookmarks
Further information
Create Financial Models
You want to perform: Forecasting, Valuation, Performance Indicators, Scenario Analysis
Budgeting, Financial Analysis
Reviews
4.6 / 5 (36 votes)- 78%
- 14%
- -
- 6%
- 3%
- Rate this Downloadable Best Practice
Write a review
Waleed Zahran(last updated: 16/10/2020 16:05)
Adib Basbous(last updated: 10/09/2020 07:53)
Kenneth Nwakanma(last updated: 02/03/2020 11:52)
Sylvia Rhodes(last updated: 15/11/2019 07:00)
Melisa Tao(last updated: 27/09/2019 03:02)
Muhammad Ridwan(last updated: 20/09/2019 12:00)
Bibars(last updated: 11/09/2019 16:54)
Sylvia Islam(last updated: 11/09/2019 07:10)
Amir Ganic(last updated: 18/07/2019 13:53)
Allan Otieno(last updated: 27/05/2019 14:52)
Aiga Galvane(last updated: 03/04/2019 22:08)
Ashiq Hossain(last updated: 15/01/2019 12:28)
achmat affandi(last updated: 25/12/2018 14:51)
Ramon Suarez Jr(last updated: 05/12/2018 15:09)
Wabo Majavu(last updated: 18/11/2018 18:29)
Emmanuel Egbumokei(last updated: 18/10/2018 12:05)
Yasser Almutlaq(last updated: 20/09/2018 08:38)
Sandip Modha(last updated: 19/09/2018 20:48)
Jaime Rosado Martínez(last updated: 06/09/2018 17:26)
Eiad Al Saba(last updated: 06/09/2018 07:07)
RAJU G V V S(last updated: 08/08/2018 15:46)
dasha smirnova(last updated: 13/06/2018 19:44)
Wilopski(last updated: 12/06/2018 08:44)
Stephen Wachira(last updated: 07/06/2018 13:21)
Allen Chng(last updated: 13/05/2018 01:21)
PV Kanthi Rekha(last updated: 12/05/2018 03:15)
Don Donowitz(last updated: 29/04/2018 07:34)
Gershon Koh(last updated: 24/04/2018 01:52)
Long Lê(last updated: 25/03/2018 17:04)
InspirationVery well explainedCamron Miraftab(last updated: 13/03/2018 14:45)
People using this Best Practice also downloaded
Complete Private Equity Model
Complete financial model for valuing, forecasting, and acquiring companies in the form of private equity investments.investmentfinancevaluationleveraged buyoutdcf2,991Discussadd_shopping_cart$199.00by DW Financial Services
Consulting Projects - Full Excel Financial Model
In the Excel file you will find a full financial model of a producer of products of hand-made ceramic tiles.p&lvaluationcash flowfinancial modelfinancial modeling3,561Discussadd_shopping_cartfreeby Asen Gyczew
Air Business Bundle (Airline & Airport Models)
Bundle with Airline and Airport Financial Modelsinvestmentfinancevaluationfinancial modelexcel189Discussadd_shopping_cart$140.00by Big4WallStreet
12 Questions 3-Way Model
The 12 Questions Model, based on only 12 simple questions, generates the 3 financial statements & investment metrics.investmentfinancevaluationfinancial modelingexcel64Discussadd_shopping_cart$59.00by Big4WallStreet
Start Up Car Park Excel Model and Valuation Template
A full & detailed Excel Model of a Car park business with 3 statements & investment metrics - to download and use.business planmodelvaluationfinancial modelexcel865Discussadd_shopping_cart$49.00by Big4WallStreet
eCommerce Startup Valuation: Financial Modelling Tutorial
Tutorial on building a financial model for an e-commerce startup valuation.valuationfinancial modelstartupfinancial modelingecommerce1,2463freeby CFI
Real Estate - Financial Model for an Industrial Warehouse Development Project
Case study PDF and Excel File for the Financial Model.financereal estatecase studyfinancial modelexcel237Discussadd_shopping_cart$10.00by Padmashri V
10 Years Financial Forecast and Valuation Excel Model
Three statement financial model to forecast the Company's P&L account, BS, Cash Flow and Company's Valuationincome statementvaluationcash flowfinancial modelbalance sheet2,3482add_shopping_cart$50.00by Jair Almeida
Greenhouse Start Up Excel Model Template
Excel model for a start up Greenhouse business for you to download and use.business planmodelvaluationcash flowfinancial model8065add_shopping_cart$49.00by Big4WallStreet
Commercial Real Estate Acquisition Model - Protected
Advanced Real Estate Model, that allows a professional DCF Valuation for Office, Retail or Industrial Propertiesfinancevaluationreal estateexcelcommercial real estate412Discussadd_shopping_cart$19.00by Julian Scheeff
Related categories
Any questions on Financial Modeling In A Nutshell?
The user community and author are here to help. Go ahead!