Financial Modelling Master Class for Finance Executives

Picture of Financial Modelling Master Class for Finance Executives
Course Starts in 1 month
October 16 - 19, 2018
N250,000

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: October 16 - 19, 2018
Registration fee: N15,000 (non-refundable)
Tuition fee: N250,000 (Two Hundred and Fifty Thousand Naira Only)


pdfDownload Brochure
For Further Enquiries, Contact: registrar@ism.edu.ng,  08090890909, 08085369898, 08085369976, 08086815957
Register Online   Recommend Programme  


Recommended Courses

Health Safety and Environment Management (HSEM)
Sep
17

Health Safety and Environment Management (HSEM)

Learn More

Positive Influencing Skills
Sep
17

Positive Influencing Skills

Learn More

Petroleum Economics and Fiscal Contract Systems in Oil & Gas
Dec
03

Petroleum Economics and Fiscal Contract Systems in Oil & Gas

Learn More

Enquiry Form