· SmartHelping model update
A custom fabrication shop can win a profitable order in March and still need to borrow in April. It might buy steel before the order is signed, run payroll while the job is on the floor, and collect the final invoice weeks after shipment.
I updated the Made-to-Order Manufacturing Financial Model so you can follow those dates through a ten-year forecast. You can see when the shop needs funding, how much cash owners can take out, and what they could receive if they sell the business and its assets.
Orders, production costs and supplier payments
Supplier payment terms now start when materials are purchased.
Suppose the shop buys steel in January for a March order and pays the supplier one month after purchase. The forecast pays the bill in February. Bulk buying or ordering further ahead now moves the cash requirement with the purchase. On accrual accounting, you can follow the unpaid bill in accounts payable and the cost of the material through inventory to the shipped order.
Direct labor and variable factory overhead now follow the accounting method in the operating reports.
If a job uses $2,200 of labor spread over three production months, the cash forecast pays about $733 per month. Cash-basis reporting follows those payments. Accrual reporting recognizes the $2,200 when the order ships. Monthly Detail, Annual Detail and the summary now follow the selected method for these costs, matching the income statement.
Startup and other one-time costs can be scheduled over 36 months.
The Other Costs tab keeps an upfront column and adds separate inputs for months 1 through 36. You can put a launch consultant’s fee in month 2 and a second engagement in month 8. The first income statement month includes upfront and month-one costs. Later costs reach expenses and cash flow in their scheduled months, so you can see when the cash is needed.
Shipped units now include all ten product categories after waste.
The old shipped-unit subtotal on Sales picked up sales dollars from two columns and missed units in others. It now sums all ten product categories after waste. If the shop builds 100 units across several products and loses three, the subtotal shows 97 units available to ship.
The Costing Helper recalculates packaging inputs and clarifies break-even pricing.
The label and fastener lines now multiply quantity by unit price. Changing either input updates that component’s cost and the product estimate. The helper also distinguishes two questions. At your quoted price, how many units cover fixed costs? At your planned sales volume, what price covers them? Use the resulting estimate when setting the unit-cost and price assumptions in the forecast.
Funding the shop and paying owners
Equity can be contributed in the month the cash is needed.
Enter each contribution on Monthly Detail and compare actual contributions with minimum required equity on Global Control. This lets you model an owner funding the launch and a partner contributing later. The monthly cash balance shows whether the shop can make it to that second investment.
Sources and Uses explains what drives the funding requirement.
The new tab identifies the month when cumulative project cash flow reaches its low point. It brings equity, borrowing and operating cash together with equipment purchases, debt service, taxes and operating cash burn. The table counts all equity entered for the project. With staged investments, Monthly Detail shows how much of that equity has actually arrived by the low month.
Line-of-credit draws now reach cash flow, and term-loan proceeds follow the funding month.
A credit-line draw increases cash and the amount owed. Paying down principal uses cash and reduces the balance. Interest is tracked separately. The formal cash flow statement also picks up term-loan proceeds in the modeled draw month, before the first scheduled payment. That timing matters if the loan is funding an equipment purchase.
Distributions now leave cash and retained earnings in the month paid.
Enter a manual payout or set a starting month and minimum cash reserve for automatic payouts. The model accounts for manual payments before calculating how much excess cash can be distributed. Each payout appears in financing cash flow and reduces balance-sheet cash and retained earnings. Automatic payouts stop after exit, and the remaining reserve is handled separately in the exit month.
Financial statements and investor returns
Monthly and annual statements now reconcile funding, payouts and ending cash.
Debt and equity funding enter financing cash flow. Owner payouts reduce retained earnings, and sale proceeds reach investing cash flow. Customer deposits also show why cash and profit can move in different months. Under accrual accounting, an advance is unearned revenue until shipment. The unpaid balance then sits in receivables until collection. The annual reports roll up the monthly activity, and the ending-cash check on Global Control now includes distributions.
EBIT is visible in Monthly Detail, Annual Detail and the income statement.
Earnings before interest and taxes (EBIT) shows operating earnings after depreciation. That matters when buying a machine improves output but also adds years of depreciation. The Executive Summary labels EBIT and EBITDA excluding Other Initial Costs. Income statement EBITDA includes those costs. That distinction helps explain why launch-period earnings can look different in the two views.
Margin, growth and labor labels now match the calculations behind them.
Gross margin in the detail reports uses both product sales and ancillary income, the same revenue included in gross profit. The monthly income statement labels its twelve-month revenue comparison as year over year. The Executive Summary identifies recognized material cost, and the labor inputs specify fully loaded rates so you can account for payroll burden once.
The project return and each joint-venture partner’s return are easier to trace.
The Executive Summary shows the annual operating and cash flows behind the project. On DCF Analysis, the annual cash flows drive net present value (NPV) and internal rate of return (IRR) for the project, investor and owner/operator. Global Control brings their return measures together. The project IRR uses minimum required equity and project cash flows. Each partner’s IRR uses their share of actual contributions and distributions, which can differ substantially.
Business valuation and asset sales
Choose a revenue multiple or an EBITDA multiple for the operating business.
Choose the method on Global Control. Terminal Value takes the twelve months ending in the selected exit month and applies the corresponding multiple to revenue or to earnings before interest, taxes, depreciation and amortization (EBITDA). The operating price is shown separately from building and equipment proceeds. Use a multiple consistent with that separation so an asset is counted once.
Enter the expected equipment sale price on CAPEX.
For equipment purchased before exit, enter the expected resale amount (salvage value) on each item’s CAPEX line. Enter the building’s sale price on Building, which feeds CAPEX automatically. These amounts determine the gross asset proceeds at exit. You can now change what a used machine might sell for while keeping its purchase price, useful life and depreciation schedule intact.
Asset sale proceeds, gains or losses, and taxes now flow separately.
CAPEX compares each sale price with the asset’s remaining book value. The income statement records the signed net gain or loss in the exit month. Investing cash flow receives the gross proceeds. The model applies its income-tax assumption to the operating sale and its separate capital-gains rate to the net asset gain or loss. Switching off terminal value removes both sale components.
Formula and reporting fixes
Selected HLOOKUP formulas were replaced with INDEX/MATCH.
For example, Monthly Detail matches the product heading on Unit Costs to pull the corresponding per-unit cost. The credit schedule matches a month to its forecast cash balance. Those matches make it easier to trace a result back to the assumption or period that produced it.
Monthly balance-sheet charts now line up with their dates.
The chart date ranges now align with the 120 forecast months, so a movement in the balance sheet appears under the corresponding month.
Duplicate debt-balance lines were removed from the operating reports.
Monthly Detail, Annual Detail and the Executive Summary still show debt service. For principal outstanding in a particular month, use the balance on Initial Loan or Line of Credit. The summary also drops its old equity payback helper rows. The product-level break-even analysis stays in the Costing Helper.
An obsolete link to another Excel workbook was removed.
The file no longer carries that external workbook reference when you open your own copy.
What can you test in the updated model?
Try buying one month of materials at a time instead of three, keeping customer deposits and shipping terms fixed. Compare the supplier payment months and the lowest cash balance under each plan. Then increase the deposit, check the new funding gap and adjust the planned credit-line draw. The same workbook lets you carry that decision through to cash available for owners and their projected return at exit.
Explore the manufacturing Excel modelWatch the updated walkthrough