B.Com. (Actuarial Studies) Vocational Skill Course Data Visualization 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 Vocational Skill Course - Data Visualization - I
The University prints this paper as “Vocational Skill Course Paper I (Data Visualization)”.
Module 1: Introduction to Data Visualization 15 hours
- Meaning, Need, Importance and Principles of Data Visualization.
- Types of Financial Data Visualization: Line charts, Bar charts, Pie charts, Histogram, Scatter Plot, Area Chart, Radar Chart and Candlestick Charts. (Need and when to use them)
- Creating and reporting data using Line charts, Bar charts, Pie charts, Histogram, Scatter Plot, Area Chart, Radar Chart and Candlestick Charts with Excel/ other tools
- Pivot Tables and Pivot Charts, Remove Duplicates, Conditional Formatting, Charts of Various Kinds, Data Validation
Module 2: Theory and Excel Application of Interest Rates, Annuity, Financial Models Project Appraisal, Securities and Term Structure 15 hours
- Theory of interest rates: Describe effective interest rates, discount rates, accumulation and discounting. Explain Present value and accumulation value. Describe nominal rate of interest, force of interest and their applications. Describe real rate of interest and money rate of interest.
- Annuity: Explain level annuity and increasing annuity. Find present value and future values of annuity.
- Loan Schedules: Find loan schedule structure by equating annuity payments. Use the formulas of interest component, capital component, loan outstanding (Prospective and Retrospective methods). Describe flat rate of interest and Annual Percentage Rate.
- Project Appraisal: Use Net Present Value, Internal Rate of Return and Discounted Payback Period to appraise a financial project.
- Bonds: Describe Zero coupon Bond, Fixed interest bonds and index linked bonds. Describe the effects of income tax, capital gain tax and variable redemption dates on price and yield of Bonds.
- Property and equity: Calculate the price of property and equity
- Explain Financial functions in Excel (DB,PV, FV, NPV, IRR, RATE, YIELD)
- Use Excel Functions to create annuities and increase annuity.
- Use Excel Functions to create loan schedules.
- Use Excel Functions to appraise financial projects.
- Use Excel Functions to find the price and yield of bonds.
- Use Excel Functions to use Inflation Index and term structure of interest rates for bond pricing.
- Use Excel Functions to calculate price of property and equity
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.