Kiosk - 3 Year Startup Financial Excel Model

Revenue and cost logic specific to running multiple kiosks.

by Jason Varner
Smarthelping.com - Freelancer - I make my living working in Excel and G-sheets.Follow 82

104 views|Start the discussion!|Bookmark

Description
This specific template was built with the intention of opening multiple frozen yogurt (froyo) kiosks. The logic allows for you to built out your initial investment based on a variety of factors that include multiple kiosks, up to 5 expansion periods, and franchise fees if applicable.

The logic could be used for other types of kiosks as well.

If we dig into the revenue assumptions, you will be able to adjust up to 3 pricing tiers for various flavors. To scale out, you could simply enter average price of 3 separate types of kiosks. There are a lot of ways to use the logic to help you plan out 3 years worth of business operations and ramping.

The cost assumptions allow you to define what your refill labor looks like with various total kiosk counts, electricity, repairs, and other relevant expenses.

Your COGS are done in more of a top down way where you enter the % of total revenue that each COGS item is planned to makeup.

A flip of the switch on the global assumptions tab allows you to adjust key revenue variable to be Low, Base, or High. You can also define the magnitude of low and high scenarios as a % change from the base assumptions.

There is a financing schedule that automatically flows into the pro forma / cash flow summary.

A DCF (discounted cash flow) analysis is available as well in its own summary tab.

Visuals exists to how a breakdown of expenses over the 3 year startup period as well as key financial line items including total units, average revenue per unit, and average cash flow per unit over time.

Gross margins and EBITDA are displayed as well as accumulated total cash flow.

This is a great way to test your assumptions and see what kind of numbers you need to have in sales / costs in order to turn a given desired profit.

The assumptions populate a monthly and annual pro forma.

There is also a high level financial summary that combines visuals and metrics such as ending debt balance, ending cash position, revenue per product type, and the annual sales needed to break even.

One final key financial metric that you will see is break-even sales needed per day, per month, and per quarter in each of the 3 years.

This business tool includes
1 Excel template and 1 tutorial video