Modeling Financial Statements: B10.3304

Overview

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 and projecting comprehensive 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.

The course will start from conceptual examples that illustrate the key intuition and explain linkages between financial statements. It will then build on these examples to forecast the financial statements of real companies.

Disclaimers

This course is for you if you need to build models for your job. I do not wish to insult you with the statements below, but please do not take this course if the following applies to you:

• You need a review of accounting. This course does not review accounting concepts. It assumes a good knowledge of accounting. The prework described below requires you to review the core accounting course before starting this course.
• You want a textbook for the course. I am writing my own materials, but it will take me two more years before I have anything resembling a book.
• You do not have the time to do the assignments. The course has extensive prework to ensure that you have the skills needed to start. The prework could take between 10-20 hours and is the most time-consuming part of the course. Once the course starts, the assignments could take up to 6-8 hours of work per week. Take a look at ratings to see that at least 33% of the class did not find the workload manageable.
• Your Excel skills are weak. This is not an Excel class. You can learn Excel much cheaper outside a graduate school.
• As announced below, make sure that you can attend the last class because there will be a final exam in the last class. The exam cannot be rescheduled.
• If you are on the waitlist. please read this email from Dean Corfman before contacting me.

Prerequisites

• You need to bring a laptop to class with sufficient battery power to last three hours. If you have any technical questions, please contact the IT department (212-998-0180), NOT me.
• I will be using Excel 2010. Any version from Excel 2003 to 2010 should work for you.
• Make sure that you can connect your laptop to the Stern wireless network.

Help and Office

• Teaching assistants: Contact TAs first. Please do NOT copy me on your messages to the TAs. They are not assigned to any section. However, a suggested assignment is shown below:
  • Morning class: Anthony Pirraglia (anthony.pirraglia@stern.nyu.edu)
  • Afternoon class: Xingshuo Regina Zhao (regina.zhao@stern.nyu.edu)
  • Evening class: sunny.singh. He has several emails. I am trying to sort out which one he wants listed here.
• Me: dgode@stern.nyu.edu, 212-998-0021, Office: KMEC 10-86.
• Administrative assistant: Halima Khan hkhan@stern.nyu.edu 212-998-0003, Office: KMEC 10th Floor

Materials

• I will not require a textbook because I have never found one that covers modeling financial statements in sufficient detail. I am writing my own materials.

Assignments

• Please do not email me to reconfirm any of the statements below.
• The assignments count towards 20% of your grade. If you don't do them carefully, you will bomb the final. I glance at the assignment record before final grading.
• The assignments appear as tests on Almaris.
• See the grading section below. Some assignments are short, others are long. Please manage your time. Click on each assignment to see how to prepare for that assignment.
• NO EXTENSIONS will be granted for any reason except medical or family emergencies. If you have religious or personal conflicts, submit the assignments early. The related materials are covered well in advance of the assignments. Please do not email me to request extensions unless you have a medical or family emergency.
• You can learn concepts from others, but you must work on the actual assignment alone. You may be called upon in class to explain your answer to the assignments.
• All assignments are mandatory. To view the on-line assignments, login at http://www.almaris.com/assess/ using your official Stern email (no aliases) and most recent password emailed to you by Almaris. To retrieve the password, use your Stern email id as it appears in the registrar's records. If you were added to the class list after the initial registration date, see instructions on Blackboard.
• Assignments are marked "late" if you do not meet or exceed the passing score described below before the deadline. There is no additional penalty for lateness other than the low score.
• Assignments have a "passing score" of either 100% or less than 100%.
  • I set the passing score at 100% if I believe that you should be able to ace the assignment. In reality, there is no passing grade. Whatever you get on your last attempt is your final score. That is, you are graded on accuracy but not the number of attempts. If you are allowed five attempts, and you use them, then your score on the fifth attempt is your final score for the assignment. There is a difference between "passing" and getting full credit. If you get 70/100 on your fifth attempt, you "pass" but you don't score a 100.
  • On a few assignments, I set the passing score to be less than 100% if I believe that you may not be able to get every question right. Any score above that score is rounded up to 100%. For example, if the passing score is set at 90%, and you get 93%, then your score is rounded up to 100%. I do the rounding up in a separate spreadsheet. You will see only the raw score on line.
• Almaris is not affiliated with Stern in any way. It is offering these tests to Stern at no charge to Stern.
• Almaris staff is not authorized to extend deadlines under any circumstances. Only my TAs can do that. Almaris staff will reply to your emails only if they pertain to technical issues with the Almaris system. You should contact Stern IT for technical issues with your network.
• Final project

Exams and Grading

• The class relies on your participation. However, you will not be penalized for missing classes. You need NOT email me if you plan to miss a class, be late, or leave early. All classes are videotaped and the link is posted to Blackboard.
• Students make the mistake of assuming that they can learn the material on their own or by watching the video. You cannot learn this material by watching a video. I have noticed a high degree of correlation between attendance and grades. It is a terrible idea to miss a class.
• If you have a qualified disability and will require academic accommodation during this course, please contact me directly. I will arrange a separate room/time for you.

The grades will be based on the assignments (20%), final exam (40%), and project (40%). It is not necessary for you to get a full score on the assignments; any score above 80% is considered a passing score. The final exam will not be rescheduled for any reasons except medical or family emergencies. Work commitments will not be a valid reason for rescheduling.

Schedule

The day classes are held in KMEC 2-90 and the evening class is held in KMEC 4-60.