Roi Calculator

---
name: roi-calculator
description: "A B2B sales ROI (Return on Investment) calculation framework. Used for 'sales ROI calculation,' 'TCO analysis,' 'payback period,' 'cost reduction analysis,' and 'value proposition quantification' when writing sales proposals. Note: Financial statement auditing and tax advisory are outside the scope of this skill."
---

# ROI Calculator — B2B Sales ROI Calculation Framework

A skill that enhances value proposition quantification for proposal-writer and presenter.

## Target Agents

- **proposal-writer** — Includes persuasive ROI in the proposal
- **presenter** — Constructs ROI visualization materials for the presentation

## ROI Calculation Formulas

### Basic ROI

```
ROI = (Net Benefit - Investment Cost) / Investment Cost x 100%

Net Benefit = Cost Savings + Revenue Increase + Productivity Gains (Value)
Investment Cost = Adoption Cost + Implementation Cost + Operating Cost + Switching Cost
```

### TCO (Total Cost of Ownership)

```
TCO = Initial Cost + Operating Cost (N years) + Switching Cost + Hidden Costs

Initial Cost:
  - License/purchase fees
  - Implementation/customization
  - Data migration
  - Training costs

Operating Cost (annual):
  - Subscription/maintenance fees
  - Infrastructure costs
  - Administrative labor costs
  - Upgrade costs

Switching Cost:
  - Existing system termination
  - Parallel operation period costs
  - Productivity loss (learning curve)

Hidden Costs:
  - Downtime costs
  - Security incident risk
  - Regulatory non-compliance penalties
```

### Payback Period

```
Payback = Total Investment / Monthly Net Benefit

Example:
  Investment: $1M
  Monthly savings: $125K
  Payback = $1M / $125K = 8 months
```

## Value Quantification Framework

### Cost Reduction

```
1. Labor cost savings
   Savings = Automated hours x Hourly rate x Headcount
   Example: 10 hrs/week x $50/hr x 20 people = $40K/month

2. Infrastructure savings
   Savings = (Current infra cost - New infra cost) x 12
   Example: ($50K/mo - $20K/mo) x 12 = $360K/year

3. Error cost reduction
   Savings = Error count x Cost per error x Reduction rate
   Example: 50/month x $1K x 80% = $40K/month
```

### Revenue Growth

```
1. Conversion rate improvement
   Increase = Current revenue x Conversion rate uplift
   Example: $10M/month x 2% uplift = $200K/month

2. Churn reduction
   Increase = Churned customers x Customer value x Prevention rate
   Example: 100/month x $5K x 30% = $150K/month

3. Upsell/Cross-sell
   Increase = Target customers x Additional purchase rate x Average value
```

### Productivity

```
1. Time savings
   Value = Hours saved x Hourly rate x Headcount
   Example: 2 hrs/day x $50/hr x 50 people = $110K/month

2. Decision speed
   Value = Opportunity cost x Time reduction

3. Customer service efficiency
   Value = Processing time reduction per case x Case volume x Time value
```

## Three-Stage ROI Presentation

```
Stage 1: Conservative Scenario
  - Reflects only minimum effects
  - "Even in the worst case, ROI is at least this much"
  - Pre-emptively lowers figures the customer might question

Stage 2: Base Scenario
  - Based on comparable customer cases
  - "ROI most customers experience"
  - Cites specific case studies

Stage 3: Optimistic Scenario
  - When full functionality is utilized
  - "ROI achievable after optimization"
  - Includes long-term value
```

## Boosting ROI Credibility

```
1. Use customer data
   "Based on your current processing volume of X..."

2. Industry peer case studies
   "Measured over 18 months at a similarly sized manufacturer..."

3. State conservative assumptions
   "We've conservatively assumed a 50% adoption rate"

4. Cite third-party data
   "According to Gartner, the average ROI in this category is X%..."

5. Phased milestones
   "Month 3: Cost savings begin, Month 6: Break-even, Month 12: ROI 200%"
```

## ROI Calculation Sheet Template

```markdown
## ROI Analysis Summary

### Investment Cost (3-Year TCO)
| Item | Year 1 | Year 2 | Year 3 | Total |
|------|--------|--------|--------|-------|
| Initial Cost | | - | - | |
| Operating Cost | | | | |
| **Total** | | | | |

### Expected Benefits (Annual)
| Item | Calculation Basis | Year 1 | Year 2 | Year 3 |
|------|-----------------|--------|--------|--------|
| Cost Savings | | | | |
| Revenue Increase | | | | |
| Productivity | | | | |
| **Total** | | | | |

### ROI Summary
- 3-Year ROI: [N]%
- Payback: [N] months
- 3-Year Net Benefit: $[N]
```