Clear Inputs For Non-Finance Users
I’m not deep into modeling, so this template was a relief. It made the setup feel understandable and cut my learning curve by hours.
I’m not deep into modeling, so this template was a relief. It made the setup feel understandable and cut my learning curve by hours.
The cash-flow tabs made our shortfall timing much clearer, and that changed how we planned funding. We booked an investor call with cleaner numbers and a better view of runway.
What used to take me most of a day to build manually was done much faster here. I saved about 8 hours and had a presentable forecast without starting from scratch.
The Financial model of the digital wallet is an editable five-year workbook on seller and buyer acquisitions, transaction fees, subscriptions, costs, scenarios and financial statements.
Use the model to plan how seller and buyer acquisitions become orders, GMV, commission revenue, subscriptions, expenses, cash flow, and profitability over time.
Editable operational assumptions are the source of monthly calculations, while scenarios and reporting views show how changes affect projected financial results over a five-year horizon.
The model acquires sellers and buyers separately, builds active buyers' cohorts and orders, calculates commissions based on GMV, and then adds monthly seller subscriptions and supplements.
New sellers and buyers shall equate their separate purchase budgets divided by the corresponding CAC.
Each side should be divided into levels and cohorts should be maintained for the life of each level.
Purchasers' orders shall combine new purchasers' orders with recurring orders from eligible active cohorts.
Orders and the level of AOV constitute GMV and then charge rates and fixed fees constitute commission.
The monthly revenue adds revenue to the commission, seller subscriptions, buyer subscriptions and enabled additional sellers.
Worksheet revenue separates the seller's acquisition from the buyer and then controls the retaining of the seller's levels, order economy, commissions, subscriptions and allowances.
Revenue
Worksheet COGS & OPEX organises direct costs, variable costs and recurring fixed costs during the forecast period.
COGS & OPEX
The scenario analysis compares the Low, Base, and High cases for revenue, gross margin, contribution margin and EBITDA over five years.
Scenarios
You can use the dashboard to review model configurations, scenario checks, basic financial results, a mixture of revenue, profitability, cash flow and payback period of investments in one place.
Dashboard
It is compatible with bilateral portfolio markets using horizontal acquisition, order commissions, subscriptions and seller additions; different revenue structures may require individual modelling.
The indicator is the starting point for planning, not a guarantee of performance.
Financial Models Lab can build or customize a model when your requirements use different revenue logic, operating schedules or reporting structures.
Order of the financial model for the orderAfter purchasing, you will receive a fully editable Excel or Google Sheets workbook with five-year forecasts, scenario analysis and financial reporting.
Open and edit the financial model in Excel or Google Sheets.
Five-year planning with detailed monthly and annual forecasts.
Compare Low, Base, and High cases in key operational and financial products.
A review of the income statement, the cash flow, the balance sheet, the summaries and the dashboard views.
The basic answers are visible in their entirety, without the need to click on the accordion.
It calculates the monthly revenue from the buyer's order commission, the seller's subscription, the buyer's subscription and the seller's eligible supplements. Purchasers' orders come from a cohort of new and retained buyers.
You can change the seller's and buyer's acquisition budgets, CAC, seasonality, level mixes, lifetime, recurring orders, AOV, commission terms, subscriptions and additional seller results.
The scenario analysis compares the Low, Base, and High variants for revenue, gross margin, contribution margin and EBITDA over five years.
The results include the income statement, the cash flow report, the balance sheet, the summary, the dashboard, the scenario analysis and the additional management reports shown in the workbook gallery.
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting structures.
This is a planning forecast and not a guarantee of business results, profitability, financing or return.
Download your digital wallet business plan Excel template instantly after purchase and start your financial planning today.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark