TRAINING COURSE ON FINANCIAL ANALYSIS USING EXCEL

Ksh 2000 USD

Processing your request, Please wait....




Safety Tips

Meet a seller in public place and be sure to pay only after collecting your item.

Learn More

Additional Info

Mobile+254723360025

Register online: https://bit.ly/2UdbWjI
Organizer: DATA-AFRIQUE CONSULTANCY (www.data-afriqueconsultancy.org)
Course fee: USD 2,000
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
• 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
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.
• We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more: [email protected]-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: [email protected]

Listing ID: 5975e281f421007a

January 22, 2020 6:54 pm

This ad has expired