Overview

Course code: ACCT-UB.0003

This course helps you understand the flow of money in a business and its link to shareholder value and credit ratings. The course presents a framework for analysis and provides spreadsheets to implement the framework. All materials are available for free at http://www.godeohlson.com/. Eight core spreadsheets that help addresses the following questions:

Attendance and penalty for missing classes

Requiring attendance is necessary for several reasons. First, you incorrectly assume you can catch up on a missed class by watching a recording (if available). Videos do not engage your brain as much as a live class. Second, less than 20% of you watch the recording (if available). You are then lost in class, which provides wrong signals to me as an instructor. Third, your absence hurts class discussions. Fourth, you miss out on feedback if you do not work through the questions I pose in class. Fifth, I lose the feedback since there are fewer questions.

The policy below will be in effect only after the add/drop period.

Without mandatory attendance, attendance is often below 50%. Therefore, though I dislike doing this, I penalize absences. If you anticipate being absent for good reasons, please email me well in advance. Please enter "Excused" on the attendance sheet described below to avoid the penalty if I approve. If you miss a class due to emergencies and cannot tell me in advance, do not panic. Take care of the emergency first, and then email me. I will permit you to change the "Absent" to "Excused." But, if you miss a class without a valid reason, there is a penalty, as stated below.

For sections meeting in 150-190 minute sessions, you will lose one grade (A to A-, A- to B+, B+ to B, B to B-, and so on) for EVERY missed session unless you were explicitly excused via email. Thus, if you miss two class sessions, you will lose two grades, and so on.

For sections meeting in 75-80 minute sessions, you will lose one grade (A to A-, A- to B+, B+ to B, B to B-, and so on) for EVERY TWO missed sessions unless you were explicitly excused via email. Thus, if you miss four class sessions, you will lose two grades, and so on.

Please sit in the same seat in every class and display your name tags. For Zoom classes, you must keep your video on AT ALL TIMES. You must also have a good working headset or mic, as it is extremely rude to be inaudible and force me to ask you to repeat yourself. After entering the class, please mark yourself present in the first 20 minutes on the OneDrive sheet (link posted on Brightspace). You will be marked absent if you are more than 20 minutes late unless it is because of factors beyond your control (traffic, subway, interviews running late). You will also be marked absent if you leave the class early unless you have my permission or get it afterward. You will get an F in the course if you are caught cheating on the attendance sheet.

Financial Statement Analysis Spreadsheets

Valuation Spreadsheets

Materials

Prerequisites

Help and Office

Materials

Assignments

Exams and Grading

The grades will be based on the assignments (20%), midterm exam (30%), and final (50%). If your score on the midterm is poor, but the final score is good, your final will count towards 100%. You need not 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 reason except medical or family emergencies.

Schedule

All classes will be held in KMC 4-80 on Tu and Th from 9:30 AM to 10:45 AM except during the spring break.

Midterm: 30%

Final: 50%

Class Topic
1
  • Introduction to FSA
  • Link between modeling and FSA
2
  • Unlevered versus levered analysis and the link to DCF
3
  • Six key value drivers
4
  • Analyzing sales growth
5
  • Analyzing margins
6
  • Analyzing the ratio of operating assets to sales
7
  • Analyzing the ratio of operating liabilities to sales
8
  • Analyzing liquidity
9
  • Analyzing leverage
10
  • ROI metrics: ROE and ROIC
11
  • Price-earnings ratio, price-to-book ratio, and dividend yield
12
  • Synthesis and review