One way, assuming monthly payments:

A1: Payment
A2: Interest Rate
A3: Number of years

A4: =PV(A2/12, A3*12, -A1)



In article ,
Len wrote:

Hi Everyone,

What I want to be able to do is enter the payment, interest rate, and number
of years on a loan and then have the spread sheet tell me how much I can
borrow. Does anyone know of any Excel templates that do this?

Thank You