Workshop Agenda
Five Year Budget Model Hands-On Workshop Agenda
Day One - The Five Year Budget
Model and Forecasting Techniques
1. Introduction
2. Budgets and Forecasting
3. What is a Model
4. Model Attributes
5. Model Overview
Main Menu, View Form, Worksheet Layout
6. Budget Assumptions
Admissions, Enrollments, Retention rates,
Financial Aid,
Tuition Discounting, Goal Seek, Endowment,
Tuition, Fees, Other Ed & Gen revenue
Residence Halls, Board, Other Aux Ent
Revenue
Inflation, Fundraising, Debt Service
7. Expense Assumptions
8. Financial Aid Assumptions
9. Budget Reports, Split Screen' What-If
10. Revenue Budgets
11. Expense Budgets
Department Detail, Budget Code Table
Budget Import, Year-to-Date Import, Prior
Year Import
Budget Reconciliation
Pivot Tables: Object; Department; Division;
Vice President; Location
12. Models
Admissions, Enrollments, Financial Aid,
Tuition Discounting, Endowment,
Enrollment Retention, Fundraising, Debt
Service, Model Charts
13. Vice Presidents 5 Year Budget Forecast and Year-to-Date Actual
Reports
14. Position Budgets for Faculty and Staff, Pivot Tables for both
15. Capital Budgets, Financial Position, Ratios, Summary Statistics
16. Financial Ratio Model
17. Pivot Table Exercise
18. Data Lists, and Subtotaling
19. Filtering
20. Scenarios
21. Goal Seek
22. What-If and Tables
23. Analyzing Data
24. Auditing Worksheets
25. Protecting Workbooks and Worksheets
Day Two - Customizing the Five
Year Budget Model
26. Recent Updates to the Model
27. How to add updates to your Model
28. Budget Reconciliation
29. Excel Tips
30. Customize
31. Visual Basic Editor
32. Create a Macro Command Button
33. Recording Macros
34. Macro Debugging
35. Macro Editing and Command Buttons
36. Creating Print and Print Preview Macro
37. Customizing the View Form
38. Creating a new User Form
39. Model's Pivot Tables
40. Pivot Table Dash Board
41. Index Match Formula
42. Insert a blank worksheet
43. Add worksheet to View Menu
44. Print routine for new worksheet
45. Export budget to General Ledger system
46. Move columns for next Year
47. Import Prior Year Actual
48. Position Budget Model - Faculty
49. Position Budget Model - Staff
50. Position Budget Model - Pivot tables