|
Business Financial Modeling and Forecasting Online and Classroom Course
NGN 650,000
|
Venue: 4, Akinpelu Street, Lagos - Ibadan Express Road, Behind ENYO Petrol, Ibafo Bus stop, Ibafo, Ogun State. Online and Class room
This course seeks to give participants a foundation in building financial model and conducting analysis in excel in the areas of feasibility study and business planning, valuing a company for investment purposes, determining the value of a business before buying or selling it, forecasting and budgeting for a product, service, business unit or the entire company.
Learning Objectives:
At the end of this session, participants will be able to:
- Demonstrate practical knowledge and skill in modelling financial statements like Income Statement, Cash flow, Statement of Financial Position;
- Create a background into the principles and application of valuation using discounted cash flow method with Microsoft Excel
Course Outline
- Review of relevant excel functions and formulae
- Excel formulae and functions useful in building financial models
- Debugging /evaluating formula errors
- Building the financial model - income statement - 5 years
- Step by Step building of a financial model
- Model presentation - design/layout and structure
- Best practices in modelling
- Determining fixed assets
- Building discounted cash flow models in excel
- Valuing stocks
- Overview of valuation models
- Conducting analysis - Ratios
- Scenario analysis and Risk Assessment
4, Akinpelu Street, Lagos - Ibadan Express Road, Behind ENYO Petrol, Ibafo Bus stop, Ibafo, Ogun State. Online and Class room | Aug 11 - 13 Aug, 2025 |
NGN 650,000.00 | |
Prof. Richard Mayungbe +1-646-202-8832, 08033467639, 08023019508