AceBridgeEDU财务模型培训.ppt

1、ICE-BREAKING FINANCIAL MODELING CAREER ADVICE,ICE-BREAKING,PKU GoodBuy,SJTU Time Machine,Fudan Give Me Five,SUFE SAVVY,Tsinghua LEVEAGE,Tsinghua AA To Buy,SJTU Team of Dream,Tsinghua SkyRocket,Fudan 刚好三加一,PKU 1%,ICE-BREAKING,FIND YOURSELF- Props: A4 paper / Pen / Sellotape- Process: Write down your

2、self-assessment first 1min Help each other to post it on your back Music! Invite more and more people to write down their comments for you, please keep objective 5min Volunteer to do self-introduction on the stage to share the REAL YOU,Please think about- WHY different?- WHAT is the consequences?- H

3、OW to adjust to keep the consistence?,ICE-BREAKING,ICE-BREAKING FINANCIAL MODELING CAREER ADVICE,FINANCIAL MODELING,Financial Modeling,Scenario: working on a financial model to capture all the financial changes and valuation Excel Basics Financial Statement Analysis Financial Modeling Prepare an Int

4、egrated Financial Statement Forecast Integrity Checking Editing Modeling with speed and style Trading comparables DCF valuation method,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A M

5、odel,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Buildi

6、ng A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,

7、Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A

8、Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Build

9、ing A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model

10、,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Building A Model,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Finan

11、cial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated

12、 Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Inte

13、grated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare a

14、n Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Pre

15、pare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Foreca

16、st,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement

17、Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Stat

18、ement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,Prepare an Integrated Financial Statement Forecast,VALUATION,Valuation is key to many areas of Finance,How much should you pay for a

19、 business in an M&A transaction (investment banking) Is the value fair? (fairness opinion) Acquisition divestiture advice Break-up value of the business versus combined value Do you think the price of a stock is reasonable (equity research) How much can you sell a companys shares for (equity capital

20、 market) How much can a private equity house pay for a business (financial sponsors and leverage finance),Valuation Roadmap,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valu

21、ation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,

22、DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,DCF Valuation,ICE-BREAKING FINANCIAL MODELING CAREER ADVICE,CAREER WALKTHROUGH,A KILLER RESUME,Initial Review Only 30

23、seconds General Scanner quick scan / matching the criteria Spike Seeker love highlights / 1-2 strong unique traits Idealist an ideal in mind already / looking for some elements,A KILLER RESUME,Critical Big 4: Banking Quantitative / analytical ability Drive for results Communication skills Team playe

24、r mentality Others: Relevant industry or functional experience Leadership capability or potential Knowledge of financial services Ability to balance multiple responsibilities Client oriented Top schools Interesting activities,A KILLER RESUME,The Role of Cover Letter Insiders overwhelmingly indicate

25、that little, if any, attention is paid to cover letters. Sometimes theyre read, sometimes not. Because of this, a cover letter is almost more of a courtesy than a necessity (though we would not advise submitting a resume through the mail or e-mail without including a cover letter). One insider says,

26、 “We do look at them, but we skim rather than read them.”,A KILLER RESUME,Anatomy Focus: Customize Sequence: Education / Experience / Others DONT include Career Objective, Summary or other general overview Content GPA: % Short on description & Long on results,Examples,A KILLER RESUME,Examples,A KILLER RESUME,Formatting 1 page only Standard font Readable type size Neutral paper color Standard layout Clear resume organization Clear cover letter organization,A KILLER RESUME,A KILLER RESUME,STAR MODEL,To Deliver a STAR SITUATION TASK ACTION RESULT,Presentation,Maximize how you look Ey