Thread: CALCULATE MAXIMUM AMOUNT TO BORROW
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default CALCULATE MAXIMUM AMOUNT TO BORROW
You also need to know the term (length of the loan), but you want present
value, as in:

=PV(IntRate/12,Years*12,-Payment)

Regards,
Fred.

"CHARI" wrote in message
...
What calculation do I use for Excel 2003 to calculate the maximum I can
borrow when I know the rate and the maximum amount I can afford?

Reply With QuoteReply With Quote