$75.00 USD
After purchase, the template will be immediately available to download. It is also included in the niche SaaS, Industry-Specific, and scenario planning template bundles as well as the Super Smart Bundle.
I'm really happy with the current state of my template user experience and would be confident working with any client on how to use it for their situation. This has taken many years to perfect and only really possible after working with 1,000s of clients on their new business scenarios. You will see all the features below.
You will find this template can be used for a wide range of businesses without changing much other than the verbiage. In order to make the logic easier to get your arms around, I decided to apply a new business idea (making homes safer for the elderly) to the template so it bridges the learning gap faster for users to on-board to my style of modeling.
Template Features:
- Model for up to a period of 60 months.
- Clear revenue and direct cost assumptions applied to each revenue stream for smarter scaling logic.
- Dynamic financial statements (income statement, balance sheet, cash flow statement).
- Scenario analysis on five variables (low, base, high).
- Cash flow planning / EBITDA / margins and equity requirements / returns.
- Three debt sources (one line of credit and two different term loan options).
- Visualizations / charts for key financial summary items.
- Includes debt service coverage ratios if financing is a major part of the startup.
I made the decision to not include a DCF Analysis because 9 out of 10 users don't have any idea what discount rate to use and it ends up becoming a distraction. The main return figures the model focuses on are IRR and Equity Multiple at the project level and at the operator / investor level for joint venture simulations.
Revenue Assumptions:
- Audit Revenue - One-time Initial
- Start Month of Operations
- Starting Home Audits/mo.
- Monthly Growth of Audits
- Audit Price
- Audit Price Growth
- Project Revenue - One-time Upsell
- % of Audits Converting to Projects
- Average Project Price
- Project Price Growth
- Price Over Time
- Project Fee (your revenue)
- The project fee would be paid by the customer as an amount on top of the Project Cost.
- Monthly Memberships - Recurring Services
- % of Audits Converting to Memberships
- Start Month
- Membership Price
- Membership Price Growth
- Average % of Customers Lost/mo.
- This above input drives the retention curve, which by default uses exponential decay. You can manually define the curve in the 'Retention Curve' tab if desired.
The scenario variables you can lever up and down include:
- Starting Home Audits/mo.
- Growth Rate of Audits
- Audit Price
- Project Price
- Membership Price
The user can define the plus or minus from base percentages independently for each of the five variables above.
Direct Cost Assumptions:
- Home Audit Direct Costs
- Assessor labor (Cost per audit)
- Travel / mileage (Cost per audit)
- Report preparation labor (Cost per audit)
- Printed checklist / leave-behind materials (Cost per audit)
- Payment processing fees (%)
- Refund / reschedule allowance (%)
- Retrofit Project Concierge Direct Costs
- Since we are modeling the customer paying the contractor directly with our fee on top of that as a %, all we need to model for direct costs is project management labor.
- Average Project Management Hours/Project
- % Change
- Fully Loaded Hourly Labor Cost
- % Change
- Membership Direct Costs
- Customer support
- Members per CS Rep
- % Change
- Fully Loaded CS Rep Salary
- Other Items
- Software / dashboard cost
- SMS / email notifications
- Annual safety re-check
- Device monitoring, if included
- Payment processing
- failed-payment recovery
- Member benefits / vendor discounts
- Other Direct Costs
- Sales Commissions / Referrals
- % of Audits Sourced From Referrals
- Cost per Paid Referral
- % Change
- % of Retrofit Projects Sourced From Referrals / Sales People
- Commission Rate
- % of Memberships Sourced From Referrals / Sales People
- Cost per Paid Referral
- % Change
- Scheduling / Admin Labor for Audits
- Monthly Audits per Admin Personnel
- % Change
- Fully Loaded Salary of Admin Personnel
- % Change
Other Assumptions
- Fixed cost schedule for corporate overhead.
- FTE cost schedule if needed with headcounts / salaries.
- CAPEX items.
- Initial startup costs (24 months schedule).
- Three loan options.
Similar Templates:
- Office-as-a-Service
- Cleaning Service
- Project Management
- Daycare Service
- Professional Services Agency
- On-demand Car Cleaning Service
