hfm rolling forecast

Post on 28-Feb-2018

235 Views

Category:

Documents

1 Downloads

Preview:

Click to see full reader

TRANSCRIPT

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

7/25/2019 HFM rolling forecast

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

©2016

Finit EPM Services

Page 2

Full Cycle Implementations

Upgrades

Dedicated Support

7/25/2019 HFM rolling forecast

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

©2016

Why is Finit here?

Page 3

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

7/25/2019 HFM rolling forecast

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

©2016

The Finit Family

Page 4

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

7/25/2019 HFM rolling forecast

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

©2016

Finit Values

Page 5

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

7/25/2019 HFM rolling forecast

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

©2016

Finit Customer Success

Page 6

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+)

7/25/2019 HFM rolling forecast

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

Some Finit Customers

7/25/2019 HFM rolling forecast

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

Questions

7/25/2019 HFM rolling forecast

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

Upcoming Webinars

Page 9

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

7/25/2019 HFM rolling forecast

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

About the Presenters

Page 10

Justin Cooper( jcooper@finitsolutions.com)

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.

7/25/2019 HFM rolling forecast

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

About the Presenters

Page 11

Bryan Hogan(bhogan@finitsolutions.com)

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.

7/25/2019 HFM rolling forecast

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

Rolling Forecast - Agenda

Page 12

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

• Rolling Forecasts in Hyperion Planning

• “Out of the box” Solution• Customized Solution

• Summary/Questions

7/25/2019 HFM rolling forecast

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

What is a Rolling Forecast?

7/25/2019 HFM rolling forecast

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

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”

Page 14

7/25/2019 HFM rolling forecast

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

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

Page 15

7/25/2019 HFM rolling forecast

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

Traditional vs. RollingForecast

7/25/2019 HFM rolling forecast

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

Traditional vs. Rolling Forecast

Page 17

• 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

7/25/2019 HFM rolling forecast

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

Traditional vs. Rolling Forecast

Page 18

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

7/25/2019 HFM rolling forecast

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

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?

Page 19

7/25/2019 HFM rolling forecast

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

Rolling Forecasts in HyperionPlanning “Out of the Box” &

“Customized” solution

7/25/2019 HFM rolling forecast

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

©2016

Rolling Forecast in Planning

Page 21

• Main object used to enable Rolling Forecast aresubstitution variables

• Global placeholder for information that changes regularly

7/25/2019 HFM rolling forecast

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

©2016

Rolling Forecast – “Out of the box”

Page 22

• Substitution variables are auto-generated via the Planningweb.

7/25/2019 HFM rolling forecast

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

©2016

Hyperion Planning “Out of the Box”

Page 23

7/25/2019 HFM rolling forecast

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

©2016

Hyperion Planning - Customized

Page 24

7/25/2019 HFM rolling forecast

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

Key Business Drivers -Example

Page

7/25/2019 HFM rolling forecast

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

©2016

Key Business Drivers - Example

Page 26

• 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

7/25/2019 HFM rolling forecast

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

©2016

Key Business Drivers - Example

Page 27

7/25/2019 HFM rolling forecast

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

©2016

Benefits of Implementing RollingForecasts in Hyperion Planning

• Centralized system/application• Spreadsheets not book of record

• Version control

• Standardization

• Data integration

• Security

• Reporting

Page 28

7/25/2019 HFM rolling forecast

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

Summary

7/25/2019 HFM rolling forecast

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

©2016

Summary

Page 30

• 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

7/25/2019 HFM rolling forecast

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

Questions and Answers

7/25/2019 HFM rolling forecast

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

Thank you for attending!

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

insights@finitsolutions.com

Past webinars:

www.finitsolutions.com/webinars

Presenters:Bryan Hogan

bhogan@finitsolutions.com

Justin Cooper

 jcooper@finitsolutions.com

General Questions:

Greg Barrett

gbarrett@finitsolutions.com

Joe Mizerk

 jmizerk@finitsolutions.com

7/25/2019 HFM rolling forecast

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

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

top related