return payoff after "X" amount of payments


J

jermsalerms

How would I do this:

A1 = Loan amount
A2 = rate
A3 = term (yrs)
A4 = Payment (=PMT(B3/12,B4*12,-B2))
A5 = Payoff in yrs (ex. 2yrs)
A6 = Balance at time of payoff


How do I solve for A6. I used to know this but it has slipped my memory
somehow.
 
Ad

Advertisements

J

jermsalerms

I figured it out.

If anyone needs to know in the future here it is:

=-PV(A6/12,A7*12-A10*12,A8)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top