Equations are how an 📝Integrated Financial Model (IFM) represents a business: every business process can be expressed as an equation or set of equations in an Integrated Financial Model.
Examples
The equations used across IFMs pair spreadsheet functions with the model's common named ranges, the conventions described in 📝Components of an IFM.
- 📝ChangeFactor - Limiter Equation — improves a metric a little bit each month until it achieves a goal.
- VLookup LookupVal — looks up an account code from the LookupVal column in a source tab, such as the income statement.
- Sum Offset QColumn — sums a quarter's worth of cells located by the QuarterColumn offset.
Related
- 📝Summary IFM — the summary-level business model in a Google Sheet
- 📝Overview - Forecasting with the IFM — how a business is forecast with the IFM
- 📝Financeable Equation — a business story stated precisely enough to finance