Formulas are a column type that allows tracker users to create calculation formulas using data in existing currency and numeric columns.

 

To create a formula column within a tracker,

  1   In the area you'd like your formula column, hover next to any column head to expose the options menu (3 dots) and choose 'Insert Left' or 'Insert Right' according to preference. The 'Add Column' window opens.

  2   Choose Formula.

  3   Click into the 'Formula Builder' area and build your formula by choosing from available currency and numeric columns shown, and selecting calculator buttons. You may also type directly into the field to add additional formula components. Common formulas and associated formula inputs are displayed below.

  4   Choose 'Format' and the number of decimal places to display.

  5   Click Save. The formula executes and results appear in your new column.

Up to 10 formula columns can be created. Also, when figures are updated in columns used in a formula, the associated formula column updates as well.

Some example calculations include:

• EV/EBITDA Ratio

  • • Compares a company’s Enterprise Value (EV) to its EBITDA. The EV/EBITDA ratio is commonly used as a valuation metric to compare the relative value of different businesses

      • Required columns: EV (Currency); EBITDA (Currency)

      • EV/EBITDA = EV / EBITDA

      • Format: Multiplier

• Gross Profit

  • • Profit generated from core business operations before deducting operating expenses

      • Required columns: Total Revenue(Currency); Cost of Goods Sold (Currency)

      • Gross Profit = Total Revenue − COGS

      • Format: Currency

• ROI

  • • Calculates the return generated relative to the investment made

      • Required columns: Net Profit (Currency); Investment Cost (Currency)

      • ROI = Net Profit / Investment Cost

      • Format: Percent %

• Enterprise Value to Revenue Ratio (EV/R)

  • • Used to evaluate the valuation of a company relative to its revenue

      • Required columns: Enterprise Value (Currency); Revenue (Currency)

      • EV/R = Enterprise Value / Revenue

      • Format: Multiplier

• Price to Earnings (P/E) Ratio

  • • • Compares the company's current share price to its earnings per share

      • Required columns: Share Price (Currency); Earnings per Share (Currency)

      • P/E Ratio = Share Price / Earnings per Share

      • Format: Currency