Help! I am trying to calculate the individual principal and interest cash flows associated with a fixed rate loan amortization schedule. In the past, I’ve seen it done using the ARRAY function in SAS so each of the cash flows throughout the life of the loan can be displayed. The problem I am running into is that in order to calculate the amortization schedule, you need to reference the each "previous period” value of the ARRAY to calculate the new value (e.g. you need the outstanding principal balance after payment from month 3 to calculate the financials for month 4, etc.). I am definitely an amateur coder, so bear with me. (note: this code does not run, but I figured it's my best start). I've seen this done before, so I know there is a way. I can't remember how it went though, so not sure how far off I am. Predefined variables: -amf (amount borrowed) term (term of the loan) rate (interest rate on loan), pmt (monthly principal and interest payment) My stab at the coding: Array loan_bal {72}; Do i = 1 to 72; Where loan_bal{i}=0 then prin_bal{i}=amf; (in other words, at time zero, the outstanding loan balance is the amount borrowed). loan_bal{i} = loan_bal{i-1} – ( pmt - (loan_bal{i-1} * (rate / 12))); (what i am trying to do here is calculate the next period's outstanding balance, say period 1 for example, by referencing the loan balance from period 0). Again, not concerned with how to calculate the financials (I know that much), more of how to access the one period lagged value of the outstanding loan balance within the context of an ARRAY (bolded). Thank you!!
... View more