3D Printing (B2C) Excel Financial Model

A 5-year monthly and annual template to plan out the startup and financial performance of a 3D Printing B2C business.

by Jason Varner
smarthelping.com - Financial Modeling for EveryoneFollow 156

227 views|Start the discussion!|Bookmark Add to cart - $70.00

Description
I was looking into some of the highest growth industries and 3D printing was what I came away with. There are a few different primary business models used around this new technology. The template here involves a B2C offering where 3D printing machines are purchased and used to build things that are then sold for a profit.

There is a lot of general logic here that may apply to a wide range so let's get into it.The revenue driver is based on have 3 types of 3D printing machines (type 1/2/3) and within each type there are sub-types (10+ slots for each type). This allows for the most granular and useful way to figure out purchasing costs as well as revenues for different things. The user can define the count of each sub-type purchased, the month of purchase, the avg. starting sales per type per month, avg. monthly growth per type, avg. sales price per type and max capacity per type. These assumptions make it easy to scale out basic or diverse business plans i.e. you may purchase some 3D printing machines that are used to make lower price items vs. some machines may be more expense and make things that sell for a higher price with different growth outlooks and sales volumes.


There is logic to identify direct costs per printer type per month (mostly used for the various supply costs per month per type of 3D printer).


You can easily plan out the hiring of an executive team over time as well as staff and other G&A / S&M / R&D expenses with variable start months and costs over time.


Assumptions exists for investor and owner equity requirements based on the remaining cash required after any funding from a traditional bank loan. There is also logic for an exit multiple that can happen in any month.


A DCF analysis is done for the project, investor, and owner equity contributions. The model defaults into an equity requirement based on the minimum project cash position over time. A display of IRR, ROI, and equity multiple exists for all sources as well.12 visuals exists to easily communicate the results of the user's assumptions. There is also a high level executive summary that displays primary line items over 5 years.


Finally, the resulting monthly depreciation expense will display dynamically based on the month of each purchase and the defined useful life. This is used to drill down from EBITDA to EBT.

This Best Practice includes
1 Excel template and 1 tutorial video