# How to Use the NPV Function in Google Sheets

When it comes to financial computations, a spreadsheet tool like Google Sheets can help you get more done in less time.
They feature a lot of built-in financial calculator functions. The NPV function, for example, is used to determine the net present value of an investment.
In investment planning and capital budgeting, net present value is used to assess an investment’s profitability.
It is the difference between the current value of cash inflows and outflows over a given time period. If the Net Present Value (NPV) is positive, it indicates that the investment’s future cash flows will be positive, which is a favorable thing when considering investments or other initiatives.

If the periodic cash flows and discount rates are given, NPV can be easily calculated in Google Sheets.

Using NPV Function

Syntax for this function is –

=NPV(discount, cashflow1, [cashflow2…]) here,

discount – this is the investment’s discount rate over a single period
cashflow. 1 – the first cashflow in the future

This input is optional. cashflow2- If desired, you can continue to add more cashflows to the formula.
This function can be used with either negative or positive cash flows. They’ll be taken into account in the order in which they’re entered into the formula.

The first cash flow in the example above is negative (-300), which represents the investment’s upfront cost. Because the discount rate is 7%, the NPV of this set of cash flows is \$689.39.
Google Sheets’ financial capabilities make calculations like NPV exceedingly simple. If you know how to apply this function and have the discount rate and cashflows, you can perform these computations in a matter of seconds.

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

### Recent Content

link to Format Phone numbers in Google Sheets

Format Phone numbers in Google Sheets

Formatting phone numbers in Google Sheets refers to how they would appear in the cells. Unformatted phone numbers wouldn’t look any different than just some digits written together, without any dashes, slashes or spaces to indicate the digit distribution in a phone number. You could input phone numbers by putting the dashes in between the […]