hfm rolling forecast

7/25/2019 HFM rolling forecast

http://slidepdf.com/reader/full/hfm-rolling-forecast 1/33

Rolling Forecast

January 29, 2016

Bryan Hogan

Justin Cooper

©2016



©2016

Finit EPM Services

Full Cycle Implementations

Upgrades

Dedicated Support



©2016

Why is Finit here?

Finit takes pride in being a companyof makers and Doers; people who dig

in and get their hands dirty

We make and deliver personalized financial

reporting solutions and experiences

…Not Company to

Company, but Personto

Person

By listening, questioning,

and analyzing



©2016

The Finit Family

Fully aligned with

our clients, not just

bottom line

No debt or external

ownership

Work with Finit

employees, no

subcontractors

Compensation

based on CLIENT

SATISFACTION

PRIVATELY

OWNED

CLIENT

SATSIFACTION

NO

SUBCONTRACTORS

EBT FREE



©2016

Finit Values

Our values on which we ask you to provide consultant feedback:

• Approach & Collaboration

• Integrity & Honesty

•

Client Betterment

• Self Betterment

• Colleague Betterment

•

Finit Betterment

• Work Effectiveness

• Impact & Innovation

• Proactiveness

& Passion

Service Solutions Betterment



©2016

Finit Customer Success

Our values, culture, and approach tobecoming a trusted advisor to our

customers has led to100% customer success

for every Finit client (250+) and forevery Oracle Hyperion project (500+)


http://slidepdf.com/reader/full/hfm-rolling-forecast 7/33©2016

Some Finit Customers



Questions



Upcoming Webinars

February 12th - Driver Based Forecasting -Carla Cwiertnia

February 19th - HFM Classic vs Calc Manager – Chris Barbieri / Scott Sawers

February 26th - Intro to Planning Part II -Cindy Eichner



About the Presenters

Justin Cooper( [email protected])

Certification/Education

Bachelor of Science in ComputerInformation Systems

Experience

8 years with Essbase8 years with Hyperion Planning

9 years with Financial Reports

2 years with HFM

2 years with FDM

Client Testimonial Justin is doing a great job on our project. Justin has made great

suggestions and works on his own when needed to complete a task. He has

taken the time to show me exactly how some of his calc scripts work (asrequested) and has made me feel comfortable that once Finit rolls off we

will be able to maintain and troubleshoot our Planning tool.

mailto:[email protected]




About the Presenters

Bryan Hogan([email protected])

Experience

8 years with Essbase4 years with Planning

3 years with Enterprise

21 years with financial systems,

reporting, and dashboards

Certification/Education

BBA- Finance & Banking, Universityof North Texas

Client TestimonialFinit has a remarkable reputation and no matter who you meet from the

company, you can understand where the comments come from. Each of

them is knowledgeable in so many aspects and takes the time to make surethe client fully understands the topic. They exceed the bar of

professionalism while maintaining an enjoyable atmosphere.





Rolling Forecast - Agenda

• What is a Rolling Forecast?• Traditional vs. Rolling Forecasts

• Rolling Forecasts in Hyperion Planning

• “Out of the box” Solution• Customized Solution

• Summary/Questions



What is a Rolling Forecast?



What is a Rolling Forecast

• More fluid approach to the planning process• Creates a cycle of continuous planning

• Avoids the year-end “wall”

•Not bound to targets or predeterminedexpectations

• Drives more strategic decisions versus tacticaldecisions made to “hit a number”



Key Components of a Rolling Forecast

• Focus on key drivers versus a detailed list ofassumptions

• Update key drivers on a regular andpredetermined basis

• Incorporate the latest known impacts on thebusiness

• Utilize what-if scenarios to evaluate catastrophic

events• Risk and Opportunities schedules are important

to evaluate a range of impacts to the what-ifscenarios



Traditional vs. RollingForecast



Traditional vs. Rolling Forecast

• Both types of forecast have the same amount ofactual data for trending and other analysis

• The traditional forecasts hit the year end wall inDecember while the Rolling Forecasts push intothe following fiscal year and beyond

J F M A M J J A S O N D J F M A M J J A S O N D

Traditional Q1 (P3+9) Forecast

Traditional Q3 (P9+3) Forecast

Rolling Q1 Forecast (12 mth)

Rolling Q3 Forecast (12 mth)

Current Year Current Year +1

Year End Wall



Traditional vs. Rolling Forecast

Traditional Planning Process Rolling Forecast Process

Year-end Wall Always a fixed number of months

into the future

Budgets are “fixed”; forecasts are

adjusted snapshots of budget

Updated continuously

Time intensive to update; budget is

annual “event”

Takes only days to develop each

forecast

Typically planning is at a lower level Key drivers only

Negotiated targets Flexible what-if and R&O focusedoutcomes



Rolling Forecast Questions

• Will a rolling forecast add more work to thefinance teams to develop and maintain anotherset of numbers?

• Would a rolling forecast process replace:

• Monthly financial reporting and variance analysis?

• Current monthly/quarterly forecasts?

• The annual budget process?

• The LRP/Strategic planning process?

• What is the best way to manage all of theversions and any integration points with otherforecasts within an organization?



Rolling Forecasts in HyperionPlanning “Out of the Box” &

“Customized” solution



©2016

Rolling Forecast in Planning

• Main object used to enable Rolling Forecast aresubstitution variables

• Global placeholder for information that changes regularly



©2016

Rolling Forecast – “Out of the box”

• Substitution variables are auto-generated via the Planningweb.



Key Business Drivers -Example

Page



©2016

Key Business Drivers - Example

• Rolling forecast monthly meeting agenda:• Discuss impacts of new actual data to

previous forecast trends

• Assess any new risks and opportunities to key

drivers• Provide estimates and assign or update

probability to R&O as necessary

• Update the rolling forecast model asappropriate



©2016

Benefits of Implementing RollingForecasts in Hyperion Planning

• Centralized system/application• Spreadsheets not book of record

• Version control

• Standardization

• Data integration

• Security

• Reporting



Summary



©2016

Summary

• Provides a more dynamic view of the business• Identifies alternative actions more quickly as:

• Are more flexible

• Are proactive versus reactive

• Focus on key business drivers and strategic decisions

• Take less time to update

• Are more effective and easier to manage byutilizing a systemic planning solution to assist with:

• Standardization

• Version control

• Simplified dissemination of information



Questions and Answers



Thank you for attending!

Questions?Email us for a copy of the slides orlink to the recording

[email protected]

Past webinars:

www.finitsolutions.com/webinars

Presenters:Bryan Hogan

[email protected]

Justin Cooper

[email protected]

General Questions:

Greg Barrett

[email protected]

Joe Mizerk

[email protected]


http://www.finitsolutions.com/webinars









http://www.finitsolutions.com/webinars




Upcoming Webinars

February 12th - Driver Based Forecasting -Carla Cwiertnia

February 19th - HFM Classic vs Calc Manager – Chris Barbieri / Scott Sawers

February 26th - Intro to Planning Part II -Cindy Eichner

hfm rolling forecast

Documents