SaaS-Cash-Flow-Trough5
The left image shows the main elements of the funnel, and the right image breaks down the actual flow of leads. If we look at the very top of the funnel on the right, we see that leads are assumed to come from two different types of sources: paid leads and organic leads unpaid. The model assumes that organic unpaid leads grow at about the same rate as paid leads, and allows you to set a variable, which is the percentage of your overall visitor traffic that comes from unpaid sources. In the example data, I set it to 50%.
Below I show a portion of the spreadsheet model that calculates philippines mobile database the lead cost required to service a new salesperson $8,698 per month. This turns out to be very important because it is an important cost that is often overlooked.
SaaS-Cash-Flow-Trough6
The model also calculates rough values for CAC cost to acquire a customer and LTV lifetime value of a customer. These values are rough because they do not include the costs of a marketer or sales management. Adding these costs is not difficult: divide the monthly cost value by the number of customers acquired that month.