Click main image to view in full screen.
3D Printing Fleet: Startup Financial Model (Excel XLSX)
Excel (XLSX)
VIDEO DEMO
BENEFITS OF THIS EXCEL DOCUMENT
- Unit Economic Insight
- Cash Flow Forecasting
3D PRINTING EXCEL DESCRIPTION
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.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in 3D Printing, Integrated Financial Model Excel: 3D Printing Fleet: Startup Financial Model Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping
ABOUT THE AUTHOR
I graduated in 2011 with a Bachelor's degree in Accounting and began my career as a financial analyst at a small chain of auto repair shops. After gaining valuable experience, I launched my own practice specializing in real estate underwriting, later expanding into general business modeling.
I honed my spreadsheet modeling expertise by completing over 400 projects on Upwork with a 100% success
... [read more]
Ask the Author a Question
You must be logged in to contact the author.
This document is available as part of the following discounted bundle(s):
Save %!
Industry-specific Financial Models (40+)
This bundle contains 62 total documents. See all the documents to the right.
