The finance developer workbenchSearch the reference Development · 0.1.4 · unpublished

valuation / wire operation

Value a company from its statements

totalfinance.valuation.company

Project the three statements from explicit drivers, take the free cash flows the valuation basis needs, and discount them under the stated conventions (basis, date, currency, the REQUIRED discount rate, compounding, day count, the terminal value method, the enterprise-to-equity bridge). The result is discountedCashFlowFromStatements(...) verbatim — the projection with its balance-sheet reconciliation, the cash flows used, and the valuation — plus discountedCashFlowSensitivityTable(...) over the same flows when a sensitivity request is supplied. Opt-in (valuationPack).

Pack / profilesvaluation / full, valuation
Default discoveryOpt-in
Required capabilitiesNone
Effects / authorizationnone / none
Cost / cancellationmedium / Do not assume inline interruption
Handle-eligible inputsNone
Idempotencynot-applicable
Input schema
{
  "type": "object",
  "properties": {
    "projection": {
      "type": "object",
      "properties": {
        "baseStatements": {
          "type": "object",
          "properties": {
            "income": {
              "type": "object",
              "properties": {
                "period": {
                  "type": "object",
                  "properties": {
                    "periodStartDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "periodEndDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "fiscalYear": {
                      "type": "integer"
                    },
                    "fiscalQuarter": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 2,
                          "type": "number"
                        },
                        {
                          "const": 3,
                          "type": "number"
                        },
                        {
                          "const": 4,
                          "type": "number"
                        }
                      ]
                    },
                    "periodType": {
                      "type": "string",
                      "enum": [
                        "quarter",
                        "year",
                        "trailing-twelve-months"
                      ]
                    },
                    "filedTimestampMs": {
                      "type": "number"
                    },
                    "availableTimestampMs": {
                      "type": "number"
                    },
                    "currency": {
                      "type": "string",
                      "minLength": 1
                    },
                    "monetaryScale": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 1000,
                          "type": "number"
                        },
                        {
                          "const": 1000000,
                          "type": "number"
                        }
                      ]
                    },
                    "form": {
                      "type": "string"
                    }
                  },
                  "additionalProperties": false,
                  "required": [
                    "periodEndDate",
                    "fiscalYear",
                    "periodType",
                    "availableTimestampMs",
                    "currency",
                    "monetaryScale"
                  ]
                },
                "revenue": {
                  "type": "number"
                },
                "costOfRevenue": {
                  "type": "number"
                },
                "grossProfit": {
                  "type": "number"
                },
                "operatingExpenses": {
                  "type": "number"
                },
                "operatingIncome": {
                  "type": "number"
                },
                "interestExpense": {
                  "type": "number"
                },
                "incomeTaxExpense": {
                  "type": "number"
                },
                "netIncome": {
                  "type": "number"
                },
                "incomeFromContinuingOperations": {
                  "type": "number"
                },
                "sellingGeneralAdministrativeExpense": {
                  "type": "number"
                },
                "dilutedSharesOutstanding": {
                  "type": "number"
                },
                "metadata": {
                  "type": "object",
                  "additionalProperties": {}
                }
              },
              "additionalProperties": false,
              "required": [
                "period",
                "revenue",
                "operatingIncome",
                "netIncome"
              ]
            },
            "balance": {
              "type": "object",
              "properties": {
                "period": {
                  "type": "object",
                  "properties": {
                    "periodStartDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "periodEndDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "fiscalYear": {
                      "type": "integer"
                    },
                    "fiscalQuarter": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 2,
                          "type": "number"
                        },
                        {
                          "const": 3,
                          "type": "number"
                        },
                        {
                          "const": 4,
                          "type": "number"
                        }
                      ]
                    },
                    "periodType": {
                      "type": "string",
                      "enum": [
                        "quarter",
                        "year",
                        "trailing-twelve-months"
                      ]
                    },
                    "filedTimestampMs": {
                      "type": "number"
                    },
                    "availableTimestampMs": {
                      "type": "number"
                    },
                    "currency": {
                      "type": "string",
                      "minLength": 1
                    },
                    "monetaryScale": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 1000,
                          "type": "number"
                        },
                        {
                          "const": 1000000,
                          "type": "number"
                        }
                      ]
                    },
                    "form": {
                      "type": "string"
                    }
                  },
                  "additionalProperties": false,
                  "required": [
                    "periodEndDate",
                    "fiscalYear",
                    "periodType",
                    "availableTimestampMs",
                    "currency",
                    "monetaryScale"
                  ]
                },
                "cashAndCashEquivalents": {
                  "type": "number"
                },
                "shortTermInvestments": {
                  "type": "number"
                },
                "accountsReceivable": {
                  "type": "number"
                },
                "inventory": {
                  "type": "number"
                },
                "currentAssets": {
                  "type": "number"
                },
                "propertyPlantEquipmentNet": {
                  "type": "number"
                },
                "otherAssets": {
                  "type": "number"
                },
                "totalAssets": {
                  "type": "number"
                },
                "currentLiabilities": {
                  "type": "number"
                },
                "accountsPayable": {
                  "type": "number"
                },
                "shortTermDebt": {
                  "type": "number"
                },
                "longTermDebt": {
                  "type": "number"
                },
                "otherLiabilities": {
                  "type": "number"
                },
                "totalDebt": {
                  "type": "number"
                },
                "totalLiabilities": {
                  "type": "number"
                },
                "preferredEquity": {
                  "type": "number"
                },
                "minorityInterest": {
                  "type": "number"
                },
                "totalEquity": {
                  "type": "number"
                },
                "metadata": {
                  "type": "object",
                  "additionalProperties": {}
                }
              },
              "additionalProperties": false,
              "required": [
                "period",
                "cashAndCashEquivalents",
                "totalAssets",
                "totalLiabilities",
                "totalEquity"
              ]
            },
            "cashFlow": {
              "type": "object",
              "properties": {
                "period": {
                  "type": "object",
                  "properties": {
                    "periodStartDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "periodEndDate": {
                      "type": "string",
                      "format": "date"
                    },
                    "fiscalYear": {
                      "type": "integer"
                    },
                    "fiscalQuarter": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 2,
                          "type": "number"
                        },
                        {
                          "const": 3,
                          "type": "number"
                        },
                        {
                          "const": 4,
                          "type": "number"
                        }
                      ]
                    },
                    "periodType": {
                      "type": "string",
                      "enum": [
                        "quarter",
                        "year",
                        "trailing-twelve-months"
                      ]
                    },
                    "filedTimestampMs": {
                      "type": "number"
                    },
                    "availableTimestampMs": {
                      "type": "number"
                    },
                    "currency": {
                      "type": "string",
                      "minLength": 1
                    },
                    "monetaryScale": {
                      "anyOf": [
                        {
                          "const": 1,
                          "type": "number"
                        },
                        {
                          "const": 1000,
                          "type": "number"
                        },
                        {
                          "const": 1000000,
                          "type": "number"
                        }
                      ]
                    },
                    "form": {
                      "type": "string"
                    }
                  },
                  "additionalProperties": false,
                  "required": [
                    "periodEndDate",
                    "fiscalYear",
                    "periodType",
                    "availableTimestampMs",
                    "currency",
                    "monetaryScale"
                  ]
                },
                "operatingCashFlow": {
                  "type": "number"
                },
                "investingCashFlow": {
                  "type": "number"
                },
                "financingCashFlow": {
                  "type": "number"
                },
                "capitalExpenditure": {
                  "type": "number"
                },
                "depreciationAndAmortization": {
                  "type": "number"
                },
                "stockBasedCompensation": {
                  "type": "number"
                },
                "acquisitions": {
                  "type": "number"
                },
                "dividendsPaid": {
                  "type": "number"
                },
                "shareRepurchases": {
                  "type": "number"
                },
                "increaseInNetWorkingCapital": {
                  "type": "number"
                },
                "netChangeInCash": {
                  "type": "number"
                },
                "metadata": {
                  "type": "object",
                  "additionalProperties": {}
                }
              },
              "additionalProperties": false,
              "required": [
                "period",
                "operatingCashFlow",
                "investingCashFlow",
                "financingCashFlow"
              ]
            }
          },
          "additionalProperties": false,
          "required": [
            "income",
            "balance",
            "cashFlow"
          ],
          "description": "The typed historical base (one period of the three statements) the projection rolls forward"
        },
        "periods": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "periodLabel": {
                "type": "string",
                "minLength": 1
              },
              "revenue": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "growthRate": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "growthRate"
                    ]
                  }
                ]
              },
              "operatingMargin": {
                "type": "number"
              },
              "taxRate": {
                "type": "number"
              },
              "interestExpense": {
                "type": "number"
              },
              "depreciationAndAmortization": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "fractionOfRevenue": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "fractionOfRevenue"
                    ]
                  }
                ]
              },
              "capitalExpenditure": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "fractionOfRevenue": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "fractionOfRevenue"
                    ]
                  }
                ]
              },
              "accountsReceivable": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "fractionOfRevenue": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "fractionOfRevenue"
                    ]
                  }
                ]
              },
              "inventory": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "fractionOfRevenue": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "fractionOfRevenue"
                    ]
                  }
                ]
              },
              "accountsPayable": {
                "anyOf": [
                  {
                    "type": "object",
                    "properties": {
                      "amount": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "amount"
                    ]
                  },
                  {
                    "type": "object",
                    "properties": {
                      "fractionOfRevenue": {
                        "type": "number"
                      }
                    },
                    "additionalProperties": false,
                    "required": [
                      "fractionOfRevenue"
                    ]
                  }
                ]
              },
              "netBorrowing": {
                "type": "number"
              },
              "dividendsPaid": {
                "type": "number"
              }
            },
            "additionalProperties": false,
            "required": [
              "periodLabel",
              "revenue",
              "operatingMargin",
              "taxRate",
              "interestExpense",
              "depreciationAndAmortization",
              "capitalExpenditure",
              "accountsReceivable",
              "inventory",
              "accountsPayable",
              "netBorrowing",
              "dividendsPaid"
            ]
          },
          "minItems": 1
        }
      },
      "additionalProperties": false,
      "required": [
        "baseStatements",
        "periods"
      ]
    },
    "valuation": {
      "type": "object",
      "properties": {
        "valuationBasis": {
          "type": "string",
          "enum": [
            "firm",
            "equity"
          ]
        },
        "valuationDate": {
          "type": "string",
          "format": "date"
        },
        "currency": {
          "type": "string",
          "minLength": 1
        },
        "annualDiscountRate": {
          "type": "number",
          "description": "REQUIRED and explicit — a discount rate is a goal, never a default (FC0)"
        },
        "compounding": {
          "anyOf": [
            {
              "type": "string",
              "enum": [
                "simple",
                "continuous",
                "annual",
                "semiannual",
                "quarterly",
                "monthly"
              ]
            },
            {
              "type": "object",
              "properties": {
                "type": {
                  "const": "periodic",
                  "type": "string"
                },
                "periodsPerYear": {
                  "type": "integer",
                  "exclusiveMinimum": 0
                }
              },
              "additionalProperties": false,
              "required": [
                "type",
                "periodsPerYear"
              ]
            }
          ]
        },
        "dayCount": {
          "type": "string",
          "enum": [
            "ACT/365F",
            "ACT/360",
            "30/360"
          ]
        },
        "terminalValueMethod": {
          "anyOf": [
            {
              "type": "object",
              "properties": {
                "method": {
                  "const": "perpetual-growth",
                  "type": "string"
                },
                "terminalCashFlow": {
                  "type": "number"
                },
                "perpetualGrowthRate": {
                  "type": "number"
                }
              },
              "additionalProperties": false,
              "required": [
                "method",
                "terminalCashFlow",
                "perpetualGrowthRate"
              ]
            },
            {
              "type": "object",
              "properties": {
                "method": {
                  "const": "exit-multiple",
                  "type": "string"
                },
                "terminalMetricAmount": {
                  "type": "number"
                },
                "exitMultiple": {
                  "type": "number"
                }
              },
              "additionalProperties": false,
              "required": [
                "method",
                "terminalMetricAmount",
                "exitMultiple"
              ]
            }
          ]
        },
        "enterpriseToEquityBridge": {
          "type": "object",
          "properties": {
            "cashAndCashEquivalents": {
              "type": "number"
            },
            "totalDebt": {
              "type": "number"
            },
            "preferredEquity": {
              "type": "number"
            },
            "minorityInterest": {
              "type": "number"
            },
            "nonOperatingAssets": {
              "type": "number"
            }
          },
          "additionalProperties": false,
          "required": [
            "cashAndCashEquivalents",
            "totalDebt",
            "preferredEquity",
            "minorityInterest",
            "nonOperatingAssets"
          ]
        },
        "dilutedSharesOutstanding": {
          "type": "number",
          "exclusiveMinimum": 0
        },
        "provenance": {
          "type": "object",
          "properties": {
            "forecastIdentity": {
              "type": "string"
            },
            "statementIdentity": {
              "type": "string"
            },
            "restatementIdentity": {
              "type": "string"
            },
            "source": {
              "type": "string"
            }
          },
          "additionalProperties": false
        }
      },
      "additionalProperties": false,
      "required": [
        "valuationBasis",
        "valuationDate",
        "currency",
        "annualDiscountRate",
        "compounding",
        "terminalValueMethod"
      ],
      "description": "discountedCashFlow's conventions, minus the projected flows the projection supplies"
    },
    "sensitivity": {
      "type": "object",
      "properties": {
        "rowAxis": {
          "type": "object",
          "properties": {
            "variable": {
              "type": "string",
              "enum": [
                "annual-discount-rate",
                "perpetual-growth-rate",
                "exit-multiple"
              ]
            },
            "values": {
              "type": "array",
              "items": {
                "type": "number"
              },
              "minItems": 1
            }
          },
          "additionalProperties": false,
          "required": [
            "variable",
            "values"
          ]
        },
        "columnAxis": {
          "type": "object",
          "properties": {
            "variable": {
              "type": "string",
              "enum": [
                "annual-discount-rate",
                "perpetual-growth-rate",
                "exit-multiple"
              ]
            },
            "values": {
              "type": "array",
              "items": {
                "type": "number"
              },
              "minItems": 1
            }
          },
          "additionalProperties": false,
          "required": [
            "variable",
            "values"
          ]
        }
      },
      "additionalProperties": false,
      "required": [
        "rowAxis",
        "columnAxis"
      ],
      "description": "Adds discountedCashFlowSensitivityTable over the same flows when supplied"
    }
  },
  "additionalProperties": false,
  "required": [
    "projection",
    "valuation"
  ]
}
Output schema
{
  "type": "object",
  "properties": {
    "projection": {
      "type": "object",
      "description": "projectFinancialStatements(...) verbatim"
    },
    "cashFlowsUsed": {
      "type": "string",
      "enum": [
        "freeCashFlowToFirm",
        "freeCashFlowToEquity"
      ]
    },
    "valuation": {
      "type": "object",
      "description": "discountedCashFlow(...) verbatim"
    },
    "sensitivity": {
      "type": [
        "object",
        "null"
      ],
      "description": "discountedCashFlowSensitivityTable(...) verbatim, or null when not requested"
    },
    "assumptions": {
      "type": "object",
      "description": "Applied conventions"
    },
    "diagnostics": {
      "type": "object",
      "description": "Engine, method, warnings"
    }
  },
  "required": [
    "projection",
    "cashFlowsUsed",
    "valuation",
    "sensitivity",
    "assumptions",
    "diagnostics"
  ]
}

All operations · Setup, handles, jobs & permissions