Such models are intended to be used as decision-making tools. Company executives might use them to estimate the costs and project the profits of a proposed new project.
Start here
3 articles · 45 min
-
DCF Valuation & Comparable Company Analysis: A Practitioner Guide
How investment bankers and analysts value companies using discounted cash flow analysis, comparable company analysis (trading comps), and precedent…
-
Pro Forma Financial Statements: Percent-of-Sales Method, EFN & Growth Rate Formulas
Learn how to build pro forma financial statements using the percent-of-sales method, calculate external financing needed (EFN), and determine sustainable…
-
LBO Model Fundamentals: Structure, Returns & the Mechanics of Leveraged Buyouts
Master LBO model mechanics: Sources & Uses construction, debt schedule, IRR/MOIC calculation, the five return drivers, exit assumptions, and sensitivity…
Project Finance: From Structure to Model
1 part · 12 min
Building a Project Finance Financial Model: Structure, Inputs, and Outputs
Comprehensive guide to project finance model structure, inputs, outputs, and uses. Covers CFADS, cover ratios, sensitivity analysis, and Banking Case vs Base…
Commercial Real Estate Finance
1 part · 17 min
CRE Cash Flow Proforma & DCF Valuation
Learn how to build a commercial real estate cash flow proforma, project reversion value, choose a CRE discount rate, and apply DCF valuation to commercial…
More articles
3 articles · 25 min
yfinance Export to Excel: A Step-by-Step Python Guide From Python for Finance
In this blog post, we will demonstrate how to download historical stock prices using the yfinance library and Python, and then export to Excel file.
Scenario Analysis: Base, Bull and Bear From Equities
Learn scenario analysis with base, bull and bear cases. Follow revenue, margins, EPS and P/E through a stock valuation example and interpret the results.
Sensitivity Analysis Explained
Learn sensitivity analysis with a complete profit example, tornado rankings, realistic input ranges, and decision thresholds that show which assumptions matter.
Tools for this topic
- CRE Pro Forma CalculatorFree online calculator Excel model: CRE Pro Forma Calculator
- DCF CalculatorFree online calculator Excel model: DCF Calculator
- LBO Returns Calculator (IRR & MOIC)Free online calculator Excel model: LBO Returns Calculator (IRR & MOIC)
- Project Finance Coverage DashboardFree online calculator Excel model: Project Finance Coverage Dashboard
- Sustainable Growth Rate CalculatorFree online calculator Excel model: Sustainable Growth Rate Calculator
Browse other topics
Videos on Financial Modeling
All 25 Financial Modeling videos →
Professional certificates
Explore Top Finance Certificates
Access official certificates from Wharton Online & Columbia Business School Executive Education, powered by Wall Street Prep. Save up to $500 with my exclusive discount code:
