Lesson 1 of 0

SEPTEMBER-DECEMBER 2024[EVENING]

INTRODUCTION TO BDA


TOPIC 3 CORE APPLICATIONS 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

CLASS FILE

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/FINANCIAL-STATEMENTS.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/FINANCIAL-STATEMENTS-CLASS-SOLUTION-3.xlsx






Statement of Cashflows IAS 7
CLASS FILE
FINANCIAL STATEMENTS STATEMENT OF CASHFLOWS IAS7
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/FINANCIAL-STATEMENTS-STATEMENT-OF-CASHFLOWS-IAS7-1.xlsx

CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/09/QUIZ-ASSIGNMENT-ONE.xlsx

CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/09/QUIZ-ASSIGNMENT-ONE.xlsx

GROUP CASHFLOW STATEMENTS

CLASS FILE

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/GROUP-FINANCIAL-STATEMENTS.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/GROUP-FINANCIAL-STATEMENTS.xlsx

GROUP INCOME STATEMENT & STATEMENT OF FINANCIAL POSITION
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/GROUP-FINANCIAL-STATEMENTS-2.xlsx

CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/GROUP-FINANCIAL-STATEMENTS-2.xlsx


ANALYSIS OF FINANCIAL STATEMENTS USING RATION VERTICAL AND TREND ANALYSIS

CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/ANALYSIS-OF-FINANCILA-STATEMENTS.xlsx
CLASS SOLUTION
FORECASTING OF FINANCIAL STATEMENTS CLASS SOLUTION







3.2 FINANCIAL MANAGEMENT
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/FINANCIAL-MANAGEMENT-CLASS-FILE.xlsx

CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/FINANCIAL-MANAGEMENT-CLASS-SOLUTION-4.xlsx





MANAGEMENT ACCOUNTING

CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/MANAGEMENT-ACCOUNTING-CLASS-FILE.xlsx

CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/MANAGEMENT-ACCOUNTING-CLASS-SOLUTION-3.xlsx

COST ESTIMATION USING HIGH-LOW METHOD AND REGRESSION ANALYSIS METHOD






SELECTIVE SECTIONS

AUDIT AND ASSURANCE

CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/Audit-Schedule-Class-File.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/Audit-Schedule-Class-Solution-1.xlsx


AUGUST 2024 Q25[XLOOKUP VLOOKUP]

CLASS FILE

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/EXCEL-FUNTIONS-AND-FORMULAS.xlsx

CLASS SOLUTION

https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/EXCEL-FUNTIONS-AND-FORMULAS-SOLUTION.xlsx

TAXATION
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2024/08/TAXATION-OF-EMPLOYMENT-INCOME-2.pptx