3D Printing Fleet: Startup Financial Model (Excel XLSX)

Having the ability to see how your business is going to make money and what it takes to achieve stabilized profits should not be a mystery. This spreadsheet will help that.

3D printing or additive manufacturing is the process of using raw materials, programming, and 3D printers that take that code and build things out of the materials that have all types of uses.

This financial model was built to handle key assumptions that are specific to running a fleet of your own 3D printers to create and sell products.

Final reports include:

•  5-Year Monthly and Annual Pro Forma detail
•  5-Year Annual Executive Summary
•  5-Year Annual DCF Analysis
•  5-Year Contribution/distribution summary with IRR/ROI/Equity Multiple
•  Visualizations
•  Automated depreciation based on purchasing schedule

The model is highly scalable to manage the financial forecasting of very large operations or can be toned down for only a few machines.

There are up to 35 3D printer slots and each slot has its own input for:

•  count of printers
•  purchase month
•  cost per unit
•  Avg Starting
•  Sellable items per Mo. Per 3D Printer
•  Avg. Sales Price
•  Avg. Monthly Compounding Growth Rate of Sales
•  Max Sales Production per Month per 3D Printer

There is an area for direct costs related to printing materials for each of the 35 printer types (up to 10 material costs per type) and a schedule for on-going overhead costs as well as other one-time startup costs.

The financial planning spreadsheet will make it very clear what the initial investment requirement will be, the timing of cash flows, the expected return on investment, and levers to modify sales volumes, pricing, exit month (for terminal value). Instructional video included in the file.