NPV Function

Calculates the net present value of an investment based on a series of cash flows and a discount rate
Sample Usage
NPV([Discount Rate]14, [Cash Flow]14, [Future Cash Flows]14:[Future Cash Flows]18)
Syntax
NPV(
  • discount_rate
  • number
  • range1
  • [
    • range2
      • ​
    • ...
    ]
)
  • discount_rate
    —
    Percentage or decimal value to determine the discount
  • number
    —
    Current cash flow
  • range1
    —
    The group of future cash flows
    • range2
      • ​
    • ...
    —[optional]
    Additional ranges of future cash flows
Examples

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 


Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community