FRANCHISE FINANCIAL PROJECTIONS MODEL - Used by several franchises to prepare financial projections - By expd franchise CFO
Marcello do Guzman
If you have an existing business or startup venture that requires a
state-of-the-art financial projections model for a FRANCHISE I have
what you need. I developed the business plan and financial projections
model for franchisors.
If you've made an attempt at producing the financial projections for a
franchise, you are probably finding out how difficult and challenging
this task can be. Fortunately I have prior franchising experience,
with a strong financial background (CFO and Controller), and am an
expert at developing financial models for just about any industry.
The FRANCHISE FINANCIAL PROJECTIONS model includes four separate
modules. Some of the features and capabilities are as follows:
FINANCIAL PROJECTIONS MODULE:
1) Startup Capital Expenditures template. This is where you enter your
startup costs.
2) Profit & Loss Statements - Includes detail and summary. The
detailed P&L are for the first two years and includes months 1 though
12. The summary P&L includes SIX years of projections.
3) Cash Flow Statement - Includes detail and summary. The detailed
Cash Flow Statements are for the first two years and includes months 1
though 12. The summary Cash Flow Statement includes SIX years of
projections.
4) Balance Sheet - Six Years Summary.
5) Breakeven Point Analysis.
6) ROI and Payback Analysis (Includes on two pages six years of
projections so that investors and institutional lenders can see the
"big picture" and most importantly the cash-on-cash ROI and payback
period for the investors and entrepreneur.
7) Lots of graphs and charts to highlight and make a dramatic
presentation.
AREA FRANCHISEES MODULE:
If you have master or area franchisees this module will allow you to
project area franchisee franchise fees and includes:
1) Unit Franchisees signed up by TERRITORY. Up to 42 territories
(states).
2) Area Franchisee Counts.
3) Area Franchisee Franchise Fees.
UNIT FRANCHISEES MODULE:
This allows you to project each unit franchisee store. Projections by
TERRITORY. Up to 42 territories plus FOUR extra ones if you need them.
Here are some of the features:
1) Unit Franchisee Assumptions template - This is where you enter the
revenue assumptions for your unit franchise stores.
2) Unit Franchisee store openings by TERRITORY. Up to 42 territories
plus FOUR extra ones if you need them.
3) Unit Franchisee Counts - Shows the cumulative unit franchise store
counts by month going out six years.
4) Unit Franchisee franchise fees - Shows the amount of franchise fees
by month going out six years.
5) Unit Franchisee Franchise Fee Split - If you are splitting the Unit
Franchisee franchise fees with the master of Area Franchisees, this
will show you the split amounts by month going out six years.
6) Unit Franchisee Regular Royalties - Shows the regular royalties for
the unit franchise stores by month going out six years.
7) Unit Franchisee Advertising Royalties - If you collect a separate
royalty for advertising, this will show the amounts by month going out
six years.
8) Combined Royalties - This combines regular and advertising
royalties for the Unit Franchise stores and shows the amounts by month
going out six years.
9) Product Sales - This shows sales to the Unit Franchise stores for
FIVE major categories of products or services.
10) Product Cost of Goods - This shows the cost of gods to the Unit
Franchise stores for FIVE major categories of products or services.
11) Lots of GRAPHS AND CHARTS for that dramatic visual look.
PAYROLL MODULE:
This allows you to show OWNERS/OFFICERS, REGULAR EMPLOYEES and two
categories of INDEPENDENT CONTRACTORS. You can include any number of
employees or contractors. Automatically calcualtes year-to-year raises
and keeps head counts.
SPECIAL FEATURES:
1) Head Counts
2) Franchisee Counts
3) Detail and Compressed VIEWS for P&L and Cash Flow Statements.
4) Fiscal or Calendar Year - Automatically changes months in each
column.
5) Automatically change NAME OF COMPANY so that it appears on all
reports and graphs.
6) Automatically formated for printing.
7) SIX YEARS of financial projections.
8) Additional SALES templates (SIX YEARS WORTH) in case you have to
have more detail on sales.
9) All modules LINKED so that making a change in one this
automatically updates the data in the Financial Projections Module.
I feel confident that my FRANCHISE FINANCIAL PROJECTIONS model will
handle what you will ever need right out-of-the-box. I can also make
modifications to the model to meet your specific requirements at
additional cost.
If this sounds interesting and you want to get a leg up on your
Franchise financial projections like a pro, contact me immediately.
Thank you in advance.
Email me at: pbtcon...@aol.com
or call me at (925) 768-1805
john.f...@gmail.com
This looks like what I need. Can I view it. My daughter is buying into a cosmetic injectable franchise in Australia and want me to run the numbers for her.
Regards
John Fergus