Cost-Benefit Analysis Tool

CBA Option 1

Initial Investment:

Discount Rate (e.g., 0.1 for 10%):

Project Duration (Years):

Annual Costs:

Annual Benefits:

Results:

NPV:

IRR:

Payback Period:

CBA Option 2

Initial Investment:

Discount Rate (e.g., 0.1 for 10%):

Project Duration (Years):

Annual Costs:

Annual Benefits:

Results:

NPV:

IRR:

Payback Period:

CBA Option 3

Initial Investment:

Discount Rate (e.g., 0.1 for 10%):

Project Duration (Years):

Annual Costs:

Annual Benefits:

Results:

NPV:

IRR:

Payback Period:

CBA Option 4

Initial Investment:

Discount Rate (e.g., 0.1 for 10%):

Project Duration (Years):

Annual Costs:

Annual Benefits:

Results:

NPV:

IRR:

Payback Period:

Multi-Criteria Analysis

Criteria	Weight (0-1)	Option 1 Score (1-5)	Option 2 Score (1-5)	Option 3 Score (1-5)	Option 4 Score (1-5)
Total Weighted Score

Summary Table

Metric	Option 1	Option 2	Option 3	Option 4
NPV
IRR
Payback Period (Years)

Cost-Benefit Analysis Tool

CBA Option 1

Annual Costs:

Annual Benefits:

Results:

CBA Option 2

Annual Costs:

Annual Benefits:

Results:

CBA Option 3

Annual Costs:

Annual Benefits:

Results:

CBA Option 4

Annual Costs:

Annual Benefits:

Results:

Multi-Criteria Analysis

Summary Table

Charts

NPV Comparison

IRR Comparison

Payback Period Comparison

Multi-Criteria Score Comparison

Full Report