Free Excel Template: Forecasting with External Factors

Excel template: Forecasting with external factors

Unlock Accurate Forecasting with Our Free Excel Template!

Are you looking for a powerful tool to enhance your business forecasting?

Our Excel template is designed to help you make more accurate predictions by incorporating key external factors. Whether you're forecasting sales, demand, or financial metrics, this template provides a comprehensive and easy-to-use solution.

  • Easy to use on your data: Just paste your data in
  • Built-in-Excel functionality: No hidden formulars or Macros
  • Example data included: Making it easier to grasp
  • Video tutorial: Showing how to use the sheet
Download template

Key Features

Weight external factors

Analyses past relationships between the forecasted variable and its external factors and uses this to weigh the importance of each factor

Transforms the data

Transforms the data to unify the scale and optimize the regression

Seasonal pattern

Analyze seasonal patterns and deviations

Fill in your details to download the Excel template

Explore our forecast templates

US Non-Farm Payrolls

Forecasting the US NFP requires analyzing a blend of high-frequency indicators, like Initial jobless claims, Purchasing Managers index, Deposits, Inflation, GDP growth, and unemployment rates, as they provide insight into the overall health of the labor market.

Jobless Claims, Initial, Total

⭐⭐⭐⭐

Jobless Claims, 4 Week MA

⭐⭐⭐

Jobless Claims, Initial, Total, SA

⭐⭐

CPI, All Items, SA, Index

⭐

80+

21

92%

Models evaluated

Variables evaluated

Accuracy

US PMI

Nowcasting the PMI in US requires analyzing a blend of high-frequency indicators like the CISS, Oil Spot Price, Economic Surprise Index, Interbank Rates and Volatility Indices as they provide an early insight into the overall health of the economy.

Composite Indicator of Systemic Stress

⭐⭐⭐⭐

Crude Oil, USD

⭐⭐⭐

Economic Surprise Index, Citi

⭐⭐

LIBOR, 6 Month, Fixing

⭐

80+

18

98,5%

Models evaluated

Variables evaluated

Accuracy

EU Economic Sentiment Indicator

Nowcasting the Economic Sentiment Indicator in EU requires analyzing a blend of high-frequency indicators like the Yield for Spain, Germany, and France, Economic Surprise Index from Citi, and DAX 40, as they provide an early insight into the overall health of the economy.

Spain, 3 Year, Yield

⭐⭐⭐⭐

Germany, 3 Month, Yield

⭐⭐⭐

France, 3 Year, Yield

⭐⭐

Euro Area, Citi, Economic Surprise Index

⭐

80+

25

99,7%

Models evaluated

Variables evaluated

Accuracy

US CPI

Forecasting the inflation in US requires analyzing a blend of high-frequency indicators, like prices of Energy, gasoline, electricity, transport, food and lumber as they provide insight into the overall price development.

Gasoline, All Formulations, Price

⭐⭐⭐⭐

Beef, Select Carcass Value, USD

⭐⭐⭐

Total US Rig Count, Gas

⭐⭐

Rail Traffic, Total

⭐

80+

14

95,2%

Models evaluated

Variables evaluated

Accuracy

Germany GDP

Nowcasting the GDP in Germany requires analyzing a blend of high-frequency indicators like Weekly Activity Index, IFO - Manufacturing Expectations the Next 6 Months, ZEW  Financial Market Report, IFO Trade index, GFK Consumer Climate.

Ifo, Manufacturing Industry, Expectations

⭐⭐⭐⭐

Weekly Activity Index

⭐⭐⭐

ZEW, Economic Expectations

⭐⭐

Ifo, Business Situation

⭐

80+

28

99,4%

Models evaluated

Variables evaluated

Accuracy

US New Home Sales

Forecasting the US housing market requires analyzing a blend of factors like, Construction spending, Inflation, Financial volatility index, and New Privately-Owned Housing Units Started.

Construction Spending

⭐⭐⭐⭐

CPI, all items

⭐⭐⭐

Volatility Index

⭐⭐

New Housing Started, SAAR

⭐

80+

21

92%

Models evaluated

Variables evaluated

Accuracy

Virtual demo

View our click-through demo

Experience the ease and accuracy of Indicio’s automated forecasting platform firsthand. Click to start a virtual demo today and discover how our cutting-edge tools can streamline your decision-making process.

View Demo

We are an automated forecasting software that bridges the latest statistical models from academia with the specific leading indicators in an organization's market environment. Helping your organization achieve the highest forecast accuracy.

© 2025 Indicio Technologies All Rights Reserved