3D Printing, Financial Model, Manufacturing

5-year Financial Projections, Accounting, Break-Even, Budget, Budgeting, Business Valuation, Cash Flow Analysis, Cash Flow Projections, CFO, Controlling, Dashboard, DCF Model, Debt Amortization, Debt Schedule, Debt Service Coverage, Discount Rate, Dividends, Excel, Financial Feasibility, Financial Model, Financial Planning, Financial Projections, Forecast, Forecasting, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), Know-How, NPV (Net Present Value), Private Equity, Pro-Forma, Profitability Analysis, Project Plan, Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Uses and Sources of Funds, Valuation, Venture Capital

Video Tutorial:

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 to 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 detailed 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 a 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.