Skip to content
Erudite AfricaCenter of Excellence
← Financial Management for SMEs: Strategic Financial Management

Advanced Excel for SMEs

Module 05 / 6 · 65 min

Build a clean, checkable financial model in Excel with a scenario switch, sensitivity tables, loan and lease schedules, a KPI dashboard and a monthly monitoring routine.

In this module you will learn to

  • Structure a financial model into inputs, calculations and outputs with clear formatting rules
  • Link the three statements and build error checks, including a balance check
  • Add a scenario switch, sensitivity tables and Goal Seek to test the plan
  • Build loan and lease schedules that feed interest and debt into the statements
  • Design a one-page KPI dashboard and a monthly monitoring routine with controlled data

Built on

  • Erudite Africa training curriculum: Financial Management for SMEs, Level 3 Advanced, Strategic Financial Management (October 2026)
  • Income Tax Proclamation No. 979/2016 as amended by No. 1395/2025; VAT Proclamation No. 1341/2024 and VAT Registration Directive No. 1104/2025; Federal Tax Administration Proclamation No. 983/2016 as amended by No. 1434/2026
  • Capital Goods Leasing Business Proclamation No. 103/1998 as amended by No. 807/2013; Investment Proclamation No. 1180/2020; Investment Incentive Regulation No. 586/2026
  • Commercial Code Proclamation No. 1243/2021 and Financial Reporting Proclamation No. 847/2014 (IFRS for SMEs, AABE filing)
  • NBE Directives No. NBE/INT/13/2026 (interest rates), SBB/95/2025 (capital adequacy), FXD/01/2024 and FXD/05/2026 (foreign exchange)
  • Published good practice on financial modeling, quality of earnings review and the balanced scorecard (Kaplan and Norton)

Examples and companies are fictional. Tax rates and rules are shown as they stood when the course was written; always check the current proclamations, directives and guidance from the Ministry of Revenues before filing, and take professional advice for your own case.