Hello,

I have constructed this excel to help those who wish to operate vertical companies.

Vertical companies are those which produce their own raw materials.
Choosing to make your own raw materials is one approach where you have zero operating costs (minus energy expenditure) and daily revenue and product.

Being able to produce and make revenue right away is greatly rewarding when you can interact and play the market quickly, but it comes at a cost. You will have to make a substantial investment in your supply chain which will mean you will not have net profit until typically 0.5 to 1 years -- however, the ROI after you pay off your debts is greater than any other strategy on EDom, as you will be making pure net profit!

Below I have attached two screenshots of a company with 0 production bonuses and one of 100 production bonuses. I have also attached a video and link to the excel that explains how you can use it to tier your personal vertical company plan on making money. Please see the video on how to do that and also a breakdown of how to use this excel for your calculations. 

Notes:
Prices derived from past articles on average black market prices. Selling in the trading center will typically yield better profit, adjust the prices to your research and expectations.
Cost of Aircraft is not consider the cost of getting to Q5 tanks, and same for tanks for weapons. Please see this screenshot for an idea of real investment of Airplanes/Tanks or watch video.

Screenshot of company breakdown with 0% production bonus

Screenshot of company breakdown with 100% production bonus

Screenshot of company breakdown given a personal setup

Download Excel

Video of using mode 1 (personal mode)