10-year Financial Projections, Budgeting, Cash Flow Projections, Cash on Cash Yield, Consolidation, Excel, Financial Feasibility, Financial Model, Financial Planning, Financial Projections, Fundraising, Investor Cash Flows, IRR (Internal Rate of Return), Levered Yield, Startup Financial Models, Three Statement Model | Three Financial Statements, Uses and Sources of Funds

The model analyzes the financial feasibility in detail by deriving the projected site financial statements. The Excel model template then consolidates the site financials into a consolidated financial plan.

As the rollout of the retail chain might take years to execute, the plan foresees different start years for each site and uses a phasing plan to rollout the expansion of the business to additional sites.

The model keeps track of important overall financial metrics and funding requirements and allows full flexibility to fine-tune the phasing plan by moving around the start years of each phase or site as needed.

Furthermore, the model also provides a framework to evaluate buy or rent decisions for the real estate in light of their overall effects on available cash. The model calculates all financial metrics including IRR, NPV, Minimum Funding required on a consolidated basis as well as on a per-site basis. In addition, the investor specific calculations are made including pre- and post-money valuation of potential fundraising.

A walkthrough of the model is provided here:

The financial model template in Excel includes the following:

10-year financial forecasts per site and on a consolidated basis
Monthly forecast by site for 3 years

Per Retail Site

Income Statement
Balance Sheet
Cash Flow Statement
Financial Ratios
Debt Schedule
Fixed Asset Schedule
Summary of Financial Metrics
Site Assumptions
Free Cash Flow Calculations
Financial Metrics such as NPV, Project IRR, Equity IRR with and without funding buffer, Levered Yield, Funding Required, Minimum Funding Required, Avg. ROCE, ROE
Uses and Sources of Funds Table
Consolidated Financials
- Income Statement
- Balance Sheet
- Cash Flow Statement
- Financial Ratios
- Free Cash Flow Calculations
- Financial Metrics such as NPV, Project IRR, Equity IRR with and without funding buffer, Levered Yield, Funding Required, Minimum Funding Required, Avg. ROCE, ROE
Uses and Sources of Funds Table
Investor cash flow projections and calculation of financial metrics
Executive Summary sheet containing
- Summary of key financials such as Revenue, EBITDA, etc.
- Forecasted Cash Balance and Financial Debt
- Table with main site settings including
  - Phase
  - Start year,
  - If to be consolidated or not,
  - Buy or rent of the real estate
  - Project IRR
  - Equity Multiple
  - Model Checks
  - Funding required (Total and Equity)
Phasing plan with three phases
Summary of financial metrics
Graphs and charts
Uses and Sources of Funds
Pre- and Post-Money Valuation for Investors
Investor metrics
Worksheets for up to 25 sites
Worksheet with tables which can be copy/pasted into PowerPoint