Professor Droussiotis's Web Platform

Financial Spreadsheets

HOME PAGE
_______________________________
---- SPRING 2024 COURSES ---
Columbia University Saturday Seminar
Columbia Intro to Finance
Fordham Fin. Modeling
SHU BFIN 4234/7331 Derivatives
SHU ECO 2408 Money and Banking
_______________________________
-----PROFESSOR's INFO-----
PROFESSOR'S TEXT BOOKS
LECTURE VIDEOS
DROU ACCADEMY SEMINARS
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
CITY UNITY COLLEGE
SETON HALL UNIVERSITY
_______________________________

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