CUMULATIVE PRINCIPAL

[TOM]

I AM TRYING TO USE THE CUMULATIVE PRINCIPAL FUNCTION FOR
THE FIRST TIME. IS THERE ANY REASON THE FOLLOWING
FUNCTION WILL NOT WORK?

=CUMPRINC(0.0075, 360, 125000, 1, 1, 0)


THE CELL DISPLAYS "#NAME?" WHEN I EXECUTE THE FUNCTION.

THANKS FOR YOUR HELP.

 

[Don Guillett]

Could just be that you are YELLING TOO LOUD. It is considered impolite to
post in all caps. If you look in HELP index for CUMPRINC function, you will
find
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

 

[Guest]

Is the analysis toolpack add-in installed?

 

[Gord Dibben]

Tom

First, take off the Caps Lock. All caps hard to read and considered as
"shouting".

Second, the Analysis Toolpak must be loaded for CUMPRINC to function.

Tools>Add-ins. Check ANalysis Toolpak.

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Tom!

It's more difficult to read upper case especially if your first
language isn't the one used.

Use Tools > Addins
Select Analysis ToolPak
OK

If you don't have Analysis ToolPak installed you'll need to access the
installation disc.

Or, since you only want the principal element of a single payment you
could use the built in function:

=PPMT(0.0075,1,360,125000,0,0)
Returns: -68.2782711809762

Almost the same as:
=CUMPRINC(0.0075,360,125000,1,1,0)
Returns: -68.2782711809767

Or, again, without Analysis ToolPak, you could use:
=-125000-FV(0.0075,1,PMT(0.0075,360,125000,0,0),125000,0)
Returns: -68.2782711809705

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.