Calculation of incremental pricing

Hi gurus,

I'm tasked to do a workbook to facilitate the following:

1. the initial price of unit is $1
2. with every unit sold, the price increases by 0.0001%


there's no cap on the amount of units to be sold, and the expected end result is that the user wants to know how many units can be bought if a payment of e.g. $1000 is paid, and what is the current selling price of the next available unit.

can i check if this can be done in Excel? if so, may i ask how do i set up this table please?