View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Becky Becky is offline
external usenet poster
 
Posts: 73
Default Help on pv function



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