How would I do this:
A5 = Loan amount
A6 = rate
A7 = term (yrs)
A8 = Payment (=PMT(A6/12,A6*12,-A5))
A10 = Payoff in yrs (ex. 2yrs)
A12 = Balance at time of payoff
How do I solve for A12. I used to know this but it has slipped my memory somehow.
How would I do this:
A5 = Loan amount
A6 = rate
A7 = term (yrs)
A8 = Payment (=PMT(A6/12,A6*12,-A5))
A10 = Payoff in yrs (ex. 2yrs)
A12 = Balance at time of payoff
How do I solve for A12. I used to know this but it has slipped my memory somehow.
Last edited by jermsalerms; 07-08-2006 at 12:12 PM.
I figured it out.
If anyone needs to know in the future here it is:
=-PV(A6/12,A7*12-A10*12,A8)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks