Financial Model, Retail

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

The model comes as a free PDF Demo version (free) and a fully editable Excel version (paid). The latest model version is 1.1

File types:
– .xlsx (open with MS Excel)
– .pdf (open with Adobe Acrobat Reader)