Financial Analysis using excel Course 1

Financial Analysis using excel Course on 5th to 16th September 2022

course calendar

 

Introduction

This course is designed for existing users of Excel or similar spreadsheet programs needing

to vastly increase their modelling & analytical skills especially in the disciplinary areas of

Finance, Accounting, Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information

Duration

2weeks

Who should attend?

This certificate course is for analysts, financial officers, and portfolio managers seeking a deeper understanding of Valuation, and the skills and knowledge to confidently make financial decisions.

Course Objective:

·         creating professional charts in Microsoft Excel

·         working with large amounts of data

·         Understanding Accounting and Bookkeeping principles

·         Building a company’s financial statements

·         Performing Financial Statement Analysis

·         Understanding importance of timing in terms of revenue and cost recognition

·         Calculating Liquidity, Solvency, Profitability, and Growth ratios

·         assessing project feasibility

·         calculating a complete loan schedule

·         Understanding the difference between variable and fixed interest rates

·         Performing industry analysis

·         Understanding drives a company’s value

·         analyzing a business