Test the price, capacity and costs behind your machine shop. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Product lines, units and pricesUses the verified E21 manufacturing engine for a four-machine CNC job shop: each physical product line has an independent launch date, sold-unit volume and selling price, followed by seasonality and separately supported additional revenue.Explore layout ↓
02Materials and direct production costSeparates raw material, tooling consumption, outside processing, expedited freight, scrap, rework and sales-linked fees from paid payroll and fixed overhead so each billable spindle-hour has a visible contribution.Explore layout ↓
03Production capacity and qualityBridges independently entered sales to four CNC machines, staffed shifts, setup time, cycle time, inspection, secondary operations and maintenance, with setup, run, finishing, inspection, maintenance and downtime visible rather than assuming every scheduled hour produces saleable output.Explore layout ↓
04Staffing and operating expensesSchedules paid owner work, production and administrative roles, start dates, employer costs, occupancy, utilities, maintenance, software, sales and recurring overhead.Explore layout ↓
05Startup uses, funding and scenariosSchedules facility work, CNC equipment, inspection, software, tooling, workholding, stock and reserve, working capital and financing, then compares low, base and high unit, price, contribution and fixed-cost paths.Explore layout ↓
06Statements and dashboardConnects product-line revenue, direct production cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Machine ShopPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$620,000
$980,000
$1,346,800
Material, tooling consumption, outside processing, freight, scrap and payment-linked costs
$285,200
$431,200
$565,656
Paid owner-management, machinists, setup, inspection and administrative labor
$340,000
$380,000
$420,000
Rent, utilities, maintenance, software, insurance, sales and overhead
$225,000
$235,000
$245,000
EBITDA
−$230,200
−$66,200
$116,144
EBITDA margin
-37.1%
-6.8%
8.6%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Product lines, units and pricesWorksheet specification
Product lines, units and prices
Planned purpose: Uses the verified E21 manufacturing engine for a four-machine CNC job shop: each physical product line has an independent launch date, sold-unit volume and selling price, followed by seasonality and separately supported additional revenue.
Inputs
Product-line names
Launch dates
Units sold by line
Selling price by line
Monthly seasonality
Separately supported additional revenue
Outputs
Revenue by product line
Monthly and annual revenue
Product mix and growth
Limits and completion needs
The product lines must remain operationally distinct: milled parts, turned parts, repeat production lots, prototypes and separately priced secondary services.
Do not count one job as both sold parts and billable spindle-hours in the same revenue total; the public hour is a capacity bridge, while the paid model uses product-line units and prices.
02Materials and direct production costWorksheet specification
Materials and direct production cost
Planned purpose: Separates raw material, tooling consumption, outside processing, expedited freight, scrap, rework and sales-linked fees from paid payroll and fixed overhead so each billable spindle-hour has a visible contribution.
A quoted tolerance or inspection requirement must have a capable process, controlled revision and recorded acceptance; a spreadsheet cannot establish capability.
03Production capacity and qualityWorksheet specification
Production capacity and quality
Planned purpose: Bridges independently entered sales to four CNC machines, staffed shifts, setup time, cycle time, inspection, secondary operations and maintenance, with setup, run, finishing, inspection, maintenance and downtime visible rather than assuming every scheduled hour produces saleable output.
Inputs
Machine and finishing capacity
Setup and run time
Yield and scrap
Inspection and rework
Maintenance and downtime
Outputs
Available production time
Used capacity
Bottlenecks, yield and rework
Limits and completion needs
Revenue inputs do not prove that equipment, labor or quality systems can deliver the volume.
04Staffing and operating expensesWorksheet specification
Staffing and operating expenses
Planned purpose: Schedules paid owner work, production and administrative roles, start dates, employer costs, occupancy, utilities, maintenance, software, sales and recurring overhead.
Inputs
Roles and headcount
Pay rates and employer burden
Shift and coverage plan
Operating expenses
Maintenance and replacement policy
Outputs
Monthly payroll
Operating expense
Coverage gaps and cash need
Limits and completion needs
National occupation data do not set local offers or a complete employer burden.
Estimating, setup, production, inspection, finishing, shipping, sales and administration must be assigned.
05Startup uses, funding and scenariosWorksheet specification
Startup uses, funding and scenarios
Planned purpose: Schedules facility work, CNC equipment, inspection, software, tooling, workholding, stock and reserve, working capital and financing, then compares low, base and high unit, price, contribution and fixed-cost paths.
Inputs
Opening uses
Vendor and installation timing
Reserve policy
Debt and equity
Scenario multipliers
Outputs
Sources and uses
Cash runway
Funding gap
Break-even and sensitivity
Limits and completion needs
The StartFigures allocation is not a property, equipment, contractor, insurer or lender quote.
Debt service, tax, deposits, installation timing and replacement capital require a dated cash schedule.
06Statements and dashboardWorksheet specification
Statements and dashboard
Planned purpose: Connects product-line revenue, direct production cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.
Inputs
Selected scenario
Working-capital timing
Financing
Tax assumptions
Opening balances
Outputs
P&L
Cash flow
Balance sheet
Dashboard and ratios
Limits and completion needs
Outputs inherit every unit, price, yield, capacity, cost, funding and collection assumption.
A forecast does not certify demand, quality, permits, safety, capacity or profitability.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Billable spindle-hours per operating day across four machines
28
16 – 38
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$55,417
Held constant
Operating break-even threshold
Contribution margin
58.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
35.0%
Base ramp input
Opening month revenue
Mature volume added / month
4.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
16
$64,084
$95,547
Not reached
Base volume
28
$112,147
$95,547
Month 14
Higher volume
38
$152,200
$95,547
Month 8
Only billable spindle-hours per operating day across four machines changes. Realized revenue per billable spindle-hour: $185.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$620k
Year 1
$980k
Year 2
$1.3m
Year 3
$1.6m
Year 4
$1.9m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, power, compressed air, rigging, guarding and safety work$220,000
Two vertical machining centers$300,000
CNC lathe and bar-handling capability$190,000
Inspection, CAD/CAM, computers and tool preset capability$120,000
Tooling, workholding, coolant systems and opening raw stock$110,000
Deposits, licensing, insurance and professional setup$60,000
Preopening payroll, training and customer qualification$70,000
Working capital and contingency$130,000
One-time budget: $1,200,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $1,346,800.
Material, tooling consumption, outside processing, freight, scrap and payment-linked costs$565,656
Paid owner-management, machinists, setup, inspection and administrative labor$420,000
Rent, utilities, maintenance, software, insurance, sales and overhead$245,000
EBITDA$116,144
EBITDA margin: 8.6%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
24
Break-even revenue / month
$95,547
Base revenue / month at maturity
$112,147
First operating break-even
Month 14
Units mean billable spindle-hours per operating day across four machines. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$620,000
$767,085
Year 1 operating result
−$230,200
−$220,094
Year 3 / mature annual operating result
$116,144
$115,539
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your machine shop together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Machine Shop Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Product lines, units and prices, Materials and direct production cost, Production capacity and quality, Staffing and operating expenses, Startup uses, funding and scenarios, Statements and dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review realized revenue per billable spindle-hour, billable spindle-hours per operating day across four machines, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
