Description
Course Overview:
This comprehensive financial modelling course equips participants with the knowledge and practical skills to build dynamic financial models using Excel. Participants will learn to effectively plan, design, and structure financial models, construct and integrate financial statements, and enhance their understanding of financial analysis and valuation techniques. The course covers advanced Excel functions, scenario analysis, and best practices in model presentation. Participants will also gain practical knowledge in optimising cash flow management, making informed capital investment decisions, forecasting cash flows, and managing liquidity and solvency. Through hands-on practice and case studies, the course ensures that participants develop financial modelling and Excel proficiency.
The course aims to equip participants with advanced skills in financial modeling using Excel, teaching them to effectively plan, design, and structure financial models. Participants will develop proficiency in constructing and integrating financial statements, enhance their understanding of financial analysis and valuation techniques, and gain practical knowledge for optimising cash flow management and working capital. Additionally, the course fosters the ability to make informed capital investment decisions and improves skills in forecasting cash flows and managing liquidity and solvency.
Targeted Audience:
- Finance professionals
- Business analysts
- Accountants
- Investment bankers
- Financial consultants
- Students in finance or business programs
- Anyone interested in mastering financial modeling and Excel
Description
Course Outline:
1. Introduction to Cash Flow Statement
- Understanding cash flow movements
- Importance of cash flow management
- Capital structure
- Working capital management for optimized cash flow
- Capital investment decisions
- Direct versus indirect cash flow
2. Components of Financial Statement
- Balance sheet
- Income & expenditure account
- Cash flow statement
- Statement of changes in equity
- Notes to financial statements
- Case study: Cash flow statement of Walmart
3. Understanding Working Capital Ratios
- Significance of working capital ratios
- Determining efficiency of working capital management
- Current ratio
- Liquid asset ratio
- Inventory turnover ratio
- Debtors turnover ratio
- Operating cycle
- Cash conversion cycle (CCC)
4. Importance of ERP in Cash Flow Planning
- Sales
- Bill of material
- Material management
- Procurement
- Production
- Finance
5. Cash Flow Forecast
- Importance of cash flow forecast
- Establishing assumptions based on current conditions
- Estimating cash inflows and outflows
- Identifying short-term investments
- Exploring sources of funds
- Controlling application of funds
- Best practices in cash management
6. Liquidity vs. Solvency
- Difference between liquidity and solvency
- Understanding solvency ratios
- Shareholder equity ratio
- Debt equity ratio
- Interest coverage
7. Capital Expenditure
- Capital investment appraisal
- Return on investment
- Payback period
- Net present value
- Internal rate of return
- Lease or buy decisions
8. Cost of Capital
- Borrowing requirements
- Long-term vs. short-term borrowing
- Equity or debt capital?
- Dividend policy
- Cost of capital
- Weighted average cost of capital
9. Case Studies
- Preparation of direct and indirect cash flow statements
- Interpretation of financial statements of a listed company
General Notes
GENERAL NOTES
i. The clients have many options on where they would wish to have the training
ii. The client should communicate their preferred training venue at least seven days before the training date failure to which the training shall take place in Nairobi.
iii. This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
iii. Training manuals and additional reference materials are provided to the participants.
iv. Upon successful completion of this course, participants will be issued with a Chania finance consultancy certificate.
v. The onsite training fee covers tuition fees, training materials, tea at 10am, lunch, tea at 4pm, training venue and a certificate on completion. Accommodation and travel may be arranged for our participants upon request.
vi. The online training fee covers tuition fees, training materials, and a certificate on completion.
Available at the following Venues
- Nairobi
- Mombasa
- Kisumu
- Nakuru
- Zoom
- Google Meet
- Google Teams
- Webex
Choose the date you would like to take the course
Related Courses
10,000+ unique online course list designs
