How To Calculate Payments in FoxPro (155692)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 3.0
Microsoft Visual FoxPro for Windows 3.0b
Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 6.0

This article was previously published under Q155692

SUMMARY

The PAYMENT() function in Visual FoxPro allows the user to calculate a payment amount per month based upon a fixed interest rate.

MORE INFORMATION

The following program displays the monthly payment for a 15-year home mortgage based upon an 8-percent interest rate:

   nTotal=100000  && total amount borrowed is $100000
   nRate=.08/12   && payment is made at the end of each month with fixed
                  && interest rate
   nPayments=180  && 180 months in 15 year period

   cDisplay=MESSAGEBOX("Your monthly payment is" ;
      +" "+"$"+ALLTRIM(STR(PAYMENT(nTotal,nRate,nPayments))))

Modification Type:	Minor	Last Reviewed:	6/29/2004
Keywords:	kbhowto KB155692