Financial Models

The outputs of this model focus on cash flow before tax (leveraged and unleveraged). Starting one or multiple robotic kiosk machines takes startup costs, potential franchise fees, and a bit of working capital. This is a 3 year monthly and annual financial model to plan out the initial launch and expansion of kiosks or vending machine-like units. A common type of unit is for frozen yogurt (froyo), but the logic designed in this can work for a wide range of dispensaries.

The assumption configuration is fairly simple. The user begins with global assumptions about the start year and expected debt financing if applicable. The next stage is entering startup costs and expansion of the machines via a configurable count, and cost per unit for initial launch and then future expansion is defined by month, unit count, cost per unit. A sensitivity rate can be used to show low/base/high sales volumes. There are slots for up to five expansion months. Revenue is based on the cumulative count of units deployed against the average sales count per month over each of the three years for up to three different product categories (averages can be used if there are more categories). Cost of goods sold is based on a schedule of the % of total revenue with up to five COGS slots. This would apply to things like different ingredients or the overall cost to purchase items. To account for re-supply, the user can define the headcount needed over time and their fully loaded cost per month. There are 7 other operating expense slots where the user defines the start month and monthly cost over each of the three years. a DCF Analysis was built in as well as plenty of visualizations and a final return summary.