Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The information given below has been made available by Pep Retailers to assist in the preparation of the cash budget for the fourth quarter of

The information given below has been made available by Pep Retailers to assist in the preparation of the cash budget for the fourth quarter of 2023.
1. Estimated cash sales after a 10% cash discount are as follows:
September R720 000
October R792 000
November R864 000
December R1 044 000
2. Forty percent (40%) of the sales is for cash and 60% is on credit.
3. Payments by debtors for credit sales are received in the month after the sale.
4. Expected inventory purchases (excluding discounts) are as follows:
September R960 000
October R1 040 000
November R1 120 000
December R680 000
Inventory purchases are paid for in the month of the purchase to take advantage of a 10% discount.
5. Details regarding recurring monthly expenses are as follows:
5.1 The salary bill for December 2023 is R316 800, 10% more than the salaries for each of the preceding two months.
5.2 Other monthly expenses are paid monthly and amount to R384 000, including depreciation of R80 000.
6. Pep Retailers is expected to obtain a long-term loan of R560 000 on 01 November 2023 with an expansion project in mind for 2024. Interest is charged at 18% per annum. Capital repayments of R20 000 and interest are to be paid monthly, commencing 30 November 2023.
7. The annual property rates will be paid 01 November 2023. The assessment for the year is calculated at R4 per R100 of the property value. The property is valued at R1 800 000.
8. Pep Retailers expects to have an unfavorable bank balance of R100 000 on 30 September 2023.

Prepare the Cash Budget for October, November and December 2023 from the information provided above

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

CIA Review Part 2 Internal Audit Practice For The New 3 Part Exam

Authors: Irvin N.Gleim

17th Edition

158194375X, 978-1581943757

More Books

Students also viewed these Accounting questions