Future loan balance using amortization calculation

[mphrna1989]

Given the origination balance, interest rate, and term, is there a function in SAS that would yield balance as of a future date? I have researched the mort and finance functions, but it doesn't seem that those would work. Thanks!

[VDD]

proc loan

http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_loan_sect010.h...

[mphrna1989]

I was able to use the finance function with "CUMPRINC" to back into this number. Thanks for the help everyone!

pay_curr_bal=pay_Orig_Amt2+finance('CUMPRINC',pay_int_rt/12,pay_ori_term,pay_Orig_Amt2,1,loan_age+1);

[ballardw]

And if you have SAS/ETS available then Proc Loan may be of interest for printing actual amortization tables and has a number of other options.

[VDD]

http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_loan_sect007.h...

proc loan is what you want to use.

proc loan start=1998:12;
   fixed amount=100000 rate=7.5 life=180
         schedule=1
         label='BANK1, Fixed Rate';
run;

The LOAN Procedure

Loan Repayment Schedule BANK1, Fixed Rate
Date	Beginning Outstanding	Payment	Interest Payment	Principal Repayment	Ending Outstanding
DEC1998	100000.00	0.00	0.00	0.00	100000.00
DEC1998	100000.00	0.00	0.00	0.00	100000.00
JAN1999	100000.00	927.01	625.00	302.01	99697.99
FEB1999	99697.99	927.01	623.11	303.90	99394.09
MAR1999	99394.09	927.01	621.21	305.80	99088.29
APR1999	99088.29	927.01	619.30	307.71	98780.58
MAY1999	98780.58	927.01	617.38	309.63	98470.95
JUN1999	98470.95	927.01	615.44	311.57	98159.38
JUL1999	98159.38	927.01	613.50	313.51	97845.87
AUG1999	97845.87	927.01	611.54	315.47	97530.40
SEP1999	97530.40	927.01	609.57	317.44	97212.96
OCT1999	97212.96	927.01	607.58	319.43	96893.53
NOV1999	96893.53	927.01	605.58	321.43	96572.10
DEC1999	96572.10	927.01	603.58	323.43	96248.67
DEC1999	100000.00	11124.12	7372.79	3751.33	96248.67