Create a Schedule Roll

General

A typical payment schedule is one that has similar payments and a single interest rate throughout.  You may want to customize the payment schedule on your loan. A schedule roll lets you change the payment schedule from payment period to payment period. This is done by entering lines that will include the number of payments the line will apply for, the interest rate, and a payment amount for those lines. You also have the option to enter a principal balance that the loan should be at when the payments in the schedule line are made. If you enter a balance, the schedule line will calculate the payment amount that will get the loan there.

What is a Schedule Roll?

Roll schedule and schedule roll are terms used in LoanPro to describe a change to the calculated payment schedule for a loan.  Custom payment schedules are created one line at a time.  Each line of a schedule roll lets you input the following:

  • Term – This is the number of payment periods for which the rest of the settings for the current schedule line will apply
  • Rate – This is the interest rate that will apply over the Term for this schedule line
  • Solve Using – This option works in conjunction with the Amount field and will let you choose how the payment amount will be calculated for the payments in this schedule line.  The options are:
    • Payment – If this option is selected, you will see the Type and Force Balloon Payment drop-downs.  Your selection from the Type drop-down will help determine how the payments are calculated.
    • Balance – This option will let you solve for payment based on what the balance should be after the payments in this line are made.  For example, if you choose balance and then enter $0.00, the payments will be calculated to be whatever they have to be so that the loan will be paid off (have a $0.00 balance) after the Term of this schedule line. This works similarly to the smooth advance tool, that solves for payment using an iterative method to get as close to the payment amount that will cause the principal balance to hit the target amount as it can.
  • Amount/Percent/Payment Calc Terms – This field works in conjunction with the Solve Using field and the Type.  Here you enter the balance, payment amount, or number of payment periods depending on your Solve Using and type selections.
  • Type – This option is only available if you choose Payment from the Solve Using drop-down.  Your selection here can change the Amount/Percent/Payment Calc Terms field.
    • Advanced Schedule – Choosing this option will set the Amount/Percent/Payment Calc Terms field to Payment Calc Terms.  This option will let you enter a number of payment periods into the Payment Calc Terms field.  The number entered will become the remaining number of payments on the loan and the loan will be taken to a $0.00 balance after these payments
    • Dollar Amount – This will set the Amount/Percent/Payment Calc field to Amount.  Here you can enter the dollar amount for the payments in this schedule line.
    • Interest Only – If this option is selected, the Amount/Percent/Payment field will no longer appear.  Payments will be set to the amount of interest that accrues in a payment period.  These payments won’t pay any principal.
    • Interest Only Plus – This option will set the Amount/Percent/Payment Calc field to Amount.  The payment amount will be the amount of interest that accrues in a payment period plus the amount you enter into the Amount field.
    • % of Remaining Balance -This option will set the Amount/Percent/Payment Calc field to Percentage.  This will calculate payments so that after the payments are made, the principal balance will equal the percentage of the remaining principal balance you entered into the Percentage field.
    • % of Principal – This works just like % of Remaining Principal Balance except the balance after the payments will be a percentage of the original principal balance instead of the remaining principal balance.
    • % of Principal + Underwriting – This works just like % of Remaining Principal Balance except the balance after the payments will be a percentage of the original principal balance plus underwriting fee instead of the remaining principal balance.
  • Force Balloon Payment – This option lets you choose to force a balloon payment on the loan after the schedule line.  This will mean that the next payment after the schedule line is completed will cover the entire outstanding amount on the loan at that point.

Create a Schedule Roll

To create a new schedule roll, navigate to Account Setup > Setup Terms inside a loan account.

Click Schedule Tools;and choose Roll Schedule.

To add a schedule line, click New Schedule Line

Enter a term, rate, and other applicable information for the schedule line.  Click Save to save the schedule line.

You can enter as many schedule lines as you need to complete your payment schedule.  If you don’t enter enough schedule lines to cover the term of the loan, the payment schedule after the schedule roll is exhausted will be like it was in the last schedule line for the schedule roll. You can also set the “Last as Final” drop-down to “Yes” to choose to make the last payment for this line grow or shrink to accommodate late or missed payments so it will truly be the last payment.

Once you have entered all the desired schedule lines for your Schedule Roll, click Save to save to save it.

Example

Let’s say that you want to give a 12-month loans with a 3-month introductory interest rate of 5%, but after the first 3 months, the interest rate jumps to 15%.  To make a schedule roll to accomplish this, navigate to Account Setup > Setup Terms inside the loan. Click Schedule Tools and choose Roll Schedule.

Now click New Schedule Line to add the first new schedule line. Enter 3 for the term, since the introductory interest rate will last for 3 months.  Enter 5 for the rate as the introductory 5% interest rate.  Solve using Payment. Make sure you select Advanced Schedule from the Type drop-down.  Since these loans are 12-month loans, we will enter 12 into the Payment Calc Terms box.  You could actually choose from many different payment calculation options, but this will calculate the payment amount it would take to have 12 payments pay the loan off.  Since these payments will have a 5% interest rate, they will be of a lower amount than the 15% payments.  This lets the borrower see the benefit of the lower interest rate.  Choose no for Force Balloon Payment and click Save.

Now click New Schedule Line to enter the second schedule line.

For the second schedule line, enter a term of 9 since there will be 12 periods in this loan and 3 of them will be taken up by the first schedule line.  Enter 15 as the rate, since the rate is going up to 15%.  Choose to Solve Using Payment and choose Advanced Schedule from the Type drop-down.  Enter Payment Calc Terms of 12.  This should keep the loan at 12 payments since the interest was lower at the beginning than it is now, so all the principal should be paid by payments that are calculated at a higher interest rate for a 12-term loan.

Click Save to save the schedule line, then click Save to save the schedule.


How did we do?


Powered by HelpDocs (opens in a new tab)