Ordinary level 2023 South West regional mock financial reporting 3

Ordinary level 2023 South West regional mock financial reporting 3

Ordinary level 2023 South West regional mock financial reporting 3

PART ONE (50 marks)
AKUM & Bros, based in KUMBA, has decided to process automatically the customer invoice
schedules using Excel spreadsheets.
Intern in this company after exams, the person in charge of encashment gives you in the
table in the appendix an extract of the schedule as of 30/12/2022 and asks you to complete it
automatically. The following questionnaire will guide you through this task.
1- Start the Excel spreadsheet and reproduce the table below (appendix 1).
(10 marks)
2- Introduce in cell F3 the formula =E3*(1+$C$13) to have the amount Tax Inclusive of
AGWAFOR then use the copy command to have the amount Tax Inclusive for the others, from

total amount Tax Exclusive of unpaid invoices.
(5 marks)
4- Adapt the formula of question 2 in cell F14 to have the total amount including VAT of unpaid