Financial Analysis Using Excel Workshop

INTRODUCTION

Master the art of financial analysis with our Financial Analysis Using Excel Workshop. Designed for users of Excel or other spreadsheet software, this course equips participants with advanced analytical skills in finance, accounting, management, and procurement. Enhance your Excel modeling capabilities and gain the expertise needed to predict, analyze, and present business and financial data effectively. This comprehensive course covers a range of financial analysis techniques, including creating professional charts, understanding financial statements, and calculating key financial ratios. Participants will also learn to assess project feasibility, develop financial models, and perform in-depth business analysis using Excel. By the end of this workshop, you will be proficient in using Excel to support strategic financial decisions and enhance your business insights.

COURSE OBJECTIVES

By the end of this Financial Analysis Using Excel course, participants will be able to:

• Use Excel to create professional charts.
• Understand the principles of accounting and bookkeeping.
• Build the financial statements of an organization.
• Recognize 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.
• Perform industry analysis.
• Understand company value drivers.
• Conduct business analysis.

DURATION

10 Days

WHO SHOULD ATTEND

This Financial Analysis Using Excel course is ideal for financial officers, analysts, and portfolio managers who want to learn about valuation and gain skills relevant to making financial decisions.

COURSE OUTLINE

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
• IF Functions: ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, INT, TRUNC, MOD
• HLOOKUP, VLOOKUP
• Discounting on Uneven Periods: NPV, XNPV, IRR, XIRR
• Data Validation and Text to Column
• Pivot Tables, What-If Analysis, and Data Tables
• Scenario and Sensitivity Analysis

Modeling for Financial and Operational Planning

• Debt Repayment
• Seniority of Debt Obligations Modeling
• Book and Tax Depreciation and Deferred Tax Modeling
• Liability/Asset Management
• Asset Sales Modeling

Credit Perspective

• Capital Structure
• Leverage Ratios
• Interest Coverage
• Working Capital
• Operating Results
• Liquidity Ratios

Capital Structures Analysis

• Existing Debt
• Bank Revolver
• Long-Term Debt
• Preferred Stock
• Book Capitalization
• Total Debt
• Book Equity
• Borrowing Base
• 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 Multi-Stage Models
• Financial Analysis Principles Using NPV, IRR, 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 Transactions

Evaluation of Newly Built Financial Model

• Objectives
• Hypothesis
• Logical Flow
• Key Inputs
• Inputs Interrelationships
• Expected Outcomes
• Factual, Rational, and Structural Checks

GENERAL NOTES

• This course is delivered by seasoned trainers with extensive professional experience.
• Training includes a mix of practical activities, theoretical knowledge, group work, and case studies.
• Participants receive comprehensive training manuals and additional reference materials.
• A certificate is awarded upon successful course completion.
• Tailor-made courses to meet specific organizational needs are available. Contact us at training@skillsforafrica.org for more information.
• The training will be conducted at the Skills for Africa Training Institute in Nairobi, Kenya.
• The training fee covers tuition, materials, lunch, and the training venue. Accommodation and airport transfer can be arranged upon request.

Payment should be made to our bank account before the training starts, and proof of payment sent to: training@skillsforafrica.org.