Database Search

TechHome

• Addition of Arbitrary Sized Numbers
• CRC32 Computations
• CubeRoot
• Factorials Combinations Permutations
• Financial UDFs
• Round to Significant Digits

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Financial UDFs

; $ values
; Principle  or Total
; number of time periods
; Interest per time persiod   
; payment

; Usually the principle it the total amount of the loan
; time perions is usually the number of months to pay off the loan
; interest is usually interest per month, or annual interest/12
; payments is the amount of each of the payments.

;Given 3 of the four items, the remaining item can be computed
 Decimals(2)

#DefineFunction RecurringPaymentFromTIN(Total,Interest,Periods)
   RecurringPayment = Total / ((1.0-((1.0 + Interest)**-Periods)) / Interest)
   return(RecurringPayment)
#EndFunction

#DefineFunction PrinciplefromFromPIN(Payment,Interest,Periods)
   Total  = ((1.0-((1.0 + Interest)**-Periods)) / Interest)  * Payment
   return(Total)
#EndFunction


;Monthly payment calculations
Total=10000
Interest=0.09/12 ;   Interest per payment period
Periods=36
RecurringPayment= RecurringPaymentFromTIN(Total,Interest,Periods)
Message("Recurring Payment",RecurringPayment)



RecurringPayment=318.00
Interest=0.09/12 ;   Interest per payment period
NumberofPayments=36.0
total=    PrinciplefromFromPIN(RecurringPayment,Interest,NumberofPayments)
Message("Total",Total)


Total=10000.00
RecurringPayment=318.00
Interest=0.09/12 ;   Interest per payment period

   Total/Payment*Interest -1.0  = -((1.0 + Interest)**-Periods)


exit

Article ID:   W16224

File Created: 2004:03:30:15:43:30

Last Updated: 2004:03:30:15:43:30