answersLogoWhite

0


Best Answer

You use the NPV function. Start by specifying the rate and follow it with a list of future values that you want to help determine your result. So you could have something like this:

=NPV(5%,10,20)

User Avatar

Wiki User

15y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

It is the Net Present Value function.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

It is a financial function that finds the Net Present Value of an investment.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

NPV(rate,value1,value2, ...)

Rate is the rate of discount over the length of one period.

Value1, value2, ... are 1 to 29 arguments representing the payments and income.

  • Value1, value2, ... must be equally spaced in time and occur at the end of each period.
  • NPV uses the order of value1, value2, ... to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence.
  • Arguments that are numbers, empty cells, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
  • If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
This answer is:
User Avatar

User Avatar

Wiki User

11y ago

It is a financial function that finds the Net Present Value of an investment.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

It is the Net Present Value function.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What does the NPV function do in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Give 5 functions of formulas in Excel?

Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


A formula prewritten by excel is called?

Function


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


Does lower WACC equal lower NPV?

no it increases npv


How do you make a box plot in Excel?

Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.


What is a function reference in Excel?

A function can reference cells or named ranges in the function.


Can you enter a function in Excel using autocomplete?

You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.