Thread: Function to establish mortgage bond size.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
  
Posts: 829
Default Function to establish mortgage bond size.
wrote:
Can anyone tell me the function in excel to use to
establish the mortgage bond size I can get based on
the monthly payment I can afford.
I know to use PMT to do it the other way around where
I can determine the monthly payment based on a bond
value.

Perhaps =PV(monthlyRate,numberOfMonths,-monthlyPayment)
Reply With QuoteReply With Quote