Appendix C: ROI Calculators and Worksheets
These worksheets are designed to be printed out and filled in by hand, or recreated in a spreadsheet. Each one helps you quantify the financial impact of AI adoption in a specific area of your business. The math is simple on purpose — no MBA required.
Worksheet 1: Missed Call Revenue Calculator
This is the single most important calculation in this book. Most trade business owners dramatically underestimate how much revenue they lose to unanswered calls.
Step 1: Gather Your Data
| Data Point | Your Number |
|---|---|
| A. Total calls per week (check phone records) | _______ |
| B. Calls missed or sent to voicemail per week | _______ |
| C. Your close rate on leads (estimate 25-35% if unsure) | _______% |
| D. Average job value (total revenue / total jobs last year) | $_______ |
Step 2: Calculate Weekly Lost Revenue
Missed calls per week (B) x Close rate (C) x Average job value (D)
= Weekly revenue lost to missed calls
_______ x _______% x $_______ = $_______ per week
Step 3: Annualize It
Weekly lost revenue x 52 weeks = Annual revenue lost
$_______ x 52 = $_______ per year
Step 4: Calculate AI Phone Answering ROI
Monthly cost of AI phone answering service: $_______ /month
Annual cost: $_______ x 12 = $_______ /year
Annual revenue recovered (Step 3): $_______ /year
Annual cost of AI service: $_______ /year
Net annual gain: $_______ - $_______ = $_______ /year
ROI multiple: Revenue recovered / Cost = _______x return
Example
A plumbing company receives 120 calls per week, misses 25 of them, has a 30% close rate, and an average job value of $450.
- Weekly lost revenue: 25 x 0.30 x $450 = $3,375
- Annual lost revenue: $3,375 x 52 = $175,500
- AI phone service cost: $200/month = $2,400/year
- Net annual gain: $175,500 - $2,400 = $173,100
- ROI: 73x return on investment
Even if the AI only captures half of those missed calls, the ROI is still extraordinary.
Worksheet 2: AI Marketing ROI Calculator
This worksheet helps you evaluate whether an AI marketing tool (social media, email, reputation management, or SEO) is worth the investment.
Step 1: Baseline Your Current Marketing
| Data Point | Your Number |
|---|---|
| A. Leads generated per month (all sources) | _______ |
| B. Close rate on leads | _______% |
| C. Average job value | $_______ |
| D. Current monthly marketing spend (all channels) | $_______ |
Step 2: Calculate Current Marketing Revenue
Monthly leads (A) x Close rate (B) x Average job value (C)
= Monthly revenue from marketing
_______ x _______% x $_______ = $_______ /month
Step 3: Calculate Current Cost Per Lead and Cost Per Job
Cost per lead: Monthly spend (D) / Monthly leads (A)
= $_______ / _______ = $_______ per lead
Cost per job: Monthly spend (D) / (Monthly leads x Close rate)
= $_______ / (_______ x _______%) = $_______ per job
Step 4: Project AI Marketing Impact
Most contractors see a 20-40% increase in lead volume within 90 days of implementing AI marketing tools, primarily through improved response time, automated follow-up, and better online reputation management.
Conservative estimate (20% increase):
New monthly leads: _______ x 1.20 = _______
New monthly revenue: _______ x _______% x $_______ = $_______
Revenue increase: $_______ - $_______ = $_______ /month
Moderate estimate (30% increase):
New monthly leads: _______ x 1.30 = _______
New monthly revenue: _______ x _______% x $_______ = $_______
Revenue increase: $_______ - $_______ = $_______ /month
Step 5: Calculate Net ROI
Monthly AI marketing tool cost: $_______
Monthly revenue increase (conservative): $_______
Net monthly gain: $_______ - $_______ = $_______
Annual net gain: $_______ x 12 = $_______
Worksheet 3: AI Operations Savings Calculator
This worksheet quantifies the time savings from AI automation and converts it to dollar value.
Step 1: Identify Time Spent on Automatable Tasks
Fill in the weekly hours your team spends on each task. Be honest — track it for a week if you are not sure.
| Task | Hours/Week | Can AI Do This? | AI Reduction % |
|---|---|---|---|
| Answering and returning phone calls | _______ | Yes | 60-80% |
| Scheduling and dispatching | _______ | Yes | 40-60% |
| Creating estimates and proposals | _______ | Yes | 50-70% |
| Invoicing and payment follow-up | _______ | Yes | 60-80% |
| Social media and marketing | _______ | Yes | 70-90% |
| Data entry and paperwork | _______ | Yes | 70-90% |
| Customer follow-up and review requests | _______ | Yes | 80-90% |
| Ordering parts and supplies | _______ | Yes | 40-60% |
| Total hours/week on automatable tasks | _______ |
Step 2: Calculate Time Savings
Total automatable hours per week: _______
Conservative AI reduction (50%): _______ x 0.50 = _______ hours saved/week
Step 3: Convert to Dollar Value
Hourly value of the person(s) doing this work:
(Include salary + benefits + overhead. If it is you, the owner,
use what your time is actually worth — likely $75-150/hour.)
Hourly rate: $_______
Weekly savings: _______ hours x $_______ = $_______ /week
Annual savings: $_______ x 52 = $_______ /year
Step 4: Calculate Net ROI
Total monthly cost of AI operations tools: $_______
Annual tool cost: $_______ x 12 = $_______
Annual time savings value (Step 3): $_______
Annual tool cost: $_______
Net annual savings: $_______ - $_______ = $_______
The Hidden Multiplier
Time savings have a compounding effect that is hard to capture in a simple worksheet. When you save 15 hours per week on administrative tasks, those hours do not just disappear — they can be redirected to:
- Revenue-generating activities (selling, estimating, customer visits)
- Business development (networking, training, strategic planning)
- Quality of life (leaving at 5 PM instead of 8 PM)
If you redirect even half of your saved hours to revenue-generating activities, the actual ROI is 2-3 times what the worksheet shows.
Worksheet 4: 90-Day AI Implementation Tracker
Use this week-by-week checklist to stay on track during your first 90 days of AI adoption.
Weeks 1-2: Foundation
- Complete the AI Readiness Score (Chapter 16)
- Make your 3 decisions (bottleneck, budget, owner)
- Complete the Monday Morning Checklist
- Sign up for a free trial of your first AI tool
- Calculate your missed call revenue (Worksheet 1)
- Set up a dedicated folder/notebook for tracking AI results
Weeks 3-4: First Tool Implementation
- Configure your first AI tool with your business information
- Test the tool thoroughly (run every scenario you can think of)
- Train any team members who need to interact with it
- Set up tracking for your key metric (calls answered, leads generated, time saved)
- Document your baseline numbers before the AI was active
Weeks 5-6: Measure and Adjust
- Review first month of data from your AI tool
- Compare to baseline numbers — is it working?
- Identify what needs adjustment (scripts, settings, workflows)
- Make adjustments and note what you changed
- Calculate actual ROI for the first month
Weeks 7-8: Expand or Optimize
- If first tool is working: research your second AI tool (address next bottleneck)
- If first tool is underperforming: troubleshoot or evaluate alternatives
- Talk to your team about what is working and what is not
- Join an online community of contractors using AI (for ongoing learning)
- Complete AI Marketing ROI Calculator (Worksheet 2)
Weeks 9-10: Second Tool or Deeper Integration
- Implement second AI tool or deepen use of first tool
- Look for integration opportunities between tools
- Complete AI Operations Savings Calculator (Worksheet 3)
- Update your tracking spreadsheet with all metrics
Weeks 11-12: Review and Plan Next Quarter
- Compile 90-day results across all AI tools
- Calculate total ROI for the quarter
- Identify your next 3 bottlenecks to address
- Set budget for next quarter based on results
- Create your Q2 AI implementation plan
- Share results with your team to build buy-in
90-Day Success Metrics
At the end of 90 days, you should be able to answer these questions:
- How many additional calls are being answered? _______
- How much additional revenue has AI generated or recovered? $_______
- How many hours per week has AI saved your team? _______
- What is the total monthly cost of your AI tools? $_______
- What is your net monthly ROI? $_______
Worksheet 5: AI Tool Evaluation Scorecard
Use this scorecard when comparing AI tools. Score each criterion from 1 (poor) to 5 (excellent) and multiply by the weight.
| Criterion | Weight | Tool A Score (1-5) | Tool A Weighted | Tool B Score (1-5) | Tool B Weighted |
|---|---|---|---|---|---|
| Solves your core problem | x4 | _____ | _____ | _____ | _____ |
| Ease of setup | x3 | _____ | _____ | _____ | _____ |
| Ease of daily use | x3 | _____ | _____ | _____ | _____ |
| Integration with existing tools | x3 | _____ | _____ | _____ | _____ |
| Monthly cost vs. expected ROI | x4 | _____ | _____ | _____ | _____ |
| Quality of customer support | x2 | _____ | _____ | _____ | _____ |
| Training and onboarding resources | x2 | _____ | _____ | _____ | _____ |
| Mobile app quality | x2 | _____ | _____ | _____ | _____ |
| Reviews from other contractors | x2 | _____ | _____ | _____ | _____ |
| Contract flexibility (month-to-month vs. annual) | x1 | _____ | _____ | _____ | _____ |
| Data export capability | x1 | _____ | _____ | _____ | _____ |
| TOTAL WEIGHTED SCORE | _____ | _____ |
Scoring Guide
- 100-130 points: Strong candidate. Start the free trial.
- 75-99 points: Decent option. Compare with at least one alternative.
- 50-74 points: Significant concerns. Look for better alternatives.
- Below 50 points: Not a fit. Move on.
Red Flags to Watch For
Before signing up for any tool, check for these warning signs:
- Annual contract required with no trial period. Reputable tools offer monthly billing or at least a 14-day free trial.
- No integrations with common software. If it does not connect to anything you already use, it becomes another data silo.
- Support is email-only with 48+ hour response times. When your AI phone system goes down on a Monday morning, you need help now, not Wednesday.
- Cannot export your data. If you decide to switch tools, you need to take your customer data with you.
- Pricing is hidden until you talk to sales. Transparent pricing is a sign of a confident product. "Call for pricing" often means "we will charge what we think you can afford."
- No other contractors in your trade are using it. Being an early adopter is fine, but if zero contractors in your trade use a tool, there is probably a reason.
Quick Reference: Key Formulas
Keep these formulas handy for ongoing ROI tracking:
Revenue per lead: Average job value x Close rate = Revenue per lead
Cost per acquisition: Monthly marketing spend / New customers acquired = Cost per acquisition
Customer lifetime value: Average job value x Average jobs per customer per year x Average customer lifespan in years = Customer lifetime value
AI tool ROI: (Revenue gained or recovered - Tool cost) / Tool cost x 100 = ROI percentage
Break-even point: Monthly tool cost / Revenue generated per additional lead = Leads needed to break even
Hourly value of saved time: Annual salary + benefits / 2,080 work hours = Effective hourly rate
These are not complicated formulas. But the contractors who track these numbers make dramatically better technology investments than those who guess.