Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. Calculate the budgeted cash receipts from debtors for the period January 2023 to April 2023.
  2. Calculate the values of A to AM.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

What are the benefits and limitations of social franchising?

Answered: 1 week ago