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
https://vimeo.com/1082299355/df98ecb51c?share=copy
https://vimeo.com/1083648272/41c11ac129?share=copy
https://vimeo.com/1084018664/98b407e9df?share=copy
https://vimeo.com/1084382347/955a40ed89?share=copy
https://vimeo.com/1085810523/2b41d668f9?share=copy
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
https://vimeo.com/1087819935/bee7467aa6?share=copy
https://vimeo.com/1088171093/a11b21c665?share=copy
https://vimeo.com/1088531050/8a588aa28f?share=copy
https://vimeo.com/1089844836/3f34162297?share=copy
https://vimeo.com/1090225100/549adce2d2?share=copy
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
https://vimeo.com/1090225103/58392b572f?share=copy
https://vimeo.com/1090612424/98c0509186?share=copy
https://vimeo.com/1091907238/a94ee5633c?share=copy
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
https://vimeo.com/1092237784/c19be946b5?share=copy
https://vimeo.com/1092572198/8a48754f92?share=copy
https://vimeo.com/1094165161/698a249d1c?share=copy
https://vimeo.com/1094499934/735deb2acb?share=copy
https://vimeo.com/1095710692/88e3c6698d?share=copy
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
https://vimeo.com/1095710700/b70f726caa?share=copy
https://vimeo.com/1096040376/7bc99f0132?share=copy
https://vimeo.com/1096370499/21949a9c61?share=copy
https://vimeo.com/1097636137/33ab57160f?share=copy
https://vimeo.com/1097968601/320474bca0?share=copy
https://vimeo.com/1098295666/2d2cdfe5da?share=copy
https://vimeo.com/1099452995/36de5d8d93?share=copy
https://vimeo.com/1099767329/3ec5375264?share=copy
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
https://vimeo.com/1100092880/97765c6a71?share=copy
https://vimeo.com/1101316814/699be1a4fc?share=copy
https://vimeo.com/1101649630/32f3e947b7?share=copy
https://vimeo.com/1101983594/0ea7897c7c?share=copy
https://vimeo.com/1103240913/bc1a3ad292?share=copy
https://vimeo.com/1103575823/d9aafebedd?share=copy
https://vimeo.com/1105240770/14c0ef73bd?share=copy
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
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/07/MANAGEMENT-ACCOUNTING-CLASS-SOLUTION-1.xlsx
https://vimeo.com/1105571286/59ce2ef36a?share=copy
https://vimeo.com/1105898741/74af34077a?share=copy
TAX CLASSES
https://vimeo.com/1102307137/1f290cbd89
https://vimeo.com/1104251328/e1d0cc325c
https://vimeo.com/1105240770/14c0ef73bd
https://vimeo.com/1105898741/74af34077a
https://vimeo.com/1106242410/c02ca6a714