Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
  • Kiosk - 3 Year Startup Financial Excel Model
Originally published: 09/04/2018 09:37
Last version published: 25/06/2018 13:29
Publication number: ELQ-99047-3
View all versions & Certificate
certified

Kiosk - 3 Year Startup Financial Excel Model

Revenue and cost logic specific to running multiple kiosks.

cash flowdcfdiscounted cash flowfinancial modelfroyofrozen yogurtkioskstartup financial model

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

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Build a case for scaling out kiosk stands.

Any kind of business that involves deploying automated kiosks.

Non kiosk businesses.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Kiosk - 3 Year Startup Financial Excel Model?

The user community and author are here to help. Go ahead!

please wait...