Quartz | Level 8

## EMI calculations with a Balloon Payment

I want to create/use a function which takes ballon payment in the end period to give EMIs. For example, a loan at 4% annually of 1000 for 12 months with a balloon payment of 100 at the end will have an EMI of 76.97. An equivalent to Excel formula = PMT(RATE,N,PV,[FV],[type]). There is an option in Excel of FV which doesn't seem to be in SAS function PMT.

Any help is deeply appreciated.

(P.S. - PROC LOAN is not an option as it takes too much time to calculate it for each row)

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: EMI calculations with a Balloon Payment

@thepushkarsingh wrote:

I want to create/use a function which takes ballon payment in the end period to give EMIs. For example, a loan at 4% annually of 1000 for 12 months with a balloon payment of 100 at the end will have an EMI of 76.97. An equivalent to Excel formula = PMT(RATE,N,PV,[FV],[type]). There is an option in Excel of FV which doesn't seem to be in SAS function PMT.

Any help is deeply appreciated.

(P.S. - PROC LOAN is not an option as it takes too much time to calculate it for each row)

The FINANCE functions PMT and PPMT both have FV as options.

```FINANCE('PMT', rate, nper, pv, <fv>, <type>);

FINANCE('PPMT', rate, period, nper, pv, <fv>, <type>); ```
2 REPLIES 2
Super User

## Re: EMI calculations with a Balloon Payment

@thepushkarsingh wrote:

I want to create/use a function which takes ballon payment in the end period to give EMIs. For example, a loan at 4% annually of 1000 for 12 months with a balloon payment of 100 at the end will have an EMI of 76.97. An equivalent to Excel formula = PMT(RATE,N,PV,[FV],[type]). There is an option in Excel of FV which doesn't seem to be in SAS function PMT.

Any help is deeply appreciated.

(P.S. - PROC LOAN is not an option as it takes too much time to calculate it for each row)

The FINANCE functions PMT and PPMT both have FV as options.

```FINANCE('PMT', rate, nper, pv, <fv>, <type>);

FINANCE('PPMT', rate, period, nper, pv, <fv>, <type>); ```
Quartz | Level 8

## Re: EMI calculations with a Balloon Payment

Thank you very much! There's so much to know in SAS.
Discussion stats
• 2 replies
• 743 views
• 2 likes
• 2 in conversation