Financial Modelling Master Class for Finance Executives
Our Financial Modelling Master Class for Finance Executives is a professional development and proficiency course designed as a combination of a series of “hands-on” modules in finance and accounting based on extensive use of computers and spreadsheets. Its general objective is to develop spreadsheet and management skills for creating computer-based models for analyzing a variety of decision problems facing today’s financial managers and professionals The course presents the theory and practice of financial management, emphasizing computer-based modelling and forecasting using Microsoft Excel (MS) spreadsheets and/or other software products to analyze the impacts of financial decisions in financial statement analysis, cash budgeting, and cost of capital determination, capital budgeting, and capital structure choices. The course covers a variety of techniques, such as sensitivity and scenario analysis, optimization methods, Monte Carlo simulation, and regression analysis.
Students will learn how to create computer-based models to prepare, analyze, and use financial statements; to conduct financial ratio analysis; to calculate financial and operating leverages; to prepare cash budgets; to create sinking funds and evaluate loan and mortgage repayment schedules; to determine the cost of capital; to evaluate net present values,rates of return, and break-even points for various types of capital investments; to analyze investment payoffs and risks; to evaluate stocks and bonds; to manage stock and bond portfolios; and to evaluate put and call stock options.
This course is an exposition the use of spreadsheet tools and techniques, such as a number of financial and statistical command functions, what-if scenarios, one- and two-way input tables, optimization, Monte Carlo simulation, and regression analysis. Students will learn how to use logical IF statements, to custom format cells, and to conditionally format cells so as to highlight areas where management attention is needed.
In addition to teaching how to use spreadsheets to calculate correct answers, the course emphasizes the preparation of spreadsheets in formats that can be easily understood. It shows how to create various types of charts that communicate results clearly and make convincing management presentations.
Students will learn how to link the cells in spreadsheets, how to link separate spreadsheets to one another, and how to paste or embed spreadsheets in Word documents, with or without linkages between the spreadsheet and Word document.
Registration and Contact Details
|Date:||July 16 - 19, 2019|
|Registration fee:||N15,000 (non-refundable)|
|Tuition fee:||N270,000 (Two Hundred and Seventy Thousand Naira Only)|
|For Further Enquiries, Contact: firstname.lastname@example.org, 08090890909, 08085369898, 08085369976, 08086815957|
|Register Online Recommend Programme|