Yes.
Runway Calculator Tool
Free
Sources and uses of funds calculator to understand how long your investment will last and illustrate your runway.
- Template for ecommerce and SaaS
- Simple and detailed version
- Excel model
- Plan your runway
1358
happy users
It helps
Detailed Feedback
A founder just emailed me some feedback and I thought it would be insightful for you to hear from someone who actually used this to fundraise and has got offers.
I am very new to fundraising, but one of the biggest takeaways is something you preach: building your financial model to ACTUALLY operate from. We recently went through DD with a VC and they admitted that a pre-revenue financial model was somewhat of a shot in the dark, but they wanted to see we had a legitimate plan for capital utilization.
I had a 2 hour zoom with one of the associates at the firm going line by line through inputs of the source and use model you have created (for free, btw – thanks a million), mostly asking what the logic was behind the inputs and why.
The feedback I recently received is that the biggest driver of their offer decision was the team, followed by the fact that we had a solid plan & financial model. They also commended our humility in understanding that we don’t know what we don’t know, and being open to advice, guidance, and learning quickly / being able to pivot when needed.
Seriously man, I share your stuff with all of my other founder / entrepreneur friends. It’s brilliant and I can’t believe how much value you provide for free. Thanks again!
– Jacob
Note: This is a random dude looking all fancy as I’m not sharing the real founder
What
What is a Runway Calculator Tool?
How much investment do you need to raise? What is your startup runway? What charts should you show on your sources and use page (‘The ask‘)?
These are all questions I’m sure that are in your head when you’re thinking about what venture capitalists are looking for from you when pitching when the question about how much you are raising inevitably crops up.
This Excel tool has four sheets and is set up for two types of startups: ecommerce and SaaS. Though if you have a different business model you can adjust it for your own purposes.
who
Who Needs a Runway Calculator Tool?
Everyone in startup-related land needs to know about this topic. So whether you are a founder, investor or advisor, why not have a little play with this!
Details
What Does the Tool Look Like?
Here are a few images to have a little gander at for your viewing pleasure.
Need
Why Do You Need a Runway Calculator Tool?
-
1
How Long Your Funds Will Last
- Even if the startup doesn’t fail, they run out of time (aka money)
- Learn what your gross and net runway will be in months
-
2
Where You Allocate Funds
- Where are funds allocated?
- How are funds allocated over time?
-
3
Role of Revenue
- Understand how revenue impacts your runway
- Expect that you make no revenue and understand how this impacts the time you have alive
features
What Can the Model Do?
These are some of the features in the model.
For Your Time Constraints
Two versions:
- Detailed: If you want instructional line items, you can input all your cost items and the model will add them up and stick them in the right buckets
- Short: If you have a model already and want to use the template to get the cool charts, you can just fill in the high-level numbers and stick em in
Make Charts
Create different kinds of charts:
- Marimekko chart: It’s really pimp. It breaks up your costs on two axes’ so you can see the spending relatively
- Pie chart: This is probably what you do at the moment. It’s a pie, with slices and stuff
- Radar chart: I think this is kinda cool, but not as much as the Marimekko (of course). It shows relatively where costs are allocated
- Costs vs revenue and orders: This is a stacked chart of your costs, with lines on your revenue (and orders)
- Costs % spend over runway: This shows how your costs are spent as a % of the total each month over your runway
Set Up For Two Business Models
Customise for your needs, but I made for two:
- SaaS: Cost and revenue line items
- Ecommerce: Cost and revenue line items
Need
Why is My Tool Worth Getting
-
1
I Make Cool Things (and am capable)
- There is a lot of blah around by people who aren’t terribly good at Excel/PowerPoint etc
- You’ll see the attention to detail and actual thought put into what I gift you (so you aren’t wasting your time)
-
2
My Free Tools Are Better Than What Some Charge For
- I only made tools because I couldn’t find anything I would use myself
- Even if you don’t ‘actually need the tool’, the point is to teach you concepts you can apply
-
3
I Don’t Have a Hardcore Marketing Funnel
- I make tools to actually help founders
- You aren’t going to be hounded with emails to get you to buy things
- Whilst I do sell some stuff, seeing the quality I give for free is way better marketing than using fancy words to convince you
video time
Watch a Video On the Tool
Here is a video I made for the SaaS model to explain this sheet (Note I’ve added a new sheet here to illustrate your runway to investors. No stress. There’s a description in the model to understand how to use it).
I’ll make a video for this at some point (depending on how Tinder goes).
read more
Read the Full Blog
This is a pretty page I have made so downloading tools is cleaner and simpler for you. I’ve moved blog details to blog(s). If you would like to read more, click on!
SaaS Financial Model
SaaS startup with monthly and annual contracts. Self-onboard and sales supported customers. Think Buffer, Zapier, Hubspot, or Xero. Cohort model with all the capability you expect including expansion revenue, churn and full marketing funnel. If you are in SaaS this is a no brainer model for you. Get the enterprise SaaS model if you have a long sales cycle though.
Learn more
Ecommerce Financial Model
For ecommerce startups that sell physical goods such as fashion, food, supplements. Ship from your own warehouse. This was originally based on a fast fashion ecommerce startup I invested in. It's not a marketplace model.
Learn moreViral Growth Model Tool
Learn moreTop Line SaaS Tool
Learn moreSubject Heading Email Template
Learn morePost Money SAFE Calculator Tool
Learn moreOKR PPP KPI Tracker Tool
Learn moreAccess
Get the Runway Calculator Tool For Free
Fill in your details and it will be emailed to you.
I’m not sketchy, so here is everything you need to know just in case!
- It is automatically emailed to you!
- I’ll send you some emails about startup/investing after
- You can unsubscribe whenever you want
- Your data is never sold! I’m not organised to even do that lol
- You agree to all T&C legal stuff (to cover my ass)
FAQs
Check the FAQs if you are having issues. Don’t message me if “I can’t download the file”.
Is this free?
How do I download?
Fill in your name and email in the submission form and it will be emailed to you.
I didn't receive the email?
My (automated) system works. You’ve made a basic mistake.
- Check you input your email accurately
- Check your spam folder (Whitelist me if you found the email in spam)
Can I get consulting to use the file?
Yes. You can book a consulting call here:
I have feedback to improve
How do I open the file?
When you press download in an email from me, it normally saves to your Downloads folder.
So go there first to find the file.
I normally have to ZIP the file so it will work with SaaS automation systems.
So get WinZip, WinRAR, or use whatever Mac/PC offers these days. Unzip the file (Right click and press “uncompress” etc). If you don’t know how to do this, then use Google.
Once you uncompress, the ZIP file will remain, and you will see a new file (sort the download folder by date modified if confused).
I assure you that everything I provide works, so if you can’t access it, it’s a ‘you’ problem.
Can I sell / share your tools?
No.
You can share a link to this page, which would be much appreciated!
Can I share your tools on social media?
Please share the link to this page. It would be super-appreciated, but only if you like it!
If you don’t like it, then leave a comment or shoot me an email first so I can take your feedback on board first and see if I can improve!
