Financial Models

A startup 5-year monthly and annual financial model for a network / marketplace. Includes a cap table with percentage distributions over time. Revenue is driven primarily be 3 listing types that all have their own configurable attributes.

The model focuses on the most basic elements of a network/marketplace in order to be usable for a broad range of use cases. The user will start by entering global assumptions about the start year, exit month (if applicable), exit multiple, funding sources, and any debt sources. The nuts and bolts are in the ‘Activity Assumptions’ tab and include the following fields across 5 years: # of Units Listed per Month by Year (three tiers each with their own % monthly growth in transaction volume, value per unit by year for all three tiers, network fee charged per transaction (to buyers) and its % change per year, network fee charged per transaction (to seller) and its % change per year, % of items listed that actually transact, standard listing fee for sellers (% of price), advanced placement (sellers paying more to rank higher in the organic results) and the % of low/mid/high level items given priority placement, average % increase from listing fee for priority placement, ad revenue based on expected unique monthly network visitors, their pageviews per month, and an average CPM that can change each year. Operating cost assumptions are populated in their own schedule based on start month and cost per month in each year. Startup and capex are also populated in their own schedules. A resulting monthly and annual financial summary will populate that drives down to EBITDA and cash flow. A break-even analysis was also built for the project level. The cap table shows total cash returned to each entity/owner as well as their IRR, total cash returned, and total ROI. Finally, there is a visuals tab to display key metrics of the forecast as well as a high level executive summary of the project that displays revenues, COGS, opex, EBITDA, all cash flow items, and final cash flow along with its own visual.