Download JNTUH MBA 4th Sem 2018 May Financial Modeling Question Paper

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

HallTicketNo QuestionPaperCode:CMB420
.
.
MBAIVSemesterEndExaminations(Regular)-May/June,2018
Regulation: .?R16
FINANCIALMODELING
Time:3Hours (MBA) MaxMarks: 70
AnswerONEQuestionfromeachUnit
AllQuestionsCarryEqualMarks
Allpartsofthequestionmustbeansweredinoneplaceonly
UNIT?I
1. (a) Calculatethefollowingusingappropriate?nancialfunctionsofexcel:
i. AhasinvestedUS 100in2016. Thepaymenthasbeenmadeyearly. Theinterestrateis $
10%p.a.WhatwouldbetheFVin2019?
ii. MhasinvestedUS 100attheendof2016.Itisexpectedthattheinterestratewillchange $
everyyear. In2017,2018&2019,theinterestrateswouldbe4%,6%&5%respectively.
WhatwouldbetheFVin2019? [7M]
(b) Explaindi?erenttypesofformcontrolsprovidedinexcel. [7M]
2. (a) Listandbrie?yexplaindi?erentattributesofgoodexcelmodel. [7M]
(b) WritethesyntaxofDMAXfunctionandexplaindi?erentargumentsofthisfunctionbytaking
anexample. [7M]
UNIT?II
3. (a) Brie?ydiscussthebene?tsandlimitationsofsimulationmodel. [7M]
(b) Explaintheprocessofsettingupdatavalidation. [7M]
4. (a) Discussthestepsinvolvedincreatingtwovariabledatasets [7M]
(b) Explainhowexcelsupportsthebusinessanalystindevelopingmodelsin?nanceusingsimulation.
[7M]
UNIT?III
5. (a) Brie?ydiscusstheprocessofmodelingthestatementofcash?ows. [7M]
(b) Givethecomparisonbetweenpresentvalueandnetpresentvalue. [7M]
6. (a) IllustratehowtocalculatethepriceofacalloptionwrittenonastockwhosecurrentpriceS=
50,whentheexercisepriceX=45,theannualizedinterestrater=4%,and =30%. The ?
optionhasT=0.75yearstoexercise.AllthreeoftheparametersT,rand areassumedtobe ?
inannualterms. [7M]
(b) Givethedi?erencesbetweentheincomestatementandthecash?owstatement. [7M]
UNIT?IV
7. (a) IllustratetheusageofusingSumIF,CountIFandAverageIFfunctionsinexcelbytakingan
exampleforeach. [7M]
(b) Brie?ydiscussBlackandScholessolutiontotheoptimizationproblem. [7M]
Page1of2
FirstRanker.com - FirstRanker's Choice
HallTicketNo QuestionPaperCode:CMB420
.
.
MBAIVSemesterEndExaminations(Regular)-May/June,2018
Regulation: .?R16
FINANCIALMODELING
Time:3Hours (MBA) MaxMarks: 70
AnswerONEQuestionfromeachUnit
AllQuestionsCarryEqualMarks
Allpartsofthequestionmustbeansweredinoneplaceonly
UNIT?I
1. (a) Calculatethefollowingusingappropriate?nancialfunctionsofexcel:
i. AhasinvestedUS 100in2016. Thepaymenthasbeenmadeyearly. Theinterestrateis $
10%p.a.WhatwouldbetheFVin2019?
ii. MhasinvestedUS 100attheendof2016.Itisexpectedthattheinterestratewillchange $
everyyear. In2017,2018&2019,theinterestrateswouldbe4%,6%&5%respectively.
WhatwouldbetheFVin2019? [7M]
(b) Explaindi?erenttypesofformcontrolsprovidedinexcel. [7M]
2. (a) Listandbrie?yexplaindi?erentattributesofgoodexcelmodel. [7M]
(b) WritethesyntaxofDMAXfunctionandexplaindi?erentargumentsofthisfunctionbytaking
anexample. [7M]
UNIT?II
3. (a) Brie?ydiscussthebene?tsandlimitationsofsimulationmodel. [7M]
(b) Explaintheprocessofsettingupdatavalidation. [7M]
4. (a) Discussthestepsinvolvedincreatingtwovariabledatasets [7M]
(b) Explainhowexcelsupportsthebusinessanalystindevelopingmodelsin?nanceusingsimulation.
[7M]
UNIT?III
5. (a) Brie?ydiscusstheprocessofmodelingthestatementofcash?ows. [7M]
(b) Givethecomparisonbetweenpresentvalueandnetpresentvalue. [7M]
6. (a) IllustratehowtocalculatethepriceofacalloptionwrittenonastockwhosecurrentpriceS=
50,whentheexercisepriceX=45,theannualizedinterestrater=4%,and =30%. The ?
optionhasT=0.75yearstoexercise.AllthreeoftheparametersT,rand areassumedtobe ?
inannualterms. [7M]
(b) Givethedi?erencesbetweentheincomestatementandthecash?owstatement. [7M]
UNIT?IV
7. (a) IllustratetheusageofusingSumIF,CountIFandAverageIFfunctionsinexcelbytakingan
exampleforeach. [7M]
(b) Brie?ydiscussBlackandScholessolutiontotheoptimizationproblem. [7M]
Page1of2
8. (a) Explaindi?erentprepositionsfore?cientportfolionomenclature. [7M]
(b) Brie?ydiscusscommonmethodsfordebuggingExcelVBAcode. [7M]
UNIT?V
9. (a) Listandbrie?ydiscussdi?erentVBAdebuggingtools. [7M]
(b) Explaindi?erentstepsincreatinga?nancialmodelusingexcelandVBA. [7M]
10. (a) Whatisamacrorecorder?Brie?ydiscusstheusesandlimitationsofamacrorecorder. [7M]
(b) ListtheimportantrulesofnamingvariablesinVBA. [7M]
Page2of2
FirstRanker.com - FirstRanker's Choice