topic Re: Future loan balance using amortization calculation in New SAS User

Future loan balance using amortization calculation

mphrna1989 — Fri, 19 Apr 2019 15:38:22 GMT

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!

Re: Future loan balance using amortization calculation

VDD — Fri, 19 Apr 2019 15:46:41 GMT

proc loan

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

Re: Future loan balance using amortization calculation

mphrna1989 — Fri, 19 Apr 2019 16:17:30 GMT

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);

Re: Future loan balance using amortization calculation

ballardw — Fri, 19 Apr 2019 16:22:52 GMT

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.

Re: Future loan balance using amortization calculation

VDD — Fri, 19 Apr 2019 17:19:18 GMT

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

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