重要前提
安装AI Skills的关键前提是:必须科学上网,且开启TUN模式,这一点至关重要,直接决定安装能否顺利完成,在此郑重提醒三遍:科学上网,科学上网,科学上网。查看完整安装教程 →
roi-calculator by dkyazzentwatwa/chatgpt-skills
npx skills add https://github.com/dkyazzentwatwa/chatgpt-skills --skill roi-calculator用于市场营销、投资和商业决策的综合投资回报率计算。
from roi_calculator import ROICalculator
calc = ROICalculator()
# 简单 ROI
roi = calc.simple_roi(investment=10000, return_value=15000)
print(f"ROI: {roi['roi_percent']}%")
# 市场营销 ROI
marketing = calc.marketing_roi(
ad_spend=5000,
revenue_generated=25000,
cost_of_goods=10000
)
print(f"Marketing ROI: {marketing['roi_percent']}%")
# 盈亏平衡分析
breakeven = calc.break_even(
fixed_costs=50000,
price_per_unit=100,
variable_cost_per_unit=60
)
print(f"Break-even units: {breakeven['units']}")
# 简单 ROI
python roi_calculator.py --investment 10000 --return 15000
# 营销活动 ROI
python roi_calculator.py --marketing --spend 5000 --revenue 25000 --cogs 10000
# 盈亏平衡分析
python roi_calculator.py --breakeven --fixed 50000 --price 100 --variable 60
# 考虑时间的投资(复合年增长率)
python roi_calculator.py --investment 10000 --return 20000 --years 5
# 投资回收期
python roi_calculator.py --payback --investment 100000 --annual-return 25000
# 比较多项投资
python roi_calculator.py --compare investments.csv
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
class ROICalculator:
def __init__(self)
# 基础 ROI
def simple_roi(self, investment: float, return_value: float) -> Dict
def net_roi(self, investment: float, gain: float, costs: float = 0) -> Dict
# 市场营销 ROI
def marketing_roi(self, ad_spend: float, revenue_generated: float,
cost_of_goods: float = 0) -> Dict
def campaign_roi(self, campaigns: List[Dict]) -> pd.DataFrame
def roas(self, ad_spend: float, revenue: float) -> Dict # Return on Ad Spend
# 投资 ROI
def investment_roi(self, initial: float, final: float, years: float) -> Dict
def cagr(self, initial: float, final: float, years: float) -> float
def total_return(self, initial: float, final: float, dividends: float = 0) -> Dict
# 盈亏平衡分析
def break_even(self, fixed_costs: float, price_per_unit: float,
variable_cost_per_unit: float) -> Dict
def break_even_revenue(self, fixed_costs: float, contribution_margin_ratio: float) -> Dict
# 投资回收期
def payback_period(self, investment: float, annual_cash_flow: float) -> Dict
def payback_period_uneven(self, investment: float, cash_flows: List[float]) -> Dict
# 比较分析
def compare_investments(self, investments: List[Dict]) -> pd.DataFrame
def rank_by_roi(self, investments: List[Dict]) -> List[Dict]
# 敏感性分析
def sensitivity_analysis(self, base_case: Dict, variables: Dict) -> pd.DataFrame
def scenario_analysis(self, scenarios: List[Dict]) -> pd.DataFrame
# 报告生成
def generate_report(self, analysis: Dict, output: str) -> str
result = calc.simple_roi(investment=10000, return_value=15000)
# 返回:
# {
# "investment": 10000,
# "return_value": 15000,
# "gain": 5000,
# "roi_percent": 50.0,
# "roi_ratio": 0.5
# }
result = calc.net_roi(
investment=10000,
gain=8000,
costs=2000 # 额外成本
)
# 返回:
# {
# "investment": 10000,
# "gross_gain": 8000,
# "costs": 2000,
# "net_gain": 6000,
# "roi_percent": 60.0
# }
result = calc.marketing_roi(
ad_spend=5000,
revenue_generated=25000,
cost_of_goods=10000
)
# 返回:
# {
# "ad_spend": 5000,
# "revenue": 25000,
# "cost_of_goods": 10000,
# "gross_profit": 15000,
# "net_profit": 10000, # 扣除广告支出后
# "roi_percent": 200.0,
# "roas": 5.0 # 每1美元广告支出产生5美元收入
# }
result = calc.roas(ad_spend=1000, revenue=4000)
# 返回:
# {
# "ad_spend": 1000,
# "revenue": 4000,
# "roas": 4.0,
# "roas_percent": 400.0
# }
campaigns = [
{"name": "Facebook", "spend": 2000, "revenue": 8000, "cogs": 3000},
{"name": "Google", "spend": 3000, "revenue": 15000, "cogs": 6000},
{"name": "Email", "spend": 500, "revenue": 3000, "cogs": 1000}
]
results = calc.campaign_roi(campaigns)
# 返回包含每个活动 ROI 的 DataFrame
result = calc.investment_roi(
initial=10000,
final=20000,
years=5
)
# 返回:
# {
# "initial": 10000,
# "final": 20000,
# "total_gain": 10000,
# "total_roi_percent": 100.0,
# "cagr_percent": 14.87, # 复合年增长率
# "years": 5
# }
result = calc.total_return(
initial=10000,
final=12000,
dividends=1500
)
# 返回:
# {
# "initial": 10000,
# "final": 12000,
# "capital_gain": 2000,
# "dividends": 1500,
# "total_return": 3500,
# "total_return_percent": 35.0
# }
result = calc.break_even(
fixed_costs=50000,
price_per_unit=100,
variable_cost_per_unit=60
)
# 返回:
# {
# "fixed_costs": 50000,
# "price_per_unit": 100,
# "variable_cost_per_unit": 60,
# "contribution_margin": 40,
# "contribution_margin_ratio": 0.4,
# "break_even_units": 1250,
# "break_even_revenue": 125000
# }
result = calc.break_even_revenue(
fixed_costs=50000,
contribution_margin_ratio=0.4 # 40% 利润率
)
# 返回:
# {
# "fixed_costs": 50000,
# "contribution_margin_ratio": 0.4,
# "break_even_revenue": 125000
# }
result = calc.payback_period(
investment=100000,
annual_cash_flow=25000
)
# 返回:
# {
# "investment": 100000,
# "annual_cash_flow": 25000,
# "payback_years": 4.0,
# "payback_months": 48
# }
result = calc.payback_period_uneven(
investment=100000,
cash_flows=[20000, 30000, 40000, 35000, 25000] # 每年
)
# 返回:
# {
# "investment": 100000,
# "payback_years": 2.75, # 第3年收回
# "cumulative_flows": [20000, 50000, 90000, 125000, 150000]
# }
investments = [
{"name": "Project A", "investment": 50000, "return": 75000, "years": 2},
{"name": "Project B", "investment": 30000, "return": 48000, "years": 3},
{"name": "Project C", "investment": 100000, "return": 180000, "years": 5}
]
comparison = calc.compare_investments(investments)
# 返回 DataFrame:
# name | investment | return | roi% | cagr% | payback
# Project A | 50000 | 75000 | 50.0 | 22.5 | 1.33
# Project B | 30000 | 48000 | 60.0 | 17.0 | 1.88
# Project C | 100000 | 180000 | 80.0 | 12.5 | 2.78
ranked = calc.rank_by_roi(investments)
# 返回按 ROI 百分比排序的投资列表
base_case = {
"fixed_costs": 50000,
"price_per_unit": 100,
"variable_cost_per_unit": 60,
"units_sold": 2000
}
# 测试价格变动的影响
sensitivity = calc.sensitivity_analysis(
base_case=base_case,
variables={
"price_per_unit": [80, 90, 100, 110, 120],
"units_sold": [1500, 1750, 2000, 2250, 2500]
}
)
# 返回显示每种组合下利润的 DataFrame
scenarios = [
{"name": "Pessimistic", "units": 1500, "price": 90},
{"name": "Base", "units": 2000, "price": 100},
{"name": "Optimistic", "units": 2500, "price": 110}
]
results = calc.scenario_analysis(scenarios)
calc = ROICalculator()
# 分析第四季度营销活动
campaigns = [
{"name": "Black Friday Email", "spend": 2000, "revenue": 45000, "cogs": 20000},
{"name": "Holiday Facebook", "spend": 8000, "revenue": 35000, "cogs": 14000},
{"name": "Google Shopping", "spend": 5000, "revenue": 28000, "cogs": 12000}
]
results = calc.campaign_roi(campaigns)
print(results.sort_values("roi_percent", ascending=False))
# 找出表现最佳的活动
best = results.loc[results["roi_percent"].idxmax()]
print(f"Best ROI: {best['name']} at {best['roi_percent']:.1f}%")
calc = ROICalculator()
# 比较扩张选项
options = [
{"name": "New Location", "investment": 200000, "annual_return": 45000},
{"name": "Equipment Upgrade", "investment": 75000, "annual_return": 20000},
{"name": "Digital Marketing", "investment": 30000, "annual_return": 12000}
]
for opt in options:
payback = calc.payback_period(opt["investment"], opt["annual_return"])
roi = calc.simple_roi(opt["investment"], opt["investment"] + opt["annual_return"] * 5)
print(f"{opt['name']}: Payback={payback['payback_years']:.1f}yr, 5yr ROI={roi['roi_percent']:.1f}%")
calc = ROICalculator()
# 不同价格点的盈亏平衡分析
fixed_costs = 100000
variable_cost = 25
for price in [40, 50, 60, 75, 100]:
be = calc.break_even(fixed_costs, price, variable_cost)
print(f"Price ${price}: Break-even at {be['break_even_units']:,} units (${be['break_even_revenue']:,.0f})")
每周安装量
62
代码仓库
GitHub 星标数
38
首次出现
2026年1月24日
安全审计
安装于
opencode53
gemini-cli52
codex50
cursor50
github-copilot48
claude-code44
Comprehensive ROI calculations for marketing, investments, and business decisions.
from roi_calculator import ROICalculator
calc = ROICalculator()
# Simple ROI
roi = calc.simple_roi(investment=10000, return_value=15000)
print(f"ROI: {roi['roi_percent']}%")
# Marketing ROI
marketing = calc.marketing_roi(
ad_spend=5000,
revenue_generated=25000,
cost_of_goods=10000
)
print(f"Marketing ROI: {marketing['roi_percent']}%")
# Break-even analysis
breakeven = calc.break_even(
fixed_costs=50000,
price_per_unit=100,
variable_cost_per_unit=60
)
print(f"Break-even units: {breakeven['units']}")
# Simple ROI
python roi_calculator.py --investment 10000 --return 15000
# Marketing campaign ROI
python roi_calculator.py --marketing --spend 5000 --revenue 25000 --cogs 10000
# Break-even analysis
python roi_calculator.py --breakeven --fixed 50000 --price 100 --variable 60
# Investment with time (CAGR)
python roi_calculator.py --investment 10000 --return 20000 --years 5
# Payback period
python roi_calculator.py --payback --investment 100000 --annual-return 25000
# Compare multiple investments
python roi_calculator.py --compare investments.csv
class ROICalculator:
def __init__(self)
# Basic ROI
def simple_roi(self, investment: float, return_value: float) -> Dict
def net_roi(self, investment: float, gain: float, costs: float = 0) -> Dict
# Marketing ROI
def marketing_roi(self, ad_spend: float, revenue_generated: float,
cost_of_goods: float = 0) -> Dict
def campaign_roi(self, campaigns: List[Dict]) -> pd.DataFrame
def roas(self, ad_spend: float, revenue: float) -> Dict # Return on Ad Spend
# Investment ROI
def investment_roi(self, initial: float, final: float, years: float) -> Dict
def cagr(self, initial: float, final: float, years: float) -> float
def total_return(self, initial: float, final: float, dividends: float = 0) -> Dict
# Break-Even Analysis
def break_even(self, fixed_costs: float, price_per_unit: float,
variable_cost_per_unit: float) -> Dict
def break_even_revenue(self, fixed_costs: float, contribution_margin_ratio: float) -> Dict
# Payback Period
def payback_period(self, investment: float, annual_cash_flow: float) -> Dict
def payback_period_uneven(self, investment: float, cash_flows: List[float]) -> Dict
# Comparative Analysis
def compare_investments(self, investments: List[Dict]) -> pd.DataFrame
def rank_by_roi(self, investments: List[Dict]) -> List[Dict]
# Sensitivity Analysis
def sensitivity_analysis(self, base_case: Dict, variables: Dict) -> pd.DataFrame
def scenario_analysis(self, scenarios: List[Dict]) -> pd.DataFrame
# Reporting
def generate_report(self, analysis: Dict, output: str) -> str
result = calc.simple_roi(investment=10000, return_value=15000)
# Returns:
# {
# "investment": 10000,
# "return_value": 15000,
# "gain": 5000,
# "roi_percent": 50.0,
# "roi_ratio": 0.5
# }
result = calc.net_roi(
investment=10000,
gain=8000,
costs=2000 # Additional costs
)
# Returns:
# {
# "investment": 10000,
# "gross_gain": 8000,
# "costs": 2000,
# "net_gain": 6000,
# "roi_percent": 60.0
# }
result = calc.marketing_roi(
ad_spend=5000,
revenue_generated=25000,
cost_of_goods=10000
)
# Returns:
# {
# "ad_spend": 5000,
# "revenue": 25000,
# "cost_of_goods": 10000,
# "gross_profit": 15000,
# "net_profit": 10000, # After ad spend
# "roi_percent": 200.0,
# "roas": 5.0 # $5 revenue per $1 ad spend
# }
result = calc.roas(ad_spend=1000, revenue=4000)
# Returns:
# {
# "ad_spend": 1000,
# "revenue": 4000,
# "roas": 4.0,
# "roas_percent": 400.0
# }
campaigns = [
{"name": "Facebook", "spend": 2000, "revenue": 8000, "cogs": 3000},
{"name": "Google", "spend": 3000, "revenue": 15000, "cogs": 6000},
{"name": "Email", "spend": 500, "revenue": 3000, "cogs": 1000}
]
results = calc.campaign_roi(campaigns)
# Returns DataFrame with ROI for each campaign
result = calc.investment_roi(
initial=10000,
final=20000,
years=5
)
# Returns:
# {
# "initial": 10000,
# "final": 20000,
# "total_gain": 10000,
# "total_roi_percent": 100.0,
# "cagr_percent": 14.87, # Compound Annual Growth Rate
# "years": 5
# }
result = calc.total_return(
initial=10000,
final=12000,
dividends=1500
)
# Returns:
# {
# "initial": 10000,
# "final": 12000,
# "capital_gain": 2000,
# "dividends": 1500,
# "total_return": 3500,
# "total_return_percent": 35.0
# }
result = calc.break_even(
fixed_costs=50000,
price_per_unit=100,
variable_cost_per_unit=60
)
# Returns:
# {
# "fixed_costs": 50000,
# "price_per_unit": 100,
# "variable_cost_per_unit": 60,
# "contribution_margin": 40,
# "contribution_margin_ratio": 0.4,
# "break_even_units": 1250,
# "break_even_revenue": 125000
# }
result = calc.break_even_revenue(
fixed_costs=50000,
contribution_margin_ratio=0.4 # 40% margin
)
# Returns:
# {
# "fixed_costs": 50000,
# "contribution_margin_ratio": 0.4,
# "break_even_revenue": 125000
# }
result = calc.payback_period(
investment=100000,
annual_cash_flow=25000
)
# Returns:
# {
# "investment": 100000,
# "annual_cash_flow": 25000,
# "payback_years": 4.0,
# "payback_months": 48
# }
result = calc.payback_period_uneven(
investment=100000,
cash_flows=[20000, 30000, 40000, 35000, 25000] # Per year
)
# Returns:
# {
# "investment": 100000,
# "payback_years": 2.75, # Recovered in year 3
# "cumulative_flows": [20000, 50000, 90000, 125000, 150000]
# }
investments = [
{"name": "Project A", "investment": 50000, "return": 75000, "years": 2},
{"name": "Project B", "investment": 30000, "return": 48000, "years": 3},
{"name": "Project C", "investment": 100000, "return": 180000, "years": 5}
]
comparison = calc.compare_investments(investments)
# Returns DataFrame:
# name | investment | return | roi% | cagr% | payback
# Project A | 50000 | 75000 | 50.0 | 22.5 | 1.33
# Project B | 30000 | 48000 | 60.0 | 17.0 | 1.88
# Project C | 100000 | 180000 | 80.0 | 12.5 | 2.78
ranked = calc.rank_by_roi(investments)
# Returns investments sorted by ROI percentage
base_case = {
"fixed_costs": 50000,
"price_per_unit": 100,
"variable_cost_per_unit": 60,
"units_sold": 2000
}
# Test impact of price changes
sensitivity = calc.sensitivity_analysis(
base_case=base_case,
variables={
"price_per_unit": [80, 90, 100, 110, 120],
"units_sold": [1500, 1750, 2000, 2250, 2500]
}
)
# Returns DataFrame showing profit at each combination
scenarios = [
{"name": "Pessimistic", "units": 1500, "price": 90},
{"name": "Base", "units": 2000, "price": 100},
{"name": "Optimistic", "units": 2500, "price": 110}
]
results = calc.scenario_analysis(scenarios)
calc = ROICalculator()
# Analyze Q4 campaigns
campaigns = [
{"name": "Black Friday Email", "spend": 2000, "revenue": 45000, "cogs": 20000},
{"name": "Holiday Facebook", "spend": 8000, "revenue": 35000, "cogs": 14000},
{"name": "Google Shopping", "spend": 5000, "revenue": 28000, "cogs": 12000}
]
results = calc.campaign_roi(campaigns)
print(results.sort_values("roi_percent", ascending=False))
# Find best performing campaign
best = results.loc[results["roi_percent"].idxmax()]
print(f"Best ROI: {best['name']} at {best['roi_percent']:.1f}%")
calc = ROICalculator()
# Compare expansion options
options = [
{"name": "New Location", "investment": 200000, "annual_return": 45000},
{"name": "Equipment Upgrade", "investment": 75000, "annual_return": 20000},
{"name": "Digital Marketing", "investment": 30000, "annual_return": 12000}
]
for opt in options:
payback = calc.payback_period(opt["investment"], opt["annual_return"])
roi = calc.simple_roi(opt["investment"], opt["investment"] + opt["annual_return"] * 5)
print(f"{opt['name']}: Payback={payback['payback_years']:.1f}yr, 5yr ROI={roi['roi_percent']:.1f}%")
calc = ROICalculator()
# Break-even at different price points
fixed_costs = 100000
variable_cost = 25
for price in [40, 50, 60, 75, 100]:
be = calc.break_even(fixed_costs, price, variable_cost)
print(f"Price ${price}: Break-even at {be['break_even_units']:,} units (${be['break_even_revenue']:,.0f})")
Weekly Installs
62
Repository
GitHub Stars
38
First Seen
Jan 24, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
opencode53
gemini-cli52
codex50
cursor50
github-copilot48
claude-code44
DOCX文件创建、编辑与分析完整指南 - 使用docx-js、Pandoc和Python脚本
52,800 周安装