### TRAINING COURSE ON FINANCIAL ANALYSIS USING EXCEL

Course Date Location Course fee: Registrations (Group)
Start Date: 12/12/2022 End Date: 23/12/2022 Mombasa \$ 2,000 Register as Individual Register for Online Training Register as a Group
 INTRODUCTION 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 Calculte 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 DURATION 2 Weeks 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. We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more: training@data-afriqueconsultancy.org The training will be conducted at DATA-AFRIQUE TRAINING CENTRE, Nairobi Kenya. The training fee covers tuition fees, training materials, lunch and training venue. Accommodation and airport transfer are arranged for our participants upon request. Payment should be sent to our bank account before start of training and proof of payment sent to: training@data-afriqueconsultancy.org

### Our 2022 Group Rates (in USD)

# of Days
Group #
5 DAYS PER PERSON
10 DAYS PER PERSON
#
PAXS
USD
USD
1. 1 1000.00 2000.00
2. 2 - 10 800.00 1,600.00
3. 11 - 20 750.00 1,500.00
4. 21 - 30 700.00 1,400.00
5. 32 - 40 650.00 1,300.00
6. 41 - 50 600.00 1,200.00
7. 51 > Above 500.00 1000.00