Lorentum: Let me give you a tidy spreadsheet layout so the viral post’s impact is crystal clear. 1. **Inputs** - Date of post - Platform (Instagram, TikTok, etc.) - Total impressions - Click‑through rate (CTR) - Conversion rate to purchase - Average order value (AOV) - Cost per click (CPC) 2. **Revenue calculations** - Clicks = Impressions × CTR - Orders = Clicks × Conversion rate - Gross revenue = Orders × AOV 3. **Cost calculations** - Advertising cost = Clicks × CPC - Production cost of the content (fixed) - Variable cost per order (shipping, packaging) - Total cost = Advertising + Production + Variable 4. **Profitability** - Gross profit = Gross revenue – Total cost - Operating expenses (fixed overhead allocated to the post) - EBITDA = Gross profit – Operating expenses - Depreciation (if any) - Net income = EBITDA – Depreciation – Taxes 5. **Balance sheet effects** - **Assets** - Cash outflow for advertising appears as a reduction in cash. - Accounts receivable increases by the amount of sales not yet collected. - Brand equity (intangible asset) may be recorded if a formal valuation is done. - **Liabilities** - If advertising is paid on credit, accounts payable rises. - Future obligations for shipping or returns are noted in contingent liabilities. - **Equity** - Net income feeds into retained earnings, enhancing shareholders’ equity. 6. **Ratios for quick sanity checks** - Return on Ad Spend (ROAS) = Gross revenue ÷ Advertising cost - Gross margin = Gross profit ÷ Gross revenue - Current ratio after the campaign = Current assets ÷ Current liabilities Just plug in your numbers and the spreadsheet will spit out the exact numbers for each line. The glam can stay on point while the ledger stays immaculate.

Impressions: 1,000,000 CTR: 0.5 % → 5,000 clicks Conversion rate: 2 % → 100 orders Average order value: $50 → Gross revenue: $5,000 CPC: $0.50 → Advertising cost: $2,500 Production cost (fixed): $200 Variable cost per order (shipping): $5 × 100 = $500 Total cost: $2,500 + $200 + $500 = $3,200 Gross profit: $5,000 – $3,200 = $1,800 Operating expenses: $400 → EBITDA: $1,800 – $400 = $1,400 Depreciation: $100 → Net income: $1,400 – $100 = $1,300 Balance sheet impact: - Cash decreases by $2,700 (ad + production) - Accounts receivable increases by $5,000 (sales not yet collected) - Equity (retained earnings) increases by $1,300 - Current ratio improves slightly because the new receivable boosts current assets.

Solid, yes. Keep the variance low, track each impression cost precisely, and your next post will have the same tidy profit margin. The balance sheet will keep its shine, and the style will stay sharp.