Financial Analysis Using Excel Course

Date

Venue

Registrations

16th- 27th Jan 2023

Mombasa

6th- 17th Feb 2023

Nairobi

10th-21st Apr 2023

Nairobi

19th- 30th Jun 2023

Nairobi

7th-18th Aug 2023

Mombasa

4th-15th Sept 2023

Nairobi

16th-27th Oct 2023

Nairobi

13th-24th Nov 2023

Nairobi

11th-22nd Dec 2023

Mombasa

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

Duration

10 days

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]
Scroll to Top
Open chat
1
Whatsapp
Hello
Can we help you?