DESCRIPTION
Pelatihan Optimizing Budgeting With Excel Spreadsheet ini akan memberikan pengetahuan dan aplikasi dalam menggunakan Excel Spreadsheet untuk pembuatan budget, mengoptimalkan fasilitas excel yang sudah ada dan trik-trik nya.
OBJECTIVE
- Menyegarkan pemahaman terhadap budgeting cycle
- Menguasai teknik dalam mengoptimalkan fasilitas yang terdapat dalam Excel
- Mengusai teknik dalam membuat budget mulai dari cash budget, capital budget hingga membangun pro-forma financial statement
- Menguasai teknik menggunakan fasilitas makro, dan what if analysis (scenario dan goal seek)
- Menguasai teknik dalam mengoptimalkan fasilitas excel dalam membuat report
COURSE OUTLINE
- Budgeting Cycle and Pro-forma Financial Statement
+ Planning Activities and Developing Budget Number
+ Budgeting Cycle
+ Output and report of Budgeting
- Microsoft Excel – Spreadsheet
+ Basic Purpose Of A Spreadsheet Program
+ Various Components Of The Excel
+ Purpose And Usage Of Excel’s Built-In Functions And Macro Functions
- Optimizing Usage of Excel
+ Workbook and Worksheet Tricks
+ Data Analysis Tricks
+ Chart Tricks
- Cash Budget With Excel
+ Calculate total cash collections and disbursements
+ Calculate expected ending cash balance and short-term borrowing needs.
+ Determine the optimal timing of major cash expenditures.
- Scenario Manager to evaluate different assumptions
- Capital Budgeting
+ Relevant cash flows in capital budgeting.
+ Calculating the after-tax cash flows used as inputs to the various decision making techniques.
+ payback period, discounted payback, NPV, PI, IRR, and MIRR
+ Scenario analysis in Excel.
+ Excel’s Solver to determine optimal capital budget under capital rationing
- Forecasting Techniques
+ Percent of sales method is used to develop pro-forma
+ Financial Statements and how to construct such statements in Excel.
+ TREND function for forecasting sales or any other trending variables.
+ Regression analysis with Excel’s built-in regression tools.
- Developing Pro-forma Financial Statement
- Understanding Macro Function
- Developing Report
- Case Study
METHOD
- Pre-test
- Presentation
- Discussion
- Case study
- Post-test