Battlefields in Ukraine and the Middle East have proven drone warfighting tactics a decisive and evolving force of the modern battlefield. Armored vehicles and military infrastructure worth millions can be brought down by modified consumer drones available to any modern consumer.
I created the following table as a cross-ticker comparison of some of the leading publicly traded stocks in drone technology, military and aviation. The cross-comparison view shows relative rankings between all tickers. Individually available are the historical financial filings of each company. This worksheet uses a combination of:
* API calls to pull up to 25 years of SEC filings (if available) and
* Colored data bars to give a quick visualization of trends across key metrics
Note that data bars show display the relative ranking of a metric across its highest and lowest range. A growing trend, in revenue for example, will have bars expanding towards the most recent quarters. A positive trend should appear like the head of a colorful comet. A metric with broken, irregular or negative numbers will appear brown and jagged. The goal was a quick visual way to visualize earnings trends and flag problems.
A full analysis would also require an investigation into the product, competitive advantage, leadership track record and capital structure. For now, these first pass metrics include EV, P/E, revenue, gross / operating margin, operating cash flow, net income, FCF, assets / liabilities, current ratio, long term debt and book price.
\---------
As of my read: Few of the companies have any substantial revenue, fewer are profitable on a net income basis and almost all have negative free cash flow.
# -- Cross Ticker Comparison --
[https://imgur.com/XWJmg5D](https://imgur.com/XWJmg5D) (view first)
**Individual dive**
|TICKER|Analysis|
|:-|:-|
|ONDS|[https://imgur.com/NZWrrWU](https://imgur.com/NZWrrWU)|
|AVAV|[https://imgur.com/Xf1YtGu](https://imgur.com/Xf1YtGu)|
|LPTH|[https://imgur.com/0EoJiSR](https://imgur.com/0EoJiSR)|
|AVEX|[https://imgur.com/SGupCD5](https://imgur.com/SGupCD5)|
|KTOS|[https://imgur.com/tRbbMyC](https://imgur.com/tRbbMyC)|
|UMAC|[https://imgur.com/32zkCgd](https://imgur.com/32zkCgd)|
|PYDN|[https://imgur.com/cTKcP5n](https://imgur.com/cTKcP5n)|
|RCAT|[https://imgur.com/N8maPWQ](https://imgur.com/N8maPWQ)|
|ZENA|[https://imgur.com/1wg7OY6](https://imgur.com/1wg7OY6)|
|UAVS|[https://imgur.com/f1xoCB6](https://imgur.com/f1xoCB6)|
|AMPX|[https://imgur.com/3jpvmZO](https://imgur.com/3jpvmZO)|
|SWMR|[https://imgur.com/x6CLRsU](https://imgur.com/x6CLRsU)|
|DPRO|[https://imgur.com/K0bymQL](https://imgur.com/K0bymQL)|