megananax.blogg.se - Lifehacker budget spreadsheet pdf

LIFEHACKER BUDGET SPREADSHEET PDF UPDATE
LIFEHACKER BUDGET SPREADSHEET PDF MANUAL

Here’s a sample of how that spreadsheet could look: Churn Rate: Expected cancellations every month.Marketing Budget Scale: How much is the budget climbing month over month this is usually a percentage increase.Marketing Budget: The estimated marketing spend for a given month (this data is imported from the SG&A spreadsheet).Max/Min CAC: Maximum and minimum Cost of Acquisition.CAC Trend: As your budget grows, your CAC will tend to increase, and you should account for that in your model.In our model, we have a formula that takes into account the following variables:

Predictable Revenue is one of the reasons why I love SaaS businesses: once you have a good idea of your CAC and your Churn, you can pretty accurately estimate you much money you are going to be making in X amount of time or increasing your marketing budget by Y. These values are tracked in the Revenue Spreadsheet.

Blue text: Formula results (avoid modifying).

LIFEHACKER BUDGET SPREADSHEET PDF MANUAL

Gray text: Variables and manual inputs.

It’s hard to fake such complex data, so some of these screenshots actually belong to our live working model. Still, I’m going to highlight certain parts of it to give you an idea of projections that you can eventually automate using our template. Obviously, this is a blank canvas since all businesses behave differently, and it probably looks like a lot of (boring) work to get from here to a fully working document. As a tech company, most of our CAPEX is on laptops and some office furniture, but we account it nonetheless, along with its estimated depreciation. WK+CAPEXįinally, this is where you manage physical assets and equipment. While COGS usually tracks the cost of production goods, we’ve started using it for services that are essential for our app to be live, including for example AWS and Intercom (one of the most important tools in our growth and customer success efforts). There’s a little debate over what should go here on an internet business. For a long time, I took over the task if syncing this with our debit card/bank statements at the end of the month, and have recently delegated this to our office manager.

LIFEHACKER BUDGET SPREADSHEET PDF UPDATE

This is the main expenses sheet and the one you will want to update on a regular basis based on your week over week spend. A SaaS product, for example, should have MRR and Churn as the core drivers/variables, while also accounting for estimated user cost of acquisition vs. This sheet should be adapted based on your Business Model. This is a standard Financial Statement sheet taking into account Income, Balance Sheet, and Cash Flow. A list of variables that you can comfortably adjust here, and measure their impact on the financials for the future. The Summary Spreadsheet also holds the Dashboard. If you’ve just raised money, then this should be modified to look into your expansion budget. No formulas should be calculated here this should just reflect important lines and results for your current company status: if you’re running low on cash, this should be very focused on your bank statements. This is a custom page that you should build based on your most immediate needs.

Let’s go over the sections: Summary Spreadsheet

All the formulas I use I found with Google Searches and adapted them to my needs. Again, I encourage you to use a more ‘universal’ platform that will allow you to share it with anyone. I ran a quick Google Search for ‘Startup Financial Models’ and came across a few subscription tools that offer this service. THE ALL-MIGHTY SPREADSHEETĪll financial models are spreadsheets, and my best suggestion is to go with Google Sheets, which will not only allow you to keep int in sync with other teammates but to automate certain task and data inputs based on your other spreadsheets in the cloud. I’ll elaborate on the main features we used to make the model work in our favor- it should work for most companies. Over the years, I’ve simplified it to remove unnecessary modules and adapted it to serve the purposes of our SaaS business model. The spreadsheet we use is an evolution of a template created by our investors at Carao Ventures. To give you an example, about nine months ago a quick prediction in our financial model enabled us to make our company profitable while duplicating our marketing budget. Being on top of your Financial Model and business budget can make a difference and can enable managers and founders to make game-changing decisions. If there is one quintessential task a startup CEO needs to be in charge of is not letting the company running out of money.