E-commerce and marketplace - mixed business model - Excel Template

This is a model of marketplace that runs also its on e-commerce business model along with some revenues from advertising

Original Best Practice:  Marketplace Financial Excel Model  by Asen Gyczew

Description
In the Excel file you will find a model of a business that operates at the same time marketplace (with 3 sides), e-commerce model and advertising business on the back of the marketplace. In this model I will show you how to model in Excel more complicated businesses that consist of many business units. For every business unit we will do separate estimation of sales and margin.

In this file I will show you how to create in Excel model that encompasses 3 business models. This to some extent is a simplified version of Amazon business model (they have e-commerce, marketplace and advertising business).

Mixed models including marketplaces and e-commerce are much more complicated to model than traditional marketplace or e-commerce. We will also model more complicated type of marketplace a 3-sided marketplace. In this type of marketplaces, you cannot quite often make enough money on end-customers and suppliers and you need the 3rd side to generate the profits expected by your shareholders. Such examples you can find in all big marketplaces: Uber (the 3-side are car producers, advertisers in the future), Postmates (bike and other accessories producers) etc. In the model I will show you how on the back of traditional marketplace model to build the model of a 3-sided marketplace. The 3rd side is a source of profit but also will require additional effort in acquiring. Therefore, you will have to model it independently as well to see how much cash it will require. That is one of the reason why the 3rd side is only added after some time. At the beginning startups tend to concentrate only on 1 of the sides of the marketplace. The 2nd side is also addressed but with limited resources and attention. The 3rd sided is only added when the market is mature.

The model obviously can be used also to model 2-sided marketplace and e-commerce model.

This Best Practice includes
1 Excel file

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Asen Gyczew

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for E-commerce And Marketplace - Mixed Business Model - Excel Template

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

  • Christina H
    Hi Asen, Just curious how the projected Revenue and COGS is built into this model... is it all driven based on traffic/visits? I have my previous (perhaps too complex) model which triggers working capital purchases based on consumed goods. Will this need to be manually entered here? Thanks.
    arrow_drop_uparrow_drop_downReply reply
    • Asen Gyczew
      Hi. It's very simple model where the Revenue is driven by Traffic, conversion rate and Average Transaction Value. COGS are assumed as a percentage of Revenue. We unfortunatelly, don't have here the cash flow forecast. It is just forecasting the P&L. We have the Cash flow on our to-do list but for the time being we are busy with projects so no time is left for upgrades
      arrow_drop_uparrow_drop_downReply reply
    • Kannan Chandran
      Hii ...I have just downloaded template , i would like to know What is PLN means ..Please advise
      arrow_drop_uparrow_drop_downReply reply
      • Asen Gyczew
        HI PLN is a currency name - Polish Zloty like USD, EUR etc.
        arrow_drop_uparrow_drop_downReply reply


      4.7 / 5 (17 votes)

      please wait...