Financial Analysis using excel Course
Details
Introduction
This course is designed for existing users of Excel or similar spreadsheet programs needing
to vastly increase their modelling & analytical skills especially in the disciplinary areas of
Finance, Accounting, Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information
Duration
2weeks
Who should attend?
This certificate course is for analysts, financial officers, and portfolio managers seeking a deeper understanding of Valuation, and the skills and knowledge to confidently make financial decisions.
Course Objective:
- creating professional charts in Microsoft Excel
- working with large amounts of data
- Understanding Accounting and Bookkeeping principles
- Building a company’s financial statements
- Performing Financial Statement Analysis
- Understanding importance of timing in terms of revenue and cost recognition
- Calculating Liquidity, Solvency, Profitability, and Growth ratios
- assessing project feasibility
- calculating a complete loan schedule
- Understanding the difference between variable and fixed interest rates
- Performing industry analysis
- Understanding drives a company’s value
- analyzing a business
Course content
Session 1: Financial Modeling
- Accuracy, flexibility, User-friendliness
- Structural standards
- Iteration, Circular Errors, the #REF! problem
- Factual checks, Rational checks, Structural checks,
- Model Stress Testing, Proofreading
Session 2: Financial modeling Functions
- Different ways of summing and counting: SUM; SUMIF;
- SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF fuctions
- ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT;
- TRUNC; MOD
- HLOOKUP; VLOOKUP
- Discounting on uneven periods: NPV; XNPV; IRR; XIRR
- Data validation; Text to column
- Pivot tables, what if analysis and data tables
- Sensitivity and scenario analysis
Session 3: Modeling for financial and operational planning
- A working capital management model
· A capital budgeting model
· An inventory policy model
· A plant opening/closing model
Session 5: Additional Analysis in Financial Modeling
- Debt repayment
- Modeling based on seniority of debt obligations
- Book Depreciation and Tax Depreciation and modeling deferred tax
- asset/liability
- Modeling Asset Sales
Session 6: Credit Perspective
- Capital Structure
- Leverage Ratios
- Interest Coverage
- Working Capital
- Operating Results
- Liquidity Ratios
Session 7: Capital Structure Analysis
· Existing Debt
· Bank Revolver
· Other Long-Term Debt
· Preferred Stock
· Book Capitalization
· Total Debt
· Book Equity
· Borrowing Base
· Revolver Debt
Session 7: Cost of Capital Modelling
Session 8: Valuation models using Discounted Cash Flow Analysis
- Free Cash Flow to Firm
· Free Cash Flow to Equity
· Single stage and multi stage models
· Principles of financial analysis using NPV, IRR, PBP and other measures
· Discounted Cash Flow Analysis
· Relative Valuation
· Hybrid of DCF and relative valuation
· Conducting reality check on results
Session 9: Modeling for Corporate Finance Transaction
Session 10: Evaluation of Newly built financial model
· Objectives
· Assumptions
· Logical flow
· Key inputs
· Interrelationships among inputs
· Expected output
· Factual checks, Rational checks, Structural checks
Schedules
Weekdays | 09:00 AM — 05:00 PM |
No. of Days: | 10 |