Professor Droussiotis's Web Space

Financial Spreadsheets

Home
Baruch Mergers & Acquisitions
Columbia University - Introduction to Finance
Baruch FIN 3710
Baruch FIN 4710
__________________________
Baruch Exec. MS FIN 9793
Baruch CAPS - Corp. Fin.
Baruch CAPS Debt Markets
Baruch CAPS - Derivatives
Baruch CAPS Equity Markets
Baruch CAPS - Inv. Banking
Baruch CAPS - International Accountancy
Fordham Credit & Banking
Seton Hall - Derivatives
FDU Managing Fin. Systems
FDU Quantitative Analysis
FDU / Wyndam New Venture Mgmt
FDU Business Statistics
Banking & Finance Lectures
SPREADSHEETS/MODELS
Blog / Articles
Biography
Pictures
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:

Public Company Valuation Methods

Private Co Equity Valuation - WACC, CAPM & IRR

Bond Analysis & Valuation

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