Professor Droussiotis's Web Platform

Financial Spreadsheets

HOME PAGE
_______________________________
---- SPRING 2025 LECTURES ---
Columbia ERM 5001 Intro to Finance
Fordham FNBU 3446 Deriv. - Tue
Fordham FNBU 3446 Deriv. - Wed
SHU BFIN 4255/7255 Fin. Model Mon
SHU BFIN 4255 Fin. Model Tue/Thu
SHU BFIN 4261 Private Equity
SHU BFIN 4234/7331 Derivatives
_______________________________
--------- 2025 SEMINARS ---------
Columbia University Saturday Seminar
DROU ACCADEMY SEMINARS
_______________________________
Market Data Resources Links
_______________________________
-----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

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