NPV calc with more than 29 arguements?
 

I am trying to do an NPV calc for 180 months with varying amounts, but a flat
interest rate. Is there a way to do this in Excel without calculating it in
pieces (180/29)?

The 29 does not have to be separate months. Each of the 29 arguments can be
a range, and you likely only need one argument with a single range, eg:-

=NPV(0.1,A1:A180)

See the Function Help for more info.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Felix" wrote in message
...
I am trying to do an NPV calc for 180 months with varying amounts, but a
flat
interest rate. Is there a way to do this in Excel without calculating it
in
pieces (180/29)?

Thank you! This solved my problem. I was in a time crunch and I appreciate
your quick response.

"Ken Wright" wrote:

The 29 does not have to be separate months. Each of the 29 arguments can be
a range, and you likely only need one argument with a single range, eg:-

=NPV(0.1,A1:A180)

See the Function Help for more info.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Felix" wrote in message
...
I am trying to do an NPV calc for 180 months with varying amounts, but a
flat
interest rate. Is there a way to do this in Excel without calculating it
in
pieces (180/29)?

You're welcome :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Felix" wrote in message
...
Thank you! This solved my problem. I was in a time crunch and I
appreciate
your quick response.

"Ken Wright" wrote:

The 29 does not have to be separate months. Each of the 29 arguments
can be
a range, and you likely only need one argument with a single range, eg:-

=NPV(0.1,A1:A180)

See the Function Help for more info.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"Felix" wrote in message
...
I am trying to do an NPV calc for 180 months with varying amounts, but
a
flat
interest rate. Is there a way to do this in Excel without calculating
it
in
pieces (180/29)?