There are a few different ways to go in the 3D printing industry. This template focuses on B2C opportunities, meaning a business that purchases 3D printers and uses those printers to make things to sell for a profit. There are a lot of niche opportunities here and this industry is growing. The real value creation is going to happen in the software and creativity area i.e. you need to think of unique things to build that service an audience that is demanding whatever it is you are making.
In order to make strategy and planning easy, this template gives unique revenue logic that lets the user scale out purchases of up to 3 types of 3D printers (each with 10+ sub-types). Things that drive revenue include: cost per unit, count of units purchased, month of purchase, avg. sales price of products that each sub-type creates, average monthly growth of sales, and max capacity per month per printer unit.
The forecast goes out 5 years by month and year. There is a detail summary report that shows how all the assumptions come together and key Profit/Loss items. The model drives all the way down to EBITDA and EBT. That means a dynamic depreciation expense is being calculated.
Assumptions for fund sources range from traditional bank loan to investors and owners. Cash distribution summaries populate based on defined inputs for those sources. Metrics include IRR, ROI, and an equity multiple as well as a ton of visuals so the story can be told more easily as well as fit in a slide deck.
An executive summary breaks out the most important items from the Profit/Loss detail and cash flow areas. This drills down to cash flow after equity and cumulative cash flow.
There is a specific direct cost area so the user can define a range of costs per month per type of 3D printer. This would fall along the lines of supplies used and anything else that is logical to define on a cost accrued per printer per month basis.