免费 NPV和IRR计算器 电子表格模板
计算投资项目的净现值和内部收益率。输入现金流和折现率来评估潜在投资。
Upgrade your spreadsheet
Here is how you unlock a better version.
Essentials
- Full-featured NPV & IRR Calculator with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
$12 one-time
Ultimate Most complete
- Compare up to 3 investment projects side by side with independent cash flow projections
- Each project has a dedicated sheet with 15-year cash flow table, discount factors, present values, and cumulative PV
- Dashboard with portfolio KPIs: best NPV, project count, total invested, and a summary table with Accept/Reject decisions
$19 one-time
包含内容
- 仪表板显示 NPV 和 IRR 结果，包括净现值、内部收益率和回收期
- 按期间输入现金流，列包含年份、描述、现金流入、现金流出和净现金流
- 折现率输入字段，调整 NPV 计算以反映您对投资的要求回报率
- 使用 Excel NPV 公式自动计算 NPV，按指定折现率应用于净现金流序列
- IRR 计算，配有彩色标记的输入单元格（黄色）和自动计算的投资评估指标（蓝色）
- 适用于 Microsoft Excel、Google Sheets 和 LibreOffice Calc，无需任何设置
Free、Essentials 与 Ultimate - 有什么区别？
Free $0
- "NPV and IRR" sheet with clearly labeled input cells at the top
- Live formulas - every result recalculates as you tweak inputs
- Compact output table so you can scan results without scrolling
- Step-by-step "How to Use" guide included in a second sheet
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc - no setup or sign-up
Essentials $12
- 包含 Free 的全部
- Full-featured NPV & IRR Calculator with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
- $12 one-time purchase, lifetime access
Ultimate $19
- 包含 Essentials 的全部
- Compare up to 3 investment projects side by side with independent cash flow projections
- Each project has a dedicated sheet with 15-year cash flow table, discount factors, present values, and cumulative PV
- Dashboard with portfolio KPIs: best NPV, project count, total invested, and a summary table with Accept/Reject decisions
- Comparison sheet ranking all projects by NPV, payback period, and profitability index
NPV和IRR计算器 模板的工作原理
Net present value and simple ROI for a 5-year cashflow project. Open the spreadsheet, enter your own numbers, and let the formulas do the math.
此模板何时有用
- You are deciding between two financial options and need a quick number.
- You want to see how changing one input (rate, years, amount) shifts the result.
- You want a calculation you can save and revisit, not a one-shot web form.
- You want to tweak the math - this is a spreadsheet, not a black box.
充分利用的小贴士
- Keep the column labels simple - the formulas work best when categories are consistent month to month.
- Evaluate investments regularly - once a week is a good rhythm for most people.
需要避免的常见错误
- Treating the result as a decision rather than an input. Calculators answer "what if" - the final call is yours.
- Mixing up annual and monthly rates. If a formula uses a monthly rate, divide the annual by 12 before entering.
- Ignoring taxes, fees, or assumptions. A result is only as good as the inputs you feed it.
如何使用这个NPV和IRR计算器模板
1
输入现金流
列出每期现金流 - 初始投资（负值）以及后续各年的流入和流出。
2
设定折现率
输入您的要求回报率或资本成本。NPV 计算使用此利率对未来现金流进行折现。
3
查看 NPV
仪表板显示净现值。正的 NPV 表示投资回报超过要求回报率。
4
查看 IRR
内部收益率显示现金流隐含的实际回报率。将其与您的折现率进行比较。
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
Upgrade your spreadsheet
Here is how you unlock a better version.
Essentials
- Full-featured NPV & IRR Calculator with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
$12 one-time
Ultimate Most complete
- Compare up to 3 investment projects side by side with independent cash flow projections
- Each project has a dedicated sheet with 15-year cash flow table, discount factors, present values, and cumulative PV
- Dashboard with portfolio KPIs: best NPV, project count, total invested, and a summary table with Accept/Reject decisions
$19 one-time
常见问题
正的 NPV 意味着什么？
正的 NPV 意味着投资的预期回报超过了您的要求回报率。NPV 越高，项目增加的价值越大。
IRR 与折现率如何比较？
如果 IRR 超过折现率，投资达到了您的回报门槛。如果 IRR 低于折现率，项目不满足您的要求。
应该使用什么折现率？
使用您的资本成本、要求回报率或机会成本 - 即您在类似风险的替代投资中可获得的回报率。
可以输入月度现金流吗？
模板设置为年度周期。如需月度现金流，更改周期标签并使用月度折现率（年率除以12）。
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。
此模板使用什么许可证？
所有免费模板均采用 CC BY 4.0（知识共享署名）许可证发布。您可以自由使用、修改和分享，包括用于商业用途，只需注明来源为 FinancialAha.com。模板按原样提供，不构成财务建议。