You have $10$ gold coins and the price today is $\$10,000$ and it appreciates $10\%$ a year. You sell $\$1000$ every month.

Question

• You start out with $10$ gold coins

• The price is $\$10,000$ for the entire year.

• Gold coins appreciate $10\%$ at the start of each year.

• You cash out $\$1,000$ every month.

How many months/years will this last before you reach $0$ gold coins?

Is there a special math formula to calculate this easily? Or excel formula? What is this called?