Loan Builder

The Loan Builder module may be used to compute almost any loan imaginable, from the simplest equal payment loan to loans that have exotic and highly customized features.

Sample Request

The following sample illustrates the core structure of a Loan Builder request. It is a request for an equal payment loan with a single advance of $10,000, accruing interest at 5.0%, with a term of 12 months.

<inLOAN_BUILDER>
  <Advance Date="2024-12-01" Amount="10000.00" />
  <EditInterest Date="2024-12-01" AccrualCode="320" IntRate="5.000" />
  <PmtStream Begin="2025-01-01" Term="12" />
</inLOAN_BUILDER>  

Sample Response

The following response is returned from the SCEX when provided with the sample request (above).

<?xml version="1.0" standalone="no" ?>
<!DOCTYPE outLOAN_BUILDER SYSTEM "outLOAN_BUILDER.dtd">
<outLOAN_BUILDER>
   <Results>
      <Description>Successful Calculation</Description>
   </Results>
   <FedBox>
      <AmtFin>10000.00</AmtFin>
      <FinChg>272.60</FinChg>
      <TotPmts>10272.60</TotPmts>
      <RegZAPR Type="Actuarial">4.995</RegZAPR>
   </FedBox>
   <Moneys>
      <Proceeds>10000.00</Proceeds>
      <Principal>10000.00</Principal>
      <Interest>272.60</Interest>
   </Moneys>
   <Accrual>
      <Method>Actual/365 USRule</Method>
      <Days1Pmt DayCount="Actual">31</Days1Pmt>
      <Maturity>2025-12-01</Maturity>
   </Accrual>
   <PmtStream Term="12" Pmt="856.05" Rate="5.000" Begin="2025-01-01" PPY="12"/>
   <AmTable>
      <AmLine Idx="0" Date="2024-12-01" BegBal="0.00" Pmt="0.00" Int="0.00" Prin="-10000.00" UnpaidInt="0.00" EndBal="10000.00"/>
      <AmLine Idx="0" Date="2024-12-01" BegBal="10000.00" Pmt="0.00" Int="0.00" Prin="0.00" UnpaidInt="0.00" EndBal="10000.00"/>
      <AmLine Idx="1" Date="2025-01-01" BegBal="10000.00" Pmt="856.05" Int="42.47" Prin="813.58" UnpaidInt="0.00" EndBal="9186.42"/>
      <AmLine Idx="2" Date="2025-02-01" BegBal="9186.42" Pmt="856.05" Int="39.01" Prin="817.04" UnpaidInt="0.00" EndBal="8369.38"/>
      <AmLine Idx="3" Date="2025-03-01" BegBal="8369.38" Pmt="856.05" Int="32.10" Prin="823.95" UnpaidInt="0.00" EndBal="7545.43"/>
      <AmLine Idx="4" Date="2025-04-01" BegBal="7545.43" Pmt="856.05" Int="32.04" Prin="824.01" UnpaidInt="0.00" EndBal="6721.42"/>
      <AmLine Idx="5" Date="2025-05-01" BegBal="6721.42" Pmt="856.05" Int="27.62" Prin="828.43" UnpaidInt="0.00" EndBal="5892.99"/>
      <AmLine Idx="6" Date="2025-06-01" BegBal="5892.99" Pmt="856.05" Int="25.03" Prin="831.02" UnpaidInt="0.00" EndBal="5061.97"/>
      <AmLine Idx="7" Date="2025-07-01" BegBal="5061.97" Pmt="856.05" Int="20.80" Prin="835.25" UnpaidInt="0.00" EndBal="4226.72"/>
      <AmLine Idx="8" Date="2025-08-01" BegBal="4226.72" Pmt="856.05" Int="17.95" Prin="838.10" UnpaidInt="0.00" EndBal="3388.62"/>
      <AmLine Idx="9" Date="2025-09-01" BegBal="3388.62" Pmt="856.05" Int="14.39" Prin="841.66" UnpaidInt="0.00" EndBal="2546.96"/>
      <AmLine Idx="10" Date="2025-10-01" BegBal="2546.96" Pmt="856.05" Int="10.47" Prin="845.58" UnpaidInt="0.00" EndBal="1701.38"/>
      <AmLine Idx="11" Date="2025-11-01" BegBal="1701.38" Pmt="856.05" Int="7.23" Prin="848.82" UnpaidInt="0.00" EndBal="852.56"/>
      <AmLine Idx="12" Date="2025-12-01" BegBal="852.56" Pmt="856.05" Int="3.50" Prin="852.55" UnpaidInt="0.00" EndBal="0.01"/>
   </AmTable>
</outLOAN_BUILDER>