All Industries, Distribution, Financial Model, General Excel Financial Models, Manufacturing, Media, Retail

5-year Financial Projections, Accounts Payable, Accounts Receivable, Break-Even, Campaign, Cash Flow Projections, Conversion, Cost per Click (CPC), Crew Planning, Debt Schedule, Excel, Financial Analysis, Financial Debt, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Marketing, Mortgage, Payback Period, PDF, PPC (Pay per Click), Pro-Forma, Return on Investment (ROI), Sales Funnel, Staffing, Startup Financial Models, Subscribers, Three Statement Model | Three Financial Statements

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.