INTRODUCTION
Excel or other spreadsheet users can benefit from this training. The goal of the course is to give participants analytical abilities in the fields of finance, accounting, management, and procurement. The goal of the course is to help finance professionals improve their Excel modeling and analytical skills for forecasting, analyzing, and presenting 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
Financial officers, analysts, and portfolio managers who wish to learn about valuation and develop skills necessary for making financial decisions are the target audience for this course.
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
- Our seasoned instructors, who have years of experience as seasoned professionals in their respective fields of work, will be teaching this course. A combination of practical exercises, theory, group projects, and case studies are used to teach the course.
- The participants receive training manuals and supplementary reading materials.
- Participants who complete this course successfully will receive a certificate.
- We can also create a course specifically for your organization to match your needs. To learn more, get in touch with us at training@dealsontrainers.org.
- The training will take place at DEALSON TRAINERS IN NAIROBI, KENYA in Nairobi, Kenya.
- The training fee includes lunch, course materials, and lodging for the training session. Upon request, we may arrange for our participants' lodging and transportation to the airport.
- Payment must be made to our bank account before the training begins, and documentation of payment should be emailed to training@dealsontrainers.org