1. Working with Planning Modules
  2. Working With Financials
  3. About Trends

About Trends

You can enter trend-based assumptions that let you plan and forecast based on trends. Financials includes the following trends:

Note:

In a 13-period application, Month does not represent a calendar month but the period defined through the 13 period calendar.
  • Current Year Actual Average—Calculates the average for an account for the Current Fiscal Year specified in Planning and Forecast Preparation.

  • Current Month Actual—Takes the value for an account for the month or week specified as the Current Period for the Current Fiscal Year specified in Planning and Forecast Preparation.

  • Hold Forecast to Current Year Plan—For the Forecast Scenario only, compares how much has been spent year to date for an account to the Plan for the current year, and spreads the remainder evenly over the remaining months in the Forecast. For example, if Travel YTD Actuals is 260,000, the full year Plan is 500,000, and the current month is June, there is 240,000 remaining to be spread over the remaining 6 months in the year (July – Dec): 240000 / 6 = 40000. The 40000 is spread evenly for Jul to Dec. This trend ensures that you keep Forecast in line with Plan. If YTD spending exceeds the Plan, the forecast for the remaining periods is set to zero, rather than a negative number.

  • Prior Year Actual Average—Calculates the average for an account for the year prior to the Current Fiscal Year specified in Planning and Forecast Preparation. For example, if the Current Fiscal Year is FY17, the prior year is FY16.

  • Prior Year Actual with Seasonality—Takes the value for account for the month using the value for the same month in the prior year.

  • Forecast Average—For the Plan Scenario only, takes the average for the Forecast from the prior year. For example, for FY18 in the Plan scenario, selecting this trend calculates the average for the account from FY17 in the Forecast Scenario.

  • Forecast with Seasonality—For the Plan Scenario only, takes the monthly values from the Forecast from the prior year. For example, in FY18 for the Plan Scenario, selecting this trend calculates the monthly value for the account from FY17 in the Forecast Scenario.

  • Year over Year Increase/Decrease—Applies a % increase or decrease to the prior year’s value.

  • No Trend—Removes the trend and clears the data from a previously set trend.

  • Monthly Growth—Calculates year over year change for an account using current year and prior year as the basis to calculate the growth.

  • Prior Month Run Rate—Takes the value of the prior period. For example, if Current Month is June FY16 and the first period of Forecast is July, this trend takes the value of June and applies it to July. If adjustments are made to the July value, the adjusted July value is used for August.

Tutorials

Tutorials provide instructions with sequenced videos and documentation to help you learn a topic.

Table 4-5 Tutorials to Learn About Financials

Your Goal Learn How
Learn how to perform trend-based planning in Financials. See how to enter trend-based assumptions that let you plan and forecast based on trends.

tutorial icon Trend-Based Planning in Financials