IndustryStartup Financial Dashboard

writes on August 8, 2011

Share with your friends


If you’re building or running a startup with recurring revenue, you’ve got to buy Numbers for Startups. The price jumps to $19.99 on Friday, so grab your copy now.

It’s a super powerful (but easy to use) Excel model that helps you …

  1. Test the financial viability of your idea
  2. Track the Seven Key Metrics
  3. Know how much capital you need to raise to hit break-even
  4. Track the effectiveness of different marketing channels and their affect on your net profit
  5. Run Red Line / Green Line analysis
  6. Understand your Yield on Cost
  7. Approach investors with confidence

Screen grab of the Excel file


The idea came about when I was having coffee with my friend and Brother-in-Law (Ryan Cumley) this weekend. He’s a tremendously talented financial analyst with insane Excel and logic skills. I mentioned that if he could build a really powerful and flexible Excel model for SaaS startups, I thought it’d be a hugely helpful (and popular). 48 hours later, he launched it.

Just to be clear: I don’t have any financial interest in this. The tool is 100% owned by Ryan. I just think it’s a great idea that will really help startup founders be more successful.

You’re probably wondering why he released this as a downloable Excel file  instead of coding it as a web app. The reason is that Ryan has mad Excel skills and in the spirit of MVP, he knew he could get a great product shipped in 48 hours if he used his advanced Excel skills (instead of trying to hack it together in Ruby or PHP).

He’s hoping to add versions for Numbers (Mac) and Google Docs very soon.

10 Responses to “Startup Financial Dashboard”

  1. Looks good. Any ideas about something similar for freelancers?

  2. He has password-protected changes to (the content of) the spreadsheets, which means it’s completely read-only. Emailed him about it but haven’t heard back yet.

    • Ryan Cumley on August 8, 2011 at 3:12 pm said:

      Hi Joris!

      I sent you a reply, so hopefully it’s in your e-mail now.

      The tool was built to be somewhat foolproof, in that you can’t accidentally change the underlying formulas or calculations. The workflow is designed to have you edit the numeric assumptions of the model (highlighted in green on the “Projects” tab under cells D2:D38) and everything else automatically updates without fear of having messed anything up.

      Everything “under the hood” is still visible as you can click on any cell to inspect the formula and see how everything works, or use the formulas to create your own tools in a different excel file. 

      Another excellent option to see all the formulas is under tab in the ribbon, within the section there is a button for “Show Formulas” which will immediately reveal all the formulas right within the workbook.


  3. Ryan Cumley on August 8, 2011 at 6:00 pm said:

    As Joris pointed out, there was a permissions bug between the Microsoft and Mac versions of Excel. Long story short, only cell permissions created in the Mac version are universal. 

    Anyone picking up the model now will be able to immediately download the updated version.

    And if you’re one of the hundred or so people who’ve already obtained a copy, I sent the updated version directly to the e-mail you used for billing. Check that inbox (or junk mail, I used a large BCC to get everyone’s address).

    Thanks again to Joris for noticing!

  4. Jerome Iveson on August 10, 2011 at 7:24 am said:

    Thanks Ryan and Ryan. I’ve been looking for something like this. It will definitely be an improvement on the stuff I’ve cobbled together myself. One quicky, does the price include the future versions as well?

  5. Anonymous on September 1, 2011 at 8:52 am said:

    If only everybody going on Dragon’s Den used this first.

    Would stop the awkward silences when asked about ‘the numbers’.

  6. Anyone seen Ryan? Ask him to contact if you see him

Leave a Reply

Learning to code can be fun!

Get started today with a free trial and discover why thousands of students are choosing Treehouse to learn about web development, design, and business.

Learn more