《2023年JUFEFinModeling.docx》由会员分享，可在线阅读，更多相关《2023年JUFEFinModeling.docx（5页珍藏版）》请在金锄头文库上搜索。
1、FINANCIALMODELING(ExcelApplicationinFinance)Instructor:Dr.MingshengLiAssociateProfessorofFinanceCollegeofBusinessAdministrationBowlingGreenStateUniversity,Ohio,USA:mlibgsu.edu Text:PrinciplesofFinancewithExcel,2ndEdition,2023Oxford(or1stEdition2006) RecommendedText:FinancialAnalysiswithMSExcel,6thEd
2、ition,2023,South-West-CengageLearning,byMayes&Shank. AssignedMini-cases&homework,readingsmaterials(PDFfiles),PowerPointnotes,andotherhandoutsPrerequisites:(1)PrincipleofAccounting;(2)CorporateFinanceCourseDescriptionFinancialModelingisanadvancedcourseinFinance.Toenrollinthiscourse,studentsshouldhave
3、alreadytakenPrincipleofAccountingandCorporateFinance.ThecoursefocusesprimarilyonthedevelopmentofExcelapplicationsandtheu搜索引擎优化fmini-case&projectapproachtosolverealworldproblemsintheareaoffinance.PleasebeawarethatthiscourseisNOTdesignedtodevelopcomplexmathematicalmodelsbuttohelpstudentsexplorethemost
4、widelyusedExcelfunctionsandmaximizetheirlearningoffinanceknowledgethroughpractice.CourseGoalsMicrosoftExcelisoneofthemostwidelyusedanalysistoolsinthebusinessworld.However,moststudentsarenotawaretheimportantroleofExcelapplicationsandlackthebasicExcelskillsneededinthechallengingbusinessenvironmentandt
5、heglobalizingeconomy.TheprimarygoalsofFinancialModelinginclude(1)enhancingstudentsknowledgeintheareasofcorporatefinanceandinvestment;(2)improvingstudentsanalyticalskillsandproblemsolvingabilitythroughspreadsheetdevelopments;(3)enablingstudentstoexploreandbetterunderstandcurrentissuesinfinance,and(4)
6、maximizingstudentslearningopportunitybyapplyingExcelskilltosolvefinanceproblems.Thecourseemploysdifferentmethods(suchasspreadsheetdevelopment,labexercises,andshortprojects,etc.)inachievingthesegoals.Additionally,lecturesarepresentedthroughoutthecoursediscussingthemaintheoriesandissuesinfinanceareasa
7、ndintroducingExcelfunctionsthatarecommonlyusedinfinance.TopicstoBeCovered FinanceTopicsA.FinancialStatement/FinancialConditionAnalysisB.TimeValueofMoneyandSecurityValuations.C.SourceandCostofCapital/CapitalStructureDecisionsD.CapitalBudgetingandInvestmentDecisionsE.SecurityRiskAnalysisandPortfolioMa
8、nagementF.CapitalMarketLine,SecurityMarketLine,CAPMG.BondValuationsandAnalysesH.ValuationofOptions,Arbitrages,etc. ExcelTopicsA.Basicdataprocessingandformattingsuchasconvertingtextandnumericdataitemsandcombiningdifferentformsofdata.B.ProfessionalpresentationandreportfromExcelfilestootherfiles.C.Appl
9、yvariousbasicstatisticfunctionssuchasAverage,Correlation,Countif,Min,Max,Sum,Sumproduct,Slope,Std,Var,etc.,tofinancialproblemsolving.E.CreatedynamictablesandchartsthroughtheextensiveusesofusefulfunctionssuchasV-lookup,H-lookup,Match,Index,Offset,etc.D.Understandandapplymacrostovarioussituations.E.Un
10、derstandanddevelopbasicVBApplications.F.Explorethecreativeu搜索引擎优化fFormControlsandActivexinproblemsolving.LearningOutcomesAftersuccessfullycompletingthiscourse,studentsshouldbeableto:1. Demonstrateaclearunderstandingofbothfinancialtheoriesandanalyticaltechniquesnecessarytomakesoundcorporatefinancialm
11、anagementandinvestmentdecisions;2. Utilizespreadsheetsmoreeffectivelytomakeandpresentcalculationsandanalyses.3. BeabletocreatedynamictablesandchartsthroughtheextensiveusesofusefulfunctionssuchasV-lookup,H-lookup,Match,Index,Offset,etc.GradingEvaluations:Giventhenatureofthecourse,studentswillbeactive
12、lyinvolvedthroughoutthecourse.Caseanalyses,bothwrittenandoral,willberequired.Studentswillbeactivelyinvolvedinusingspreadsheetapplicationstofinancialproblems.Astudentsfinallettergradeinthecoursedependsuponhis/herperformanceinseveralareas:1)writtencasereportandcasepresentations;2)assignedhomeworkandqu
13、izzes,3)participationinclassdiscussions,4)examsandproject.Thecoursegradewillbedeterminedbasedonthefollowingdistribution:GRADINGDISTRIBUTIONMid-term20%(50pts)Final40%(100pts)Group-cases16%(40pts)Individualassignments&participation4%(10pts)TalentProject20%(50PTS)Total100%(250pts)LearningAssessmentDuri
14、ngthesemester,theinstructorwillbecontinuallymonitoringthestudentsperformancetoassessandevaluatetheirprogresstowardstheirlearningoutcomeofthesubjectmatter.Theinstructorsassessmentwillprimarilyconsistofevaluatingthestudentsindividualassignments,performanceasapartofagroup,classparticipations(incasedisc
15、ussionsand/orinthequalityandfrequencyofquestionsasked),casequizzes,andontheresearchpaper(s).Morespecifically,eachstudentwillbemonitoredinthefollowingway:1.Onpresentations:identifyingissues,qualityandthoroughnessofanalysisofissues,therelevanceandcompletenessofsolutionsrecommended(basedupontheanalysis
16、),clarityofpresentationandotherstandardrequirementsofagoodpresentation;2.Oncase&projectreport:writingquality,accuracyofprogramandsolutions,clarityofexplanations,andmanyoftherequirementsnotedabovewillalsobeconsideredforwrittenreport.3.Ontheassignedhomework&quizzes:correctnessofsolutionsandprogram,clarityo
