[Excel Financial Functions] Not able to pass Rate parameter in FinancialNPer function

Forge Component
(1)
Published on 2010-08-20 by Pedro Carrilho
1 vote
Published on 2010-08-20 by Pedro Carrilho
Hi,

I'm having problems using the function FinancialNPer and FinancialPMT.
It's working only when the rate in 0. Imagine that the rate is 0.49 and I got an error in ServiceCenter: "Value was either too large or to small for a Decimal"

I don't understand why

In Excel we must put a percentage in the value like this:
=NPER(0,49%;-1000;10000;0)

But your function on rate parameter is asking for a decimal.

Can you help me?

Thank you.

Kind regards,
Nuno Oliveira


If all of our problems were like this one, we will be very happy.
The problem was simple. I was trying to pass in the rate parameter 0.49... tried to pass 0.49%
The solution is to calculate 0.49% which is 0.0049 and pass this value and it's working

Thanks

Kind regards,
Nuno Oliveira

Nuno Oliveira wrote:


If all of our problems were like this one, we will be very happy.
The problem was simple. I was trying to pass in the rate parameter 0.49... tried to pass 0.49%
The solution is to calculate 0.49% which is 0.0049 and pass this value and it's working

Thanks

Kind regards,
Nuno Oliveira

Hi Nuno,

I know it's been a few years since you posted this but I was wondering if the Financial Function in forge working as expected?

I am trying to use the PMT against the Excel PMT and I cannot seem to arrive at the same result.

Hoping you can shed some light on this.

best regards,
Michael


Hi Michael,

Working like a charme!


I will give you a clue of the inputs that we are using for you check if you are puttin them nice:


Rate: InterestRateToUse / 12 / 100

nper:NumberOfMonths

pv: -FinancialAmount

fv: BalloonPayment

typ: NullObject()


Good luck!


Nuno Oliveira wrote:

Hi Michael,

Working like a charme!


I will give you a clue of the inputs that we are using for you check if you are puttin them nice:


Rate: InterestRateToUse / 12 / 100

nper:NumberOfMonths

pv: -FinancialAmount

fv: BalloonPayment

typ: NullObject()


Good luck!


Thanks Nuno for the clue...:)