Professor Droussiotis's Web Platform

City Unity College Nicosia
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
_______________________________

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