loader image
Skip to main content
  • BAC4311 Financial Modeling and Forecasting
    0%

Focus Mode is ON. Click on the ‘collapse icon’ to close it.

  • Previous
  • Course data
    Introduction
    Download Online Resourses
    Join the Zoom Online Class
    Financial Modelling and Forecasting Module
    BAC4311 Scheme of Work for Semester 2 2025
    Optimisation Techniques using the Solver
    Unit One: Introduction to Excel Tools for Modelling
    Lecture Notes: Unit One Slides
    Tutorial 1: Excel Tools for Modelling
    Unit Two: Basics of Financial Modelling and the Business Environment
    Lecture Notes: Unit Two Slides
    Tutorial 2: Absolute and Relative Referencing
    Unit Three: Classification of Financial Models
    Lecture Notes: Unit Three Slides
    Tutorial 3: Budgeting
    Stocastic Model - Video
    Unit 4: Steps for Building Financial Models
    Lecture Notes: Unit Four Slides
    Video: Dashboard Modelling Example
    Unit 5: Role of Assumptions in Financial Modelling
    Lecture Notes: Unit Five Slides
    Video - Dashboard Modeling
    Video - Using VBA and Macros in Excel
    2025 Assessments
    2025 Assignemnt 1 Logbook 1 - Submission Link
    Class Exercise (5 marks of the Final 60 marks)
    2025 Assignment 2 Logbook Exercise 2 Case Study
    Assignment 1 Logbook 2 Submission Link
    CASE STUDY/QUESTIONS: S2 2025 FINAL Logbook Assignment 3 Financial Forecasting and Optimization
    S2 2025 FINAL Logbook Assignment 3 Financial Forecasting and Optimization -SUBMISSION LINK
    Unit 6: Decision Support Applications of Modelling
    Lecture Notes: Unit Six Slides
    Video - Profit and Loss Dashboard Example
    Unit 7: Effective Management of Historic Data in Excel
    Lecture Notes: Unit Seven Slides
    Video - Pivot Tables and Indexing
    Tutorial - Pivoting and Indexing in Exel
    Unit 8: Sensitivity Analysis and Scenarios using Excel
    Lecture Notes - Unit Eight Slides
    Unit 9: Princincles of Forecasting and Time Series Analysis
    Lecture Notes - Unit Nine Slides
    Unit 10: Determining Trends, Cycles and Seasonality
    Lecture Notes - Unit Ten Slides
    Unit 11: Optimization Techniques in Models using Excel
    Video - Cost Optimisation Example
    Video - Price Optimization Example
  • Next
  • Categories
    • All categories
    ZCAS UNIVERSITY
    School of Computing, Technology and Applied Sciences
    • Department of Information Technology and Systems
    • Department of Applied Sciences
    • Department of Computer Sciences
    School of Social Sciences
    • Department of Economics
    • Department of Management
    • Short Learning Programs
    • Department of Education
    School of Business Studies
    • Department of Banking and Finance
    • Department of Business Administration
    • Department of Accounting
    School of Law
    • Department of Law
    • Zamcol
    • Graduates
    • ODeL Centres
    • ICT Course
  • Home
  • TimeTables
  • Announcements
  • Important Documents
Log in
Forgot your password?
Categories Collapse Expand
  • All categories
ZCAS UNIVERSITY
School of Computing, Technology and Applied Sciences
  • Department of Information Technology and Systems
  • Department of Applied Sciences
  • Department of Computer Sciences
School of Social Sciences
  • Department of Economics
  • Department of Management
  • Short Learning Programs
  • Department of Education
School of Business Studies
  • Department of Banking and Finance
  • Department of Business Administration
  • Department of Accounting
School of Law
  • Department of Law
  • Zamcol
  • Graduates
  • ODeL Centres
  • ICT Course
Home TimeTables Announcements Important Documents
Skip Main menu

Main menu

  • forum icon
    PRINT EXAM DOCKET GUIDE Forum
  • forum icon
    PAST PAPERS Forum
  • folder icon
    EXAM TIMETABLES / CLASS TIMETABLES Folder
  • url icon
    CLASS TIMETABLES URL
  • resource icon
    UPDATED FEES FOR SEMESTER TWO 2025- UNDERGRADUATE AND POST GRADUATE File
  • folder icon
    All Announcements Folder
  • url icon
    Full-Time and Part-Time Timetables URL
  • folder icon
    Important Documents Folder
  • resource icon
    STUDENT UNION NOTICE File
  • url icon
    STUDENT SATISFACTION SURVEY URL
  • resource icon
    ZCASU ALUMI File
  • resource icon
    ZCAS UNIVERSITY NEWSLETTER ISSUE #03/2023 File
  • resource icon
    ZCAS UNIVERSITY NEWSLETTER ISSUE #03/2023 File
    • Site Files (USE THIS FOR ALL SITE WIDE FILES) Site Files (USE THIS FOR ALL SITE WIDE FILES)
      • zcasu career day poster 2.pdf zcasu career day poster 2.pdf
  • resource icon
    Student Guidelines on Taking Quizzes File
  • folder icon
    Bill Muster Folder
  • resource icon
    Timetables File
  • resource icon
    Timetables (copy) File
  • resource icon
    Student Union Applications File
  • folder icon
    ACCOMMODATION Folder

                        Welcome To ZCASU eLearning Portal Click here to view Links to Timetables.

                          Please Make sure to UPDATE YOUR MODE OF STUDY UPON LOGIN.

Click here to access the 2025 Semester 2 Online Orientation

                                                  Click here to view the Distance Timetable.                                               
Click here to view the Full-time/Part-time Timetable.

    Course info

    BAC4311 Financial Modeling and Forecasting

    Skill Level: Beginner

    Contact site support
    You are not logged in. (Log in)
    Data retention summary
    Get the mobile app

    kipaswin

    bosjoko

    Powered by Moodle


    MISSION
    MISSION

    To produce world-class graduates through effective development and delivery of industry-responsive learning programmes using highly skilled staff and cutting-edge

    Links
    Moodle
    Student Information System
    e-Resources
    Links


    SOCIAL MEDIA
    SOCIAL MEDIA


    Like and Follow👍

    © 2026 ZCAS UNIVERSITY. All Rights Reserved.