topic Re: How to calculate annually interest rate? in SAS Programming

How to calculate annually interest rate?

AnuragRankja — Sat, 28 Aug 2021 19:46:02 GMT

If i want to calculate interest rate 6 annually for amount 5000 then i will write 5000*1.06 but if i want to calculate same thing with interest rate 5.75?

Re: How to calculate annually interest rate?

Kurt_Bremser — Sat, 28 Aug 2021 19:55:14 GMT

Multiply by 1.0575.

Re: How to calculate annually interest rate?

sbxkoenk — Sat, 28 Aug 2021 20:34:32 GMT

SAS has also FINANCIAL FUNCTIONS for this type of calculations.

Use for example the FINANCE ACCRINT Function: Computes the accrued interest for a security that pays periodic interest.

data _null_;
   issue        =mdy(8, 28, 2021);
   firstinterest=mdy(8, 28, 2022);
   settlement   =mdy(8, 28, 2022);
   rate         =0.0575;
   par          =5000;
   frequency    =1;
   basis        =1;
   r=finance('accrint', issue, firstinterest, settlement, rate, par, frequency, basis);
   put r=;
   my_r = 5000 * 1.0575;
   put my_r=;
run;
/* end of program */

Cheers,

Koen