| Course Name | Financial modelling |
| Course Code | 24COM242 |
| Program | B. Com. (Honours) in FinTech |
| Credits | 3 |
| Campus |
Understanding the Basic Features of Excel
Introduction to modelling, introduction to excel, understanding advanced features of excel database functions in excel, creating charts, using forms and control toolbox, understanding finance functions present in excel, creating dynamic models.
Sensitivity Analysis Using Excel
Scenario manager, other sensitivity analysis features, simulation using excel different statistical distributions used in simulation generating random numbers that follow a particular distribution, building models in finance using simulation.
Preparing common size statements directly from trial balance, forecasting financial statements using excel, analysing financial statements by using spreadsheet model, excel in project appraisal, determining project viability. Risk analysis in project appraisal, simulation in project appraisal, excel in valuation, determination of value drivers, discontinued cash flow valuation, risk analysis in valuation.
Excel in Portfolio Theory
Determining efficient portfolio, creating dynamic portfolios, portfolio insurance, fixed income portfolio management using excel, excel in derivatives black and schools model in excel, Greeks in excel, real options valuation, building a mega model.
Understanding Subroutines and Functions and Building Simple Financial Models Using Subroutines.
Recording and editing macros, subroutines and functions, decision rules, message box and input box, debugging, designing advanced financial models using visual basic application user forms, other advanced features, actual model building.
Course Objective:
The objective of this course is to give an overview of various aspects of financial modelling.
Course Outcome:
The students will able:
CO1: To understand the financial modelling in excel, understanding advanced features of excel database functions in excel, creating charts, using forms and control toolbox.
CO2: To create awareness for students about the present scenario of manager and sensitivity analysis features.
CO3: To make use of excel sheet to prepare common size statements directly from trial balance and also forecasting the financial statements and to analyse the risk in project appraisal, simulation in project appraisal; excel in valuation, determination of value drivers, discontinued cash flow valuation, risk analysis in valuation.
C04: To determine efficient portfolio, creating dynamic portfolios, portfolio insurance and fixed income portfolio management using excel.
CO5: To interpret the recording and editing of macros, subroutines and functions in excel and explain how to design an advanced financial model using visual basic application user forms.
|
PO1 |
PO2 |
PO3 |
PO4 |
PO5 |
PO6 |
PO7 |
PO8 |
PO9 |
PO10 |
PO11 |
PO12 |
PO13 |
PO14 |
PO15 |
|
|
CO1 |
3 |
2 |
1 |
0 |
2 |
1 |
0 |
1 |
2 |
0 |
1 |
2 |
3 |
1 |
0 |
|
CO2 |
1 |
3 |
2 |
1 |
0 |
2 |
1 |
0 |
1 |
2 |
0 |
1 |
2 |
3 |
1 |
|
CO3 |
0 |
1 |
3 |
2 |
1 |
0 |
2 |
1 |
0 |
1 |
2 |
0 |
1 |
2 |
3 |
|
CO4 |
2 |
0 |
1 |
3 |
2 |
1 |
0 |
2 |
1 |
0 |
1 |
2 |
0 |
1 |
2 |
|
CO5 |
1 |
2 |
0 |
1 |
3 |
2 |
1 |
0 |
2 |
1 |
0 |
1 |
2 |
0 |
1 |
References:
Francis J. Clauss – Corporate Financial Analysis with Excel – McGraw Hill
Christian Albright- VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel – Cengage
Chandan Sengupta – Financial Analysis and Modelling Using Excel and VBA – Wiley
DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.
