-
Teacher
-
Category
IT Programmes
-
Course PriceGHC3500.00
Advance Excel for Financial Modeling
This course equips participants with the knowledge and practical skills to increase productivity. Build on your existing modelling skills and apply new techniques to better analyze financial data, predict revenues and cost and assess risks to justify business decision in the most time-efficient and effective way.
Course Details
• Master Excel Skills: From basic functions to advanced features like PivotTables, learners will gain proficiency in using MS Excel for financial modeling. • Build a Strong Accounting Foundation: Understand financial statements, income statements, and balance sheets. Learn to read annual reports and analyze • Comprehend Income Statements: Explore revenue recognition methods, profit margins, and conduct a detailed analysis using various case studies. • Navigate Balance Sheets: Gain practical insights into current assets, long-term assets, liabilities, and equity. Value inventory, handle prepaid expenses • Comprehensive Cash Flow Analysis: Learn about direct and indirect methods, CFO, CFI and CFF. Engage in practical exercises to calculate various cash flow items • Corporate Valuations: Delve into dividend discount models, income statement forecasting, and enterprise value calculation. • Develop expertise in sensitivity analysis, options, and cost of debt and equity. • Hands-on Financial Modeling: Covering revenue forecasting, cost sheet calculations, cash flow projections, and DCF • Conclude with sensitivity analysis, growth rate considerations, and exit options. • Through a structured approach and real-world examples, it provides a comprehensive journey from fundamental concepts to advanced techniques in fin modeling
Requirements
None
Course Syllabus
Call Now: +233244366801
Course Information
- Course Price: GHC3,500
- Class Start: June 17, 2024
- Course Duration: 5 Days
- Course Capacity: Max 20 Students
- Class Schedule: Mondays - Fridays
- Class Time: 8:30 a.m.
Location & Cohorts
- Location: Gimpa Main
- Cohort: Second Half Cohort
No comments yet
Be the first to write a commnet