Financial Modelling Master Class for Finance Executives

Picture of Financial Modelling Master Class for Finance Executives
Course Starts in 5 days
August 11 - 14, 2020
N240,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: August 11 - 14, 2020
Registration fee: N15,000 (non-refundable)
Tuition fee: N240,000 (Two Hundred and Fourty Thousand Naira Only)


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


Recommended Courses

Certificate of Proficiency in Spoken and  Written English
Sep
14

Certificate of Proficiency in Spoken and Written English

Learn More

Postgraduate Certificate in Social Entrepreneurship and Innovation
Sep
07

Postgraduate Certificate in Social Entrepreneurship and Innovation

Learn More

Management of Professional Service Firms (PSF) & General Office Administration
Sep
10

Management of Professional Service Firms (PSF) & General Office Administration

Learn More

Enquiry Form