Prepare the Cash Budget for October, November and December 2023 from the information provided below. Note:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare the Cash Budget for October, November and December 2023 from the information provided below. Note: Where applicable, round off amounts to the nearest Rand. Use separate monetary columns for each month. INFORMATION 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 October November December 2. 3. 4. Forty percent (40%) of the sales is for cash and 60% is on credit. Payments by debtors for credit sales are received in the month after the sale. Expected inventory purchases (excluding discounts) are as follows: September October 7. November December 8. R720 000 R792 000 R864 000 R1 044 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. R960 000 R1 040 000 R1 120 000 R680 000 6. 5.2 Other monthly expenses are paid monthly and amount to R384 000, including depreciation of R80 000. 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. 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. Pep Retailers expects to have an unfavourable bank balance of R100 000 on 30 September 2023. Prepare the Cash Budget for October, November and December 2023 from the information provided below. Note: Where applicable, round off amounts to the nearest Rand. Use separate monetary columns for each month. INFORMATION 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 October November December 2. 3. 4. Forty percent (40%) of the sales is for cash and 60% is on credit. Payments by debtors for credit sales are received in the month after the sale. Expected inventory purchases (excluding discounts) are as follows: September October 7. November December 8. R720 000 R792 000 R864 000 R1 044 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. R960 000 R1 040 000 R1 120 000 R680 000 6. 5.2 Other monthly expenses are paid monthly and amount to R384 000, including depreciation of R80 000. 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. 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. Pep Retailers expects to have an unfavourable bank balance of R100 000 on 30 September 2023.
Expert Answer:
Answer rating: 100% (QA)
To prepare the cash budget for Pep Retailers for October November and December 2023 youll need to account for the cash inflows and outflows during the... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Virtual Machines (VMs) are a major component in enterprise networks today. Research what VMs are and explore the following: how they work, the types (Type 1 and 2 hypervisors), what they are commonly...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
You are a senior auditor with Rodriguez & Jones, a small auditing firm located in Canterbury, an eastern suburb of Melbourne, Victoria. Your team has been assigned to the audit of a new client,...
-
Modify Index to make a program IndexByKeyword that takes a file name from the command line and makes an index from standard input using only the keywords in that file. Note: Using the same file for...
-
Use the Maclaurin series for ex to calculate e0.2 correct to five decimal places.
-
It is given that: S = 110, C = 15, P = 5, r = 9.758% (EAR=10.25%), T = 0.5yr, and X = 105. What is the immediate cash flow fromarbitrage?
-
Split the National Football League data used in Problem 3.1 into estimation and prediction data sets. Evaluate the statistical properties of these two data sets. Develop a model from the estimation...
-
Tapley Inc. currently has assets of $5 million, has zero debt, is in the 40% federal-plus-state tax bracket, has a net income of $1 million, and pays out 40% of its earnings as dividends. Net income...
-
Baron Von's Munch House offers an equal number of soups and salads, along with 7 types of sandwiches. He advertises 253 possible pairings of his You-Pick-2 special (where customers pick any two...
-
Following are the ordinates of a storm hydrograph of a river draining a catchment area of 423 km due to a 6h storm.. Derive the ordinates of 6h unit hydrograph & plot the same. Time in hr -6 Stream...
-
Compare and contrast process management tools for driving continuous improvement in the performance of value chain activities to help an organization achieve superior strategy execution Competent...
-
Many salespeople, after being introduced to communication- style concepts, attempt to categorize each of their customers. They report that their relationships become mutually more enjoyable and...
-
Suppose you want to estimate a population proportion p. The total population consists of 1,000, your population consists of 100, and the sample proportion is .42. Find a 95 % confidence interval for...
-
Select several advertisements from a trade magazine. Analyze each one and determine which rational buying motives the advertiser is appealing to. Explain whether these advertisements also appeal to...
-
A quality control engineer at the Brite Lite Light Bulb Company wants to test for the number of defective light bulbs in a case of 1,200. From past experience, he knows that the population standard...
-
Books have been written explaining hundreds of different closes that salespeople can use. One close that some salespeople commonly use is called the impending doom close. This is one of many closing...
-
Assuming that the runs made by the Indian cricket team in one-day matches follow a normal distribution. The following is the data on the runs made by the Indian team in ten one-day matches. 110, 150,...
-
The landing gear of an aircraft with: mass of 2000 kg the spring-mass-damper system Consider that the runway surface is y(t) = 0.2 cos 157.08t stiffness of the spring is 5 x 105 N/m. What is the...
-
Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...
-
Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...
-
Sophie is a single taxpayer. For the first payroll period in October 2012, she is paid wages of $3,250 monthly. Sophie claims three allowances on her Form W-4. a. Use the percentage method to...
-
Prove that \(B(x ; n, p)=1-B(n-x-1 ; n, 1-p)\).
-
Prove that \(b(x ; n, p)=b(n-x ; n, 1-p)\).
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
Study smarter with the SolutionInn App