All work stories
Anonymized case studySkilled trades / B2B marketplace

Turning product customers into a contractor marketplace

An established trade-products seller was designing a network where customers could price installation projects, verified contractors could compete for the work, and professional members received tiered access to product discounts and platform services. The investment model had to connect commerce, subscription and transaction economics.

Platform and funding planningFinancial model
Customers, trade professionals and a product warehouse connected through a fictional membership and project-quotation marketplace.
Original concept illustration. No client data shown.
CONFIDENTIAL BY DESIGNWhy you won’t see the client workbook

Financial models contain pricing, salaries, conversion assumptions, funding plans and other sensitive data. I do not publish client workbooks, identifiable screenshots or proprietary inputs—especially where an NDA applies. This page uses an anonymized summary and original concept art to explain the business decision and my modeling approach.

Customers + tradesMarketplace sides

Project demand and qualified contractor supply have separate conversion and activity drivers.

Recurring + transactionalRevenue logic

Membership fees, product contribution and project take rate remain distinct before consolidation.

Tiered accessMember economics

Price, product savings and service fees change together across professional membership levels.

Direct + third-partyCommerce channels

Selling price, fulfillment and external marketplace fees determine contribution by channel.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The reconstructed investment view separates member acquisition and tier mix, recurring fees, product purchases and discounts, project volume and take rate, contractor earnings, channel contribution, development cost, cash runway and valuation.

01

Each project created three different profit pools

One customer payment could include supplied products, contractor labor and a platform charge. The customer, contractor, product seller and marketplace therefore needed a transparent waterfall rather than one blended margin.

02

The membership discount transferred margin

A deeper product discount made a higher membership tier more useful to the contractor, but it also reduced the seller’s retained product contribution. Annual fee, purchase volume, discount and project income had to be evaluated together.

03

Project volume could masquerade as platform revenue

The value of work quoted or completed through the network was not the same as the fee earned by the platform. Separating gross transaction value, product sales, contractor proceeds, take rate and payment cost was essential to an investor-ready forecast.

04

Growth scenarios could disagree with their own labels

Adoption paths, operating spend and valuation were presented as scenarios, but the labels were not always consistent with the member counts and resulting value. Formula-driven controls were needed before those cases could support a funding decision.

MODEL ARCHITECTURE

From operating activity
to a decision-ready view.

Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.

01

Member acquisition

The professional customer base, new sign-ups, qualification and conversion assumptions create the contractor network by period.

02

Tier mix and renewal

Membership level, price, renewal and movement between tiers build recurring revenue and active members without treating every sign-up as permanent.

03

Product economics

Purchase volume, product cost, fulfillment and member discount establish savings for the contractor and contribution retained by the seller.

04

Project marketplace

Customer requests, contractor coverage, quotes, acceptance and completed jobs translate marketplace activity into gross transaction value.

05

Transaction waterfall

Product proceeds, labor income, service take rate and payment cost show what each participant earns from the same completed project.

06

Channel comparison

Direct commerce and third-party marketplace sales use their own price, commission, payment and fulfillment assumptions.

07

Funding and valuation

Platform-development phases, people, marketing and operating spend roll into cash runway, member break-even and valuation scenarios.

WHAT THE ANALYSIS SURFACED

Useful answers,
without exposing client data.

The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.

Reconstructed insight

The best membership tier depended on total profit per member

Subscription price alone could favor the highest tier, while product discount alone could favor the lowest. Combining fee income, purchase contribution and project take rate showed the economic value of each member type.

Generalized project pattern

Contractor savings needed a purchase threshold

A professional would rationally compare the annual fee with expected product savings and project access. Expressing that tradeoff as a purchase threshold made the membership promise testable.

Reconstructed insight

Money moving through the marketplace was not money earned by it

Only the applicable product contribution and service take rate belonged to platform economics. Keeping contractor proceeds and gross project value outside recognized platform revenue prevented scale from being overstated.

Reconstructed insight

Break-even controls had to come before valuation

A displayed member threshold did not fully reconcile to a zero-cash result, and the scenario ordering needed review. Until those checks were formula-driven, a valuation multiple only amplified unresolved assumptions.

MODELING APPROACH

The working system
behind the answer.

  • Key-driver and professional membership mix panel
  • Member acquisition, renewal and tier schedule
  • Product purchase, discount and contribution model
  • Project volume, completion and take-rate schedule
  • Customer, contractor, seller and platform transaction waterfall
  • Direct and third-party commerce channel comparison
  • Development budget, cash runway, break-even and valuation scenarios

CASE CONFIDENTIALITY

This anonymized case explains the membership, product-commerce, contractor-marketplace and funding logic without naming the company, platform, owners, workbook authors, staff, customers, contractors, marketplaces, domains, advisers, locations or dates. Exact membership names, benefits, prices, discounts, fees, salaries, product examples, customer and contractor counts, conversion rates, purchase volumes, market estimates, budgets, fundraising terms, valuation assumptions, formulas and outputs remain private because client engagements may be confidential or NDA-protected. The source workbook, embedded image, formatting and model screenshots are not reproduced. The illustration is an original fictional skilled-trades network rather than a real platform, warehouse, contractor or job site.

CUSTOM PROJECTS START AT $2,500 USD

Need a financial model?
Or the complete business package?

The final fee reflects the agreed scope, complexity and deliverables. Combined packages are quoted individually.