SaaS Sales Revenue Plan/Budget Excel Template User Guide
SaaS Sales RevenuePlan/Budget Excel TemplateUser GuideThree year sales plan/budget for SaaS based businessThe SaaS Subscription 3-year revenue plan allows you to develop a monthlysales revenue plan for up to three years for a SaaS subscription-basedbusiness. The SaaS revenue plan incorporates up to 4 products (e.g.Starter/Freemium, Silver, Gold, Platinum). For each month, each productfeatures the opening number of subscribers, new subscribers added andcancelled during the month and calculates the closing number ofsubscribers. The subscription revenue is then calculated for each product.The overall average subscription rate per month is also calculated. Affiliateor partner discount/commission can be calculated monthly for each product.Other direct sales costs can be applied to the revenue plan to calculate grossmargin and percentage gross margin for each month.sales@businesstoolsstore.com1/1/2012
1/1/2012SAAS SALES REVENUE PLAN/BUDGETEXCEL TEMPLATE USER GUIDEThree year sales plan/budget for SaaS based businessINTRODUCTIONThe SaaS Subscription 3-year revenue plan allows you to develop a monthly sales revenueplan for up to three years for a SaaS subscription-based business. The SaaS revenue planincorporates up to 4 products (e.g. Starter /Freemium, Silver, Gold, Platinum). For eachmonth, each product features the opening number of subscribers, new subscribers added andcancelled during the month and calculates the closing number of subscribers. Thesubscription revenue is then calculated for each product. The overall average subscriptionrate per month is also calculated.Affiliate or partner discount/commission can be calculated monthly for each product. Otherdirect sales costs can be applied to the revenue plan to calculate gross margin and percentagegross margin for each month.www.businesstoolsstore.com1
1/1/2012USER INSTRUCTIONSThe EXCEL model has a simple Push Button Menu system which available at cells E1 toF2 of the Sales Revenue Plan worksheet (see figure 1). Prior to entering data the user shouldselect which currency s/he wishes to use in formatting reports. This can be done by clickingon the chosen currency symbol in the dialog box to the immediate right of the Title Graphic(cell E10 of the Sales Revenue Plan worksheet). Note this refers only to the currency symbolused and is NOT a currency conversion routine. You may need to install and enable theExcel Euro Currency Tools Add-in to display the symbol properly.Enter the Plan Title and Start Month/Year (Setup Company Menu option) Figure 1.These are used to format reports, by automatically updating each of the three year annualplans and charts.Figure 1Next, select Revenue Sources from the Data Input Menu. Enter Revenue Sources dataas per figure 2 below.www.businesstoolsstore.com2
1/1/2012Figure 2Print Revenue Sources Entry (Print Menu) for reference.Fill-in each Product Name, using the Revenue Sources on the Data Input Menu. Themodel allows for four different products with different Monthly Subscription Rates andnumbers of subscribers. Any appropriate Product Name can be entered to replace thedefault names, i.e. Starter (Freemium), Silver, Gold and Platinum.www.businesstoolsstore.com3
1/1/2012All data entered in Revenue Sourcing Entry section (columns A to D) is automaticallycopied to all the relevant cells and charts for each year. Any of the Descriptions in columnA can be edited and customized. For each Product enter the appropriate SubscriptionFee. A different Subscription Fee can be entered by each of the three years covered by theplan/budget.There is a facility to also enter the Direct Costs associated with each Product. The facilityprovides options to enter the Direct Cost associated with commission paid toPartners/Affiliates. The cost can be based on a percentage of the Subscription Fee or theUnit Cost per subscription or a combination of both. Different fees can be defined for eachproduct. Other Direct Costs can be defined and their Description entered in Colum A.The actual costs are entered in the appropriate month.Once the setup parameters have been entered; you are now ready to enter the SubscriberProjections on which the revenue budget will be calculated.Initially enter the opening (current) number of subscribers for each of the products in cellsH32, H40, H48, and H56 for the first year. For subsequent years the opening figures areautomatically carried forward from the closing number of subscribers in the previous year.The number of New Subscribers and the number of Ceased Subscribers for each monthfor each product are entered in rows 33 & 34, 41 & 42, 49 & 50 and 57 & 58 for each of thethree years (year 1 in columns H to S, year 2 in columns X to AI and year 3 in columns AN toAY).These numbers can be entered directly or calculated based on any formulae, such as growthrates, entered in the relevant columns.The following items are calculated: Total Number of Subscribers for each Product for each monthThe Revenue Projection for each monthThe Revenue Projection grand total for each monthThe Projected Direct Cost of Sales for each MonthThe Projected Gross Margin for each month.The Projected Gross Margin % for each month.The Total Number of Subscribers for each monthThe Overall Average Subscription Rate for each month.The Projected Revenue figures can be printed by selecting the appropriate option from thePrint Menu. Various analyses of the projections are also presented in graphicrepresentation in separate worksheets within this workbook.The Revenue Plan for each of the three year can be printed by selecting the option from thePrint Menu.OUTPUTExamples of the range of outputs are shown on the pages that follow.www.businesstoolsstore.com4
1/1/2012Annual Sales Revenue Plan/BudgetMonthly Sales Plan/budget for 3 yearswww.businesstoolsstore.com5
1/1/2012Annual Revenue by ProductTotal Subscribers by Month by Productwww.businesstoolsstore.com6
1/1/2012Total Subscribers by Month by YearAverage Subscription Rate by Month by Yearwww.businesstoolsstore.com7
SaaS Sales Revenue Plan/Budget Excel Template User Guide Three year sales plan/budget for SaaS based business The SaaS Subscription 3-year revenue plan allows you to develop a monthly sales revenue plan for up to three years for a SaaS subscription-based business. The SaaS
The SaaS Subscription 3 -year revenue plan allows you to develop a monthly sales revenue plan for up to three years for a SaaS subscription - based business focused on Enterprise sales . The SaaS revenue plan incorporates up to 4 products/markets (e.g. Standard, Premium, Premium Plus, a nd Enterprise). The model assumes that sales are made to
Three SaaS Sales Models Price and complexity define a strategic spectrum of sales approaches for SaaS startups that gravitate strongly toward three distinct SaaS sales models: self-service, transactional and enterprise. While a mature SaaS business may employ all three, a SaaS startup will have the resources to master only one.
A Green Field SaaS implementation is comparatively simple and pretty straight forward as it requires subscribing a new tenant or organization in SaaS application setup. SaaS Meta data driven reference data model can support "N "number of tenants connected to a single SaaS application environment. Existing application migration into SaaS :
The term "SaaS Agreement" includes this SaaS Agreement and the SaaS Subscription Order Form ("SaaS Order Form") found herein as Appendix 1, and any other document which is incorporated herein by reference. In case of conflicting terms, the following order of precedence shall apply: (i) the terms of the SaaS Agreement (ii) The SaaS .
The Sales Revenue Plan/Budget Excel template allows you to develop a monthly sales revenue plan for up to three years. It incorporates features such as product groups with revenue subtotals, an unlimited number of products within each product group and up to 20 seasonal sales patterns that can be applied individually to each product/revenue line.
Software- as- a- Service (SaaS) on AWS Business and Architecture Overview SaaS and AWS Introduction Software- as- a –Service (SaaS) is an application delivery model that enables users to utilize a software solution over the Internet. SaaS revenue models are typically subscription base
as of the writing of this report, the median public SaaS revenue multiple of 9.0 is substantially above historical norms. The timing of an equity raise or company sale is difficult to manage, and future public SaaS valuations are difficult to predict, however, an awareness of historical public SaaS valuation trends can provide meaningful
The computational anatomy of psychosis hypothesis that the mean is zero. The sample mean provides evi-dence against the null hypothesis in the form of a prediction error: namely, the sample mean minus the expectation under the null hypothesis. The sample mean provides evidence against the null but how much evidence? This can only be quantified in relation to the precision of the prediction .
