Feature
Finance Functions: NPV, IRR, XNPV Support
Professional-grade financial functions for DCF valuation, investment analysis, and cash flow modeling.
CostVela now supports industry-standard financial functions used in investment banking and corporate finance.
New Functions
Net Present Value (NPV)
Calculate the present value of cash flows using a discount rate:
projectValue: Npv(0.10, cashFlows)
Internal Rate of Return (IRR)
Find the discount rate that makes NPV equal to zero:
investmentReturn: Irr(cashFlows)
Extended NPV (XNPV)
NPV for irregular cash flow dates:
dealValue: Xnpv(0.12, cashFlows, dates)
Use Cases
- DCF Valuation: Build comprehensive 3-statement models with valuation
- Investment Analysis: Evaluate project returns and payback periods
- Portfolio Management: Calculate weighted returns across multiple investments
- Real Estate: Model property cash flows and calculate cap rates
Professional-Grade Accuracy
These functions have been rigorously tested to ensure accuracy you can trust for professional finance work and client deliverables.
Ready to try CostVela?
Start building interactive financial models today with $25 in free credits.
Get Started