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)?
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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)?
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks