Professor Droussiotis's Web Platform

City Unity College Nicosia
Home
Baruch FIN 3710
Baruch FIN 4710
Columbia University - Introduction to Finance (ON-LINE)
Columbia University - Introduction to Finance (ON-CAMPUS)
Seton Hall - Derivatives
Baruch CAPS - Derivatives
__________________________
PROFESSOR'S TEXT BOOK
DrouMarkets.com Sim Game
__________________________
Baruch Exec. MS FIN 9793
Baruch CAPS - Corp. Fin.
Baruch CAPS Debt Markets
Baruch CAPS Equity Markets
Baruch CAPS - International Accountancy
Baruch CAPS - Investment Banking
Baruch Lecture Series - Banking and Finance
Baruch Lecture Series - Valuation of Intangible Assets
Baruch Lecture Series - Mergers and Acquisitions
Baruch Summer Leadership Academy
Baruch Summer Leadership Academy - Lecture Series
City Unity College Statements & Budgeting
Fordham Financial Mgmt
Fordham Credit & Banking
SPREADSHEETS/MODELS
Blog / Articles
Biography
Pictures
Rate your Professor

LINK: SEMINAR SCHEDULED IN NICOSIA,CYPRUS MAY 23 - JUNE 4

Understanding Financial Statements and Budgeting

       Knowing how to work with historical numbers in a company's financial statements and able to use them to build short-term and long term budget is an essential skill for running a company. The meaningful interpretation and analysis of balance sheets, income statements and cash flow statements is the basis for assessing the performance of the company’s trends and ratio analysis to build the fundamental drivers and assumptions to create a budget.

SEMINAR_MAY_2019.jpg

 

 

May 23
4:00pm - 9:30pm

May 28
3:00pm - 8:30pm


June 3
3:00pm-7:30pm

June 4
3:00pm-7:30pm

           

Assigned Lectures

 

Lecture #1
Understanding Financial Statements

Lecture #1

Lecture 1 - Understanding Financial Statements

Lecture #2
Projections & Long Term Planning

Lecture #2

Lecture 2 - Budget and Planning - Corporate

Lecture #3
Transaction Analysis
Equity and Debt

Case Study Presentations

Green Landscape Services Case Study

Agenda

 

►Review and discuss in detailed each of the items found on the balance sheet, income and cash flow statements.

►Construct the cash flow statement based on the company’s financial position form year to year and explain the difference between income and cash.

►Measure the key performance ratios derived from the balance sheet, income and cash flows statement including solvency, profitability, operating and activity ratios.

► Use historical assumptions and trends to drive the Revenues – applied by industry.

► Use historical assumptions to drive the cost structure;

► Run different sensitivity cases including a downside case, a break-even case and an equity upside case.

►Case studies – practical approach using Excel application to develop historical analysis and build projections

►Case Study Presentations

Assigned Spreadsheets

 

Financial Analysis

Celerty Technology Financial Analysis

Revenue Assumpions

Celerity Technology Projections Analysis

Celerity Technology Projections

Celerity Technology Debt Capacity

Transaction Sources & Uses and WACC - BLANK WORKSHEET

Proforma Balance Sheet - BLANK WORKSHEET

Debt Schedule - BLANK WORKSHEET

Blank Spreadsheet

Green Landscape Services Spreadsheet

Homework Assignments

   

Homework Link