Course Description

THE RATIONALE

This course is suitable for users of excel or another spreadsheet software. The course aims at equipping delegates with the analytical skills in the areas of finance, accounting, management, and procurement. The course is intended to enhance the Excel modeling and analytical skills of finance professionals for predicting, analysis, and presentation of business and financial data/information.

THE COURSE OBJECTIVES:

By the end of this training, delegates will be able to:

• Using Excel to create professional charts
• Understand the principles of accounting and bookkeeping
• Build the financial statements of an organization
• Understand the importance of timing in relation to cost and revenue recognition
• Analyze financial statements
• Calculate liquidity, solvency, growth ratios, and profitability
• Assess project feasibility
• Calculate a loan schedule
• Differentiate between variable and fixed interest rates
• Carry out industry analysis
• Understand company’s value drives
• Business analysis

 THE COURSE OUTLINE

The course will cover the following:

Financial Modeling

• Flexibility, accuracy, and User-friendliness
• Structural standards
• Circular errors, the #REF! problem and Iteration
• Factual, rational and Structural checks
• Proofreading and Model Stress Testing

Functions of Financial Modeling

• Counting and summing functions- SUM; SUMIF; SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF functions- ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT; TRUNC; MOD
• HLOOKUP; VLOOKUP
• Discounting on uneven periods: NPV; XNPV; IRP; XIRP
• Validation of data; Text to column
• Pivot tables, what if analysis and data tables
• Scenario and sensitivity analysis

Modeling for Financial and Operational Planning

• Repayment of debt
• Seniority of debt obligations modeling
• Book and tax depreciation and modeling deferred tax
• Liability/asset
• Asset sales modeling

Credit Perspective

• Capital structure
• Leverage ratios
• Interest coverage
• Working capital
• Operating results
• Liquidity ratios

Capital Structures Analysis

• Debt existing
• Bank Revolver
• Long-Term Debt
• Preferred Stock
• Book Capitalization
• Total Debt
• Book Equity
• Base of Borrowing
• Debt Revolver

Cost of Capital Modeling

• Valuation Models using Discounted Cash Flow Analysis
• Firms’ free cash flow
• Free cash flow to equity
• Single stage and multistage models
• Financial analysis principles using VPN, IRP, PBP and other measures
• Analysis of discounted cash flow
• Relative valuation
• Hybrid of relative evaluation and DCF
• Reality check on results

Modeling for Corporate Finance Transaction and Evaluation of Newly Built Financial Model

• Objectives
• Hypothesis
• Logical flow
• Key inputs
• Inputs interrelationships
• Outcome expected
• Factual, rational, and structural checks

TARGET AUDIENCE

Financial officers, analysts, and portfolio managers who want to learn about valuation and gain skills relevant in making financial decisions.

Delivery Method: Combines lectures, discussions, group exercises and illustrations

Venue:

Fee:

Duration: 1 week

Course Date: April 10th-14th 2023