# Financial Model for D2C Business in India Published: 28 Oct 2026 Author: Treelife Practice area: Finance Tags: D2C CAC payback and LTV model, D2C cash flow forecast India, D2C contribution margin model, D2C inventory planning and purchase orders, D2C unit economics India, financial model for D2C business, GST input credit for D2C brands, RTO and COD impact on D2C margins Source: https://treelife.in/finance/financial-model-for-d2c-business-in-india/ --- Blog Content Overview - [0.1 What goes into a financial model for a D2C business?](#What_goes_into_a_financial_model_for_a_D2C_business) - [1 How should revenue be forecast in a D2C financial model?](#How_should_revenue_be_forecast_in_a_D2C_financial_model) [1.1 Should the same SKU carry the same price on every channel?](#Should_the_same_SKU_carry_the_same_price_on_every_channel) - [1.2 Why not forecast D2C revenue as a flat monthly growth rate?](#Why_not_forecast_D2C_revenue_as_a_flat_monthly_growth_rate) - [2 How do you move from order value to net revenue?](#How_do_you_move_from_order_value_to_net_revenue) [2.1 How should the 22/09/2025 GST rate cuts be treated in a D2C model?](#How_should_the_22092025_GST_rate_cuts_be_treated_in_a_D2C_model) - [3 What does the contribution margin stack look like for a D2C brand?](#What_does_the_contribution_margin_stack_look_like_for_a_D2C_brand) [3.1 How do you calculate landed cost per unit?](#How_do_you_calculate_landed_cost_per_unit) - [3.2 How should each variable cost line be modelled?](#How_should_each_variable_cost_line_be_modelled) - [3.3 Why model contribution by SKU and not by brand?](#Why_model_contribution_by_SKU_and_not_by_brand) - [3.4 How should COD and RTO be modelled?](#How_should_COD_and_RTO_be_modelled) - [3.5 Which CAC and payback inputs should the model carry?](#Which_CAC_and_payback_inputs_should_the_model_carry) - [3.6 How do you set a price floor from the cost stack?](#How_do_you_set_a_price_floor_from_the_cost_stack) - [3.7 How much volume can a price rise lose before it hurts?](#How_much_volume_can_a_price_rise_lose_before_it_hurts) - [3.8 How many orders does it take to break even?](#How_many_orders_does_it_take_to_break_even) - [4 How should a financial model for D2C business plan inventory?](#How_should_a_financial_model_for_D2C_business_plan_inventory) [4.1 What does one purchase order look like in numbers?](#What_does_one_purchase_order_look_like_in_numbers) [4.1.1 Need a purchase plan tied to cash before festive stock? Let’s Talk](#Need_a_purchase_plan_tied_to_cash_before_festive_stock_Let8217s_Talk) - [5 Why does D2C cash differ from D2C profit in India?](#Why_does_D2C_cash_differ_from_D2C_profit_in_India) [5.1 What happens to input tax credit after the 22/09/2025 rate cuts?](#What_happens_to_input_tax_credit_after_the_22092025_rate_cuts) - [5.2 How do marketplace and COD remittance timing change the cash line?](#How_do_marketplace_and_COD_remittance_timing_change_the_cash_line) - [5.3 Which balance sheet lines does a D2C model need?](#Which_balance_sheet_lines_does_a_D2C_model_need) - [6 How should a financial model for D2C business handle scenarios and funding?](#How_should_a_financial_model_for_D2C_business_handle_scenarios_and_funding) [6.1 How should inventory be funded, with debt or equity?](#How_should_inventory_be_funded_with_debt_or_equity) - [6.2 How should the model treat income tax for a loss-making D2C brand?](#How_should_the_model_treat_income_tax_for_a_loss-making_D2C_brand) - [7 Common mistakes that cost founders time and money](#Common_mistakes_that_cost_founders_time_and_money) - [8 FAQs on financial model for D2C business](#FAQs_on_financial_model_for_D2C_business) [8.0.0.1 Regulatory references](#Regulatory_references) A financial model for D2C business in India has to do three things a generic startup model skips. It must turn a discounted, GST-inclusive order into net revenue. It must carry every variable cost down to a per-order contribution. And it must show why the bank balance falls in a month the P&L calls profitable. Most templates stop at unit economics. This article builds the model in the order the money moves, with India-specific lines (GST, TCS, TDS, COD remittance, input tax credit) placed where they belong. All worked figures are illustrative. ### What goes into a financial model for a D2C business? A D2C financial model has five linked blocks: a revenue build by channel (traffic, conversion, order value, repeat), a gross-to-net bridge (discounts, GST, returns and RTO), a contribution margin stack (CM1 to CM3), an inventory and purchase plan, and a cash statement that carries GST, TCS and TDS timing. Profit and loss alone cannot show whether the brand can pay for next quarter’s stock. The cash flow statement, built from the balance sheet lines covered below, is the statement that shows a shortfall first. For the generic mechanics of a startup model (tab layout, three-statement logic, cap table, valuation), see Treelife’s guide to [financial modeling for startups](https://treelife.in/finance/financial-modeling-for-startups/). This article covers only what changes when the business sells physical consumer products online in India. ## How should revenue be forecast in a D2C financial model? Build revenue separately for each channel, because each channel has a different driver, a different deduction before cash and a different data source. Own-website revenue runs on traffic, conversion and order value. Marketplace revenue runs on units, price and advertising efficiency. Quick commerce and offline run on store or door count and sell-through. A single blended growth rate hides which channel earns the margin. Start with the channel that carries most of the volume today and add the others only when you have at least three months of data for them. A channel with no history gets a stated assumption, not a borrowed benchmark. **Revenue drivers and data sources by channel** ChannelRevenue driverDeduction before cashWhere to source the inputOwn websiteSessions x conversion rate x average order valueGateway fee, COD handling fee, courier remittance lagStorefront analytics, gateway settlement reportMarketplaceUnits x selling price, driven by ad-led visibilityCommission, fixed and shipping fees, TCS and TDSSeller dashboard payout reportsQuick commerceActive stores x units per store per day x pricePlatform margin, visibility spend, claimsPlatform sales and invoice reportsOffline or distributorDoors x sell-through x price to tradeTrade margin, scheme discounts, credit periodDistributor ledger, secondary sales data A worked build shows how the drivers combine. Own-website orders come from sessions and conversion. Marketplace and quick commerce orders come from seller and platform dashboards. **Illustrative monthly revenue build** ChannelInputsOrdersBilled value per order (₹, GST inclusive)Net sales excluding GST (₹ lakh)Own website2,00,000 sessions x 2.0% conversion4,00085032.4MarketplaceOrders from the seller dashboard2,50080019.0Quick commerceOrders from the platform report1,50078011.1TotalSum of channels8,000Not applicable62.6 Net sales are billed value divided by 1.05 for a SKU at 5% GST. Decide once whether platform commission sits above or below net revenue, and apply the same treatment to every channel, so channel margins stay comparable. ### Should the same SKU carry the same price on every channel? Price each SKU so the channel with the lowest net realisation still clears your CM1 floor. The same product earns a different CM1 in each channel once commission, fees and TCS come off. With an assumed 15% marketplace commission and fee on net sales, a ₹810 net sale loses about ₹121 per order before freight. Where price parity is needed, differentiate by pack size or bundle, not by cutting margin on the weakest channel. ### Why not forecast D2C revenue as a flat monthly growth rate? A flat growth rate ignores that new-customer revenue and repeat revenue behave differently. New-customer revenue depends on acquisition spend and conversion. Repeat revenue depends on the cohort that bought in earlier months and on how many of them reorder. Mixing the two makes the forecast look smooth until a month of lower ad spend exposes how much of the growth was bought. Model repeat revenue from cohorts. These are the inputs to carry: - First-order cohort by month, split by channel and by payment mode - Repeat rate by month since first order, taken from your own order data - Repeat order value and the discount depth used to win it - Acquisition cost for the cohort, so payback can be read per cohort - Share of repeat orders that move to a different channel, such as a marketplace Report repeat purchase rate (customers with a second order divided by customers in the cohort) and retention (customers who order in a later period) as separate measures, and do not mix them. Segment customers by recency, frequency and order value (RFM) to decide how much repeat-order marketing each segment earns. ## How do you move from order value to net revenue? Start with billed value after discount, remove GST to reach net sales, then deduct returns and RTO (return to origin) to reach net revenue. GST is a pass-through, not income, and a discount recorded on the invoice at the time of supply reduces the taxable value (Section 15(3)(a), Central Goods and Services Tax (CGST) Act 2017). A model that starts from MRP or GST-inclusive collections overstates revenue by the tax rate. Discounts need care in one more place, and the rule changes on 01/11/2026. Until 31/10/2026, a discount given after supply reduces taxable value only if it is agreed before or at the time of supply, linked to specific invoices, and the recipient reverses the related input credit (Section 15(3)(b), CGST Act 2017). From 01/11/2026, Section 153 of the Finance Act 2026 (in force under Notification No. 03/2026-Central Tax dated 26/10/2026) drops the agreement and invoice-linkage tests. The supplier must issue a credit note under Section 34, which now expressly covers such discounts, and the recipient must reverse the credit attributable to the discount. This matters for distributor schemes and year-end rebates, less for a consumer checkout coupon that appears on the invoice. **Illustrative gross-to-net bridge for one order shipped** Line₹ per orderAssumptionBasket at MRP, GST inclusive1,000Two units at ₹500 MRPDiscount(150)15% on the basket, shown on the invoiceBilled value, GST inclusive850Amount charged to the customerGST included in billed value(40)5% rate on the SKU, ₹850 / 1.05Net sales, excluding GST810Taxable value of supplyReturns and RTO(81)10% of net sales by value, blendedNet revenue729Base for every margin that follows Carry the HSN code and [GST rate](https://treelife.in/compliance/gst-compliance-for-startups/) on every SKU row, so a rate notification changes one column and not the whole model. ### How should the 22/09/2025 GST rate cuts be treated in a D2C model? Treat the rate cut as a pricing decision, not a free gain. Notification No. 09/2025-Central Tax (Rate), dated 17/09/2025 and effective 22/09/2025, moved hair oil, shampoo, toilet soap and toothpaste from 18% to 5% after the 56th GST Council meeting on 03/09/2025. Section 171 of the CGST Act 2017 requires a rate reduction to be passed on to the recipient through a commensurate price reduction. The arithmetic is why the choice matters. At an MRP of ₹1,000 and 18% GST, net sales per unit are ₹847. At 5%, they are ₹952, a rise of 12.4% if the MRP is held. Model three cases and pick one on purpose: - Cut MRP in full, hold net sales per unit flat, and assume a volume lift you can defend with data - Cut MRP in part, share the benefit between price and margin, and flag the Section 171 exposure - Hold MRP, take the full margin gain, and treat it as an assumption that needs a legal view Personal care and food brands should check the rate on each SKU against the notification, because the 22/09/2025 changes did not move every product in a category. ## What does the contribution margin stack look like for a D2C brand? Contribution margin is net revenue less every cost that rises with each order. Most D2C models show three layers: CM1 after product and fulfilment cost, CM2 after acquisition spend, and CM3 after variable support and platform cost. CM2 is the layer that shows whether the growth engine pays for itself before overheads. **Illustrative contribution margin stack per order shipped (₹)** Layer₹ per order% of net revenueWhat drives itNet revenue729100.0%From the gross-to-net bridgeLanded COGS, including write-off of returned stock21229.0%₹230 landed cost on delivered units, 20% of returned units written offGross margin51771.0%Price less landed costOutbound freight, return freight, packaging, pick and pack10714.7%₹70 freight on every order, return leg on 10%Payment gateway and COD handling223.0%2% gateway fee on 60% prepaid, ₹30 on 40% CODCM138853.2%Contribution before marketingMarketing cost per order shipped26035.7%Blended paid and creator spendCM212817.5%Contribution after acquisitionSupport, tech and platform fees223.0%Variable per orderCM310614.5%Contribution before fixed overheads Every input in this table is an assumption for illustration, not a benchmark. Replace each with your own last-three-month figure before the table goes near an investor. ### How do you calculate landed cost per unit? Landed cost is the supplier price plus every cost of getting the unit into your warehouse, less any tax you can recover as credit. Mixing it up with the supplier price understates COGS and overstates every margin below it. For imported inputs, basic customs duty and the social welfare surcharge sit in landed cost, but IGST paid on import does not, because it is recoverable as input credit (Section 3(7), Customs Tariff Act 1975; Section 16, CGST Act 2017). Duty rates differ by tariff heading and several changed in the Union Budget 2026-27, so take the rate for your heading from the current tariff on the CBIC portal. **Illustrative landed cost per unit (₹)** Component₹ per unitNoteSupplier price90Ex-works price per unitInward freight and insurance8Allocated by weight or valueCustoms duty and surcharge11Assumed rate for illustration, set from your tariff headingClearing and port charges3Allocated per unitShrinkage and damage allowance3From your own stock varianceLanded cost115Two units make the ₹230 basket used above ### How should each variable cost line be modelled? Give every cost line a driver, a formula and a named source, so each can be replaced with actuals one at a time. A line without a driver becomes a percentage of revenue, and percentages hide the mix shifts that move margin. **Driver, formula and source for each variable cost line** LineDriverFormula in the modelSource of the inputLanded COGSUnits deliveredUnits x landed cost per unit, plus write-off on returned unitsSupplier invoices, inward freight and dutyPackagingOrders shippedOrders x packaging cost by pack sizePackaging vendor rate cardOutbound freightOrders by zone and weightOrders x courier rate by weight slabCourier rate card and invoicesReturn freightRTO and return ordersRTO orders x return-leg rateCourier RTO reportsPick and packOrders shippedOrders x per-order fee, or warehouse cost if in-house3PL contract or payrollPayment gatewayPrepaid billed valuePrepaid billed value x fee rate, plus GST on the fee as recoverable creditGateway fee schedule, settlement reportCOD handlingCOD orders deliveredCOD orders x flat feeCourier COD rate cardMarketplace feesMarketplace net salesNet sales x commission slab, plus fixed and shipping feesMarketplace rate card, payout reportSupportOrdersOrders x contact rate x cost per contactSupport vendor invoice or team costPlatform and techOrders or fixedSubscription plus per-order feeStorefront and tool invoices ### Why model contribution by SKU and not by brand? A blended brand margin hides the SKUs that lose money per order. Build the stack at SKU level, then roll it up by channel and brand, so CM2 by SKU shows which products fund growth and which consume stock and cash. Freight, packaging and RTO differ by product weight and price, so a single brand average is wrong for every SKU in the range. ### How should COD and RTO be modelled? Model prepaid and COD orders as two separate order streams, each with its own RTO rate, courier cost, handling fee and cash timing. A blended RTO rate hides the festive quarter, when COD returns rise. The cost of one RTO is forward freight, return freight, packaging, damage, blocked capital and the acquisition spend that bought the lost order. Use your own courier data, not an industry average. For each stream, carry: - Share of orders and average order value - RTO and return rate, by quarter, so the festive spike is visible - Forward and return freight per order - Share of returned stock that can be resold, and the write-off on the rest - Days from delivery to remittance ### Which CAC and payback inputs should the model carry? Carry new-customer CAC and repeat-order marketing as separate lines, and compute lifetime value on contribution margin, not revenue. Blended CAC divides all acquisition spend by all new customers and flatters the brand when repeat orders are strong. Payback is CAC divided by the contribution margin a customer earns each month, and it should be read per cohort, not per brand. Take the stack above. If new-customer CAC is ₹520 and the first order earns ₹388 at CM1, the first order recovers 75% of CAC and payback needs the second order. Set payback and ratio targets from your own cohort data, and use the cohort table below to test them. Calculate CAC from total spend and total new customers, not from [platform dashboards](https://treelife.in/finance/financial-dashboard-services-for-startups/). Return on ad spend measures revenue against ad spend only. It leaves out COGS, freight, payment fees and returns, so a healthy ROAS can sit on top of a negative CM2. A cohort table shows payback honestly. Repeat contribution per order, after ₹80 of repeat-order marketing and ₹22 of support, is ₹286 (₹388 less ₹80 less ₹22). The first order is counted at CM1. **Illustrative 12-month cohort payback per new customer** MonthCumulative repeat orders per 100 customersCumulative contribution per customer (₹)Share of ₹520 CAC recovered0038875%31242281%62245187%93047491%123548894% On these inputs the brand has not recovered CAC by month 12. The model should then show payback beyond a year and a CAC cap by channel, not a growth plan. ### How do you set a price floor from the cost stack? Work backwards from the contribution margin you need. Per-order variable cost divided by one minus the target margin gives the net revenue each order must earn. Then reverse the bridge: gross up for returns, add GST, and gross up for the discount to reach the MRP basket. Using the illustrative stack, variable cost to CM1 is ₹341 (landed COGS ₹212, fulfilment ₹107, payment and COD ₹22). For a 45% CM1 target, net revenue per order must be ₹620 (₹341 / 0.55). Grossing up for 10% returns gives net sales of ₹689, adding 5% GST gives ₹723 billed, and a 15% discount on the invoice puts the MRP basket at ₹851. Hold per-order costs constant when you do this, then re-run the full stack at the new price. ### How much volume can a price rise lose before it hurts? A price rise pays as long as the contribution gained on the orders you keep exceeds the contribution lost on the orders you lose. The volume you can lose before total contribution falls is the price rise divided by CM per order after the rise. On the illustrative stack, a ₹40 rise in net revenue per order lifts CM2 from ₹128 to ₹168, so the brand can lose up to 23.8% of orders (₹40 / ₹168) before total CM2 is lower. Hold cost per order and CAC constant when you run this, then test it against conversion data from a price test. ### How many orders does it take to break even? Break-even orders equal monthly fixed costs divided by CM3 per order. With CM3 of ₹106 and illustrative fixed costs of ₹18 lakh a month, the brand needs about 17,000 shipped orders a month. Fixed costs step up with order volume (support team, warehouse space, [finance function](https://treelife.in/services/virtual-cfo/)), so model them in steps tied to volume and recompute break-even at each step. ## How should a financial model for D2C business plan inventory? Inventory should drive purchases, and purchases should drive cash, not the other way round. Forecast units sold by SKU, add cover days and supplier lead time to find each purchase order date, then price the order at landed cost. For a physical-product brand, stock is usually the largest single use of cash, so the purchase plan matters more than the operating budget. Build the purchase plan in this order: - Forecast units by SKU and month from the channel revenue build - Set cover days by SKU class, with more cover for fast movers and less for the long tail - Add supplier lead time and minimum order quantity (MOQ) to find the order date and size - Convert each purchase order to cash: advance, balance, freight and any import duty - Add the GST input credit on the purchase invoice as an asset, not an expense - Add an ageing and expiry provision for products with a shelf life Use the lead time in your supplier terms: production, freight and clearance days all add up before the first unit is sellable. That puts the cash outflow for a festive-quarter build before the quarter opens. A model that books the purchase when the sale happens understates peak cash need by the full build. Payables to micro and small suppliers carry a 45-day ceiling under Section 15 of the Micro, Small and Medium Enterprises Development (MSMED) Act 2006, which the MSMED (Amendment) Act 2026 (Presidential assent 13/08/2026) leaves in place and which limits how far the model can stretch the payables line. Cash-cycle formulas (DIO, DSO, DPO) and a 13-week cash view are covered in Treelife’s guide to [working capital management for startups](https://treelife.in/finance/working-capital-management-for-startups/). ### What does one purchase order look like in numbers? A purchase order is demand over the lead time, plus safety stock, priced at landed cost and split by payment terms. Illustrative inputs: 4,000 baskets a month (a basket is two units), a 75-day supplier lead time, 15 days of safety stock and ₹230 landed cost per basket. - Daily demand: 133 baskets - Reorder point: 133 x 75 days plus 133 x 15 days of safety stock, so 12,000 baskets - Order size to cover 45 days of sales: 6,000 baskets - Order value at landed cost: ₹13.8 lakh - Cash on 30% advance and 70% on dispatch: ₹4.14 lakh at order, ₹9.66 lakh on dispatch Model the advance and the balance as separate cash lines on separate dates, and add the GST input credit on the purchase invoice as an asset. > #### Need a purchase plan tied to cash before festive stock? [Let’s Talk](javascript:void(0)) [ ](https://calendly.com/consulttreelife/20min?utm_source=blogbannertreelife) ## Why does D2C cash differ from D2C profit in India? Cash differs from profit because items move cash without touching the P&L: GST collected and credited, [TCS and TDS](https://treelife.in/services/tax-and-regulatory/) held back by marketplaces, input tax credit that sits as an asset, courier and gateway settlement lags, and stock bought ahead of sale. A D2C model that stops at CM3 cannot show these, which is why a profitable quarter can still end with a lower bank balance. **India-specific items that move D2C cash but not profit** ItemLaw or ruleCash effectWhere it sits in the modelTCS on marketplace salesSection 52, CGST Act 2017; Notification 15/2024-Central Tax (10/07/2024)0.5% of net taxable value held by the platform, credited to the seller’s electronic cash ledger after the platform files GSTR-8GST cash-ledger asset, used against output taxTDS on marketplace salesSection 194-O, Income-tax Act 1961; Section 393(1), Table Sl. No. 8(v), Income-tax Act 20250.1% held back on gross salesTax asset, recovered against tax or by refundInput credit on goods and servicesSection 16, CGST Act 2017; Section 16(2)(c) upheld by the Supreme Court on 24/07/2026GST paid on purchase invoices returns only against output tax, and only where the supplier has paid the tax to the GovernmentITC balance on the balance sheet, net of vendor-default riskReverse charge on foreign ad invoicesSection 49(4), CGST Act 2017Paid from the cash ledger, credit followsCash outflow first, ITC asset nextCOD remittance and gateway settlementCourier and gateway agreementsCash arrives days after delivery, and RTO orders produce noneReceivable days by payment modeInverted-duty creditSection 54(3), first proviso, clause (ii), and Section 54(6), CGST Act 2017; Rule 89(5), CGST Rules 2017Credit builds when output tax is lower than input tax; 90% provisional refund available for these claims from 01/11/2026ITC balance and refund claim line The 0.5% [TCS rate](https://treelife.in/compliance/tds-and-tcs-compliance-in-india/) applies from 10/07/2024, when it fell from 1% (Notification 15/2024-Central Tax). The 0.1% TDS rate on e-commerce payments applies under Section 194-O, now Section 393(1) of the Income-tax Act 2025, effective 01/04/2026. For a marketplace channel with ₹10 crore of annual net sales, TCS of 0.5% is ₹5 lakh and TDS of 0.1% is ₹1 lakh on the same base (illustrative). That ₹6 lakh is blocked until it is used. A loss-making brand uses the TCS credit against GST, but the TDS credit comes back only as an income tax refund after the return is filed. On a quick commerce channel where the platform buys the goods outright, the platform may deduct TDS on purchase of goods at 0.1% above ₹50 lakh a year (Section 194Q, Income-tax Act 1961; Section 393(1), Table Sl. No. 8(ii), Income-tax Act 2025), subject to the buyer’s turnover threshold. Check which model each platform follows before you pick the line. ### What happens to input tax credit after the 22/09/2025 rate cuts? Where output GST fell to 5% but packaging, freight, agency and advertising inputs still carry 18%, credit builds faster than output tax can absorb it. A refund of inverted-duty credit under Section 54(3), first proviso, clause (ii), read with Rule 89(5), covers inputs, which Section 2(59) defines as goods other than capital goods. Credit on services stays on the balance sheet until output tax absorbs it. From 01/11/2026, Section 54(6) extends the 90% provisional refund to these claims (Section 155, Finance Act 2026; Notification No. 03/2026-Central Tax). The 57th GST Council meeting on 08/10/2026 made no rate change and recommended refunds of tax on input services for credit availed on or after 01/11/2026, but that recommendation is not law until it is notified, so do not model it yet. Here is the monthly arithmetic for a brand with ₹2 crore of net taxable sales (illustrative): - Output GST at 5% on ₹2 crore: ₹10 lakh - Input credit on ₹50 lakh of services (advertising, freight, agency) at 18%: ₹9 lakh - Input credit on ₹30 lakh of packaging and goods inputs at 18%: ₹5.4 lakh - Credit available: ₹14.4 lakh, so ₹4.4 lakh builds up each month Freight inputs need the current rates. Courier services carry 18% GST with input credit, and goods transport agencies charge either 5% without credit or 18% with credit (rates after 22/09/2025). The 57th GST Council on 08/10/2026 recommended 5% without credit on e-commerce delivery services. The scope and date await notification, so model the current rates until then. Credit also depends on the supplier having paid the tax to the Government (Section 16(2)(c), CGST Act 2017, upheld by the Supreme Court in Bhandari Scrap Traders v Union of India on 24/07/2026), so match every credit to GSTR-2B and track vendor default as a risk on the balance. A model that shows GST as cash-neutral overstates the cash position by the unabsorbed credit. Carry an ITC balance line, decide how much of it is refundable as goods credit, and treat the services portion as stuck. ### How do marketplace and COD remittance timing change the cash line? Take the settlement lag from your last three payout reports, not from a platform’s published promise. Marketplace payouts arrive net of commission, fees, TCS and TDS, so the payout never equals sales. COD cash arrives after the courier remits it, and an RTO order produces no cash at all while it still consumed freight and packaging. For each channel, set up the receivable as days of sales and read it by payment mode: - Marketplace: days from delivery to payout, less commission, fees, TCS and TDS - Prepaid own website: gateway settlement days, less the gateway fee - COD own website: courier remittance days, less the COD handling fee - Distributor: credit period agreed, less scheme discounts The 57th GST Council also recommended a registration option for small sellers using an e-commerce operator’s warehouse in another State. It is a recommendation awaiting notification, so keep any extra registration cost in the model until it takes effect. A channel-weighted receivable shows what the cash cycle costs. Illustrative inputs: 40% of sales prepaid on the own website settling in 3 days, 20% COD remitted in 12 days, 40% marketplace paid out in 10 days. That is a weighted receivable of 7.6 days. With 60 days of inventory and 30 days of supplier credit, the [cash conversion cycle](https://treelife.in/finance/cash-flow-optimization/) is 37.6 days. On ₹2 crore of monthly net revenue with landed cost at 29% of it, inventory ties up ₹116 lakh, receivables ₹50.7 lakh and payables fund ₹58 lakh, so net working capital is ₹108.7 lakh. Replace every day count with the lag in your last three payout reports. ### Which balance sheet lines does a D2C model need? A D2C balance sheet needs lines that generic templates omit: tax credits, platform receivables and supplier advances. Each line is created by one event and released by another, and the model should carry both dates. **D2C balance sheet lines and what moves them** LineCreated byReleased byInventory by SKU classPurchase orders receivedCOGS on delivery, write-off or clearanceSupplier advancesAdvance paid on a purchase orderGoods receivedITC balanceGST on purchase and service invoicesSet-off against output tax or refund claimTCS creditPlatform files GSTR-8Set-off against GST payableTDS receivablePlatform deducts under Section 194-OAdjusted against income tax or refundedMarketplace receivableDelivered orders not yet paid outPlatform payoutGateway and COD receivableDelivered orders held by gateway or courierSettlement or remittanceGST payableOutput tax on net salesPayment through the returnRefunds payableApproved returns not yet refundedRefund to the customer ## How should a financial model for D2C business handle scenarios and funding? Run five stress tests on the inputs that move D2C cash fastest: acquisition cost, conversion, RTO, festive demand and supplier price. Attach a trigger and an action to each, so the model tells you when to cut spend or raise capital. Build a no-raise case too, because a model that only works with funding is a pitch, not a plan. The illustrative stack shows how far each lever moves CM2 per order shipped. Each row changes one input and holds the rest. **Illustrative CM2 sensitivity per order shipped** ChangeCM2 (₹)CM2 as % of net revenueChange against base (₹)Base case12817.5%0Outbound freight up 15%11616.0%(12)Landed COGS up 10%10714.6%(21)Returns and RTO at 15%9313.5%(35)Discount at 20% instead of 15%8612.5%(42)New-customer CAC up 20%7610.4%(52)Discount at 30% instead of 15%10.2%(127)COGS up 10%, returns at 15%, CAC up 20% together213.0%(107) Discount depth is the largest single lever here. Moving from 15% to 30% off removes nearly all of CM2, because the cost of acquiring, packing and shipping the order does not fall with the price. Stacked stresses leave CM2 close to zero, which is the case the no-raise plan has to survive. **Stress tests for a D2C financial model** StressInput to moveFirst line affectedTrigger actionCAC inflationNew-customer CAC up 20%CM2 and payback monthsCap spend by channel until payback returns inside targetConversion dropSite conversion down 15%Revenue and CACPause top-of-funnel spend and fix landing pagesRTO spikeCOD RTO up 5 percentage pointsCM1 and inventory daysShift COD mix to prepaid and tighten address checksFestive demand missUnits 25% below planInventory days and cashHold the next purchase order and run clearanceSupplier price riseLanded cost up 10%Gross marginReprice or re-source before the next order The magnitudes above are illustrations. Set each one from the worst quarter in your own data. Run the model as a base, an upside and a downside case, and give CAC a monthly curve in place of a flat input, so a costly quarter shows up as a cash dip and not as an average. Decide in advance how a gap would be funded: equity, venture debt or working capital borrowing. Treelife’s guide to [venture debt versus equity](https://treelife.in/finance/venture-debt-vs-equity-funding/) covers the trade-offs, and the stress-test triggers above tell you when the decision falls due. ### How should inventory be funded, with debt or equity? Match the funding to the asset. Inventory and receivables turn into cash inside the cash cycle, so they suit borrowing that is repaid from that cash. A negative CM2 never turns into cash, so it needs equity. Months of cash under the no-raise case equal the cash balance divided by monthly net cash burn, and the raise should start when that number equals the time a round takes to close plus a buffer you set. For how long cash lasts under each case and what stage-wise runway targets look like, see Treelife’s guide to [burn rate and runway calculation](https://treelife.in/finance/burn-rate-runway-calculation-for-startups-in-india/). For how investors read the output, see the [Series A fundraising playbook](https://treelife.in/startups/the-series-a-fundraising-playbook/) and the [investor data room guide for D2C brands](https://treelife.in/startups/investor-data-room-for-d2c-brand/). Read the model out every month with the same ten lines: - CM1, CM2 and CM3 by channel - RTO and return rate by payment mode - CAC payback by cohort - Repeat rate by cohort - Inventory days by SKU class - Cash against forecast - ITC balance - TCS credit balance - TDS receivable - Months of cash under the no-raise case ### How should the model treat income tax for a loss-making D2C brand? Carry the tax line at zero until accumulated losses are used. A domestic company that opts for the concessional regime under Section 200 of the Income-tax Act 2025 (Section 115BAA of the Income-tax Act 1961 until 31/03/2026) pays 22% plus 10% surcharge and 4% cess, an effective 25.17%, and is outside minimum alternate tax (Income Tax Department, tax rates and computation reckoner). Business losses of tax years before 01/04/2026 carry forward for up to eight years from the loss year (Section 72(3), Income-tax Act 1961), and continue under the 2025 Act through the savings clause in Section 536 (Income Tax Department FAQs on set off and carry forward of losses). Under the concessional regime, losses attributable to specified deductions cannot be set off, so a brand that claimed those deductions earlier should check which part of its loss pool is usable before it models a tax shield. ## Common mistakes that cost founders time and money Five errors account for most of the D2C models we are asked to correct. Each one makes the brand look healthier than it is, and each one is found by an investor before it is found by the founder. - **Calculating lifetime value on revenue.** Dashboards show revenue per customer, so the ratio looks strong. A ratio that looks healthy on revenue can fall below 1:1 once COGS, freight, payment fees and returns come out (illustrative). Compute lifetime value on contribution margin, after RTO losses. - **Starting revenue at GST-inclusive collections.** The bank deposit includes tax that belongs to the government. Start from billed value, remove GST at the SKU rate and model the rate by HSN code, so the 22/09/2025 changes and any future notification flow through one column. - **Using one blended RTO and COD rate.** A single rate averages away the festive spike. Model prepaid and COD streams separately, by quarter, and read CM1 for each. - **Forecasting revenue but not purchase orders.** Revenue growth without a purchase plan hides the cash that stock absorbs. Build the plan from SKU forecasts, lead time and MOQ, and test the build against the cash balance before approving it. - **Leaving TCS, TDS and credit balances out of the cash line.** On the ₹10 crore marketplace example above, about ₹6 lakh a year is blocked (illustrative). Add an [ITC balance](https://treelife.in/finance/what-your-gst-returns-reveal-that-your-pl-hides/), a TCS credit line and a TDS receivable, and reconcile them to your GST account every month. ## FAQs on financial model for D2C business **Q: How is the tax line modelled for a loss-making D2C company?** **A:** At zero until losses are used. Business losses of tax years before 01/04/2026 carry forward for up to eight years (Section 72(3), Income-tax Act 1961) and continue under the 2025 Act through Section 536. After that, a company under Section 200 of the Income-tax Act 2025 pays 22% plus surcharge and cess, an effective 25.17%. **Q: How should the model treat TCS and TDS on marketplace sales?** **A:** As credits that block cash, not as costs. TCS is 0.5% of net taxable value (Section 52, CGST Act 2017) and TDS is 0.1% (Section 194-O, now Section 393(1) of the Income-tax Act 2025). Show each as an asset and reconcile it monthly. **Q: What does a D2C financial model cost?** **A:** There is no single price, because scope depends on the number of channels, SKUs and months of usable data. Book a call to scope it against your channel mix and your existing MIS. **Q: How long does it take to build a D2C financial model?** **A:** It depends mainly on how clean the history is. Reconciling payout reports to the books is the longest step, and the model should not start until that is done. A brand with monthly MIS and channel payout reports on hand starts sooner than one that has to rebuild them. **Q: What data is needed to build the model?** **A:** Twelve months of order-level data, an SKU master with landed cost, HSN code and GST rate, marketplace payout reports, ad spend by channel, supplier terms and MOQs, monthly MIS and GST returns (GSTR-1 and GSTR-3B). Missing items become flagged assumptions, not borrowed benchmarks. **Q: How do cross-border D2C sales change the model?** **A:** Exports are zero-rated (Section 16, Integrated Goods and Services Tax (IGST) Act 2017), so output GST is nil and unused input credit can be claimed as refund under Section 54(3) of the CGST Act. The Union Budget 2026-27 announced removal of the ₹10 lakh cap on courier exports, which widens the route for small export parcels. Add foreign-currency gateway fees, export freight and realisation timing. Confirm the current realisation period with your authorised dealer bank under the Foreign Exchange Management Act (FEMA) 1999 framework. **Q: How should founder salaries and related-party purchases appear in the model?** **A:** At market-level cost. A founder salary set at zero overstates profit, and goods bought from a founder-owned entity need arm’s length pricing. Related-party transactions can also need board or shareholder approval under Section 188 of the Companies Act 2013. **Q: Does DPIIT recognition change the model?** **A:** Not in the base case. A profit-linked deduction for certified startups needs certification and applies only to profits, so a loss-making brand gets no cash benefit yet. Model it as upside, and check eligibility on the [Startup India](https://www.startupindia.gov.in) portal. **Q: What if the funding round does not close?** **A:** The model should already contain a no-raise case. It shows the month cash falls below your minimum balance, which spend lines are cut first and which purchase orders are held. Link the case to the triggers in the stress-test table, so the response is decided before it is needed. **Q: Which outputs should a D2C model be able to defend line by line?** **A:** CM2 after RTO and returns, cohort repeat curves, CAC payback by channel and inventory ageing. Each can be checked against payout reports and GST returns. Treelife’s guide to financial model validation before a data room covers the review steps. **Q: Does ESOP cost belong in the D2C model?** **A:** Yes, as a non-cash employee cost spread over vesting, where the accounting framework requires it (Ind AS 102 for companies under Ind AS). It changes reported profit and dilution, not cash. Keep it out of the cash statement and in the cap table. **Q: How do you model a brand that also sells through distributors?** **A:** As a separate channel with its own trade margin, scheme discounts and credit period. From 01/11/2026, a post-supply scheme reduces taxable value where the supplier issues a credit note under Section 34 and the recipient reverses the related credit (Section 15(3)(b), CGST Act 2017, as substituted). Model the receivable days from the distributor ledger, not the agreed terms. **Q: Can a brand that has not launched build this model?** **A:** Yes. Use supplier quotes, courier rate cards and the gateway fee schedule in place of history, and mark every input as an assumption. Opening cash need is the first purchase order cash, launch marketing, fixed costs until CM2 turns positive, the GST credit float and a buffer. Replace the assumptions with actuals after the first full month of orders, starting with RTO and CAC. **Q: When does a D2C brand need a virtual CFO for the model?** **A:** When the model must be reconciled to payout reports and GST returns every month, and nobody in the team owns that work. Treelife’s guide to [virtual CFO versus full-time CFO](https://treelife.in/finance/virtual-cfo-vs-full-time-cfo/) sets out how the two roles differ. **Q: How often should the model be updated?** **A:** Monthly, after the books close and the settlement reconciliation is done. Replace the forecast months with actuals, re-read CM2 and the inventory plan, and roll the horizon forward. For budget and variance cadence, see Treelife’s guide to [budget forecasting for startups](https://treelife.in/finance/budget-forecasting-services-for-startups/). --- ##### **Regulatory references** - Central Goods and Services Tax Act 2017: Section 2(59) (inputs), Section 15(3)(a) and (b) (value of supply and discounts, as substituted from 01/11/2026), Section 16 and Section 16(2)(c) (input tax credit), Section 34(1) (credit notes), Section 49(4) (utilisation of credit), Section 52 (TCS by e-commerce operators), Section 54(3) first proviso clause (ii) and Section 54(6) (inverted-duty refund and 90% provisional refund), Section 171 (anti-profiteering) - Central Goods and Services Tax Rules 2017: Rule 67 (GSTR-8), Rule 89(5) (refund formula) - Integrated Goods and Services Tax Act 2017: Section 16 (zero-rated supply) - Notification No. 15/2024-Central Tax dated 10/07/2024: TCS rate reduced to 0.5% - Notification No. 09/2025-Central Tax (Rate) dated 17/09/2025, effective 22/09/2025: GST rate rationalisation, 56th GST Council meeting on 03/09/2025 - Income-tax Act 1961: Section 72(3), Section 115BAA (until 31/03/2026), Section 194-O, Section 194Q ### Related posts: - [What Is An Income Statement?](https://treelife.in/finance/what-is-an-income-statement/) - [The Rise & Fall Of Indian IPO’s](https://treelife.in/finance/the-rise-fall-of-indian-ipo/) - [Tyke’s CSOPs: Bridging Startups with Investors or Crossing Regulatory Boundaries?](https://treelife.in/finance/tykes-csops-bridging-startups-with-investors-or-crossing-regulatory-boundaries/) - [Revised Valuation Rules for Angel Tax](https://treelife.in/finance/revised-valuation-rules-for-angel-tax/) --- This is informational content from Treelife. For advice specific to your situation, contact support@treelife.in