Professor Droussiotis's Web Platform

Financial Spreadsheets

HOME PAGE
_______________________________
---- SPRING 2026 LECTURES ---
Columbia ERM 5390 Credit Risk Mgmt
Fordham FNBU 3446 Fut. & Options
SHU BFIN 4261 Private Equity
SHU BFIN 4241 Mergers & Acquisitions
SHU BFIN 4234/7331 Fut. & Options
_______________________________
-------2026 SEMINARS --------
Columbia University Saturday Seminar
Columbia University Pre-College Finance
DROU ACCADEMY SEMINARS
_______________________________
DAILY MARKETS NEWSLETTER
Market Data Resources Links
Finance Movies
_______________________________
-----PROFESSOR's INFO-----
PROFESSOR'S TEXT BOOKS
LECTURE VIDEOS
ACCESSS TEXTBOOKS (PWD)
_______________________________
DrouMarkets.com Sim Game
Biography
Published Books/Articles
Rate your Professor
_______________________________
--- OTHER COURSES ---
BARUCH COLLEGE
COLUMBIA UNIVERSITY
FAIRLEIGH DICKINSON UNIVERSITY
FORDHAM UNIVERSITY
SETON HALL UNIVERSITY
_______________________________
BARUCH CAPS
CITY UNITY COLLEGE
CIM

Excel Files - Please Download the following spreadsheets:
All rights reserved.
Legal Disclaimer: You may view and download a single copy of the Material on the Web site solely for your personal and non-commercial use. You may not sell or modify the Material or reproduce, display, distribute, or otherwise use the Material in any way for any public or commercial purpose without the written permission.


Financial Models/Spreadsheets:

Securitization Structure (CLO) Analysis (PDF)

Real Estate Equity Analysis (PDF)


Just for Fun - Craps Game Built on Excel


Password Protected Spreadsheets:

LBO Financial Model

VALUATION ANALYSIS:

Starwood Financials updated 10-04-2013

Pinnacle Casino Financials updated 10-18-2013

Texas Roadhouse Financials Update 10-18-2013

Spreadsheets for Baruch / CAPS / FDU:

PORTFOLIO ANALYSIS:

Risk & Return Spreadsheet

Alpha Coefficient - Equity Valuation

Beta Coefficient

Covariance & Correlation Spreadsheet

Statistics Workbook

CLO Portfolio Model (Q&D)

CAPITAL MARKET ANALYSIS:

Public Company Valuation 7 Methods

Private Co Equity Valuation - WACC, CAPM & IRR

Bond Yields, Market Price & Valuation Analysis

DERIVATIVES ANALYSIS:

Option Formulas Review

Basic Option Strategies

Advance Option Strategies

Binomial Option Pricing Model Method #1

Binomial Option Pricing Model - Method #2

Black Scholes Option Model

Equity Val using Black Scholes

Futures & Forwards

SWAPS

FRAs

COMPANY SPECIFIC ANALYSIS:

Financial Analysis Spreadsheet

Projections & Valuations Spreadsheet

Debt Capacity Analysis

Equity Valualtion using Option Pricing