using excel to calculate loan amount.

M

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
 
M

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top