B.Com. (Accounting and Finance) Vocational Skills in Accounting and Finance Paper I Introduction to Financial Functions Syllabus - Mumbai University
This is the FY BAF syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based syllabus below alongside it for ATKT candidates, so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Vocational Skills in Accounting and Finance Paper - I Introduction to Financial Functions
Module I: Excel Basics
- 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.
- Understanding financial functions: Present Value, Future Value, Net
Module II: Financial Present Value and Internal Rate of Return and its calculation manual Functions in and using excel Excel
- Depreciation functions: Straight Line Depreciation and Reducing Balance method and its calculation manual and using excel.
Reference Books
- 1 Quick course in Micro-soft office - Joyce Cox, Polly Orban
- 2 Office 2019 complete reference - Stephen L.Nelson
- 3 Rajkamal, Internet and web Technologies, Tata McGraw Hill (2013)
- 4 Mastering Office 2013 - GimiCouster
- 5 Excel with Microsoft Excel: Comprehensive & Easy Guide to Learn Advanced MS Excel 2019 by Naveen Mishra
- 6 Mastering Microsoft Excel Functions and Formulas 2010 by Web Tech Solutions
- 7 Microsoft Excel: Shortcut keys and Formulas 2021 by Kabir Das
Reproduced from the University of Mumbai syllabus for B.Com. (Accounting & Finance) 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.