ANALYSIS OF BDA COURSE CONTENTS AND PREDICTIONS (FOR BDA EXAMS ON 21ST AUGUST 2025)
TOPIC 1 INTRODUCTION TO EXCEL
*Utilising the keyboard shortcuts in Excel
*Conducting data analysis using data tables, pivot tables and other common
functions
*Using advanced formulas and functions to enhance the functionality of financial
models
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/INTRODUCTION-TO-EXCEL-FUNTIONS-AND-FORMULAS-CLASS-FILE.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/INTRODUCTION-TO-EXCEL-FUNTIONS-AND-FORMULAS-CLASS-SOLUTION.xlsx
TOPIC 3 CORE APLLICATIONS OF DATA ANALYTICS
3.1 Financial accounting and reporting
* Prepare financial statements; statement of profit or loss, statement of financial position and statement of cash flow for companies and groups
* Analyse financial statements using ratios, common size statements, trend and cross-sectional analysis, graphs and charts
* Prepare forecast financial statements under specified assumptions – Carry out sensitivity analysis and scenario analysis on the forecast financial statements
* Data visualization and dash boards for reporting
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FINANCIAL-STATEMENTS-CLASS-FILE.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FINANCIAL-STATEMENTS-CLASS-SOLUTION.xlsx
Statement of Cashflows
Class File
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FINANCIAL-STATEMENTS-STATEMENT-OF-CASHFLOWS-IAS7-CLASS-FILE.xlsx
Class Solution
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FINANCIAL-STATEMENTS-STATEMENT-OF-CASHFLOWS-IAS7-SOLUTION-1.xlsx
Group Accounts [Consolidated Financial Statements]
Class File
Class solution
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/GROUP-FINANCIAL-STATEMENTS-CLASS-SOLUTION-3.xlsx
Analyse financial statements using ratios, common size statements, trend
and cross-sectional analysis, graphs and charts
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FORECASTING-AND-ANALYSIS-OF-FINANCIAL-STATEMENTS-CLASS-SOLUTION-8.xlsx
RATIOS FORMULA
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/RATIO-ANALYSIS.pdf
3.2 Financial Management
*Time value of money analysis for different types of cash flows
*Loan amortization schedules
*Project evaluation techniques using net present value – (NPV), internal rate
of return (IRR)
*Carry out sensitivity analysis and scenario analysis in project evaluation
*Data visualisation and dashboards
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FINANCIAL-MANAGEMENT-CLASS-FILE.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/07/FINANCIAL-MANAGEMENT-CLASS-SOLUTION-4.xlsx
4.0 Application of data analytics in specialised areas
4.1 Management accounting – – – – –
*Estimate cost of products (goods and services) using high-low and regression analysis method
*Estimate price, revenue and profit margins
*Carry out break-even analysis
*Budget preparation and analysis (including variances)
*Carry out sensitivity analysis and scenario analysis and prepare flexible budgets
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/07/MANAGEMENT-ACCOUNTING-CLASS-FILE.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/08/MANAGEMENT-ACCOUNTING-CLASS-SOLUTION-2.xlsx
AUDIT AND ASSURANCE
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/08/Audit-Schedule-Class-File.xlsx
CLASS SOLUTION
TAX CLASSES