FINANCIAL MODELING IN EXCEL Workshop
Discounted Cash Flows Valuation

Sunday, February 26, 2012
1pm – 4pm

Accolade East Building, Room 003 (ACE 003)
York University Campus

This workshop will teach how Excel is used in financial modeling.  Participants will be taken through an exercise in valuing a company using a DCF model.

PRE-REQUISITES

Bring a laptop computer with Excel installed

Be able to use Excel at an intermediate level

Skills: entering data and formulas, absolute references, navigating between worksheets

Formulas: AVERAGE, SUM, SUMPRODUCT, GEOMEAN, ROUND, NPV, IF, HLOOKUP, VLOOKUP

Understand Basic Finance and Accounting

Finance: Time Value of Money, Dividend Discount Model, Rate of Return, CAPM, WACC, NPV

Accounting: It is extremely important that you understand the relationship between the three financial statements

Also, read up on the following

DuPont Model: Return on Equity, Return on Assets, Asset Turnover, Profit Margin, Leverage

Finance Concepts: Enterprise Value, EBITDA, Free Cash Flows, Free Cash Flows to Equity, Free Cash Flows to the Firm

Financial Ratios: Liquidity and Solvency Ratios, Working Capital Turnover, Price / Earnings, EV / EBITDA

WORKSHOP SYLLABUS

Industry Analysis
Qualitative Analysis
Assumptions
Financial Model
Discount Rates and WACC
DCF Valuation
Sensitivity Analysis

The NFSA Corporate Networking Night aims to provide top undergraduate students with coveted networking opportunities, and to educate about the CMA designation.

This second annual evening event, sponsored by CMA Ontario, builds on last year’s success, and hosts top students from universities across Southern Ontario and high caliber professionals from a wide range of industries. The event will create a solid opportunity for breaking into YOUR new career.

ATTN: Students registered for the December 2011 CFA Exam.

PASSMAX, an independent exam prep entity with one of the highest CFA exam pass rates in the industry, will be commencing its Level I CFA exam preparation program in July. The first 2 classes of this prep program will be free to members of the NFSA.

The details for these 2 free classes are as follows:

Dates & Topics: Level I:
- Sunday July 24th, 2011: Quantitative Methods.
- Sunday July 31st, 2011: Derivatives.
- (9:45am – 4:45pm, with 1-hour lunch break)

Location: University of Toronto (Downtown campus).

All of the above sessions will be taught by Krikor Ghanaghounian, CFA. Krikor received his charter in 1997 and has taught business and finance to MBA students since 1999 and CFA candidates since 2003. He continues to be a finance instructor at one of the nation’s top-ranked MBA schools.

Seating for these free classes will be very limited. You must be enrolled in the CFA Program in order to attend. To reserve a spot, simply email your name to info@passmax.org

ATTN: Students registered for the December 2011 CFA Exam.

PASSMAX, an independent exam prep entity with one of the highest CFA exam pass rates in the industry, will be commencing its Level I CFA exam preparation program in July. The first 2 classes of this prep program will be free to members of the NFSA.

The details for these 2 free classes are as follows:

Dates & Topics: Level I:
- Sunday July 24th, 2011: Quantitative Methods.
- Sunday July 31st, 2011: Derivatives.
- (9:45am – 4:45pm, with 1-hour lunch break)

Location: University of Toronto (Downtown campus).

All of the above sessions will be taught by Krikor Ghanaghounian, CFA. Krikor received his charter in 1997 and has taught business and finance to MBA students since 1999 and CFA candidates since 2003. He continues to be a finance instructor at one of the nation’s top-ranked MBA schools.

Seating for these free classes will be very limited. You must be enrolled in the CFA Program in order to attend. To reserve a spot, simply email your name to info@passmax.org

Hello Everyone,

Great meeting yesterday I was really feeling the energy in the room and I am optimistic that we’re in a great position going into next year. After many discussions amongst the executive council we finally reached a decision, now with out further adieu here the results.