0
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)
Wiki User
∙ 14y ago
Wiki User
∙ 11y agoIt 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.
Wiki User
∙ 11y agoIt 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.
Wiki User
∙ 14y agoNPV(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.
Wiki User
∙ 11y agoIt is a financial function that finds the Net Present Value of an investment.
Wiki User
∙ 11y agoIt is the Net Present Value function.
Add your answer:
Earn +20 pts
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.
Does lower WACC equal lower NPV?
no it increases npv
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
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.
