Does anyone have a formula to calculate the car lease payments

Hi,

I am just looking for a formula that will allow me to calculate the monthly
repayments for a car lease. Thanks in advance

The PMT function may help you out. Look at Excels help for details regarding
its arguments and use.


"Captain Jack" wrote:

> Hi,
>
> I am just looking for a formula that will allow me to calculate the monthly
> repayments for a car lease. Thanks in advance

see if this helps

http://tinyurl.com/dxnq4

--
Don Guillett
SalesAid Software
donaldb@281.com
"Captain Jack" <Captain Jack@discussions.microsoft.com> wrote in message
news:A8B9AA5A-1207-4339-BB40-BF7C8E4AB4F4@microsoft.com...
> Hi,
>
> I am just looking for a formula that will allow me to calculate the
monthly
> repayments for a car lease. Thanks in advance