Search results

  1. michaelg

    spreadsheet help req.

    Hi, Hmmmm, I think you're right, not sure then. Michael G
  2. michaelg

    spreadsheet help req.

    Hi, As above, that is, restart your loan calculation, but this time your PV (present value) amount is the previous balance less the amount of that extra payment, I believe. Michael G
  3. michaelg

    spreadsheet help req.

    Hi, Its $718.21 30yrs of monthly payments = 360 payments 5yrs of monthly payments = 60 payments. The balance after the 60th payment @ 6% = $93,054.36 Soooo..... After the 60th payment there remains only 300 payments left (360-60). Your new "present value" = $93,054.36...
Back
Top