Wall Street Financial Model Training Sample.pdf

《Wall Street Financial Model Training Sample.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、FinancialStatementModelingCopyright2008©byWallStreetPrep,IncCopyright2008©byWallStreetPrep,Inc.

2、Allrig.

3、Allrightsreservedhtsreserved*****************************SAMPLEPAGESFROMTUTORIALGUIDE*****************************TableofcontentsSECTION1:PREPARINGFORMODELINGDebtscheduleWelcomeletterInterest

4、expenseIntroductionGatheringhistoricaldocuments/informationSECTION3:ENHANCEMENTSTOAUnderstandingprojectionsCOMPLETEMODELModelingtechniquesinExcelBalancingthemodelandcircularityRatioanalysisSECTION2:BUILDINGAFINANCIALFormtoggles,sensitivityandscenarioanalysisSTATEMENTMODELIncomestatement–histori

5、calsIncomestatement–projectionsBalancesheet–historicalsBalancesheet–projectionsWorkingcapitalscheduleDeferredtaxesIntangibleassetsProperty,plant,&equipmentTreasurystockandsharesoutstandingMinorityinterestsandequityinaffiliatesGoodwillandotherbalancesheetitemsRetainedearnings********************

6、*********Cashflowstatement–projectionsSAMPLEPAGESFROMTUTORIALGUIDE*****************************UnderstandingprojectionsExampleofadriver(simplesalesdriver)•Takethelastreportedyear’ssalesgrowthrate,andprojectthatgrowthratetofutureyears(called“straight-liningprojections”)Calculation(blackcells)For

7、mulainExcel=E3*(1+F4)CalculationsHistoricalinputs(blackcells)Simpledriver(bluecells)(bluecells)We’lldiscussformattingrulesextensivelyinthenextsection.*****************************SAMPLEPAGESFROMTUTORIALGUIDE3ForillustrativePurposesOnly*****************************Copyright©2007byWallStreetPrep,

8、Inc.ModelingtechniquesinExcelFormatting(cont’d)•Maintainstandardformattingofnumbersthroughoutyourmodel•Maintainstandardformattingofworksheetsthroughoutyourmodel•Maintainstandardcolumnandrowheadingsacrossmultiplesheets$signonlyshownonfirstrowofworksheetandhighlightedfinancialresultsNegativenumbe

9、rsshowninparenthesisEPSandsharepricedata:alwayscarryto2decimals($25.43)*****************************SAMPLEPAGESFROMTUTORIALGUIDE4ForillustrativePurposesOnly*****************************Copyright©2007byWallStreetPrep,Inc.Modelingte