Cost/ Revenue calculator

SA - State Agent

S.No Details Cost Revenue
O
SA account fee per month
  • PSP via CA's - +
    P
    CA subscribers in SA's group
    J
    PSP subscribers in CA's group
    A
    PSP account fee per month
    K
    Group account revenue
    Q
    Group account revenue share %
    B
    Total number of deals (PSP) per month
    E
    Transactions per deal
    F
    Cost per transaction per transaction
    M
    Group transactions revenue
    R
    Group transaction revenue share %
  • Direct PSP account holders - +
    S
    PSP subscribers in SA's group
    T
    PSP account fee per month
    U
    SA Group account revenue
    V
    SA Group account revenue share %
    W
    Total number of deals (PSP) per month
    X
    Transactions per deal
    Y
    Total transactions per annum
    Z
    Cost per transaction per transaction
    AA
    Group transactions revenue
    AB
    Group transaction revenue share %
  • Direct deals - +
    AC
    Total number of deals (SA) per month
    AD
    Rate per deal
    AE
    Total revenue for deals (SA) per annum
    AF
    Transactions (SA) per deal
    AG
    Cost per transaction per transaction
    AH
    Transaction revenue (SA)
    AI
    Transaction revenue share (SA) %
  • Interest on funds - +
    AJ
    Average deposit amount per deal
    AK
    Average deposit term (months)
    AL
    Interest rate %
    AM
    Interest on funds revenue 20%
Sub-total (per annum)
SANP Net position
SA
Re-sale potential times revenue (TR)
  • Months = M12
  • Time revenue = TR
  • O. SA account fee = O * M12
  • K. Group account revenue = P * A * M12 * J
  • Q. Group account revenue share = K * Q
  • M. Group transactions revenue = B * M12 * E * F * J * P
  • R. Group transaction revenue share = M * R
  • U. SA Group account revenue = T * M12 * S
  • V. SA Group account revenue share = V * U
  • Y. Total transactions = W * M12 * X
  • AA. Group transactions revenue = Y * Z * S
  • AB. Group transaction revenue share = AA * AB
  • AE. Total revenue for deals (SA) = AC * M12 * AD
  • AH. Transactions revenue (SA) = AF * AC * M12 * AG
  • AI.Transactions revenue (SA) = AF * AC * M12 * AG * (100% - AI)
  • TR. Total deal = (B * J * M12 * P) + (W * M12 * S) + (AC * M12)
  • AM. Interest on funds revenue = TR * AJ * AL / M12 * AK * AM
  • SANP. Net position = Revenue Sub-total (per annum) - Cost Sub-total (per annum)
  • SA Re-sale potential = SANP * TR