This course is especially targeted to the executives in companies and businesses, as well as those who are self-employed and ‘micro and small’ business owners who require basic financial budgeting knowledge using Excel. It is suitable for those who seek basic financial planning and budgeting knowledge.
This would be useful for those seeking additional financing under the situation of COVID 19 and beyond. The course is based on the use of Excel. Accordingly, participants would be required to use their notebooks and have some basic knowledge of Excel. Participants will be taught on how to perform forecasting, prepare budgets, prepare summary and data presentations, be able to undertake reporting.
Brochure
— Course Fee: RM 790.00 (Inclusive of 8% Service Tax) —
• Module 1: Introduction
✓ Basics about forecasting
✓ Purpose of forecasting
• Module 2: Types of forecasts
✓ Types of forecasts and budgets – brief
✓ Components of budgets – sales, purchases, material, labour, selling and administration
budgets etc
• Module 3: Financial Planning and forecasting – part 1
✓ Forecasting tool in Excel
✓ Forecasting sales, purchases, material labour etc
✓ Forecasting using % of sales method
✓ Developing a cash budget
✓ Calculation of cash sales receipts
✓ Calculation cash purchases payments
✓ Calculation of other cash payments
✓ Cash reconciliation and identifying borrowing needs
✓ Types of forecasting methods
✓ Qualitative and quantitative methods
• Module 4: Financial Planning and forecasting – part 2
✓ Exercises