Financial Analysis Using Excel Course





​13th- 17th Jan 2020



​17th-21st Feb 2020



​16th-20th Mar 2020



​20th-24th Apr 2020



​4th-8th May 2020



​18th-22nd May 2020



​15th-19th June 2020



​13th-17th July 2020



​17th-21st Aug 2020



​14th-18th Sept 2020



​12th-16th Oct 2020



​16th-20th Nov 2020



​14th-18th Dec 2020



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


​5 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;




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

• Data validation; Text to column


• 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


  • 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
Can we help you?