Training on Financial Analysis Using Excel Course

This training on financial analysis using excel is best suited for existing userss 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

PLEASE NOTE

• All the participants should be conversant with the English language.
• All our courses involve a mix of one on one presentations, web based tutorials, group discussions, and practical exercises.
• All courses can be tailor made and adjusted to meet the client’s needs.
• We have a team of professional experts who work as professionals and trainers in their respective fields.
• Each participant will get an Uphilos Consultancy certificate, upon completion of each course.
• All our training sessions are held at Uphilos Center. For groups above five people we can train at any location in Kenya, above ten people any location within East Africa, and above twenty people at any location as per the client’s specifications.
• Participants will be responsible for their travel, dinner, airport transfers, and other personal expenses.
• Accommodation will be arranged upon request at a discounted price.
• All payments should be made two weeks prior to the training for better logistics. Proof of payment should be sent to [email protected]