Investment Analysis

Investment Analysis

Evaluate proposed investments, capital projects, or strategic business cases using rigorous financial analysis. This skill produces a structured evaluation with quantitative metrics, risk assessment, and a clear recommendation.

Step 1 — Define the Investment Opportunity

Capture the full scope of the proposed investment.

Checklist

• Problem statement or opportunity clearly articulated
• Alternatives identified (minimum: invest, delay, do nothing)
• Sponsor has committed to providing input assumptions
• Finance team has confirmed discount rate / hurdle rate
• Timeline and resource requirements are scoped

Step 2 — Estimate Costs

Build a comprehensive cost model including all direct and indirect expenses.

Cost Breakdown Template

Cost Estimation Guidelines

• Include fully-loaded costs (salary + benefits + overhead) for personnel.
• Capture opportunity costs: what else could this capital fund?
• Add contingency buffer of 10–15% for estimation uncertainty.
• Distinguish between sunk costs (already spent, do not include in forward analysis) and incremental costs.

Step 3 — Estimate Benefits

Quantify the financial returns the investment will generate.

Benefits Classification

Benefits Schedule Template

Step 4 — Financial Metrics Calculation

Compute the standard investment evaluation metrics.

Net Present Value (NPV)

NPV = Sum of [ (Benefits_t - Costs_t) / (1 + r)^t ] for t = 0 to T

• Discount Rate: Use the company's weighted average cost of capital (WACC) or hurdle rate. Typical range: 8–15%.
• Decision Rule: Invest if NPV > 0.

Internal Rate of Return (IRR)

• IRR is the discount rate that makes NPV = 0.
• Decision Rule: Invest if IRR > hurdle rate.
• Caution: IRR can be misleading for non-conventional cash flows (multiple sign changes). In those cases, use Modified IRR (MIRR).

Payback Period

• Simple Payback: Time to recover initial investment (undiscounted).
• Discounted Payback: Time to recover initial investment using discounted cash flows.
• Decision Rule: Shorter payback is better; typically acceptable if < 3 years for OpEx, < 5 years for CapEx.

Return on Investment (ROI)

ROI = (Total Benefits - Total Costs) / Total Costs x 100%

Metrics Summary

Step 5 — Sensitivity Analysis

Test how the investment outcome changes under different assumptions.

One-Variable Sensitivity Table

Values in the table represent the resulting NPV for each sensitivity.

Scenario Matrix (Two-Variable)

Break-Even Analysis

• What is the minimum revenue needed to break even (NPV = 0)?
• What is the minimum adoption rate needed?
• What is the maximum cost the project can incur before NPV turns negative?

Step 6 — Risk Assessment and Recommendation

Evaluate non-financial risks and deliver a clear recommendation.

Risk Register

Probability: Low / Medium / High. Impact: Low / Medium / High. Severity: Low / Medium / High / Critical.

Recommendation Framework

Recommendation Levels

• Strong Invest (score > 4.0): Clear financial and strategic case; manageable risk.
• Invest with Conditions (3.0–4.0): Positive case but requires specific mitigations or phased approach.
• Defer (2.0–3.0): Uncertain return; revisit when conditions change.
• Do Not Invest (< 2.0): Negative NPV or unacceptable risk; pursue alternatives.

Output Format

## Investment Analysis — [Project Name]

### 1. Executive Summary
- Investment amount: $X over Y years
- NPV: $X | IRR: X% | Payback: X years
- Recommendation: [Strong Invest / Invest with Conditions / Defer / Do Not Invest]
- Key rationale (3 bullets)

### 2. Investment Overview
[Problem statement, strategic context, alternatives considered]

### 3. Cost Analysis
[Detailed cost breakdown by year]

### 4. Benefits Analysis
[Quantified benefits with confidence ratings]

### 5. Financial Metrics
[NPV, IRR, payback, ROI summary table]

### 6. Sensitivity Analysis
[Sensitivity tables and break-even points]

### 7. Risk Assessment
[Risk register with mitigations]

### 8. Recommendation
[Weighted scoring; clear go/no-go with conditions]

### 9. Appendix
- Detailed cash flow model
- Assumption log
- Comparable investments / benchmarks

Quality Checklist

• All costs are incremental (sunk costs excluded)
• Benefits are conservatively estimated with confidence ratings
• Discount rate is documented and approved by Finance
• NPV, IRR, and payback are consistent with each other
• Sensitivity analysis covers the 3–5 most impactful variables
• Risks have specific mitigation strategies, not generic statements
• "Do nothing" alternative is explicitly evaluated
• Recommendation is supported by both quantitative and qualitative analysis

Edge Cases