This training on financial analysis using excel is best suited for existing users of Excel or maybe similar spreadsheet programs needing to vastly improve their modeling & analytical skills particularly in the disciplinary aspects of Finance, Management, Accounting, Procurement, and Management. It's created for improving the Excel modeling & analytical abilities of financial experts because of the forecast, presentation, and analysis of business &economic info

Who Can Attend?

This course on financial analysis using excel is perfect for portfolio managers, financial officers, and analysts looking for a much deeper understanding of Valuation, as well as the abilities and expertise to confidently make financial decisions.

Program Objectives:

• producing expert charts in Microsoft Excel

• working with a lot of information

• Understanding Accounting as well as Bookkeeping concepts

• Building a business's financial statements

• Performing Financial Statement Analysis

• Understanding benefits of timing in terms of revenue and cost recognition

• Calculating Liquidity, Profitability, Solvency, in addition to Growth ratios

• assessing project feasibility

• calculating a total loan schedule

• Understanding the big difference between fixed and variable interest rates

• Performing industry analysis

• Understanding moves a company 's worth

• analyzing a business

Program Content of Financial Analysis Using Excel

1. Financial Modeling

• Accuracy, user friendliness, and flexibility

• Structural standards

• Factual inspections, Rational inspections, Structural checks,

• Model-Stress Testing, Proofreading

2. Financial modeling Functions

• Different methods of summing & counting: SUM; SUMIF;

• SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF as well as If functions

• ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT;

• TRUNC; MOD

• Discounting on irregular periods: NPV; XNPV; IRR; XIRR

• Data validation; Text to column

• HLOOKUP; VLOOKUP

• Pivot tables, let's say evaluation as well as data tables

• Sensitivity plus scenario analysis

3. Modeling for operational and financial planning

• A functioning capital management model

• A capital budgeting model

• An accounting policy model

4. Additional Analysis to come down with Financial Modeling

• Debt repayment

• Modeling primarily based on seniority of debt obligations

• Book Depreciation and Modeling, tax Depreciation deferred tax

• asset/liability

• Modeling Asset Sales

5. Credit Perspective

• Capital Structure

• Interest Coverage

• Leverage Ratios

• Liquidity Ratios

• Operating Results

• Working Capital

6. Capital Structure Analysis

• Existing Debt

• Bank Revolver

• Book Capitalization

• Book Equity

• Long-Term Debt

• Preferred Stock

• Total Debt

• Borrowing Base

• Revolver Debt

7. Cost of Capital Modelling

8. Valuation models applying Discounted-Cash-flow Analysis

• Free Cash Flow to Firm

• Free CF to Equity

• Principles of fiscal analysis using other, PBP, IRR, and NPV measures

• Discounted Cash Flow Analysis

• A mixture of relative valuation and DCF

• Conducting correct check on the results

• Single phase along with multi-stage models

• Relative Valuation

9. Evaluation of Newly made financial model

• Objectives

• Assumptions

• Key inputs

• Interrelationships among inputs

• Expected output

• Logical flow

• Factual inspections, Rational inspections, Structural checks

10. Modeling for Corporate Finance Transaction