Spreadsheet: 738632d1625157657-unable-to-find-the-circular-reference-problem-circular-reference-issue-1-july
Sheet: CASHFLOW monthly

 | - CASHFLOW FORECAST
 |  |  | 2021-10-01 00:00:00 | DTC Launch Date
 |  |  |  | <--------------------------------- PRE-LAUNCH-----------------------------> |  |  |  |  |  |  |  |  | <-----------------------------------YEAR 1 FORECAST -------------------------------> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-----------------------------------YEAR 2 FORECAST -------------------------------> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <----------------------------------- YEAR 3 FORECAST ------------------------------->
 |  |  |  |  |  |  |  |  |  |  | TOTAL Pre-Launch |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | 12 months |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | 12 months |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | 12 months
 |  |  | Pre April 21 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  |  | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | Year 2 |  |  |  |  | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | Year 3
NUMBER OF PRODUCT SKUs ON SALE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Sales
NUMBER OF UNITS SOLD
 | - DTC e Commerce
 | - DTC Staff / Friends & Family
 | - Wholesale
 | Total Units
OPENING CASH BALANCE |  |  | 0
CASH INFLOWS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Cash Inflow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Cash Inflow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Cash Inflow
 | DTC Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DTC sales & Postage are paid immediately on Sale
 | DTC PAID Postage Revenues |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DTC Postage Paid immediately on Sale
 | Staff (Friends & Family) Discounted Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid immediately on sale (assuming they buy using a COUPON via DTC website)
 | Wholesale Receivables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes 60 Days Recievable
 | [NAME] Cost Reimbursed
 | VAT Received on Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT incurred when received only (when paid)
 | CASH INFLOWS FROM SALES
OPERATIONAL CASH OUTFLOWS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Costs
 | DTC Cost of Sales (Excl Inventory Costs shown below) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month incurred
 | WHOLESALE Cost of Sales (Excl Inv. Costs see below) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month incurred
 | Sales & Marketing Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month incurred
 | Overhead Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month incurred
 | Kelsey PAYE Staff Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month of payroll even though the PAYE element may be deferred a month
 | R&D (NPD) Expenditure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumes paid in month incurred
 | VAT Payable on Opex Expenses (Excl Staff)
 | TOTAL OPEX CASH OUTFLOWS
INVESTING ACTIVITIES
 | Start-Up Investment / Asset Acquisitions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source: Start-Up & NPD Sheet.  This is the Start-Up Cost sub total only.  NPD is shown as an R&D expenses in Opex Costs above.
 | Inventory Purchases
 | - Full Size SKU Orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source: Working Capital sheet. Assumes paid when ORDERED which is 3 months before needed.
 | - Samples (Sachets) Orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source: Working Capital sheet. Assumes paid when ORDERED which is 3 months before needed.
 | - Nitrile Bulbs (200,000) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source: Working Capital sheet. Assumes paid when ORDERED which is 3 months before needed.
 | - PremiSpa [NAME]
 | -Raspberry Essence Exclusivity Fee
 | - DTC Shipping Boxes & Tissue Etc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source: Working Capital sheet. Assumes paid when ORDERED which is 3 months before needed.
 | Total Stock Purchases
 | VAT Payable on Investing Activities |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO CHECK whether VAT is going to be payable on ALL of the Stock purchases and whether Kelsey can reclaim it all?
 | INVESTING CASH OUTFLOWS
TAX CASHFLOWS
 | Corporation Tax
 | R&D Tax (Refunds) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > [NAME] to get from Tax Accountant.  [NAME] the number here manually once estimated in the months they are estimated to be received. NOTE insert a NEGATIVE number for a Tax Refund.
 | Quarterly VAT (Refund) / Payment
 | TAXES PAYABLE / (REFUND)
 | NET CASHFLOW B/F FINANCING
FINANCING ACTIVITIES
 | Net Interest
 | New Equity Capital |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > This just assumes Equity is invested where the Monthly Net Cashflow is NEGATIVE.
 | CASHFLOW FROM FINANCING ACTIVITIES
 | NET MONTHLY CASHFLOWS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > Net cashflow for the Month. Positive balance carries forward into Opening Cashflow on top.  Should be ZERO or Positive.
 | - Accumulated Cashflow
VAT RECONCILIATION
UK VAT Rate |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1.2 | 0.2 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  | TO CHECK: this assumes UK VAT on ALL expenses but some stock coming from EU?
VAT RECONCILIATION
 | Opening VAT Account Balance |  |  |  |  |  |  |  |  |  | 0
 | ADD: VAT Receipts from Sales
 | LESS: [NAME] on Purchases
 | VAT (Refund Due) / Payable to HMRC
 | Timing of VAT (Refund) / Payment (1 month lag) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > Assumes QUARTERLY Vat Refunds, first refund the month before the business goes live.
 | [NAME]
EQUITY ACCOUNT
 | Opening Balance |  | 0 |  |  |  |  |  |  |  | 0
 | ADD: New Equity
 | LESS: Equity Redemptions
 | Closing Balance