AIRSA Resources
Download tools, templates, datasets, and guides to accelerate AI work across Africa.
Real Estate Investment & Rental Yield Calculator (Excel)
Evaluate a rental property in minutes. Enter the purchase price, financing terms, rent, and operating costs, and this workbook calculates the key numbers investors use to compare deals: gross and net rental yield, net operating income (NOI), vacancy losses, maintenance and CapEx expenses, cash-on-cash return, debt service coverage ratio, break-even occupancy, and payback period. What’s inside: Inputs: one sheet with every assumption in a clearly marked, editable cell. Analysis: Year 1 income, expenses, NOI, cash flow, and return metrics. Projection: a 10-year forecast with rent and expense growth, loan balance, equity, IRR, and equity multiple. Scenarios: pessimistic, base, and optimistic cases side by side, so you can stress-test a deal before you commit. How to use it: Replace the example values on the Inputs sheet with your property’s figures. All other sheets update automatically, with no formulas to edit. Good to know: The pre-filled numbers are illustrative placeholders, not market data. Results are pre-tax estimates for planning purposes and are not financial or investment advice.
Research Data Analysis and Statistical Reporting Toolkit
An Excel-based toolkit designed to simplify research data organization, descriptive statistics, data visualization, and statistical reporting. Ideal for students, researchers, lecturers, consultants, and monitoring and evaluation professionals conducting academic, institutional, or business research. File Format: Microsoft Excel (.xlsx)
Automated Financial Statements and Ratio Analysis Template (Excel)
Turn raw financial data into a full set of statements, ratios and charts. Enter your figures once on a single input sheet, and this Excel template builds your income statement, balance sheet and cash flow statement. It also calculates more than 30 financial ratios and draws six performance charts. What’s included: Three linked financial statements: income statement (with EBITDA, EPS and common-size analysis), balance sheet, and indirect-method cash flow statement with free cash flow Ratio analysis: profitability, liquidity, leverage, efficiency and cash-flow quality ratios, each with a definition and typical guide range Performance dashboard: key figures for the latest year against the prior year, plus charts for revenue and net income, margins, liquidity, cash flow, returns and leverage Built-in checks: automatic tests confirm the balance sheet balances and the cash flow statement reconciles to balance-sheet cash Ready to use: a Guide sheet with step-by-step instructions and a colour legend, plus fictional sample data showing the expected format Who it’s for: finance teams, accountants, analysts, small business owners and students who want a consistent, repeatable way to review financial performance without rebuilding formulas each period. Format: Excel (.xlsx). Covers four fiscal years plus an opening balance sheet, and works in any currency or unit. Note: The sample company and figures are fictional. Ratio guide ranges are general rules of thumb, so compare results against your own industry benchmarks.
Student Academic Performance & Dropout Risk
A comprehensive research-grade dataset containing 100,000 student records with 32 carefully engineered features capturing academic performance, socioeconomic background, engagement behaviour, institutional context, and student wellbeing - all calibrated against peer-reviewed education research and national statistics. The target variable dropout (binary: 0 = Enrolled/Graduated, 1 = Dropped Out) achieves a 32.0% positive rate, reflecting real-world college attrition patterns without any oversampling.
Impact of Social Media on Life
In recent years, the intersection of digital platform consumption, sleep hygiene, and stress has become a critical focus of behavioral and educational research. This dataset provides granular survey metrics across 4,500 students ranging from high school to postgraduate programs to analyze how digital engagement shapes daily life and well-being.
School Results and Student Performance System Excel Template
The School Results and Student Performance System is an Excel-based tool designed to help schools, teachers, and educational institutions organise student academic records and monitor learning performance. It provides a structured framework for recording examination scores, managing student results, calculating grades, and assessing academic progress. The template supports efficient academic recordkeeping, simplifies results management, and helps educators identify student performance trends for informed academic planning and decision-making.
Invoice, Receipt and Payment Tracker Excel Template
The Invoice, Receipt and Payment Tracker is a professional Excel-based tool designed to help businesses, freelancers, consultants, and entrepreneurs manage invoicing, record customer payments, monitor outstanding balances, and track overdue invoices. It provides a structured approach to maintaining accurate payment records, improving cash flow visibility, and strengthening financial management. The template is suitable for small and medium-sized enterprises, service providers, and other organisations seeking to streamline their billing and payment tracking processes using Microsoft Excel.
Monitoring, Evaluation and Learning (MEL) Tracker (Excel Template)
This Excel template helps organisations monitor project activities, measure performance against targets, track indicators, and evaluate outcomes. It supports data-driven decision-making, progress reporting, accountability, and continuous improvement. Suitable for NGOs, research institutions, government agencies, and development projects.
Asset Register and Maintenance Tracker Template
This Excel template helps organisations record, monitor, and manage their assets efficiently. It includes asset details, purchase dates, locations, conditions, depreciation, and maintenance schedules to support effective asset management, cost control, and informed decision-making. Suitable for businesses, NGOs, educational institutions, and public organisations.
Sales and Revenue Dashboard (Excel Template)
This template helps sales teams, managers and finance staff track results against targets in one place. Record each sale on the Transactions sheet and the Dashboard shows how the business is performing by month, product category, region and sales rep. What you get: Dashboard: six headline KPIs (total revenue, gross profit, profit margin, transactions, average order value and year-to-date target attainment). It also has a monthly revenue vs target table and chart, revenue by category and region, a sales rep leaderboard and the top five products. Attainment is colour-coded green (100% or more), amber (90–99%) or red (below 90%). Transactions: one row per order line, with dropdowns for region, rep and product. Product name, category, price, revenue, cost and profit are filled in automatically. It has room for 500 rows. Products: your price and cost list, with units sold, revenue and profit worked out for each product. Targets: monthly revenue targets, plus annual targets by region and by sales rep. Setup: company name, reporting year, and the lists of regions, reps and categories. Read Me: step-by-step instructions, colour legend and notes on how each figure is calculated. How to use it" On Setup, enter your company name and reporting year, and edit the lists of regions, reps and categories. On Products, list your products with their prices and costs. On Targets, enter your monthly, regional and rep targets. On Transactions, add your sales in the blue columns (A–H). The grey columns calculate on their own. Open the Dashboard to see the results. The template includes fictional sample data for Jan–Sep 2026. To start fresh, clear the blue cells in Transactions A6:H505 and replace the Products and Targets values with your own. Good to know: Net revenue is quantity × unit price × (1 − discount). Gross profit is net revenue minus cost. Only sales dated within the reporting year are counted. The dashboard shows up to 5 regions, 6 sales reps and 5 categories. Currency is shown in $. Change the number format if you use another currency. Suitable for: sales managers, sales operations, finance and business owners who want a simple monthly or quarterly performance review.
Budget & Expense Tracker Template
This Excel workbook helps you plan a yearly budget, record income and expenses, and see how actual spending compares with your plan. Everything calculates automatically; you only type into the yellow cells. Getting started (5 minutes): Setup sheet: Enter your budget year, opening balance, and the month you’re reporting through. Optionally set a savings rate target. Budget sheet: Rename the income and expense categories if needed and enter your planned amount for each month. The figures shown are samples, so replace them with your own. Day-to-day use: 3. Income Log: Record each payment you receive (date, source, description, amount). 4. Expense Log: Record each expense (date, category, description, payment method, amount). Choose categories from the drop-down lists, and enter all amounts as positive numbers. Row 6 on each log is an example entry; overwrite it. Reviewing your results (automatic): Dashboard: Year-to-date income, expenses, net savings, current balance, savings rate and budget variance, with charts. Monthly Summary: Budget vs actual income and expenses for each month, plus opening, closing and projected balances. Category Variance: Year-to-date budget vs actual for each category, with status flags (Over budget, On track, Under budget). Actuals: Monthly totals pulled from your logs. Good to know: Do not type over the Actuals, Monthly Summary, Category Variance, or Dashboard sheets, as they contain formulas. Positive variances (green) are favourable, and negative variances (red) are unfavourable. Each log holds 500 entries. Entries dated outside the budget year, or using a category that isn’t on the Budget sheet, are not counted. The Data Check on the Monthly Summary sheet will flag this. Update the “Report through month” on the Setup sheet each month to refresh the year-to-date figures.
Research Presentation Template
A ready-to-use, editable slide deck for presenting research at conferences, seminars, thesis defences, and lab meetings. It follows the structure of a research talk, with clear layouts, placeholder prompts, and speaker notes on every slide, so you can focus on your findings instead of formatting. What’s inside (16 slides, 16:9): Title, outline, and background with key-number cards Knowledge gap and research question with hypotheses Methods: study design flow, sample table, and analysis approach Three results layouts: headline stat with chart, comparison table, and full-width figure Discussion, limitations and next steps Conclusions, references and acknowledgements, and Q&A Speaker notes with timing and delivery tips on each slide Key features: Slide titles state the finding rather than only the topic. The deck uses a clean institutional look with consistent layouts, and every placeholder is marked in [brackets]. Best for: Researchers, graduate students, lab groups, evaluators, and anyone presenting study results. Format: Editable slide deck (16:9); replace the placeholders and delete the slides you do not need.