Question
You have been employed as the financial manager of RPP Ltd. One of the points on the agenda for the upcoming board meeting is the
You have been employed as the financial manager of RPP Ltd. One of the points on the agenda for the upcoming board meeting is the forecasted performance of the business for the period January 2023 to April 2023. Also, the board would like to know the impact of the forecast on the cash flow for the same period.
Your predecessor had started the process and left you the following incomplete schedule.
January 2023 | February 2023 | March 2023 | April 2023 | |
Abbreviate statement of comprehensive income:
Sales
Cost of Sales
Gross Profit
Expenses paid in cash
Net Profit
|
R191 400
A
E
(R15 000)
I |
R203 500
B
F
(R16 000)
J |
R213 400
C
G
(R17 000)
K |
R231 000
D
H
(R18 000)
L |
| ||||
Bank Balance: Opening Balance
Movement during the month
Expenses paid in cash
Creditors settled in cash
Cash Sales for the month
Cash receipts from debtors
Closing Balance for the month |
R195 320
AC
M
Q
U
Y
AD |
AE
AF
N
R
V
Z
AG |
AH
AI
O
S
W
AA
AJ |
AK
AL
P
T
X
AB
|
Additional Information:
- The business trades at a constant mark-up on cost.
- 60% of sales are on credit.
- Debtors are collected as follows:
- 65% of outstanding amounts are collected during the second month following the month in which the sale took place. (60 days)
- 25% are collected during the third month following the month in which the sale took place. (90 days)
- 5% are collected during the fourth month following the month in which the sale took place. (120 days)
- 5% irrecoverable
- All purchases of inventory are on credit, and creditors are all paid in the month following the month during which the goods were acquired. (30 days)
- All inventory purchased during the month is sold within the same month.
- There are no stock losses.
You gather the following historical data:
Actual Sales | Sept 2022 | Oct 2022 | Nov 2022 | Dec 2022 |
Total Sales
Cost of Sales
Gross profit
| R159 500
(R119 625)
R39 875 | R167 200
(R125 400)
R41 800 | R177 100
(R132 825)
R44 275 | R187 000
R140 250)
R46 750 |
REQUIRED:
- Calculate the budgeted cash receipts from debtors for the period January 2023 to April 2023.
- Calculate the values of A to AM.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started