3D Printing Business: Startup Financial Model and DCF Analysis

Video Tutorial:

This is another financial model where depreciation is a material item for the pro forma so based on tranches of 3D printer purchases, this non-cash expense item automatically populates on a monthly and annual basis.

The model is driven by the following build-out assumptions:

• Type (up to thirty-five 3D printer types) - pre-defined into 3 main categories of printers

• Purchase count

• Purchase month

• Purchase cost per unit

• Product category name

• Avg. Starting sellable items per month per 3D printer

• Avg. Sales Price

• Avg. monthly compounding growth rate of sales

• Max Sales Production per Month per 3D printer (because this can not go up to infinity)

• Expected direct material costs per month per printer type (up to 10 cost items)

Fixed costs and other one-time startup costs are defined elsewhere. Everything comes together for a nice monthly and annual pro forma view as well as an annual high level executive summary as well as a DCF Analysis for the project and for the investor/owner depending on financing sources defined. There is also an exit value if applicable and that will add to the final cash flow available for distribution if a value is entered. Over 12 visualizations display key metrics and financial performance based on the defined assumptions.