You start on the “Assumptions” tab and enter your data into the yellow cells, which are the input cells.
You can enter the following assumptions:
BUSINESS:
Rent per month
Passers-by/day
Opening days per week
Passer-by conversion rate %
Income tax rate
Sales reduction during M1 (pre-open)
Inventory Turnover Ratio
Accounts Receivable % of sales
Accounts Payable % of sales
PRICING & SALES:
Sold units per customer
Price per unit
Upsell %
Sales per customer
Salesforce contacts/day
Salesforce conversion rate %
COGS in % of sales
Shrinkage & theft %
PERSONNEL:
Manager
Salesforce
5 different types of employees, that you can define
Seasonality
Staffing per month for each position
MARKETING:
Email
Social Media
Online Search Ads
Flyer
Direct Mail
OTHER FIXED COSTS
Sales paid by debit&CC cards
Debit & CC processing fees in %
Utilities
Fees and Insurance
Operating Cost
Administration
Maintenance
Leasing
INVESTMENT & DEPRECIATION
Capex
Prices
Useful life
FINANCING
Cash/Equity
Loan/Debt
Interest rate
Term in years
Start Date
As a result of your inputs you get a detailed 5-year income statement with EBITDA, net income, and Break-even Sales, a 5-year cash flow statement, and a 5-year balance statement. The model also calculates the monthly payments of principal and interest of the planned loan.
The marketing campaigns are evaluated by Return on Investment (ROI) – So you can find the most profitable way to get customers!
NO macros were used in this model – so no problems from this side.
Similar Products
Other customers were also interested in...
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Complete Three-Statement Quarterly Budget with Sce...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
Complete Three-Statement Monthly Budget with Scena...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Quarterly Budget
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Fashion Designer (Independent) – 5 Year Financia...
Financial Model providing a highly sophisticated 5-year financial plan for a startup Independent Fas... Read more
You must log in to submit a review.