Professor Droussiotis's Web Space

Financial Spreadsheets

Home
Baruch Exec. MS FIN 9793
__________________________
Baruch FIN 3710
Baruch FIN 4710
Fordham Credit & Banking
Baruch CAPS - Derivatives
Baruch CAPS - Corp. Fin.
Baruch CAPS - Debt & Fixed Income
Baruch CAPS - Inv. Banking
FDU Managing Fin. Systems
FDU Quantitative Analysis
FDU / Wyndham - MS
FDU / Wyndam New Venture Mgmt
FDU Business Statistics
Seton Hall - Derivatives
Banking & Finance Lectures
SPREADSHEETS/MODELS
Blog / Articles
Biography
Rate your Professor

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:

Equity Analysis Spreadsheet

Bond Analysis Spreadsheet

DERIVATIVES ANALYSIS:

Option Formulas Review

Basic Option Strategies

Advanced 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