TM1 Forum

Dear all,

how to calculate the interest rate in tm1? if we use excel, the formula is (=rate(nper,pmt,pv)..
but when i try use this formula in tm1, it cannot..

i have 2 dimensions,(dim a and dim b)
dim a have 4 elements, such as
-present value
-periode
-pmt (use paymt formula)
-rate

and dim b just for write the value..

for the example, i input present value 150.000.000, periode 60, and input the rate 5% manually not using the formula,
and i got the PMT 2.830.685

but how to calculate the rate, if we now the PV, periode and PMT?

what the formula's we use?

please help me..

thanks

Admin Note: Moved to the correct forum. This does not belong in General.

tm1learn wrote: how to calculate the interest rate in tm1? if we use excel, the formula is (=rate(nper,pmt,pv)..
but when i try use this formula in tm1, it cannot..

i have 2 dimensions,(dim a and dim b)
dim a have 4 elements, such as
-present value
-periode
-pmt (use paymt formula)
-rate

and dim b just for write the value..

for the example, i input present value 150.000.000, periode 60, and input the rate 5% manually not using the formula,
and i got the PMT 2.830.685

but how to calculate the rate, if we now the PV, periode and PMT?

what the formula's we use?

please help me..

thanks

Admin Note: Moved to the correct forum. This does not belong in General.

You've asked that question in three separate threads now. Once is enough.

Also, please refer to the Request For Assistance Guidelines, which ask you to at least do a search of the documentation and the forum before posting a question.

Had you done a search for this, you may well have encountered this thread on that very subject.

i'm so sorry for the post

by the way, how to solve this ?

tm1learn wrote:i'm so sorry for the post

by the way, how to solve this ?

Go to the thread that I provided you with a link to in the previous post. On the last line the words "this thread" are a hyperlink. The method of solving it is contained there.