amortization schedule

[sammy254]

Hello everyone!
Can anyone help me make the following:
I have made an amortizations schedule, but I'm supposed to keep two values as 1000, and figure out the rest of the payments for ten years, bringing ending balance to zero. I'm supposed to give an alternative to goal seek. Any help?

[sammy254]

no help , guys?