turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- proc loan - finding a loan amount?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

09-09-2015 08:50 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to chris2377

09-09-2015 11:21 AM

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.

All Replies

Solution

09-25-2015
06:23 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to chris2377

09-09-2015 11:21 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to ballardw

09-10-2015 09:54 AM

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