Thank you all for the replies! You guys have been very helpful.
This is what my data looks like:
CARDNUMBER
AMORT_PERIOD
PRINCIPAL_AMT
EffRate
Bal0
296
24
430431.69
0.2241502
430431.69
356
24
53766.79
0.2241502
53766.79
976
24
75818.01
0.2241502
75818.01
610
24
13308.06
0.2241502
13308.06
966
6
34327.47
0
34327.47
So basically, I have a list of accounts that are enrolled in 24,18,15,12,9,6,3 months installment payment plan. I have decided to make a code for each payment plan since I don't know how to make one code for all of them.
For the 24-month payment plan, I want the result to look like this:
the result includes all principal,interest,balance for the whole 24 mos.
CARDNUMBER
AMORT_PERIOD
PRINCIPAL_AMT
EffRate
Bal0
Month1
Amort1
Interest1
Prin1
Bal1
Month2
Amort2
Interest2
Prin2
Bal2
296
24
430431.69
0.2241502
430431.69
1
22418.31636
8040.11245
14378.20391
416053.4861
2
22418.31636
7771.539343
14646.77702
401406.7091
356
24
53766.79
0.2241502
53766.79
1
2800.353543
1004.31973
1796.033815
51970.75618
2
2800.353543
970.7712827
1829.58226
50141.17392
... View more