Ecommerce - physical inventory fundraising financial model

Ecommerce business plan fundraising financial model for physical inventory

AN AWESOME EXCEL MODEL FOR STARTUPS

Forecast an ecommerce company

  • ecommerce model
  • ecommerce marketing
  • ecommerce forecast
  • ecommerce kpi
  • ecommerce charts
  • ecommerce cohort
  • ecommerce fulfilment
  • ecommerce sku
  • ecommerce funding
  • ecommerce integrated
  • Placeholder
  • Placeholder
  • Ecommerce

    For ecommerce startups that sell physical goods such as fashion, food, supplements. Ship from your own warehouse

  • Large and complete

    85,566 formulas across 17 sheets with 95 charts

  • Heavy lifting done for you

    You only need to input your assumptions into the yellow boxes. The model is fully integrated across sheets with smart automations inbuilt to help you to scale up and down

  • For those that want to impress

    Wow your CFO and investors. You will level up your ecommerce KPI knowledge as you learn to get the most out of it

  • This is NOT for wannabees

    This is for grown ups that want to take their business seriously. If you want a model to quickly fill in "because an investor asked for one" don't go here

  • It is 100% worth every cent

    2 reasons: 1/ you couldn't even hire someone to make this, 2/ it's not a model- it's a structured learning process. You need to use it to understand what I'm saying, and it does blow minds!

For traditional eCommerce companies with physical inventory that is distributed via your own site. There is no model like this on the internet. Features highly granular revenue forecasting with monthly cohort level modeling.  A full stack of marketing options from paid to social and email drive sales. 3 years (36 months) of detailed P&L for actual, forecast and combined, as well as cash based analysis. Manually plan out your hiring of staff and automate support staff depending on how you scale. Charts, KPIs, all your COGS mapped out. Unique source and use sheet illustrate your plan for your pitch deck. And a lot more...
Image
Image
Image

Excel

Unlocked

Integrated

  • Excel financial model
  • Built for PC and Mac
  • Not for Google Sheets
  • Entire model is editable by you
  • Nothing is locked or restricted
  • Fully integrated model
  • Each sheet acts as a module connected to each other which update immediately
Image
Image
Image

Updates

No modeling needed

Easy to maintain

  • Model is updated with new features
  • I'll email you updates when they're done
  • Everything works out of the box
  • Just input your assumptions
  • Designed to be easy to update monthly
  • Just change the forecast month then add in you new month of actuals
Image

Image

Support


Automations

  • If you're really stuck, ping me an email or catch me if I'm online and I'll help you figure out what to do for free
  • You can hire me per hour if you need a lot of help on whatever it is you need

  • Ware house, customer care, and photography staff added as you need them based on your assumptions
  • Payments, tech, and other costs scale to your forecasts. Set and forget
Image

FOR ALL TYPES OF ECOMMERCE STARTUPS

Model designed for all ecommerce startups with physical inventory

Image
Image
Image
Image
Image
Chuan
Peter Goldsworthy
Hideki Fujita
Robert feedback
Image

2 pricing options

Get a filled in model, or the filled in model + a blank version of the file.

Filled in model

Filled in + blank

  • The base model has been populated with numbers so you can see how it works
  • You can edit it however you want
  • This version comes with 2 Excel files
  • In addition there is a blank version of the file with no assumptions in it to save you time if you want to start from scratch
Image

Quick walkthrough

Here's me explaining the video fairly briefly and pretending to enjoy it (All videos will be updates)

Image

Who the heck is hawking me a financial model!?

Hey! It's me Alexander Jarvis. I like Excel and I love eCommerce.

Image
  • I'm the #1 seller of startup financial models in the world
  • Worked in M&A (Lazard financial institutions group)
  • I intimately know startup and what VCs care about having done both for over 10 years
  • TEDx, Top Quora Writer, accelerator mentor, fund advisor etc
  • I don't like bragging, so just read my blog and download free tools to see if I know what I'm talking about
  • Inspired by a fashion startup that raised $55m to date
Image

Free training course

I've made an 11 part training course to help you hit the ground running (It's also free)

Paid and organic marketing
KPI
Staff build

There are a lot of cool features under the hood

An insightful and useful model needs to work for you, not against you.

My models do require thought on inputs, but there are 17 sheets to support you to derive all the outputs that you need without any coding.

On this page I'm going to very briefly allude to some of the functionality on each sheet so you have an idea what's going down in funky town. 

ecommerce model architecture

17 sheets

There are lots of sheets in the model. Check out what they are so you can get an idea of what's in there. It's a list from the model with just one brief line per sheet. Writing this stuff is boring and know you don't want to read it either. Just saying.

Image

Want to know more?

Let's run through details and answer your FAQs

Details on the model

FAQ

Image

Want this model in a different currency? Now you can!

Convert all currencies in the model into one of 17 different currencies with a button mash

This model uses formatted currencies in $ (Why I use US Dollars). I often get asked if it is available in other currencies such as €? So I made an Excel PC addin to do that (It was hard!)

At the press of a button you can now convert the model into 17 different currencies. You just need to purchase the productivity addin.

Here are the currencies you can use with the macro:

Currency list The format you will see
EUR
USD $
GBP £
YEN ¥
INR
Krone kr
BAHT ฿
RUB
Peso
BRL R$
RM RM
Rp Rp
HKD HK$
ILS
KPW
RMB ¥
CHF CHF
Image

Part of the productivity addin

All my favourite hacks and time saving tools in one place

Image

More than likely, you aren't a huge Excel nerd like me, so you probably don't know about macros? These are hacks to make modeling in Excel much more faster and less painful. I love them!

I've been making models for years, so you can be sure I know what is useful and what is not. I decided to not just make the currency conversion macro, but add in all my most used hacks. You just hit a button and it will do handy things.

What can you do?

  • Automatically format your cells so they have 'investment banking' standard black, blue and green
  • Change the zoom and cell position of every sheet so it looks great when others read it
  • Save a backup of your model (v1, v2, v3) at the push of a button so you never get a corrupt model
  • Add error checks to your formulas
  • And a whole bunch of other nerdy things you'll understand when you are making models yourself!

NOTE:

  • This is for PC. Gates hates Mac so.... All the plugins other than 'check sheet sizes' work in Mac, but I don't warrant anything if you are on Mac (Sorry). I'm trying to find a developer to rewrite the code for Mac so the images, tips etc work too
  • Currency conversion only works on 50Folds models. It won't on any other model (My code looks for certain cells... There is a hack- ask if you want to know)
Image

2 pricing options

Get a filled in model, or the filled in model + a blank version of the file.

Filled in model

Filled in + blank

  • The base model has been populated with numbers so you can see how it works
  • You can edit it however you want
  • This version comes with 2 Excel files
  • In addition there is a blank version of the file with no assumptions in it to save you time if you want to start from scratch
Image

Purchase guide and note

Let's just get clear so you know how it works and what to expect

Buying models

Getting the model

  • Payment and delivery of the model is 100% automated!
  • There's 3 upsell pages (Don't hate me for trying). At the end you can press download to get the file immediately
  • It's hosted on SamCart and payment is via Stripe (Secure)
  • There are no refunds. These are digital goods you can't return
  • If you have questions ask me first in the chat or via email
  • If you aren't sure if this is the right model for you, ask me!
  • As soon as you pay there is the end page to press download
  • After you buy you get confirmation emails from SamCart
  • Delivery of the model is automated
  • Note: I don't know why, but some clients get emails slow
  • The file comes in a zip file. You need to unzip it (e.g. WinZip)
  • If you're really stuck, ping me an email or via chat box!

Comments 41

  1. Post
    Author
    1. Post
      Author
  2. Post
    Author
    1. Post
      Author
  3. Post
    Author

    Hi Jarvis, we are fundraising at the moment for our startup. Been looking for a model and haven’t been able to find much. You would think it is easier. Looks like this does a lot! Will let you know how we get on with it if ok?

    1. Post
      Author
  4. Post
    Author
    1. Post
      Author
    1. Post
      Author
  5. What’s Happening i am new to this, I stumbled
    upon this I have discovered It absolutely useful and it has aided me
    out loads. I am hoping to contribute & help other
    users like its helped me. Great job.

    1. Post
      Author
    1. Post
      Author
  6. Right here is the perfect site for everyone who hopes to find out about this
    topic. You know a whole lot its almost tough to argue with you (not that I actually
    would want to…HaHa). You definitely put a brand new spin on a
    subject that has been discussed for years. Wonderful stuff,
    just great!

    1. Post
      Author
    1. Post
      Author
  7. Thank you for sharing excellent informations. Your site is very cool.

    I am impressed by the details that you have on this
    web site. It reveals how nicely you perceive this subject.

    Bookmarked this web page, will come back for extra articles.

    You, my pal, ROCK! I found just the info I already searched all over the place and just couldn’t come
    across. What a perfect website.

    1. Post
      Author
  8. Hmm it looks like your website ate my first comment
    (it was super long) so I guess I’ll just sum it up what I wrote and say,
    I’m thoroughly enjoying your blog. I too am an aspiring blog writer but
    I’m still new to everything. Do you have any helpful hints
    for beginner blog writers? I’d definitely appreciate it.

    1. Post
      Author
    1. Post
      Author
  9. Do you mind if I quote a few of your articles as long as I provide credit and sources back to your website? My blog site is in the exact same area of interest as yours and my users would genuinely benefit from a lot of the information you provide here.
    Please let me know if this alright with you. Thank you!

    1. Post
      Author
    1. Post
      Author

      Michael-
      I make big models. If you want to do financial things seriously, you just have to use Excel. It’s way too much of a pain in the ass otherwise.
      I haven’t tested it in Sheets. The issue with sheets is that it’s not a very advanced programme so there are a lot of formulas that just exist in it.
      Alexander

    1. Post
      Author
  10. Ні guys, Ι am the owner and ceo оf Just CBD store,
    an online CBD gοods store based all thee way іn Florida. I aam aiming to olen an on-line CBD shop in thhe UK.
    Ⅾoes anybod һave any expertise оf manging a CBD аnd marijuana shop іn the
    UK? Ι ѡould ƅe grateful for any details and additionally, І am searching fоr interested
    partners who wօuld like tо assist. Ι hаvе ɑctually registered ѡith Vape
    Life Μag, CBD Life Ⅿag, Αll Vapee Stores ɑnd Аll CBD Stores aѕ affiliate
    partners. Ⲩ᧐u can reach mе onn Facebook oг ϳust drop me
    а message below.

    1. Post
      Author
  11. Hey Mr. Jarvis,

    Love all the valuable content you’ve put out and am long time email subscriber. I’m currently bootstrapping for a scalable distribution model on my product idea. Could you swing the model access for 100$?

    1. Post
      Author
    2. Post
      Author
  12. Good day! This is kind of off topoic but I need some advice from an established
    blog. Is it tough tto set up yourr owwn blog? I’m not very techincal buut I can figure things out
    prettfy quick. I’m thinking about creating my owwn but I’m
    not sure where to begin. Do you havve any points or suggestions?
    Appreciate it

    1. Post
      Author

      Hey Deon –

      Thanks for reaching out.

      I wrote a long blog to teach you how to do this in 2017, step by step. https://wordpress-153384-440792.cloudwaysapps.com/complete-startup-guide-to-start-a-blog-and-begin-content-marketing/

      I do things differently and more advanced now, but this will help you get started (I pay a lot more and do more fancy things now etc).

      It’s not hard to start a basic blog at all. If you are shite at tech, go to upwork and hire a dude (like $8-20 an hour- pay more if you can as they are more reliable…) to do it for you. You will save so much time. I taught myself to do everything, but I hire people whenever I can now. I promise you spending a little on hiring a nerd and not learning will save you so much time! If you’re broke, ok, there are guides, but will take time. You can follow my blog and have a site up fast though if you want.

      If you want to see if you will actually consistently post content (this is key), I recommend setting up a Medium account and starting there. There’s no tech and cost involved that way. If you want to build a brand I recommend owning your own site on WordPress though on your domain.

      Any ‘business’ logic questions, ask me here again and will respond.

      Best,
      Alexander

  13. Hi Alexander,

    Wondering if you have a version of this model for an e-commerce business that does not retain or distribute its own inventory. A good example for this type of business would be Goldbelly. Goldbelly aggregates sellers into a single platform, facilitates orders, processes payments, and tracks shipping. Additionally, they provide marketing services. Their sellers actually handle all inventory and physical shipping.

    Thanks

    1. Post
      Author

      Hey Adam – sorry, just saw this as am updating this model and was improving the page here.

      That’s a marketplace. Check out my marketplace model: https://wordpress-153384-440792.cloudwaysapps.com/marketplace-financial-fundraising-model-in-excel/
      I haven’t built-in marketing services into that model though. I built in ads into the model- don’t know if that is different to “marketing services” which if you are doing it with your own staff isn’t scaleable.

      I want to add in FBA like functionality so it’s more like dropshipping. I just need someone to show me the fees so I can model it. It’s easy to do, I just need to know how it works.

      Best,
      Alexander

    1. Post
      Author

      Hey Ryan-
      Sorry had COVID. I blew a bunch of time to tick off a nerd box to make my own excel addin because why not (to convert currencies- it took ages though!).
      It’s a plugin you can buy. It converts to 17 currencies. I would rationally think i don’t have an AUD specific $ because it’s annoying to look at. I trend on ease of read.
      I see you have a .com.au. I would just use $ and stick on the cover “this is in AUD”. Or whatever email investors “attached model, this is in AUD”
      But I recommend using USD as investors think in $ anyway and having AUD takes up space.
      Read: https://wordpress-153384-440792.cloudwaysapps.com/use-dollars-in-your-startup-especially-for-your-financial-model/
      Cheers mate
      ADJ

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.