> Does anyone have a code snippet for calculation the P/I spilt of a 10 to 30 year amortization schedule. I need the Interest, Principal, total Payment and the remain balance.
>
> Thank you all inadvance


Amortizations Schedule for a Loan Amount of $5000 with a 6% annual interest rate over 60 months:

lnLoanAmt=5000.00
lnInterestRate=.06/12
lnNumPeriods=60

lnPayment=ROUND(PAYMENT(lnLoanAmt,lnInterestRate,lnNumPeriods),2)
lnBalance=lnLoanAmt
FOR lnPeriod=1 TO lnNumPeriods
  lnPeriodInterest=ROUND(PAYMENT(lnBalance,lnInterestRate,1),2)-lnBalance
  lnPeriodPrincipal=lnPayment-lnPeriodInterest
  lnBalance=lnBalance-lnPeriodPrincipal
  ? lnPeriod,lnPeriodInterest,lnPeriodPrincipal
ENDFOR

You can fill in the appropriate values for your situation.

--Brad