B.Com. (Financial Management) Computer Skills for Financial Modeling I Syllabus - Mumbai University
This is the FY BCom FM syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Computer Skills for Financial Modeling - I
Intermediate level Excel for financial Modelling
- Formatting of Excel Sheets, Use of Excel Formula Function
- Advanced Modeling Techniques- Extrapolation, Histogram, Data Filter and Sort, Charts and Graphs, Table formula and Scenario building
- Lookups: V-lookup Match & offset, pivot tables
Analysis of Financial Statements
- Introduction to Financial Statement Analysis.
- Financial Reporting Mechanics; Understanding Income Statement, Balance Sheet; Cash Flow Statement.
- Financial Analysis Techniques; Inventories, Long Lived Assets; Non-Current Liabilities.
- Financial Statement Application; Financial Ratios; Ratio analysis of industries; Du point Analysis.
- Peer to peer analysis; Preparation of Financial Analysis report on an industry.
Reference
- 1 Financial Modelling by Simon Benninga
- 2 Financial Modelling by Paul Pignataro
Reproduced from the University of Mumbai syllabus for B.Com. (Financial Management) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.
The complete syllabus
This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.