B.Com. (Actuarial Studies) Skill Enhancement Course Introduction to Financial Functions I Syllabus - Mumbai University
This is the FY BCom Actuarial Studies syllabus under NEP 2020, in force from the academic year 2026-27. It is the only syllabus this degree has ever had: the University approved the course on 18 May 2026 and the first students were admitted the same year, so there is no earlier scheme to check yours against.
Loading syllabus...
Syllabus for Skill Enhancement Course - Introduction to Financial Functions - I
The University prints this paper as “Skill Enhancement Course Paper I (Introduction to Financial Functions)”.
The University's own circular is inconsistent about part of this course. Each mismatch is noted on the module it affects, with the reading the circular's own detailed syllabus gives. The PDF above is that circular's page, unaltered.
Module 1: Excel Basics 15 hours
- Introduction to Excel, Understanding the Excel interface: Tabs and its function, Basic Excel functions and formulas: Arithmetic Operations, SUM Function, Average Function, MAX/MIN Function, Count Function, Use of Artificial Intelligence Tool for generating formulas and custom formatting, Formatting in Excel: Table, Rows and Layout.
Module 2: Financial Functions in Excel 15 hours
MU’s "Modules at a Glance" table names this module "Preparation of Budgets in Excel", which is the Semester II Skill Enhancement Course’s second module. The detailed syllabus below heads it "Financial Functions in Excel", and that is what it teaches. The detailed table is followed here.
- Understanding financial functions: Present Value, Future Value, Net Present Value and Internal Rate of Return and its calculation manual and using excel, Predictive & Analytical Insight: Coefficient of Determination (R²), Basic idea of prediction and forecasting, Residual concept (introductory level), Depreciation functions: Straight Line Depreciation and Reducing Balance method and its calculation manual and using excel.
Cut from the University of Mumbai syllabus for B.Com. (Actuarial Studies) under NEP 2020, in force from the academic year 2026-27. Wording is as printed in that syllabus, and module numbering is as printed there too. The University sets no reading list for this course.
The complete syllabus
This subject is cut from the University circular for its year. Open the document here if you want the whole thing rather than a single subject.