Begin Module
Name = "Area - Rectangle"
Formula = "Area = Length * Width"
Description = ""
Begin Parameter(LENGTH)
Caption = "Length:"
Format = "General"
Constraints = ""
Details = ""
End
Begin Parameter(WIDTH)
Caption = "Width:"
Format = "General"
Constraints = ""
Details = ""
End
Begin Parameter(AREA)
Caption = "Area:"
Format = "General"
Constraints = ""
Details = ""
End
End Module
Begin Module
Name = "Constraint Demonstration"
Formula = "Total = a + b + c + d"
Description = "This USM demonstrates the use of constraints. Each field accepts only values that fall within the defined constraints."
Begin Parameter(A)
Caption = "a"
Format = "General"
Constraints = "x<-10 or x>10"
Details = "Enter a number in this field which is less than -10 or greater than 10."
End
Begin Parameter(B)
Caption = "b"
Format = "General"
Constraints = "-20..20, x<>0"
Details = "Enter a number between -20 and 20, excluding 0."
End
Begin Parameter(C)
Caption = "c"
Format = "General"
Constraints = "x<9,x>0,x<>3"
Details = "Enter a number smaller than 9 and greater than 0, but not 3."
End
Begin Parameter(D)
Caption = "d"
Format = "General"
Constraints = ""
Details = "This field has no constraints. You may enter any number."
End
Begin Parameter(TOTAL)
Caption = "Total"
Format = "General"
Constraints = "0..100"
Details = "Enter a number between 0 and 100. If you are solving for this field, it will return an error if the answer is not between 0 and 100."
End
End Module
Begin Module
Name = "Finance - Annuity, Present Value (mortgage)"
Formula = "payment = PV*i/(1-(1+i)^(-n))"
Description = "This USM can be used for calculating mortgage payments."
Begin Parameter(PV)
Caption = "Present Value:"
Format = "Currency"
Constraints = ""
Details = "Present Value."
End
Begin Parameter(I)
Caption = "Interest Rate:"
Format = "Percent"
Constraints = ""
Details = "If interest is compounded monthly, then divide this value by 12 (For instance, you may enter: 9% /12)."
End
Begin Parameter(N)
Caption = "Number of Payments:"
Format = "#"
Constraints = ""
Details = "If payments are monthly, then enter the number of years times 12 (ex: 15*12)."
End
Begin Parameter(PAYMENT)
Caption = "Periodic Payment:"
Format = "Currency"
Constraints = ""
Details = "The amount you pay each time."
End
End Module
Begin Module
Name = "Finance - Simple Interest"
Formula = "I = P*R*T"
Description = ""
Begin Parameter(P)
Caption = "Principal"
Format = "Currency"
Constraints = ""
Details = ""
End
Begin Parameter(R)
Caption = "Rate"
Format = "Percent"
Constraints = ""
Details = ""
End
Begin Parameter(T)
Caption = "Time"
Format = "#"
Constraints = ""
Details = ""
End
Begin Parameter(I)
Caption = "Interest"
Format = "Currency"
Constraints = ""
Details = ""
End
End Module
Begin Module
Name = "Finance - Add-on Interest"
Formula = "AIR = 2*I*C / ( P*(n+1) )"
Description = ""
Begin Parameter(I)
Caption = "Installments per year:"
Format = "#"
Constraints = ""
Details = "Number of installment payments per year"
End
Begin Parameter(C)
Caption = "Charge:"
Format = "Currency"
Constraints = ""
Details = "Total loan charge"
End
Begin Parameter(P)
Caption = "Principal:"
Format = "Currency"
Constraints = ""
Details = "Loan amount"
End
Begin Parameter(N)
Caption = "Installments:"
Format = "#"
Constraints = ""
Details = "Total number of installments"
End
Begin Parameter(AIR)
Caption = "Add-on Interest rate:"
Format = "Percent"
Constraints = ""
Details = "Add-on interest rate"
End
End Module
Begin Module
Name = "Finance - Compound Interest"
Formula = "CS = BD*(1+i)^n"
Description = "This USM calculates interest paid on interest earned, or interest on interest."
Begin Parameter(BD)
Caption = "Beginning deposit:"
Format = "Currency"
Constraints = ""
Details = "Same as original principal, present value, or present worth."
End
Begin Parameter(I)
Caption = "Interest rate:"
Format = "Percent"
Constraints = ".01%..1000%"
Details = "Interest rate per period, or periodic interest rate. If it is compounded monthly, then divide this value by 12."
End
Begin Parameter(N)
Caption = "Number of periods:"
Format = "#"
Constraints = ""
Details = "Total number of payment periods in the term, or number of years multiplied by number of payment periods per year."
End
Begin Parameter(CS)
Caption = "Compound Sum:"
Format = "Currency"
Constraints = ""
Details = "Also called compound amount, or maturity value, or accumulated value."
End
End Module
Begin Module
Name = "Finance - Annuity Sum (ordinary)"
Formula = "S = R*((1+i)^n-1)/i"
Description = "Ordinary annuity where payments are made at the end of each period."
Begin Parameter(R)
Caption = "Periodic payment:"
Format = "Currency"
Constraints = ""
Details = "The amount you pay each time. Also referred to as the periodic rent payment."
End
Begin Parameter(I)
Caption = "Interest rate per period:"
Format = "Percent"
Constraints = ".01%..1000%"
Details = "If it is compounded monthly, then divide this value by 12."
End
Begin Parameter(N)
Caption = "Number of periods:"
Format = "#"
Constraints = ""
Details = "If it is compounded monthly, then multiply this amount by 12."
End
Begin Parameter(S)
Caption = "Accumulated value:"
Format = "Currency"
Constraints = ""
Details = "Value of the annuity at the end of its term."
End
End Module