View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Help on pv function

You will find that most people do not give direct answers to students, as
that is the whole point is to try to figure it out on your own.

I will give you 1 hint though, think ROUNDING.....
--
John C


"becky" wrote:



Home Loan Schedule
Principal $125,000
Rate 7.2%
Years 20
Payment $984.19 per month
Year Beginning Balance Ending Balance Total Paid
1 $125,000 11,810.24

My professor wants me to use the pv functon for the ending balance on come
up with this figure of 122,095.14. I have tried everything and can not come
up with this figure. I put 7.2%/12 for rate, 20*12 for nper and 984.19*12
for pmt. Please help