how to calculate the PMT function ( advanced and arrear)

[tm1learn]

Does anyone know how to calculate the pmt funtion,

if we are using the pmt function in excel, we will input =pmt(rate,nper,pv,fv,type)
the type is 0 for end of the period and 1 for begining of the period)

but how to using the pmt function in tm1? and what is the difference if i using the pmt with advanced and arrear?


thanks

[David Usherwood]

Did you miss the PAYMT rules function when you checked in the Reference Guide?

[tm1learn]

where's the refference guide?
in excel we can use the function to calculate the payment loan with advanced and arrear..
but how to know the advanced and arrear?

i'm use office 2010 and controller 10.2

periode 5
rate 12%
pv 100000000

[EvgenyT]

where's the refference guide?

Little bit of GOOGLE effort would answer this question, wouldnt it?

[tm1learn]

oke i got it,
but the reference guide just tell me that paymt function like this
=PAYMT(principal, interest, periods)

there is no the difference calculation between the advanced and arrear..

how could i know to calculate the paymt in tm1 with the advanced and arrear?

[declanr]

oke i got it,
but the reference guide just tell me that paymt function like this
=PAYMT(principal, interest, periods)

there is no the difference calculation between the advanced and arrear..

how could i know to calculate the paymt in tm1 with the advanced and arrear?

PAYMT just assumes payments are made at the end of the period, if you want to offer both options then just google how to manually calculate the result, the formula is actually quite simple to implement even with little financial knowledge.