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)
Similar Products
Other customers were also interested in...
Financial Business Plan for Nail Salon
The Financial Business Plan Template for starting a Nail Salon was developed to obtain a comprehensi... Read more
Water Refilling Station Business Financial Model
This financial model aims to develop a thorough business plan of 5 years monthly forecast to analyze... Read more
Clothing Boutique Financial Model – Dynamic 10 Y...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Cloth... Read more
Pharmacy Financial Model – Dynamic 10 Year Busin...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Pharm... Read more
Laundromat Financial Model – 10 Year
This template allows the user to produce financial statements based on assumptions specific to the l... Read more
Liquor Store Financial Model – Dynamic 10 Year B...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Liquo... Read more
Pet Shop Financial Model – Dynamic 10 Year Busin...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Pet S... Read more
Coffee Shop – 5 Year Financial Model
Financial Model presenting an advanced 5-year financial plan for a startup or operating Coffee Shop,... Read more
Grocery Store Financial Model Excel Template
Try Grocery Store Financial Projection. Creates 5-year Pro-forma financial statements, and financial... Read more
Furniture Store Financial Model – Dynamic 10 Yea...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Furni... Read more
You must log in to submit a review.