Cyber Security Online Certification

Introducing

FINANCIAL MODELING IN EXCEL

This module unlocks the power of Microsoft Excel as a useful financial modelling tool. The knowledge of Microsoft Excel has become essential skills for finance practitioners in both financial and non-financial firms. Most of the tasks performed in an organisation require sound and working knowledge of computers, particularly, Microsoft Office, with Microsoft Excel in particular. 

APPLY NOW

Financial Modeling In Excel

Course Details

Background

Financial Modelling is a core skill that is almost mandatory for anyone who wants to build a career in finance. It is also important for anyone who wants to start his or her own business and even useful for sales/marketing professionals as it comes in handy in bidding for projects, determining payback/utility of campaigns etc.

Whenever, we need to make a financial decision, we make a projection of what revenue and costs are likely to be and on the basis of such projections, evaluate if that is a wise decision. In a stock market analysis, we look at the past performance of a company as project what the revenue, costs and profit of the company are likely to be and therefore if we should buy, sell or hold that share.

Rationale

The knowledge gained from this course will significantly increase the marketability of the students and enable them to have a good footing in their working career. The course covers the following topics: Building an excel based model, financial statement forecasting, company valuation, capital asset pricing models, stock and bond valuation, capital structure and dividend policy.
1

Code

FMO111
2

Fees

K3,500 
Groups of more than 5 persons K3,000 per person
3

Location

Online
4

Contact

Coordinator: Mr. K Chungu
Email: kchungu@mu.ac.zm
Phone Number: 0970 349607
5

Dates

6th of October to 20th of October 2021
1730hrs to 1930hrs

Aim

Aim

Objectives

After the completion of this course, students will be able to:

  • Design and build a basic financial model
  • Develop a practical driven approach derived from the theory underlying financial models
  • Understand and apply the in-built formulae to work out financial problems
  • Use financial modeling for concepts of cost of capital, project and company valuation
  • Communicate the financial decision making based on the financial models

Competencies

List od competencies

Entry requirements

You will need a working computer that is able to support Microsoft Excel 2010 version or any later version

Expected prior knowledge

Must have competency in accounting, corporate finance and Microsoft Excel.

COURSE DELIVERY.

Intensive 4 days of  face to face lectures, hands-on practical and tutorials sessions

QUALIFICATION

Qualifications obtained

Course Content

 A famous Chinese proverb reads “I hear, I forget. I see, I remember. I do, I learn”. The structure of the course “Financial Modelling with Spreadsheets” tries to capture the wisdom of this proverb. A typical session consists of three steps. First, the instructor lectures about academic concepts from the fields of Management Science, Accounting and Finance (I hear). Second, the instructor applies these concepts to a particular business situation (I see). Third, the students themselves apply the concepts to a real-world business case with the help of the instructor (I do). Students who have taken this course emphasize as strength that the course structure (lecture + example + workshop) facilitates the learning of otherwise complex quantitative models. The software used in the course is Microsoft Excel, with the add-ins Solver for optimization. We will discuss spreadsheet modelling best practices, and review useful spreadsheet features such as data tables, database operations, pivot tables and charts, the data analysis tool pack, and other statistical built-in functions.

Day

Discussion Topics

Facilitator

Week 1

Introduction 

Introduction to financial modelling

Mr. D. Muchochoma

Week 1

Key Excel functions

Three Statement Financial Modelling

Mr. D. Muchochoma

Week 2

Analysis of Financial Statements

Mr. D. Muchochoma

Week 2

Forecasting Annual Revenues

Credit Risk Modeling

Mr. D. Muchochoma

Lesson Schedule

Lesson Schedule

Teaching Methods

Teaching methods to be used in course

Timing and schedules

Time: 09hrs to 13hrs Thursday to Sunday

Last 4 Days of the Month

Assessment Method

  1. Assignment 30%
  2. Quizzes 10%
  3. Financial Modeling project 60%

Certifications

Mulungushi University certificate will be provided

Upon successful completion, the candidates will be awarded a certificate in Financial Modeling in Excel and a grade appended to the certificate. This qualification will only apply to a student who passes the project and completes the assignment or quizzes.

Connect with us

26 km from Kabwe Town along Great North Rd, Kabwe, Central Province, Zambia

  • dummy+(260) 215 228 004

  • dummy academic@mu.ac.zm

Newsletter

Enter your email and we'll send you more information

Search