Spring 2024 School of International & Public Affairs U4012 section 001

Financial Modeling in Excel

Call Number 11239
Day & Time
Location
S 10:15am-6:00pm
510A International Affairs Building
Points 0
Grading Mode Pass/Fail
Approvals Required None
Instructor Kenyon S Saverance
Type LABORATORY
Method of Instruction In-Person
Course Description

This intensive one-day workshop develops financial modeling skills through the hands-on construction of an interactive financial model. Using a real company as a case study, the lectures will direct participants to blend accounting, corporate finance and Excel skills to create a dynamic, three-statement financial model. The completed product has five years of projections, three years of historical data and supporting schedules including working capital, debt, equity, depreciation and amortization. Other advanced topics include understanding and controlling circularity errors, troubleshooting, sensitivity analysis and discounted cash flow valuations.

Web Site Vergil
Department International and Public Affairs
Enrollment 38 students (40 max) as of 1:07PM Tuesday, June 25, 2024
Subject School of International & Public Affairs
Number U4012
Section 001
Division School of International and Public Affairs
Open To SIPA
Campus Morningside
Fee $30 SIPA Course Fee
Note Spring 2024 Course Date: March 2
Section key 20241SIPA4012U001