View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default How do I enter the PV function to determine the ending balance of

Use FV() instead

--
Kind regards,

Niek Otten

"Rettarie" wrote in message
...
The principal is 140000., the rate is 7.25% for 15 years, the payment is
1278.01 per month. How do I enter a =PV fuction formula to determine the
ending balance of the loan after 1 year?