Primary Inputs, Formulas and Guidelines

1. Primary Inputs

Primary inputs are the raw data elements that drive any quantitative analysis, model, or report. Selecting accurate and relevant inputs is essential because they directly affect the reliability of the outcomes. Below are the most common categories of primary inputs:

1.1. Quantitative Data

• Historical values past sales, expenses, production volumes, etc.
• Forecasts projected demand, price trends, market growth rates.
• Financial metrics interest rates, tax rates, discount factors.

1.2. Qualitative Data

• Assumptions market entry timing, regulatory changes, consumer behavior.
• Expert judgments risk assessments, scenario probabilities.

1.3. Source Validation

Each input should be documented with its source, date of retrieval, and any adjustments applied. A typical validation table looks like this:

2. Formulas

Formulas translate primary inputs into meaningful results. They can be simple arithmetic expressions or complex algorithms. The following sections outline the most frequently used categories of formulas.

2.1. Financial Calculations

• Net Present Value (NPV) NPV = (CF / (1+r)) whereCF= cashflow in periodt,r= discount rate.
• Internal Rate of Return (IRR) the discount rate that makes NPV=0.
• Debt Service Coverage Ratio (DSCR) DSCR = Operating Cash Flow / Debt Service.

2.2. Operational Metrics

• Yield Yield = (Good Units / Total Units) 100%.
• Throughput Throughput = Capacity Utilization Rate.
• OEE (Overall Equipment Effectiveness) OEE = Availability Performance Quality.

2.3. Statistical Formulas

• Standard Deviation () = [ (x ) / (N1) ].
• Linear Regression y = + x where =Cov(x,y)/Var(x).
• Confidence Interval (95%) CI = 1.96(/N).

2.4. Example Calculation

Assume a project with the following cashflows (in $ thousands) and a discount rate of 8%:

NPV calculation:

NPV = -120/(1+0.08)^0 + 30/(1+0.08)^1 + 45/(1+0.08)^2 + 55/(1+0.08)^3 + 60/(1+0.08)^4NPV  -120 + 27.78 + 38.55 + 43.66 + 44.29  $34.28k

The positive NPV indicates the project adds value at an 8% discount rate.

3. Guidelines for Using Inputs and Formulas

Adhering to a consistent set of guidelines ensures that the analysis remains transparent, repeatable, and defensible.

3.1. Documentation

• Record every input, its source, and any transformation applied.
• Maintain a versioncontrolled spreadsheet or database.

3.2. Consistency

• Use the same units across all calculations (e.g., USD, euros, units).
• Standardize time periodsmonthly, quarterly, or yearlybefore aggregating.

3.3. Sensitivity Analysis

• Identify key drivers (e.g., discount rate, growth rate).
• Vary each driver within a realistic range while holding others constant.
• Present results in a tornado chart or a table of scenarios.

3.4. Validation & CrossCheck

• Recalculate results using an alternative method (manual vs. software).
• Compare outcomes with historical performance or industry benchmarks.

3.5. Review & Approval

• All assumptions and formulas should be reviewed by a subjectmatter expert.
• Obtain signoff from the project sponsor before finalizing the model.

3.6. Updating Processes

• Set a calendar reminder for periodic review (quarterly or annually).
• Track changes in a changelog sheet with date, author, and reason.

4. Conclusion

Primary inputs provide the factual foundation on which formulas build insight. By rigorously documenting sources, applying welldefined calculations, and following clear procedural guidelines, analysts can produce reliable, auditable results. Consistency, validation, and regular updates are the pillars that keep any quantitative model accurate and useful over time.