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