Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

# Financial Analysis Using Excel Workshop

## By: Skills for Africa Training Institute

Kenya

12 - 16 Aug, 2024  5 days

### USD 1,500

Venue: Nairobi

Other Dates

Venue Date Fee
Nairobi, Kenya 09 - 13 Sep, 2024 USD1500
Kigali, Rwanda 14 - 18 Oct, 2024 USD2950
Mombasa, Kenya 11 - 15 Nov, 2024 USD1500
Nairobi, Kenya 09 - 13 Dec, 2024 USD1500

This course is suitable for users of excel or other spreadsheet software. The course aims at equipping participants 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.

COURSE OBJECTIVES

• 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

DURATION

10 days

WHO SHOULD ATTEND

This course targets financial officers, analysts, and portfolio managers who want to learn about valuation and gain skills relevant in 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 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 multi stage 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

Evaluation of Newly Built Financial Model

• Objectives
• Hypothesis
• Logical flow
• Key inputs
• Inputs interrelationships
• Outcome expected

• Factual, rational, and structural checks

GENERAL NOTES

• This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
• Training manuals and additional reference materials are provided to the participants.
• Upon successful completion of this course, participants will be issued with a certificate.
 Nairobi Aug 12 - 16 Aug, 2024 Nairobi, Kenya 09 - 13 Sep, 2024 Kigali, Rwanda 14 - 18 Oct, 2024 Mombasa, Kenya 11 - 15 Nov, 2024 Nairobi, Kenya 09 - 13 Dec, 2024

Class Session: 08:00:am - 04:00:am

 USD 1,500.00 (Mombasa) USD 1,500.00 (Nairobi) USD 2,950.00 (Kigali) USD 4,500.00 (Dubai)
(Convert Currency)

Nixon Kahuria +254 702 249449

Skills for Africa

#### Related Courses

Workshop On Emotional Intelligence

5 days, 12 - 16 Aug, 2024

Skills for Africa Training Institute

Have you come across individuals who are incredibly bright and yet cannot pull their life together? We have seen very intelligent workers who do not seem to get ahead in the organization. As we are ...

Seminar On Operational Risk Management And Techniques

5 days, 12 - 16 Aug, 2024

Skills for Africa Training Institute

Recent events in the world have brought the subject of risk into a higher profile. Evaluating the range of available risk management techniques and choosing the most appropriate response in each ...

Training Needs Analysis And Staff Development Workshop

5 days, 12 - 16 Aug, 2024

Skills for Africa Training Institute

As organisations continue to face global financial difficulties, it brings added pressure on the Learning and Development Profession to ensure that training is both effective and focused. The focus ...

Risk-based Pension Funds Supervision And Effective Governance Training

5 days, 12 - 16 Aug, 2024

Skills for Africa Training Institute

Private Pensions are becoming an increasingly important part of retirement income. Therefore, the quality and the effectiveness of pension funds supervision is getting more and more critical, as well ...