I have decided to record all my classes for the entire semester using Mediasite and not require in-person attendance. The recordings will be auto-posted to Brightspace. I dislike recordings intensely because they constrain what I say and ruin the classroom interaction, but I have to balance that against Covid infections.

Please contact NYU IT (askit@nyu.edu, 212-998-3333) or NYU Stern IT (helpdesk@stern.nyu.edu, 212-998-0180) for all ZOOM/email/NYU Brightspace/Admin/CapitalIQ issues. Please do not copy/contact me regarding such issues. If NYU/Stern support cannot help you, please contact Student Affairs/Dean's office. All emails are sent to the email address in the NYU Brightspace roster. NYU Brightspace lists @nyu.edu email for some of you and @stern.nyu.edu email for others. This mess is beyond my control. Please contact NYU/Stern support to learn how to read/forward/check spam for @nyu.edu and @stern.nyu.edu accounts. Their instructions are rather poor. Students do not realize that they are logged in as a Stern student and think they are checking their NYU email when they are still checking NYU Stern's email. Please use a new browser to ensure that you check NYU's email. Do not write to Almaris or me if you are not getting Almaris emails sent to the NYU email address because this issue is between NYU and you.

Please make sure you read the Announcement in NYU Brightspace for this course and read the details about highly recommended prework.

Overview

MBA ACCT-GB-3304 Specializations:

Various management disciplines teach you how to analyze and forecast parts of a business. Building on this foundation, this course will help you weave your forecasts into coherent spreadsheet-based pro-forma financials. Modeling financial statements provides a reality check on the forecasts, enables “what if” analysis, provides an integrated view of the business, and is a key step in valuation and credit risk analysis.

The course is indispensable to careers in investment banking, private equity, buy-side or sell-side research, credit research, corporate finance, valuation, project finance, and due diligence advisory. It gives a competitive edge during interviews, internships, and jobs. First-year and second-year students can both take this course.

Help and Office

Prerequisites

Administrative Issues

Materials and Course Design

Almaris Assignments

Exams and Grading

Important computer tips for the final

Schedule

Module Topic
1

Deriving cash flows, enterprise or unlevered cash flows

2

Building blocks of models; Linking cash flow forecasts to value

3

Designing models, Customers; Suppliers, employees, and other expenses

4

Multiperiod models: Long-term accruals and deferrals

5

Excel tools for scenario analysis; Capacity: PP&E and depreciation

6

Modeling taxes

7

Modeling financing

8

Time value of money and bonds

9

Integrative analysis

10

Which cash flows should one discount

11

Prioritizing assumptions in models; sensitivity analysis