# Is it normal for Calc goal seek to take very long? [closed]

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I made a spreadsheet for a 30 year loan, 360 months, with a constant payment, and asked goal seek to calculate the interest rate to make it pay off at .6% of original principal a month, calculating interest by the dollars*days for a 365.25 day year. The starting value of 6% per year was almost correct. The goal seek did not have an answer even after several minutes. Does Goal Seek make too many wild guesses?

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by cloph close date 2012-07-25 15:42:58.917042

Sort by » oldest newest most voted

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I think there is a function in calc to calculate the fixed payment with a know rate:

=PMT(0,06/12;30*12;100000;1)

In the LibreOffice help:

PMT Returns the periodic payment for an annuity with constant interest rates. Syntax PMT(Rate; NPer; PV; FV; Type) Rate is the periodic interest rate. NPer is the number of periods in which annuity is paid. PV is the present value (cash value) in a sequence of payments. FV (optional) is the desired value (future value) to be reached at the end of the periodic payments. Type (optional) is the due date for the periodic payments. Type=1 is payment at the beginning and Type=0 is payment at the end of each period. In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone. Example What are the periodic payments at a yearly interest rate of 1.99% if the payment time is 3 years and the cash value is 25,000 currency units. There are 36 months as 36 payment periods, and the interest rate per payment period is 1.99%/12. =PMT(1.99%/12;36;25000) = -715.96 currency units. The periodic monthly payment is therefore 715.96 currency units.

more

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm not familiar with the English terms here, but this task seems simple enough for the goal seek to handle in a couple of seconds, not minutes.

So it's best to file a bug and attach the sample document in order to be able to debug it. https://www.libreoffice.org/get-help/bug

You might also check whether the solver does a better job in solving this specific problem.

more