Ryan (ryan@themedialab.agency)
2024-10-23 12:54:12

Shield Financial metric definitions and formulas

Ryan Vaspra (https://themedialaboratory.slack.com/team/UJF2W0EB1)
<p>@here, for future reference. I had to review this is gross detail for Marc:</p> <p><strong>Shield Financials Calculations</strong> ```Gross Spend = daily<em>spend + cc</em>cost + agency_fee</p> <p>Gross Revenue = daily_revenue</p> <p>Gross Spend = daily<em>spend + cc</em>cost + agency_fee</p> <p>COGS = daily<em>spend<br /> + cc</em>cost<br /> + agency<em>fee<br /> + mb</em>commission<br /> + sales_commission</p> <p>Total Expense = daily<em>spend -- COGS &amp; gross spend + cc</em>cost -- COGS &amp; gross spend + agency<em>fee -- COGS + mb</em>commission -- COGS + sales<em>commission -- COGS + operation</em>expense </p> <p>Internal Total Expense = i<em>daily</em>spend + i<em>mb</em>commission + i<em>sales</em>commission + i<em>cc</em>cost + i<em>agency</em>fee + i<em>operation</em>expense</p> <p>LOSG Internal Total Expense = i<em>daily</em>revenue + i<em>mb</em>commission + i<em>cc</em>cost + i<em>agency</em>fee</p> <p>Gross Profit = daily<em>revenue - daily</em>spend - cc<em>cost - agency</em>fee</p> <p>Net Profit = daily<em>revenue - daily</em>spend<br /> - cc<em>cost<br /> - agency</em>fee<br /> - mb<em>commission<br /> - sales</em>commission - op_expense</p> <p>Cash Flow = e<em>net</em>profit (Shield) - i<em>total</em>expense (TC)</p> <p>** Internal or i_ means any client with (TC), DL/TC, DLG/TC or Steve Slater or Shield AZ Law in the Customer Name based on the customer_type table```</p>
Slack Conversation