I would like to write a formula that explains how many items at different prices can be purchased given a certain initial amount. The difficulty is that every time you purchase an item, its cost increases by 10% while the decreasing the available capital by the amount just purchased.
So, as an example...
Initial capital: $1000. Rate of increase 10%
Item 1: $10
Item 2: $50
Item 3: $100
Item 4: $200
Assuming one of each is bought, the new prices are
Item 1: $11
Item 2: $55
Item 3: $110
Item 4: $220
The formula would ideally display how many of each I could buy, with the total rounding down to the nearest whole number. Thanks!
Bookmarks