Financial Analysis using excel Course

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.

      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