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?

This sounds a lot like a homework assignment?

Simply you just add another column c30:c1088 c30 contains 1 c31 contains c30+b31 and copy to the end units sold are =MATCH(B3,C30:C1088,1)

price paid is =INDEX(C30:C1088,MATCH(B3,C30:C1088,1))

although I am sure there is a formula for summing a multiplicative time series that will give you a more concise answer, you could google that

you are also using 0.0001% in b2 = 0.000001 but in b31 you use 0.001% so terms are not consistent

total price= units sold x first price x (1+(price increase* units sold/2)) as the first price is 1 I am ignoring it below!

put B4+0.5*B2*B4^2 in a cell to solve, and determine the true value of b2 as you have been inconsistent

goalseek this cell to equal 10000 by changing cell b4.