I am trying to solve for particular loan payment amounts or a particular debt coverage ratio that involve the above line. Two problems occur: (a) goal seek reports that "goal seek may not have found a solution" although I give it 1000 iterations. (b) Goal seek pastes in a value (and it is way wrong) over the formula in my "By changing cell" box. This latter problem literally changes my spreadsheet, and I have to paste the formula back in.

Has anyone seen the types of "problems" specified above? I have been searching for Internet information describing the limitations of goal seek. I am even more troubled that goal seek pastes in a value, thereby, screwing up my formula.

Two more points: Solver can solve the question. Second, I have noticed that Excel makes wild guesses for the debt coverage ratio solution; I may be looking for a 1.25 debt coverage ratio, but the guesses are like 50,000,000. Thanks, and since this is my first post, I apologize if I have ignored protocol or information requirements.