Financial Modeling Using Excel Model and project a top-down financial statement for valuation purposes or for analyzing mergers and acquisitions. Focus on incorporating accounting knowledge into the mechanics of Excel, inputting publicly available information and learning various shortcuts to construct a five-year income statement projection model from revenue down to earnings per share. Model discounted cash flow analysis, current market valuation, dilutive options, and a detailed depreciation build-up schedule. Return to the office with a model that can be immediately applied to other companies. Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Excel for Mac will not be as effective. DATE: Thursday, February 19, 2009 TIME: 9:00 a.m.–5:00 p.m. LOCATION: NYSSA 1177 Avenue of the Americas, 2nd Floor (between 45th and 46th Streets), NYC (Directions) Photo ID required for access to the building. INSTRUCTOR: Hamilton Lin, CFA (Instructor Bio) TUITION: Members $520 | Nonmembers $620 LEVEL: Intermediate   CREDITS: CE/CPE = 7