Diploma of Financial Analysis with Microsoft Excel -

Course Content

Module 1 – Introduction to Finance

Importance of Financial Analysis
Installation of Microsoft Excel 2021
Excel tools for Financial Analysis

Module 2 – Excel Basics

Module 3 – Time Value of Money & Sensitivity Analysis

Module 4 – Understanding and Creating Financial Models

Module 5 – Microsoft Excel for Accounting

Module 6 – Forecasting and Creating Budgets

Module 7 – Valuations

Module 8 – Investment Analysis

Module 9 – Financial Reporting

Module 10 – Profit & Loss Statement (P & L)

Module 11 – Loan repayment & Amortization Table

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Course Content

Module 1 – Introduction to Finance

Importance of Financial Analysis

Installation of Microsoft Excel 2021

Excel tools for Financial Analysis

Module 2 – Excel Basics

Data Entry and Formatting

Excel Navigation and Basic Functions

Excel References

Basic Formulas and Functions

Data Validation and Error Handling

Module 3 – Time Value of Money & Sensitivity Analysis

Understanding the Time Value of Money

Present and Future Value Calculations

Excel Functions for TVM (NPV, IRR)

Using Data Tables for Sensitivity

Module 4 – Understanding and Creating Financial Models

Requirement of a Financial Model

Drafting Assumption for Financial Model

Creating Financial Model Templates

Module 5 – Microsoft Excel for Accounting

Balance Sheet Analysis

Balance Sheet Analysis 2

Income Statement Analysis

Cash Flow Statement Analysis

Ratio Analysis

Module 6 – Forecasting and Creating Budgets

Sales and Revenue Forecasting

Expense Forecasting

Scenario Analysis and Goal seeking

Creating Budgets and Projections 01

Creating Budgets and Projections 02

Creating Budgets and Projections 03

Module 7 – Valuations

Introduction to Valuation

Discounted Cash Flow (DCF) Valuation

Comparable Company Analysis (CCA)

Excel Models for Valuations

Module 8 – Investment Analysis

Capital Budgeting and Investment Appraisal

Payback Period, NPV and IRR for Investment Decisions

Risk Analysis and Monte Carlo Simulation

Real Options in Investment Analysis

Module 9 – Financial Reporting

Creating Financial Charts and Graphs

Data Tables and PivotTables for Analysis

Dashboard Design for Financial Reporting

Module 10 – Profit & Loss Statement (P & L)

Introduction to Profit & Loss (P & L) Statement

Overview of the P & L and its significance in Financial analysis

Components of P & L statement

Reading and Analysis P & L statements in Excel

Module 11 – Loan repayment & Amortization Table

Introduction to Loan Repayment

Types of loans – Amortizing vs Interest only

Building an amortization table using Excel

Demonstrations, Calculations and others

Earn a certificate