Six accounts at the start. Forty by month twelve. The sample holds account count at forty for the remaining six months of the master workbook.

Fictional assumptions. Each account buys six household-goods cases and three accessory cases per month. No account loss is assumed.

The second region opens in month seven in the plan. The model combines both regions; it does not calculate a regional split.

Household goods. A case sells for $140. Its assumed landed cost is $71.20: $64 product cost, $3.20 duty, and $4 inbound freight.

Personal accessories. A case sells for $95. Its assumed landed cost is $47: $40 product cost, $4 duty, and $3 inbound freight.

Outbound fulfillment adds $6.50 per case. Duty amounts are fictional category assumptions, not verified tariff rates. Duty is included in landed cost, so the separate product-tax calculation is off.

Fixed operating costs are $5,100 per month. Operator pay adds $2,600 when the account count reaches eighteen, in February 2027.

Setup spend is $5,400 in month one and $1,800 in month seven. Equipment costs $2,400 in month one and depreciates over forty-eight months.

The model uses an assumed 24% effective income-tax rate and no owner distributions. Owner pay of $2,400 per month is included in fixed operating costs.

The unfunded plan runs short of cash in December 2026. Its lowest balance is −$26,162 in May 2027. A negative balance represents an unmet funding requirement.

Year-one net income is $30,677, but cash at year end is −$16,379. Inventory and customer payment timing absorb cash during expansion.

Opening cash is $18,000. Customers pay in thirty-five days, suppliers are paid in twenty days, and the business holds fifty-five days of inventory.

The master continues for eighteen months. With forty accounts held constant after year one, the unfunded projection returns to positive ending cash in October 2027.

Both cases add $35,000 in the first month. The loan still leaves a cash shortfall. Partner capital keeps projected cash positive, with a change in ownership.

Loan. $35,000 at an assumed 9% annual rate, repaid over twenty-four months. Payments are $1,599 per month. Loan fees are excluded.

The loan case reaches a low of −$5,073. The amount and repayment schedule do not cover the expansion as modeled.

Partner. $35,000 for an assumed 18% of the company after the contribution. The existing owners retain 82% combined, or 41% each if diluted equally.

The partner case reaches a low of $8,838. No distributions are assumed during the model period. Governance and exit terms still need agreement.

The master compares $3,128 of loan interest over eighteen months with $27,293 for the partner’s share of projected book equity at month eighteen.

Book equity is not a market valuation or the lifetime cost of ownership. The cash result and the ownership terms need to be considered separately.

The model’s cost label favors debt over its eighteen-month horizon. Its cash projection also shows a shortfall under the loan case.

Before selecting financing, revise the amount, repayment timing, or purchasing sequence and calculate the effect again.

Four projected statements, shown three months at a time. These pages use the unfunded baseline. Negative cash identifies the funding requirement.

The balance sheet, cash flow, and owners’ equity reconcile across the eighteen-month master in each funding case. Figures are rounded to whole dollars here.

Opening assets are $33,900: $18,000 cash, $5,400 receivables, and $10,500 inventory. Opening payables are $3,500, owner contributions are $30,400, and retained earnings are zero.

These are fictional planning projections, not historical results or audited financial statements.