I have seen many examples online for "Time Value Money" and "sinking funds". I want to know how I can combine any type of solver in the PMT-PV equation? Because all these examples have known FV, PV, and i (interest rate) and they all solve for PMT, but I want to solve for i.
Example: I have 10 million in the bank account, and I want to have 5 million in the balance of the account after 5 years. I want to make a withdrawal of 100 thousand every month (end of month), so I have to know what interest rates I am seeking for so this would work for me.