NMIMS Global Access
School for Continuing Education (NGA-SCE)
Course: Quantitative Methods for Valuation
Internal Assignment Applicable for December 2020 Examination

(a) Prepare a table of descriptive statistics for each of these banking groups and explain in
brief about the trends that you observe.

(b) Make a regression model with advances as dependent variable and deposits as the
independent variable. Compute the results separately for each of the banking group and
discuss in brief about the results.
(c) Discuss the lacunae in a bi-variate regression model in the context of the analysis done in
(b). (10 Marks)

1.
(a) Estimate a regression model with Advances as the dependent variable and borrowings,
operating expenses, physical capital and interest expense as the independent variable.
Give a brief analysis of the results observed and inferences made from the model.
(b) Modify the model in 2(a) with deposits as an additional explanatory variable.
(c) If you are to choose one model (a) or (b), which one would you pick. Give rationale for
the choice of your model.
(10 Marks)

2. Case –
Every IPL auction is a constrained optimization problem for all the franchise
management. Every team hires top end analysts to help them in arriving at a decision –
choice of players and valuation. Assuming you are being hired as an analyst for the
auction by a franchise;
a. Prepare a model that you would be using to help the decision making process during the
auction. Focus of this section should be on choice of the model, its variables and the
source of data for the variables chosen. (5 Marks)

NMIMS Global Access
School for Continuing Education (NGA-SCE)
Course: Quantitative Methods for Valuation
Internal Assignment Applicable for December 2020 Examination

b. Write a brief essay to defend the choice you are making with detailed arguments.
Rationale for the model and variables.