=CUMPRINC(0.09/12,360,125000,1,1,0)
percentages are stored as fractions
--
Kind regards,
Niek Otten
| Just to clarrify, I entered the "CUMPRINC" in a cell with the corresponding 6
| items that the formula needs and it returned the "#NAME?". So I then
| installed the Analysis Toolpak and the "#NAME?" went away and a number was
| returned. However the number did not seem right. So to check to see if there
| is an error I thought I would enter the sample numbers from the example in
| the "CUMPRINC" Excel Help page: =CUMPRINC(9/12,360,125000,1,1,0) ...This is
| for a 30 year loan of $125,000 @ 9% interest and is supposed to figure the
| principle paid in a single (1) payment in the first (1) month. The zero (0)
| at the end of the problem means the payment is at the end of the period The
| amount the Excel example says it is supposed to be is: -68.27827 ... the
| amount I got in my spreadsheet was: 0
|
| If you have any suggestions or if you have used this formula succesfully
| and have some samples you are willing to share I would appreciate it.
|
| Thanks for your interest.
|
| pcsski
|
| "Niek Otten" wrote:
|
| > What values did you use and what result did you get?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| >
| > | Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
| > | formula, however the results do not seem correct. I even entered the sample
| > | from Help and it did not return the result that is shown in Help. I did the
| > | Error Checking function and it came back with no errors
| >
| >
| >
