# Roi Analysis

> Calculate and analyze return on investment for projects and initiatives. Use for: ROI calculation, cost-benefit analysis, payback period, NPV analysis, business case development, investment evaluation, project justification, and financial decision-making.

- Skill: `majiayu000/roi-analysis` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/roi-analysis`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/roi-analysis/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/roi-analysis

---


# ROI Analysis

Calculate and analyze return on investment to evaluate and justify business decisions and projects.

## Overview

Return on Investment (ROI) analysis is a financial metric used to evaluate the profitability and efficiency of investments. It compares the benefits (returns) of an investment to its costs, helping organizations make informed decisions about resource allocation. This skill covers ROI calculation methods, related metrics (NPV, IRR, payback period), cost-benefit analysis, business case development, and decision-making frameworks.

## ROI Fundamentals

### Basic ROI Formula

```
ROI = (Net Benefit / Cost of Investment) × 100%

Or:
ROI = (Gain from Investment - Cost of Investment) / Cost of Investment × 100%
```

**Example**:
```
Investment: $100,000
Return: $150,000
Net Benefit: $50,000

ROI = ($50,000 / $100,000) × 100% = 50%
```

**Interpretation**: For every dollar invested, you gain $0.50 in return.

### ROI Components

**Costs (Investment)**:
- Initial capital expenditure
- Implementation costs
- Training and change management
- Ongoing operational costs
- Maintenance and support
- Opportunity costs

**Benefits (Returns)**:
- Revenue increase
- Cost savings
- Productivity gains
- Risk reduction
- Quality improvements
- Strategic value

### Time Value of Money

**Concept**: A dollar today is worth more than a dollar tomorrow

**Why It Matters**:
- Inflation erodes purchasing power
- Money can be invested to earn returns
- Risk and uncertainty increase over time

**Implication**: Must discount future cash flows to present value for accurate ROI analysis

## ROI Calculation Methods

### Simple ROI

**Formula**: (Total Benefits - Total Costs) / Total Costs × 100%

**Advantages**:
- Easy to calculate and understand
- Quick comparison of alternatives
- Widely recognized metric

**Disadvantages**:
- Ignores time value of money
- Doesn't account for timing of cash flows
- Can be manipulated by changing time period

**When to Use**: Quick screening, short-term projects (<1 year), rough estimates

### Annualized ROI

**Formula**: [(1 + ROI)^(1/n) - 1] × 100%
where n = number of years

**Example**:
```
3-year ROI = 50%
Annualized ROI = [(1 + 0.50)^(1/3) - 1] × 100% = 14.5% per year
```

**Advantage**: Enables comparison of investments with different time horizons

### Net Present Value (NPV)

**Formula**:
```
NPV = Σ [Cash Flow_t / (1 + r)^t] - Initial Investment

where:
t = time period
r = discount rate
```

**Example**:
```
Initial Investment: $100,000
Year 1 Cash Flow: $30,000
Year 2 Cash Flow: $40,000
Year 3 Cash Flow: $50,000
Discount Rate: 10%

NPV = $30,000/(1.10)^1 + $40,000/(1.10)^2 + $50,000/(1.10)^3 - $100,000
    = $27,273 + $33,058 + $37,566 - $100,000
    = -$2,103
```

**Decision Rule**:
- NPV > 0: Accept project (creates value)
- NPV < 0: Reject project (destroys value)
- NPV = 0: Indifferent

**Advantages**:
- Accounts for time value of money
- Considers all cash flows
- Absolute measure of value creation

**Disadvantages**:
- Requires discount rate assumption
- Difficult to compare projects of different sizes
- Less intuitive than ROI percentage

### Internal Rate of Return (IRR)

**Definition**: Discount rate that makes NPV = 0

**Calculation**: Solve for r in NPV formula when NPV = 0
(Typically done using Excel IRR function or financial calculator)

**Decision Rule**:
- IRR > Required Return: Accept project
- IRR < Required Return: Reject project

**Example**:
```
Initial Investment: $100,000
Year 1-5 Cash Flows: $30,000 each

IRR = 15.2%

If required return is 10%, accept project (15.2% > 10%)
```

**Advantages**:
- Easy to understand (percentage return)
- Accounts for time value of money
- No need to specify discount rate

**Disadvantages**:
- Can have multiple IRRs for non-conventional cash flows
- Assumes reinvestment at IRR (often unrealistic)
- Can be misleading for mutually exclusive projects

### Payback Period

**Definition**: Time required to recover initial investment

**Formula**: Initial Investment / Annual Cash Flow (if cash flows are equal)

**Example**:
```
Initial Investment: $100,000
Annual Cash Flow: $25,000

Payback Period = $100,000 / $25,000 = 4 years
```

**For Unequal Cash Flows**: Cumulative cash flow method
```
Year 0: -$100,000
Year 1: $30,000 (Cumulative: -$70,000)
Year 2: $40,000 (Cumulative: -$30,000)
Year 3: $50,000 (Cumulative: $20,000)

Payback Period = 2 + ($30,000 / $50,000) = 2.6 years
```

**Decision Rule**: Shorter payback period is better

**Advantages**:
- Simple to calculate and understand
- Focuses on liquidity and risk
- Useful for companies with cash constraints

**Disadvantages**:
- Ignores cash flows after payback
- Ignores time value of money (unless discounted payback used)
- Arbitrary cutoff period

### Profitability Index (PI)

**Formula**: PV of Future Cash Flows / Initial Investment

**Example**:
```
PV of Future Cash Flows: $120,000
Initial Investment: $100,000

PI = $120,000 / $100,000 = 1.20
```

**Decision Rule**:
- PI > 1.0: Accept project
- PI < 1.0: Reject project

**Advantage**: Useful for ranking projects when capital is constrained

## Cost-Benefit Analysis

### Identifying Costs

**One-Time Costs**:
- Capital expenditures (equipment, software)
- Implementation and setup
- Training and change management
- Data migration
- Consulting fees

**Recurring Costs**:
- Software licenses and subscriptions
- Maintenance and support
- Personnel (salaries, benefits)
- Utilities and facilities
- Ongoing training

**Hidden Costs**:
- Productivity loss during transition
- Opportunity cost of capital
- Management time and attention
- Risk of failure or delays

### Identifying Benefits

**Tangible Benefits** (Quantifiable):
- Revenue increase
- Cost savings
- Productivity gains (hours saved × hourly rate)
- Error reduction (cost per error × errors avoided)
- Faster time-to-market

**Intangible Benefits** (Difficult to quantify):
- Improved customer satisfaction
- Better employee morale
- Enhanced brand reputation
- Competitive advantage
- Strategic positioning

**Quantifying Intangible Benefits**:
- Customer satisfaction → Retention rate → Revenue impact
- Employee morale → Turnover reduction → Recruitment cost savings
- Brand reputation → Market share increase → Revenue growth

### Cost-Benefit Analysis Process

**Step 1: Define Scope and Alternatives**
- Clearly define project or investment
- Identify alternatives (including "do nothing")
- Establish time horizon (typically 3-5 years)

**Step 2: Identify and Quantify Costs**
- List all cost categories
- Estimate amounts and timing
- Include one-time and recurring costs
- Document assumptions

**Step 3: Identify and Quantify Benefits**
- List all benefit categories
- Estimate amounts and timing
- Quantify intangibles where possible
- Document assumptions

**Step 4: Calculate Net Benefits**
- Discount future cash flows to present value
- Sum all costs and benefits
- Calculate NPV, ROI, IRR, payback period

**Step 5: Perform Sensitivity Analysis**
- Test impact of changing key assumptions
- Identify break-even points
- Assess risk and uncertainty

**Step 6: Make Recommendation**
- Compare alternatives
- Consider quantitative and qualitative factors
- Recommend course of action
- Document rationale

## Business Case Development

### Business Case Structure

**Executive Summary**:
- Problem or opportunity
- Proposed solution
- Financial summary (ROI, NPV, payback)
- Recommendation

**Business Need**:
- Current situation and problems
- Impact on business
- Urgency and consequences of inaction
- Strategic alignment

**Proposed Solution**:
- Description of project or investment
- How it addresses the need
- Alternatives considered
- Why this solution is best

**Financial Analysis**:
- Costs (one-time and recurring)
- Benefits (tangible and intangible)
- ROI, NPV, IRR, payback period
- Sensitivity analysis
- Funding requirements and sources

**Implementation Plan**:
- Timeline and milestones
- Resources required
- Risks and mitigation strategies
- Success metrics and KPIs

**Recommendation**:
- Clear recommendation (approve, reject, defer)
- Rationale
- Next steps

### Financial Summary Table

| Metric | Value | Interpretation |
|--------|-------|----------------|
| Total Investment | $500,000 | Initial and ongoing costs |
| Total Benefits (5 years) | $1,200,000 | Revenue and cost savings |
| Net Benefit | $700,000 | Total value created |
| ROI | 140% | $1.40 return per $1 invested |
| NPV (10% discount) | $350,000 | Value in today's dollars |
| IRR | 35% | Exceeds 15% hurdle rate |
| Payback Period | 2.3 years | Recovers investment quickly |

**Recommendation**: Approve project. Strong financial returns, strategic alignment, manageable risk.

## Decision-Making Frameworks

### Investment Decision Criteria

**Financial Criteria**:
- Minimum ROI threshold (e.g., 20%)
- Positive NPV
- IRR exceeds hurdle rate (e.g., 15%)
- Payback period within acceptable range (e.g., <3 years)

**Strategic Criteria**:
- Alignment with strategic objectives
- Competitive advantage
- Market positioning
- Long-term value creation

**Risk Criteria**:
- Technical feasibility
- Implementation risk
- Market risk
- Financial risk (impact on cash flow, debt)

**Resource Criteria**:
- Availability of capital
- Availability of talent and expertise
- Capacity to execute
- Opportunity cost

### Comparing Multiple Projects

**Ranking Methods**:

**1. NPV Ranking**:
- Rank projects by NPV (highest to lowest)
- Select projects until capital budget exhausted
- Best for maximizing absolute value

**2. Profitability Index Ranking**:
- Rank by PI (highest to lowest)
- Select projects until capital budget exhausted
- Best when capital is constrained

**3. IRR Ranking**:
- Rank by IRR (highest to lowest)
- Ensure IRR exceeds hurdle rate
- Can be misleading for mutually exclusive projects

**4. Balanced Scorecard**:
- Score projects on multiple criteria (financial, strategic, risk)
- Weight criteria by importance
- Calculate weighted score
- Rank by total score

**Example Balanced Scorecard**:
| Project | Financial (40%) | Strategic (30%) | Risk (20%) | Feasibility (10%) | Total Score |
|---------|-----------------|-----------------|------------|-------------------|-------------|
| A | 8 | 9 | 7 | 8 | 8.1 |
| B | 9 | 7 | 8 | 9 | 8.2 |
| C | 7 | 8 | 9 | 7 | 7.8 |

**Ranking**: B (8.2), A (8.1), C (7.8)

### Sensitivity and Risk Analysis

**Sensitivity Analysis**:
- Identify key assumptions (revenue growth, cost savings, discount rate)
- Vary each assumption by ±10%, ±20%
- Calculate impact on ROI, NPV
- Identify most sensitive variables

**Scenario Analysis**:
- Base case (most likely)
- Best case (optimistic)
- Worst case (pessimistic)
- Calculate ROI/NPV for each scenario
- Assess range of outcomes

**Break-Even Analysis**:
- Determine level of benefits needed to achieve ROI = 0% or NPV = 0
- Assess likelihood of achieving break-even
- Provides risk perspective

**Example**:
```
Investment: $100,000
Annual Benefit: $30,000 (base case)

Break-Even: $100,000 / X years = $30,000
X = 3.33 years

Question: How confident are we that benefits will last at least 3.33 years?
```

## ROI Tracking and Reporting

### Post-Implementation Review

**Purpose**: Verify that projected benefits are realized

**Process**:
1. Establish baseline before implementation
2. Track actual costs and benefits
3. Compare actual vs. projected
4. Identify variances and root causes
5. Take corrective action if needed
6. Document lessons learned

**Timing**: 6 months, 12 months, and annually after implementation

### ROI Dashboard

**Key Metrics**:
- Actual vs. projected costs
- Actual vs. projected benefits
- Actual ROI vs. projected ROI
- Benefit realization percentage
- Payback period status

**Visual Elements**:
- Trend charts (costs and benefits over time)
- Variance analysis (actual vs. projected)
- Status indicators (on track, at risk, off track)
- Cumulative ROI

### Continuous Improvement

**Lessons Learned**:

## Using the Reference Files

### When to Read Each Reference

**`/references/roi-calculation-examples.md`** — Read when calculating ROI for different project types or seeking industry-specific examples.

**`/references/npv-irr-guide.md`** — Read when performing discounted cash flow analysis or determining discount rates.

**`/references/business-case-templates.md`** — Read when developing business cases or presenting financial justifications.

**`/references/benefit-quantification.md`** — Read when quantifying intangible benefits or developing benefit realization plans.