Home User Manual Discussion Forum Search

Payment Plan Unit Tests

These Unit Tests are for Payment Plans. To see screenshots of each payment plan unit test, see Payment Plan Unit Tests Screens.

Down equals total amount

Total Amount Down Payment APR Number of Payments Payment Amt
100.00 100.00 0.00 1  

Period Descript Principal Interest Balance
#1 Downpay 100.00 0.00 100.00

Number of payments simple

Total Amount Down Payment APR Number of Payments Payment Amt
20.00 5 0.00 2  

Period Descript Principal Interest Balance
#1 Downpay 5 0 5
#2   7.5 0 12.50
#3   7.5 0 20.00

Term example

Total Amount Down Payment APR Number of Payments Payment Amt
1234.00 0.00 5.00 10  

Period Descript Principal Interest Balance
#1   121.11 5.14 126.25
#2   121.61 4.64 252.50
#3   122.12 4.13 378.75
#4   122.63 3.62 505.00
#5   123.14 3.11 631.25
#6   123.65 2.60 757.50
#7   124.17 2.08 883.75
#8   124.69 1.56 1010.00
#9   125.20 1.05 1136.25
#10   125.68 .57 1262.50

Term example

Total Amount Down Payment APR Number of Payments Payment Amt
8000.00 13.00 13.00 13  

Period Descript Principal Interest Balance
#1 Down 13.00 0 13.00
#2   575.45 86.53 674.98
#3   581.69 80.29 1336.96
#4   587.99 73.99 1998.94
#5   594.36 67.62 2660.92
#6   600.80 61.18 3322.90
#7   607.31 54.67 3984.88
#8   613.89 48.09 4646.86
#9   620.54 41.44 5308.84
#10   627.26 34.72 5970.82
#11   634.05 27.93 6632.80
#12   640.92 21.06 7294.78
#13   647.87 14.11 7956.76
#14   654.87 7.11 8618.74

Real world example

Total Amount Down Payment APR Number of Payments Payment Amt
886.00 221.50 18   150.00

Period Descript Principal Interest Balance
#1 Downpay 221.50 0.00 221.50
#2   140.03 9.97 371.50
#3   142.13 7.87 521.50
#4   144.26 5.74 671.50
#5   146.43 3.57 821.50
#6   91.65 1.37 914.52

Payment amount example

Total Amount Down Payment APR Number of Payments Payment Amt
1436.00 136.00 12   175.00

Period Descript Principal Interest Balance
#1 Downpay 136.00 0.00 136.00
#2   162.00 13.00 311.00
#3   163.62 11.38 486.00
#4   165.26 9.74 661.00
#5   166.91 8.09 836.00
#6   168.58 6.42 1011.00
#7   170.26 4.74 1186.00
#8   171.97 3.03 1361.00
#9   131.40 1.31 1493.71

Term plan with no interest and different final payment amount

Total Amount Down Payment APR Number of Payments Payment Amt
16318.33 0 0 12  

Period Descript Principal Interest Balance
#1   1359.87   1359.87
#2   1359.87   2719.74
#3   1359.87   4079.61
#4   1359.87   5439.48
#5   1359.87   6799.35
#6   1359.87   8159.22
#7   1359.87   9519.09
#8   1359.87   10878.96
#9   1359.87   12238.83
#10   1359.87   13598.70
#11   1359.87   14958.57
#12   1359.76   16318.33

Recalculations
Bolded table rows indicate future charges.

1. Balance Due on Account

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/01/2015   Check     419.08 0.00
04/29/2015 #5   98.72 7.64   106.36
05/29/2015 #6   99.96 6.40   212.72
06/29/2015 #7   101.20 5.16   319.08
07/29/2015 #8   102.47 3.89   425.44
08/29/2015 #9   103.75 2.61   531.80
09/29/215 #10   104.99 1.37   638.16

1a. Balance Due: If you select Prepay and Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/01/2015   Check     419.08  
04/29/2015 #5   98.72 7.64   106.36
05/29/2015 #6 Increased Interest $1.33 99.95 7.73   214.04
06/29/2015 #7   101.19 5.16   320.39
07/29/2015 #8   102.46 3.89   426.74
08/29/2015 #9   103.74 2.61   533.09
09/29/215 #10   105.03 1.31   639.43

1b. Balance Due: If you select Prepay and do not Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/01/2015   Check     419.08 0.00
04/29/2015 #5   98.72 7.64   106.36
05/29/2015 #6 Increased Interest $3.84 102.47 7.73   216.56
06/29/2015 #7   102.47 3.89   322.92
07/29/2015 #8   102.47 3.89   429.28
08/29/2015 #9   102.47 3.89   535.64
09/29/215 #10   102.49 3.87   642.00

1c. Balance Due: If you select Pay on Principal and Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/01/2015   Check     419.08 0.00
04/29/2015 #5   98.72 7.64   106.36
05/29/2015 #6 Increased Interest $1.33 99.95 7.73   214.04
06/29/2015 #7   101.19 5.16   320.39
07/29/2015 #8   102.46 3.89   426.74
08/29/2015 #9   103.74 2.61   533.09
09/29/215 #10   105.03 1.31   639.43

1d. Balance Due: If you select Pay on Principal and do not Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/01/2015   Check     419.08 0.00
04/29/2015 #5   98.72 7.64   106.36
05/29/2015 #6 Increased Interest $3.84 102.47 7.73   216.56
06/29/2015 #7   102.47 3.89   322.92
07/29/2015 #8   102.47 3.89   429.28
08/29/2015 #9   102.47 3.89   535.64
09/29/215 #10   102.49 3.87   642.00

2. Overpaid

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/29/2015 #5   98.72 7.64   525.44
05/01/2015   Check     725.00 -199.56
05/29/2015 #6   99.96 6.40   -93.20
06/29/2015 #7   101.20 5.16   13.16
07/29/2015 #8   102.47 3.89   119.52
08/29/2015 #9   103.75 2.61   225.88
09/29/215 #10   104.99 1.37   332.24

2a. Overpaid: If you select Prepay and Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/29/2015 #5   98.72 7.64   525.44
05/01/2015   Check     725.00 -199.56
05/13/2015   Recalculated based on prepayment 199.56 0.00   0.00
05/29/2015 #6 Prepaid 0.00 0.00   0.00
06/29/2015 #7   6.74 3.91   10.65
07/29/2015 #8   102.52 3.83   117.00
08/29/2015 #9   103.81 2.54   223.35
09/29/215 #10   99.74 1.25   324.34

2b. Overpaid: If you select Prepay and do not Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/29/2015 #5   98.72 7.64   525.44
05/01/2015   Check     725.00 -199.56
05/13/2015   Recalculated based on prepayment 199.56 0.00   0.00
05/29/2015 #6 Prepaid 0.00 0.00   0.00
06/29/2015 #7   8.30 4.86   13.16
07/29/2015 #8   101.50 4.86   119.52
08/29/2015 #9   101.50 4.86   225.88
09/29/215 #10   101.51 4.85   332.24

2c. Overpaid: If you select Pay on Principal and Recalculate Interest

Prepay
Pay on Principal
Recalculate Interest
X
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/29/2015 #5   98.72 7.64   525.44
05/01/2015   Check     725.00 -199.56
05/13/2015   Recalculated based on pay on principal 199.56 0.00   0.00
05/29/2015 #6   61.02 3.91   64.93
06/29/2015 #7   61.78 3.15   129.86
07/29/2015 #8   62.55 2.38   194.79
08/29/2015 #9   63.34 1.59   259.72
09/29/215 #10   64.12 0.80   324.64

2d. Overpaid: If you select Pay on Principal and do not Recalculate Interest.

Prepay
Pay on Principal
Recalculate Interest
X

Total Amount Down Payment APR Number of Payments Payment Amt
1000 100 15 9  

Date Period Descript Principal Interest Payment Balance
1/28/2015 #1 Downpay 100.00 0.00   100.00
1/29/2015 #2   95.11 11.25   206.36
2/28//2015 #3   96.30 10.06   312.72
3/29/2015 #4   97.50 8.86   419.08
04/29/2015 #5   98.72 7.64   525.44
05/01/2015   Check     725.00 -199.56
05/13/2015   Recalculated based on pay on principal 199.56 0.00   0.00
05/29/2015 #6   62.56 3.89   66.45
06/29/2015 #7   62.56 3.89   132.90
07/29/2015 #8   62.56 3.89   199.35
08/29/2015 #9   62.56 3.89   265.80
09/29/215 #10   62.57 3.87   332.24

 

Open Dental Software 1-503-363-5432