Training on Financial Analysis and Modelling Using Excel Course

Course Overview

Welcome to the Financial Analysis Using Excel Course!   This course is designed for existing users of Excel or similar spreadsheet programs who want to significantly enhance their modeling and analytical skills, particularly in finance, management, accounting, procurement, and other related fields. By focusing on improving Excel modeling and analytical abilities, this course helps financial experts in forecasting, presenting, and analyzing business and economic information effectively.

Target Audience

This course is perfect for:

• Portfolio managers and financial officers
• Analysts seeking a deeper understanding of valuation
• Professionals looking to confidently make financial decisions
• Anyone wanting to enhance their Excel modeling skills in financial contexts

Course Objectives

By the end of this course, participants will be able to:

• Produce expert charts and handle large datasets in Excel
• Understand accounting and bookkeeping concepts
• Build and analyze a company's financial statements
• Perform financial statement analysis
• Recognize the benefits of timing in revenue and cost recognition
• Calculate liquidity, profitability, solvency, and growth ratios
• Assess project feasibility and calculate loan schedules
• Differentiate between fixed and variable interest rates
• Conduct industry analysis and business valuation

Course Outline

1. Financial Modeling

• Ensuring accuracy, user-friendliness, and flexibility
• Understanding structural standards
• Conducting factual, rational, and structural inspections
• Performing model stress testing and proofreading

2. Financial Modeling Functions

• Mastering methods of summing and counting: SUM, SUMIF, SUMPRODUCT, COUNT, etc.
• Utilizing rounding functions: ROUND, ROUNDUP, ROUNDDOWN, etc.
• Discounting on irregular periods: NPV, XNPV, IRR, XIRR
• Data validation and text to column techniques
• Using HLOOKUP, VLOOKUP, pivot tables, and scenario analysis

3. Modeling for Operational and Financial Planning

• Developing a working capital management model
• Building a capital budgeting model
• Creating an accounting policy model

4. Additional Analysis in Financial Modeling

• Managing debt repayment and obligations
• Modeling asset sales and depreciation
• Understanding asset/liability management

5. Credit Perspective

• Analyzing capital structure and interest coverage
• Calculating leverage and liquidity ratios
• Evaluating operating results and working capital

6. Capital Structure Analysis

• Assessing existing debt and bank revolvers
• Understanding book capitalization, equity, and long-term debt
• Evaluating preferred stock and total debt

7. Cost of Capital Modeling

• Exploring cost of capital models and applications

8. Valuation Models Using Discounted Cash-Flow Analysis

• Analyzing free cash flow to firm and equity
• Understanding principles of fiscal analysis using PBP, IRR, NPV
• Conducting discounted cash flow analysis
• Combining relative valuation and DCF techniques

9. Evaluation of Newly Made Financial Models

• Setting objectives and assumptions
• Analyzing key inputs and interrelationships
• Ensuring logical flow and conducting inspections

10. Modeling for Corporate Finance Transactions

• Applying modeling techniques to corporate finance contexts