Download JNTUH MBA 4th Sem 2019 April Financial Modeling Question Paper

Download JNTUH (Jawaharlal Nehru Technological University Hyderabad) MBA Fourth Year (4th Semester) 2019 April Financial Modeling Question Paper.

HallTicketNo QuestionPaperCode:CMB420
.
.
MBAIVSemesterEndExaminations(Regular)-April,2019
Regulation: .?R16
FINANCIALMODELING
Time:3Hours (MBA) MaxMarks: 70
AnswerONEQuestionfromeachUnit
AllQuestionsCarryEqualMarks
Allpartsofthequestionmustbeansweredinoneplaceonly
UNIT?I
1. (a) Explainthestepsthatarefollowedincreatingamodel. [7M]
(b) Whatis?nancialmodel?Explainanytwotypesof?nancialmodel. [7M]
2. (a) Discussstepsinvolvedincomputingaverageofnumbersfromadatasetgiven. [7M]
(b) Explainadvancedfeaturesofexcel.Ifwewanttoaddadatalabelsinchart,whatistheprocedure
tobefollowed. [7M]
UNIT?II
3. (a) ExplainsensitivityanalysisofgoalseekinExcel. [7M]
(b) Discussthestepsinvolvedincreatingtwovariabledatasetsforstatisticaldistributions. [7M]
4. (a) ExplaintheformulateSyntaxanditsuse?=NORMINV(RAND(),B2,C2),?ahypothetical
syntax. [7M]
(b)Howexcelsupportsthebusinessanalystindevelopingmodelsin?nanceusingsimulation.
[7M]
UNIT?III
5. (a)De?neprojectappraisal.Explainthekeystepsindevelopinga?nancialstatementmodel.[7M]
(b)Explainthestepstopreparetrailbalancestatementusingexcelfordeterminingprojectviability.
[7M]
6. (a)Assurethatyouhavebeengivenhistoricalstockpricesofoneyear. Explainstepsinvolvedin
developingamodeltosimulatetheexpectedreturnandvolatilityofthestock. [7M]
(b)WritetheformulaeforNetPresentValue(NPV)equation. Explainhowdoyousubstitutethe
valuesinexcel. [7M]
UNIT?IV
7. (a)Explainthestepsinvolvedindevelopingblackandschoolsmodeltopriceoptionsinexcel.[7M]
(b)Determinee?cientportfolioandcreatevarioustypesofportfoliosof?xedincomeportfolioman-
agementusingexcel. [7M]
Page1of2
FirstRanker.com - FirstRanker's Choice
HallTicketNo QuestionPaperCode:CMB420
.
.
MBAIVSemesterEndExaminations(Regular)-April,2019
Regulation: .?R16
FINANCIALMODELING
Time:3Hours (MBA) MaxMarks: 70
AnswerONEQuestionfromeachUnit
AllQuestionsCarryEqualMarks
Allpartsofthequestionmustbeansweredinoneplaceonly
UNIT?I
1. (a) Explainthestepsthatarefollowedincreatingamodel. [7M]
(b) Whatis?nancialmodel?Explainanytwotypesof?nancialmodel. [7M]
2. (a) Discussstepsinvolvedincomputingaverageofnumbersfromadatasetgiven. [7M]
(b) Explainadvancedfeaturesofexcel.Ifwewanttoaddadatalabelsinchart,whatistheprocedure
tobefollowed. [7M]
UNIT?II
3. (a) ExplainsensitivityanalysisofgoalseekinExcel. [7M]
(b) Discussthestepsinvolvedincreatingtwovariabledatasetsforstatisticaldistributions. [7M]
4. (a) ExplaintheformulateSyntaxanditsuse?=NORMINV(RAND(),B2,C2),?ahypothetical
syntax. [7M]
(b)Howexcelsupportsthebusinessanalystindevelopingmodelsin?nanceusingsimulation.
[7M]
UNIT?III
5. (a)De?neprojectappraisal.Explainthekeystepsindevelopinga?nancialstatementmodel.[7M]
(b)Explainthestepstopreparetrailbalancestatementusingexcelfordeterminingprojectviability.
[7M]
6. (a)Assurethatyouhavebeengivenhistoricalstockpricesofoneyear. Explainstepsinvolvedin
developingamodeltosimulatetheexpectedreturnandvolatilityofthestock. [7M]
(b)WritetheformulaeforNetPresentValue(NPV)equation. Explainhowdoyousubstitutethe
valuesinexcel. [7M]
UNIT?IV
7. (a)Explainthestepsinvolvedindevelopingblackandschoolsmodeltopriceoptionsinexcel.[7M]
(b)Determinee?cientportfolioandcreatevarioustypesofportfoliosof?xedincomeportfolioman-
agementusingexcel. [7M]
Page1of2
8. (a)Explainthestepsinvolvedinhighlightingcellswithavalueoflessthan20fromagivendataset.
[7M]
(b)Explainthefollowing?nancialfunctions:i)DISCii)Durationiii)NetPresentValue(NPV)
[7M]
UNIT?V
9. (a)WhatisMacro?s.DiscusshowMacro?scanberecordedandedited. [7M]
(b)Whatisdebugging?Explainfewsyntaxerrorsandwaysofdebuggingit/them. [7M]
10. (a)Brie?yexplainaboutdesigningadvancedin?nancialmodelsusingvisualbasicapplicationuses
forms. [7M]
(b)Explainadvancedfeaturesofactualmodelbuildinganddecisionrulesoffunctions. [7M]
Page2of2
FirstRanker.com - FirstRanker's Choice