@Parko5 The PNV accounts are less than helpful, and I don't like how they categorise things.
Also my remarks here are a mix of what I am doing at the moment, and what I am thinking about in my major model rebuild, which I am embarking on now. Whatever I do in how I structure things, I tune my model to the last three years of $PNV accounts, so that the answers make sense.
Overall, I do the following:
(A) Net Revenue = sales to customers including any discounts/promotions/freebies
(B) Cost of Sales = Cost of Manufacturing (excluding D&A) and logistics cost delivered to customer (minimal)
(C) Gross Profit = (B) - (A)
(D) Sales and Marketing Expense I include:
- Cost of Sales Rep
- Allowance for Super(401K) / Health Insurance/ Other Benefits
- Expenses (flights, cars, accommodation. subsistence) - make a judgement based on the market. 10-15% of cost of the rep. is reasonable.
- Marketing Expense (see below **)
(E) R&D Expense (Project forward % revenue, with operating leverage, benchmarked)
(F) G&A (Project forward % revenue, with operating leverage, benchmarked)
(G) D&A (from capex model - PPE and intangibles ... make sure that by the end of the explicit period I like Capex = D&A if ongoing growth is low, i.e., 3% nominal. If growth is higher, then you need ongoing increase in Invested Capital)
EBIT = (C) - (D) - (E) - (F) - (G)
In the Cashflow model, to calculate FCF I include a Change in Working Capital, which is driven by Change in Inventory and the difference between Receivables and Payables, which I simply project forward as a constant % of Revenue. It is important not to overlook this, because it does tie up some of the Free Cash Flow and can be significant over time.
With D&A stripped out, I otherwise assume that costs and revenues even out between the P&L and Cash Flow models, so adding D&A back to EBIT is a good estimate of EBITDA.
In calcuating D&A, I look at invesment patterns in capital equipment and intangibles (e.g. is R&D being capitalised). While D&A is a non-cash item, I like to also project NPAT so that I can see what my model is delivering in terms of Value/Earnings (a proxy for P/E). This can help detect errors in long run projections!
In terms of capex, we were told the new manufacturing and R&D facility will use $25m of the capital raise proceeds. I am cautiously going to allow $30m due to inflation and/or capex over-runs, which are common! I am going to phase this 65% in FY24 and 35% in FY25. We haven't been told the phasing.
** For marketing expense this includes promotions in trade journals, conference exhibitions, paying expenses of opinion leaders, and online and print materials, as well as the cost of the marketing staff.
Gross Margin at $PNV and Operating Margin
Historically they've been getting %GM anywhere from 93% to 96%. But they are undertaking a major expansion from $100m sales capacity to $500m sales capacity. In 2025 when the new facilites come onstream, %GM will drop significantly, as these facilities will increase the fixed cost of the manufacturing operations.Of course, over time %GM erosion due to this factor will improve. I think I will mark them down to 90% GM in FY25, and gradually build it back up to 95% by the time they get to $500m sales - but subject to correction for remarks on market mix that follow.
The other factor is market mix. Here, I think we have to be very careful on using a constant %GM.
The US market has the highest unit prices. A 10cm x 10cm square of Novosorb BTM sells for US$800-900 before the price rise announced. A 10cm x 20cm piece is US$1600 nad a large 40cm sheet is US$6,600. Prices in UK/Europe and ANZ are likely to be a bit lower than this, assume 80% of US prices.
However, emerging markets are another story altogether. So I am going to model a separate line item for revenue from India and, evenutally, China. I'll write a separate note on assumptions here when I have finished my work, but I believe it is likely that BTM will sell in emerging markets for perhaps only 30-40% of the US Price. Of course, this will still be attractive, because the cost of a sales rep in India (fully loaded cost) is only c. A$25-40k, vs. A$120-140k in ANZ+EU+UK vs. A$180-200k in USA.
While it is important to avoid meaningless complexity, it is important to recognise that the unit economics of $PNV are going to change significantly over the next 5 years.
Those are some thoughts. This is a work in progress for me, so the above is more me thinking out loud.