Methodology
Hands on Practice
Case Study
Exercises
Who Should Attend
Executive
Managers
Pre-requisite
Familiar with Basic
Excel
Course Materials
Will be provided
Duration
2 days
(9.00am-5.00pm)
Number of
Participants
Not more than 20
MODULE 1: Spreadsheet Basics
- - Pre-test to determine the level of proficiency to decide the speed and
depth of the training scope
- - Challenge 1: McApple
· MODULE 2: The Basic Financial Statements
- - Relationship of various Financial Reports
- - Accounting Principles: Debit & Credit
- - Basic Accounting Transactions
- - What is Financial Statements
- - Cash vs Profit
· MODULE 3: The Cash Budget
- - What is Budget
- - Overview of Real Life Budget
- - Cash Budget Format & Preparation
· MODULE 4: Evaluating Performance with Financial Ratios
- - Types of Ratios: Profitability, Liquidity, Gearing & Investment
- - Financial Ratios calculations
- - Case Study: The Power of Ratios
· MODULE 5: Financial Forecasting
- - Creating Trend using Excel Chart
- - Financial Forecast & Projections
- - Forecasting Format & Preparation
· MODULE 6: Breakeven Analysis
- - Template & Calculation
- - Breakeven Chart
· MODULE 7: The Time Value of Money
- - Financial Calculation
- - Excel Financial Function
· MODULE 8: Rates of Return
- - Personal Saving
- - IRR (Internal Rate of Return)
- - ROCE (Return of Capital Employed)
· MODULE 9: The Cost of Capital
- - Loan Calculation
- - Company Borrowing
· MODULE 10: Capital Budgeting
- - Capital Budget Format & Preparation
MANAGEMENT + IT…
Programme scope, delivery arrangements and suitability are confirmed during enquiry.