BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
chris2377
Quartz | Level 8

 

Dear all,

 

I have a dataset with the following information about a number of loans:
1. they are floating interest rate loans - the interest is defined as 6M LIBOR + fixed margin, e.g. 2 percentage points
2. I know the date when each loan was granted
3.I know the life of the loan
4. I have the value of monthly repayments in 2014 (for each loan I have data refering to one specified month, e.g. for loan A I know the value of monthly repayments in Januray 2014, for loan B - in July 2014 etc.)

 

Having this information, I want to find an amount of the loan that was granted*. Can I do this with proc loan? Or maybe there is some other way?

 

* In other words (in italics I marked information specific for each loan that I have in my dataset):

Person A was granted in initial_date a floating interest rate loan for number_of_years. In given_month of 2014 monthly repayments were equal to repayments_value. What was the size of the original loan

 

Best,

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

If you know the number of payments to make, interest rate and the payment amount you may get what you need with the MORT function.

This function returns the value of the parameter not supplied. The example below figures the principal when the monthly payment is 1000, interest was 10% annual (the division does the monthly component), for 360 payments.

data _null_;
principal=mort(., 1000 , .10/12,30*12);
put principal;
run;

 

The values could be variables from a data set.

View solution in original post

2 REPLIES 2
ballardw
Super User

If you know the number of payments to make, interest rate and the payment amount you may get what you need with the MORT function.

This function returns the value of the parameter not supplied. The example below figures the principal when the monthly payment is 1000, interest was 10% annual (the division does the monthly component), for 360 payments.

data _null_;
principal=mort(., 1000 , .10/12,30*12);
put principal;
run;

 

The values could be variables from a data set.

chris2377
Quartz | Level 8

Thanks, looks promising. I'll take a look at this function

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1322 views
  • 0 likes
  • 2 in conversation