Help using Base SAS procedures

proc loan - finding a loan amount?

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

proc loan - finding a loan amount?

 

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


Accepted Solutions
Solution
‎09-25-2015 06:23 AM
Super User
Posts: 10,500

Re: proc loan - finding a loan amount?

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


All Replies
Solution
‎09-25-2015 06:23 AM
Super User
Posts: 10,500

Re: proc loan - finding a loan amount?

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.

Contributor
Posts: 50

Re: proc loan - finding a loan amount?

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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