|
DAY 1
CONSTRUCTION OF A SPREADSHEET MODEL
FORMATTING AND EDITING
SCENARIO ANALYSIS
FUTURE VALUE
PRESENT VALUE
FINANCIAL AND STATISTICAL FUNCTIONS
GRAPHICS AND CHARTING
DAY 2
CAPITAL BUDGETING
PAYBACK PERIOD
DISCOUNTED PAYBACK PERIOD
INTERNAL RATE OF RETURN
NET PRESENT VALUE
PROFITABILITY INDEX
SENSITIVITY ANALYSIS
PURCHASE/LEASE DECISION
REPLACEMENT ANALYSIS
SOURCES AND USES OF FUNDS
DAY 3
FINANCIAL RATIOS
COMMON SIZE STATEMENTS
PROFORMA FINANCIAL STATEMENTS
DAY 4
FINANCIAL PLANNING AND FORECASTING
CASH BUDGET
DECISION TREES
DURATION AND IMMUNIZATION
BOND REFUNDING
DAY 5
REGRESSION ANALYSIS
BETA ESTIMATION
OPTIMIZATION
MAXIMIZING RETURN
MAXIMIZING RETURN
MINIMIZING RISK
MINIMIZING RISK
BENEFITS FOR PARTICIPANTS:
THIS COURSE WILL HELP PARTICIPANTS UNDERSTAND THE BASICS OF
FINANCIAL ANALYSIS USING EXCEL. TIME VALUE OF MONEY WILL BE
ILLUSTRATED. PROJECT VALUATION TECHNIQUES WILL BE APPLIED.
FINANCIAL DECISIONS BASED ON RISK AND RETURN WILL BE FEATURED.
FINANCIAL RATIOS APPLICATIONS AND LIMITATIONS WILL BE COVERED.
PROFORMA BALANCE SHEETS AND ESTIMATION OF CASF FLOWS WILL BE
ILLUSTRATED. VALUATION AND BENEFITS OF DIVERSIFICATION MAY BE
COVERED.
TYPE OF ATTENDEES:
THIS COURSE IS MOST BENEFICIAL TO FINANCIAL ANALYSTS, FINANCIAL
MANAGERS, INVESTMENT GROUPS, AND CONSULTANTS.
Other Seminars:
|