Lesson 1 of 0

SEP-DEC 2025 EVENING VIDEOS

ANALYSIS OF BDA COURSE CONTENTS AND PREDICTIONS (FOR BDA EXAMS IN DECEMBER 2025)

NOTES FOR THE THEORY TOPICS[1, 2, 5]

CLICK ON THE ATTACHED LINK TO ACCESS THE NOTES

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/09/INTRODUCTION-TO-EXCEL-FUNTIONS-AND-FORMULAS-CLASS-SOLUTION-3.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/09/FINANCIAL-STATEMENTS-CLASS-FILE-1.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/FINANCIAL-STATEMENTS-CLASS-SOLUTION-5.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/09/FINANCIAL-STATEMENTS-STATEMENT-OF-CASHFLOWS-IAS7-CLASS-SOLUTION-1.xlsx

Group Accounts [Consolidated Financial Statements]

Class File

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/GROUP-FINANCIAL-STATEMENTS-CLASS-FILE.xlsx

Class Solution

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/GROUP-FINANCIAL-STATEMENTS-CLASS-SOLUTION-4.xlsx

Analyse financial statements using ratios, common size statements, trend
and cross-sectional analysis, graphs and charts

CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/06/FORECASTING-AND-ANALYSIS-OF-FINANCIAL-STATEMENTS-CLASS-FILE.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/FORECASTING-AND-ANALYSIS-OF-FINANCIAL-STATEMENTS-CLASS-SOLUTION-3.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/10/FINANCIAL-MANAGEMENT-CLASS-FILE.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/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/09/MANAGEMENT-ACCOUNTING-CLASS-FILE.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2025/09/MANAGEMENT-ACCOUNTING-CLASS-SOLUTION-4.xlsx