Goal Seek Excel Function - Interest Calculation

Question

Hi Team,

I have been looking around multiple examples of Goal Seek function from excel, but could not replicate the logic for the attached File.

I am looking for Alteryx WF that helps me calc the Interest Rate that would allocate the Total Interest through out the loan period. The solution needs to be replicated to extensive set of data, this is just one subset of the broader data.

Thank You and appreciate your help.

RP

Goal Seek.xlsx

rajeshprbh · Answer

HI  Philip,

Sorry had to add one more component - the Cost used for calculating the Goal Seek was a moving number, have updated the file. So prior days Cost + Accretion Income is the Cost for next day.

The solution you provided was excellent, but we need to include the moving cost in calc.

Thank You and appreciate your help.

RP

Goal Seek.xlsx

philipmannering · Answer

Hi @rajeshprbh

Do you start with the Dates and Costs? If so, the attached file might work. But I'm sure I've missed something.

get interest rate.yxmd