Hi everyone,
As I was wondering myself if buying Batch 3 of Z9 mini or the newly launched Z9 is going to be profitable, or what is going to be the ROI, I tried a simulation, and I thought about sharing it, as I saw other ppl ask the same questions around the forum.
See https://docs.google.com/spreadsheets/d/1lrROgkZ5Xhp6OJBqPPCvBXgS8zJi-4XpUzx2N71P8VQ , you can make a copy paste and play with the values

TODO
- number of ZEN/ZEC/1000sol/day is copy pasted from whattomine, I think a dynamic include is a good TODO
- price of shipping may not be accurate

Explanations:
- it runs the simulation on ZEC and ZEN
- it has 2 simulations, over clocked and stock

Configurations:
- projected budget (see actual below in the bottom)
- % for customs taxes
- electricity cost in cents
- whattomine values
- projected difficulty factor (i.e. 5 it means the total network hashrate will increase *5 times when new miners are released)
- projected % price modification may be positive or negative (i.e. -25% means a 25 percent decrease, 200 means a 200% increase). Once you change this you can see the new price will update. Leave 0 for current market price.
- coupons: assuming you will use coupons, it needs the value and the effective $/coupon spent

I cannot offer a lot of support on this, and I do not guarantee the formulas work fine, use at your own risk.

$250 coupons:
- expiry time 15th july 2018
- The coupons will be released by 8th, June, 2018, and the expiry date of these coupons will be 23:59:59, 15th, July, 2018 (Beijing time, GMT +8).
- More than one coupon cannot be used for the purchase of one miner, and the total coupon discount applied during checkout should not be more than 50% of the total purchase amount. For the specific usage rules, please check the specific product page as reference.

 $100 coupons
- expiry time 31th July 2018
- The coupons can only be applied to new purchases of the Antminers on https://shop.bitmain.com/
- More than one coupon cannot be used for the purchase of one miner, and total coupon discount applied during checkout should not be more than 50% of the total purchase amount. For the specific usage rules, please check specific product page as reference.

I know this is my first post here, so I am willing to cover escrow services. For the next one and a half weeks I will have limited access to answer potential enquirers, so please be patient, I will do my best.