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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I enter the PV function to determine the ending balance of (https://www.excelbanter.com/excel-worksheet-functions/72114-how-do-i-enter-pv-function-determine-ending-balance.html)

Rettarie

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

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

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?

bpeltzer

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

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

"Rettarie" wrote:

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?

All times are GMT +1. The time now is 04:22 PM.