Professor Droussiotis's Web Platform
SHU - Financial Modeling
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
INFO:
LINKS:
Syllabus
Syllabus Fall 2023
Professor's Inbox(upload info for Professor)
Professor's INBOX
Processor's Email
droussch@shu.edu
Class Info/time
Tue and Thu12:30pm-1:45pm
Tue and Thu
12:30pm-1:45pm
TEAMS Channel
Active Learning (access to Assignments):
Active Learning and Textbook
Professor's Biography
Office Hours/Remote(9:00-5pm)
Make an Appointment Link
Aug 29on-line only via TEAMS
Aug 31
Sep 5 -7
Sep 12-14
Sep 19
Sep 21, 26
Sep 28(Pre-Recorded Exam Review)
Oct 3 & 5
Oct 10
Oct 12
Oct 17-19
Oct 24-26
Oct 31Nov 2
Nov 7-9
Nov 14-21
Nov 23
Nov 28-30
Dec 5-7
Dec 12-14
Dec 19-21
NO CLASS
N
O
C
L
A
S
INVESTMENTS(PORTFOLIO MANAGEMENT)
INVESTMENTS
(PORTFOLIO MANAGEMENT)
CREDIT ANALYSIS(LBO, M&A ANALYSIS)
Assigned Chapters
Link to purchase textbook/active learning
Intro Part 1 - Portfolio Management
Chapter #1
Chapter #2-3
Chapter #3-4
In-Class Financial Modelling(Portfolio of Stocks)
Project I - Description
Zeus Stock Portfolio Analysis
Yahoo Finance Link
MIDTERM EXAM REVIEWChapters#1-4(Pre-recorded Zoom Session)
Midterm Exam Review Financial Modelling
DISCUSSION ON MIDTERM EXAM AND PROJECT I
Intro Part IV - Company Specific Analysis Chapter #15
Chapter #15 16 (Partial)
Chapter #9
CASE STUDY #6: Alexandria Hotel LBO
Case Study #6: Alexandria Hotel Template
In-Class Financial Modelling(LBO Model)
Project II: Public to Private LBO
Public to Private LBO Case Study Template
Public to Private LBO Case Study Answers PDF
EXAM REVIEW
Final Exam Review Questions Outline
Assigned Lectures & Class Presentations
Introduction to Finance Lecture 0
Lecture 1: Time Value of Money
Lecture 2 Risk, Return, Correlation
Lecture 3 Beta Coefficient, Regression Analysis
Lecture 3b Sharpe Ratios, CAPM, Alpha
Lecture 4a Prsentation
Lecture 4b Presentation
Zoom Recordings
Lecture Videos
Portfolio Management (Chapter 1-4)
Assigned Spreadsheets
TVM Template
Risk, Return & TVM
Coveriance, Correlation & Eff. Frontiers
Betas and Regression Analysis
Sharpe Ratios and CAPM
CASE STUDY #1: Celerity Technology Cash Flow and Ratios
EXAMS
TWO PART- MIDTERM ON-LINE EXAM VIA ACTIVE LEARNING
FINAL EXAM
Homework Assignments(Via Active Learning)Poroject Assignments
Homework Assignments
(Via Active Learning)
Poroject Assignments
Due Chapter 1a & 1b
Due Chapter 2
Due Chapters 3, 4
Project I Due (Portfolio of Stocks)
Due Chapters 15
Chapter 15 Problems - Answers
Due Chapters 16
Chapter 16 Spreadsheet - Problems Answers Projections
Project II Due (Summary LBO Analysis)Due Dec 19
Project II Due (Summary LBO Analysis)
Due Dec 19
Spreadsheet Templates (homework/assignments/exams) Available on Active Learning
Chapter 1 - TVM Homework
Ch. I Hwk Part A (1-27) Template
Chapter 1b - Risk and Return Homework
Ch. I Hwk Part B (1-10) Template
Chapter 2 Excel Homework Template
Chapter 3 Excel Spreadsheets
Chapter 4 Excel Templates
Chapter 15 Excel Template
Chapter 16 Excel Template
Project Assignment
Final Project I Description - Stock Portfolio
Zeus Stock Portfolio Analysis (PDF)
Yahoo Finance
Relevant Articles/Links
Chapter 15 practice template
Lecture 5 Presentation
Chapter 17 - Valuation for Public and Private Companies
Chapter 17 Valuation Analysis - Public Companies
Lecture 6 Presentation
HOME SUITES CASE STUDY
Home Suites Financial Model
