using excel to calculate loan amount.

[mercury]

I want to knw if there is a way to use excel to caluculate the total
amount of a loan once I have the interest rate, the numbers of months
of payments and the monthly payment amount. for example I want to know
how much the loan would be if I paid 500 a month on a 30 year loan at
6.5%. I want to be be able to use excel to calculate how much loan I
can get if I have those 3 variables.


thanks
Mercury

[Marcelo]

hi use fv(rate,period,payments)
note: as the payment is an outflow put it as a negative

hth
regards from Brazil
Marcelo


"mercury" escreveu:

> I want to knw if there is a way to use excel to caluculate the total
> amount of a loan once I have the interest rate, the numbers of months
> of payments and the monthly payment amount. for example I want to know
> how much the loan would be if I paid 500 a month on a 30 year loan at
> 6.5%. I want to be be able to use excel to calculate how much loan I
> can get if I have those 3 variables.
>
>
> thanks
> Mercury
>
>