Loading...
Answers
MenuDoes anyone know of a good SaaS financial projection template for excel/apple numbers?
This question has no further details.
Answers
Here is a link to a basic model - http://monetizepros.com/tools/template-library/subscription-revenue-model-spreadsheet/
Depending on the purpose of the model you could get much much more elaborate or simpler. This base model will help you to understand size of the prize. But if you want to develop an end to end profitability model (Revenue, Gross Margin, Selling & General Administrative Costs, Taxes) I would suggest working with financial analyst. You biggest drivers (inputs) on a SaaS model will be CAC (Customer Acquisition Cost, Average Selling Price / Monthly Plan Cost, Customer Churn(How many people cancel their plans month to month), & Cost to serve If you can nail down them with solid backup data on your assumption that will make thing a lot simpler.
Let me know if you need any help. I spent 7 years at a Fortune 100 company as a Sr. Financial Analyst.
I have ample experience valuing SaaS-based business models from my recent operational experience within a SaaS business and my previous experience in investment banking. Happy to provide more information, but a "good" projection model will require a strong (and well thought-out) operational build-up. The more details, the better.
You should check out knowlium.com. They have a wicked projection tool that ties in all financials into your business plan.
Yes, I share all my SaaS excel models at www.TheSaaSCFO.com. All are free to download. I have a revenue model, expense model, and many SaaS metrics models.
I make advanced financial models. I have one for SaaS and enterprise SaaS. If you are looking for something basic, then there are some free ones available. Chris Janz's is the best.
https://www.alexanderjarvis.com/fundraising-models/
You may grab one of my cases here: https://finmodelslab.com/simple-saas-financial-model/
Looks like the other experts have links to SaaS financial templates. Once you have a chance to look these over and find one that you like, I can talk you through how to tailor it to your own business model - or how to use a financial model to inform your strategy.
Happy to talk you through this so set-up a quick call if you'd like.
Giving a good SaaS financial projection template is only possible if we understand the limitations of SaaS. These limitations are as follows:
1. Applications required fast response (milliseconds) are not appropriate. SaaS applications are slower as they hosted in the cloud
2. Customization is not easy due to the application architecture.
3. Integration to company sensitive applications/data is risky and can conflict with data governance regulations.
4. Changing SaaS vendors may be a difficult task especially if transferring exceptionally large data files over the Internet.
5. Adopting new software versions may mean unexpected training costs for the customer organizations and related user errors.
6. The user may lose access to their software and perhaps data, if a SaaS vendor were to go out of business.
7. Internet performance and reliability is still an issue in some countries or geo-regions.
8. Data security is always a consideration as data are being stored on the vendor’s servers.
Understanding the limitations here is a link that might be helpful for you: https://baremetrics.com/blog/saas-financial-model
Besides if you do have any questions give me a call: https://clarity.fm/joy-brotonath
Here's a link to a fully-editable, easy-to-customize financial model built in Excel specifically for software and SaaS businesses: https://vip.graphics/shop/software-financial-model/?ref=clarity
Creating a financial model for your mobile app doesn’t have to be complicated or require any special software — this template is great for high-level financial planning & analysis (FP&A), and doubles as a complete three-statement model: automatically generating all annual financial statements (balance sheet, cash flow, and income statement). The core Assumptions sheet of this Excel financial model is pre-populated with industry benchmarks & done-for-you research. The entire model flows through to the first sheet: a Charts dashboard providing a visual overview of your SaaS/software business' financial performance.
If you’re looking for a flexible, intuitive & easily editable/extensible SaaS/software financial model for Excel &/or Google Sheets, check out the template above, or the blog & tutorial video here: https://vip.graphics/blog/how-to-create-a-saas-financial-model/?ref=clarity
2022 updated answer - Google Sheets SaaS financial model that's free and credible:
https://flowcog.com/free-saas-financial-model-template/?utm_source=clarity
As a CPA and someone who spends all his time in SaaS financial models, I built this one to help founders and finance folks understand their trajectory and have a credible model when speaking with investors/boards.
Happy to chat (for free, no strings attached) if you get stuck with it! You can reach out to me here, on LinkedIn, or on the FlowCog website.
Adam Tzagournis, CPA
Founder & CEO
FlowCog - A financial modeling tool just for SaaS co's
https://www.linkedin.com/in/adam-tzagournis-cpa/
Related Questions
-
How much equity is typically taken by investors in a seed round?
From my experience I would not advise you to go with Venture Capital when you're a start-up as in the end they will most likely end up screwing you. A much better source for funding would be angel investors or friends/family. The question of how much equity should I give away differs for every start-up. I remember with my first company I gave away 30% because I wanted to get it off the ground. This was the best decision I ever made. Don't over valuate your company as having 70% of something is big is a whole lot better than having 100% of something small. You have to decide your companies value based on Assets/I.P(Intellectual Property)/Projections. I assume you have some follow up questions and I would love to help you so if you need any help feel free to call me. Kind Regards, GiulianoGiuliano SeneseGS
-
Pre-seed / seed funding for a community app... valuation and how much to take from investors?
To answer your questions: 1) Mobile companies at your stage usually raise angel funding at a valuation equivalent of $5,000,000 for US based companies and $4,000,000 to $4,500,000 for Canadian companies. 2) The valuation is a function of how much you raise against that valuation. For instance, selling $50,000 at $5,000,000 means you are selling debt that will convert into shares equal to roughly 1% of your company. 3) I would encourage you to check out my other answers that I've recently written that talk in detail about what to raise and when to raise. Given that you've now launched and your launch is "quiet", most seed investors are going to want to see substantial traction before investing. It's best for you to raise this money on a convertible note instead of actually selling equity, especially if you are intending on raising $50,000 - $100,000. Happy to schedule a call with you to provide more specifics and encourage you to read through the answers I've provided re fundraising advice to early-stage companies as well.Tom WilliamsTW
-
What happens to a convertible note if the company fails?
Convertible notes are by no means "earned." They are often easier to raise for early-stage companies who don't want to or can't raise an equity round. Equity rounds almost always require a simultaneous close of either the whole round or a defined "first close" representing a significant share of the raised amount. Where there are many participants in the round comprised mostly of small seed funds and/or angel investors, shepherding everyone to a closing date can be very difficult. If a company raises money on a note and the company fails, the investors are creditors, getting money back prior to any shareholder and any creditor that doesn't have security or statutory preference. In almost every case, convertible note holders in these situations would be lucky to get pennies back on the dollar. It would be highly unusual of / unheard of for a convertible note to come with personal guarantees. Happy to talk to you about the particulars of your situation and explain more to you based on what you're wanting to know.Tom WilliamsTW
-
When raising money how much of equity do you give up to keep control? Is it more important to control the board or majority of shares?
It entirely depends on the kind of business you have. If you have a tech startup for example, there are pretty reliable assumptions about each round of funding. And a business plan and financial forecasts are almost totally irrelevant to sophisticated tech investors in the early stages of a company's life. Recent financial history is important if the company is already generating revenue and in that case, a twelve-month projection is also meaningful, but pre-revenue, financial forecasts in tech startups mean nothing. You shouldn't give up more than 10-15% for your first $100,000 and from that point forward, you should budget between 10-20% dilution per each round of subsequent dilution. In a tech startup, you should be more nervous about dilution than control. The reality of it is that until at least a meaningful amount of traction is reached, no one is likely to care about taking control of the venture. If the founding team screws-up, it's likely that there will be very little energy from anyone else in trying to take-over and fix those problems. Kevin is correct in that the board is elected by shareholders but, a board exerts a lot of influence on a company as time goes-on. So board seats shouldn't be given lightly. A single bad or ineffective board member can wreak havoc on a company, especially in the early stages of a company's life. In companies outside of tech, you're likely going to be dealing with valuations that are far lower, thus likely to be impacted with greater dilution and also potentially far more restrictive and onerous investment terms. If your company is a tech company, I'm happy to talk to you about the financing process. I am a startup entrepreneur who has recently raised angel and VC capital and was also formerly a VC as part of a $500,000,000 investment fund investing in every stage of tech and education companies.Tom WilliamsTW
-
What roles should the CEO and CTO have in a VC meeting?
The more important first impressions to leave a VC with are: 1) That you both are credible and inspire confidence that you can execute the plan you're fundraising on. 2) That there is good chemistry and a great relationship between the two of you; 3) That you can adequately address the concerns/objections/questions the VC raises. The CEO is expected to do most of the talking because the CEO should be the best person in the company at articulating the vision and value of the product and company you're building. If your CTO is comfortable presenting part of the pitch, it would be ideal for the CTO to speak to the product slides. The most important thing is for the CTO not to be a "bump on the log" meaning that you don't want them sitting there for most of the presentation with nothing to say. If you feel that's the case, you really shouldn't bring your CTO. Most VC meetings will not get technical and under the hood. Each question answered should be answered by the person best qualified to speak to that question. You should make eye-contact with your partner and use subtle body language to find a way to cue the other person to speak to that question or simply offer "CTO, would you like to answer that?" Bottom line, make sure that the CTO can speak confidently enough about the product and vision, otherwise -unless specifically asked by the VC - come alone. Fundraising is a big distraction to building and a good VC will always respect that in a first meeting, the CTO can be excused from attending in priority of building product. Happy to talk to you both on a call about helping get you feeling a bit more confident and prepared before your meeting. I was formerly a VC associate for a $500m fund and have raised money from VCs as a serial entrepreneur.Tom WilliamsTW
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.
