would help if we could see your entire table... AMIBS have been borderline/upside down on their return on investment if you are purchasing them outright. Your only hope of turning a profit is to snag the rare that spawns there... if not, better hope you enjoy doing them...
Do columns B and C represent per scroll averages of gold and plat, respectively? If so, layering in a running total of your iron man statue values on top would be artificially inflating your per scroll economics. Nonetheless, the plat value erosion has certainly taken a toll on AMIBs, rare drops aside.
So if I am reading your chart correctly, The return on a Red AMIB is 37,000 assuming you loot ALL the gold and sell your plat and plat statue... You also get an AMIB chest... Once highly sought after and valued are having a hard time selling. I have had one of each color and type on a vendor for over a week now at 19,999 - none have sold. So say I cut that in half, it might sell at 10k. Expected return on a Red would be 47,000, (5k less if you don't ironman/sell) That's not break even given that the asking price is more than that for a Red. Only solution... STOP PAYING break even costs for AMIBS
I do smoke a MEAN Salmon... like I said, you better enjoy doing AMIBs, cause at current prices, you are not making any money at it
I’d tighten up the model by layering in chest values and an imputed rares value adjusted for spawn rate (e.g. fishing net value x estimated spawn rate). Could also bring in weapon/armor mob drop values but I’d guess their respective values are nominal so probably fine to leave out. Nerdery aside, spending time running AMIBs at these values would be borderline masochistic. I did something similar to this for fishing nets over a year ago, here. Google sheet should still work.
when buying AMIBs, gotta factor in 2 other factors 1. Fun Factor- that's gotta be worth something 2. Lottery Ticket - Chance at that Rare, can use jumpman's calculation above to figure what that might be
The price point for all AMIBS was established, at the current, when plat was at 10k and the rares inside were harder to come by. I didn't make a chart and I don't have the fancy stuff like Jumpman but purchasing at current prices will see you losing at minimum 10-30k per scroll. I am being realistic based on the low rate of rare drops.
I think @wylwrk is trying to post a helpful cheat sheet for averaged outcome for each amib before chests and rares are factored in since those tend to fluctuate the most. Could it be more elaborate? Of course, but at least this gives a base of what you'll get out of most amibs without the chest factored in. For example, a gold trim chest could sell for 35k one week ,and then be sitting on auction or a vendor at 10k for weeks. It's a hard call because I think if amibs go for much less, you won't see as many for sale and much less fisherman on the sea. And if there are less and less being sold, then the price might go back up depending on demand. But, I usually just let market dictate. If I really want amibs, I just go fishing or buy up special nets whenever they pop up unless I built up a new amib char and im being impatient to get another iron man trophy. I'm with @Pirul that I stopped buying them for the most part when plat value went down and amibs value didn't follow suit and I had run enough of them that the fun factor had run its course for me.
100% plat value devaluation. Not getting into reds and blues simply because I don’t find them to be worth buying at all. I do still buy purples and greens because I usually hang out for a while after I’m done and get the digger and bartender to respawn thus getting 2 additional plat. That also lets me pull 20-24k gp per run. Sooooo, my loot on purples is worth 20k + 14 plat and greens 22k + 16 plat. I buy with that in mind. I don’t factor in chest values because I’ve tried selling them every way possible (singles, as full sets, on vendors, etc.) and have only found a handful of takers. Rares are also so hit and miss it’s hard to factor into the value. I pretty much take them as a nice little bonus when I find them.
If you factor in the cost for the shittiest chest then your spreadsheet would look exactly like mine. They would also come to the same conclusion: doing AMIBs for anything other than obtaining the rares, is stupid. They used to be profitable, but the gp/hr (even when plat was 10k per) was still less than traditional farming. If Chris adds 2 more tabs of plat rewards, one high tier and one medium tier, you'll see AMIBs return to a valuable commodity. Have to get the cost of plat back up to 10kper OR refresh AMIBs to reflect their current price point (or stop selling/buying at a loss or breakeven).
If you look at the chart as a reference on a red scroll you get 4 plat and roughly 12k. When plat was selling at 10k that earned you a 50-55k return on a scroll. Now with plat selling at 6k you are looking at a 35-38k return on that same scroll and yet they are still selling at 55k each. Like many of you I have stopped buying them altogether, although I may reconsider the green and purple in light of Piruls trick
