How do I enter the PV function to determine the ending balance of

[Guest]

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?

 

[Niek Otten]

Use FV() instead

 

[Guest]

I'd use the FV function: =FV(7.25%/12,12,1278.01,-140000)