1 / 19

How the University of Missouri is Using Hyperion Strategic Finance

Our Panel. Cuba Plain, University of Missouri System, Assistant VP, Budget Planning

stacy
Download Presentation

How the University of Missouri is Using Hyperion Strategic Finance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. How the University of Missouri is Using Hyperion Strategic Finance To improve Strategic Financial Planning and Communication October 3, 2010

    2. Our Panel Cuba Plain, University of Missouri System, Assistant VP, Budget Planning & Development Karla Dowd, University of Missouri System, Assistant Director of Budget & Planning Scott Song, Senior Manager, Blue Stone International David Felsenthal, Solution Manager, Blue Stone International

    3. Session Agenda Overview of University of Missouri Overview of Planning & Budget at UM Overview of HSF UM’s Historical Processes Why HSF? UM’s HSF Implementation & Model HSF Demo

    4. University of Missouri System University System with 4 campuses, system office, cooperative extension, teaching hospital Total enrollment: 69,384 HC - 53,292 FTE Fall 2009 74% undergrad, 4% 1st Prof, 22% grad (MS, PhD) Degrees granted, 15,175 - FY2010 Faculty & Staff – 24,226 - Fall 2009 Budget - $2.5 billion Operating Fund - $1.0 billion, Hospitals $0.65 billion, Other Unrestricted $0.5 billion, Restricted $0.3 billion Endowment Fund -$0.9 billion market value 6/30/10 Retirement Trust -$2.3 billion market value 6/30/10

    5. System Budget & Planning Report to VP for Finance & Admin, Nikki Krawitz Our Role Planning & Policy guidance, allocation agent for state appropriations, prepare consolidated operating budget and approp request, monitor system-wide performance, accountable to the Board Campus Role Apply approved policies, control of self-generated revenues, internal allocation of funds, develop and implement campus budget, monitor campus performance, accountable to the President through the Chancellors

    6. What is HSF? HSF stands for Hyperion Strategic Finance Client based software tool from Oracle/Hyperion Financial/strategic modeling Beyond budgeting and short term planning Provides for: Driver based modeling Multi-year planning What if analysis Target setting / Top-down budget building Ad-hoc analysis Accounting integrity Modeling integrity

    7. What HSF is not Not a transactional based system Not meant for detail budgeting tool

    8. Niche for Hyperion Strategic Finance

    10. Historical Process Different planning processes & data for Treasurer, Controller, Budget & Planning Long range projections mostly income statement view driven; Excel based Could not evaluate some items and the impacts quickly, i.e. market changes, student mix changes Could not provide key ratio and balance sheet impacts of policy decisions

    11. Why HSF? Combines many pieces of data into one model to meet various applications Incorporates fund accounting & impacts to balance sheet & pro forma ratios Relationship based modeling allows to easily change assumptions in several areas using customized drivers that may vary by campus/fund Provides multiple years of history data to base projections on Can easily determine costs & required trade-offs of policy decisions Allows for scenario management & comparison

    12. UM’s HSF Implementation Multiple business units (BU) Various Fund Groups Consolidate by Campus Consolidate by Fund across units Balance Sheet at business unit only Drivers/projections differ by fund and/or BU

    13. UM’s HSF Implementation - Our Tree

    14. UM’s HSF Implementation Our Drivers Drivers are data that are used in formulas to forecast key revenue or expenditure components Examples include: Student credit hours, by term, by student level, by residency, professional student FTEs Fee rates Salary changes by employee type Benefit changes New initiatives by major objective of expense

    15. Implementation Thoughts HSF Tool has many capabilities & is very powerful HSF implementation is very different from a typical administrative data system Blue Stone was a valuable partner in implementing HSF in our public research higher education environment We would not have been able to configure HSF to meet our needs without the help of Blue Stone We’ve had a great working relationship with Blue Stone and look forward to continuing that as we determine new needs & applications for this terrific tool.

    16. Our Status Deployed Actual data loaded through FY2010 and budget for FY2011 Will use HSF for modeling FY2012 and beyond Modeling FY2012 operations now and will do presentations starting in January to our Board

    17. Time on task

    19. DEMO Consolidation Forecasting logic with drill down capabilities Scenario analysis and comparisons Consolidating various scenarios Key ratios Applying surplus/deficit cash positions Issuance of debt – not applicable to all institutions Endowment analysis – not applicable to all institutions

    20. Contact Information Cuba Plain Email: plainc@umsystem.edu Phone: 573-882-3400 Karla Dowd Email: dowdk@umsystem.edu Phone: 573-882-3400 David Felsenthal Email: dfelsenthal@bluestoneinternal.com Phone: 773-540-1002 Blue Stone International Booth Information Booth #510

More Related