Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help with what's required on the picture The following information relates to Nappy Limited. The company is preparing its budget for 2020 and will
please help with what's required on the picture
The following information relates to Nappy Limited. The company is preparing its budget for 2020 and will detail the activities for each quarter of the year. 1. The following balances are expected on 31 December 2019 Cash at bank R200 000 Trade creditor for purchases R80 000 2. Projected sales per quarter for 2020: R500 000 R750 000 First quarter Second quarter Third quarter Fourth quarter R800 000 R950 000 Thirty percent of the sales are for cash and these customers are entitled to a 3% cash discount. 3. Collection of credit sales: 60% of the credit sales are collected in the quarter of the sale and they are allowed a discount of 1%. 35% is collected in the following quarter and the balance is written off as a bad debt. 1 4. Purchases for each quarter are expected to be as follows: R80 000 R100 000 First quarter Second quarter Third quarter Fourth quarter R120 000 R150 000 40% of the purchases are paid for in the quarter of acquisition and the remaining 60% in the following quarter 5. Fixed overheads total R200 000 per year and are paid for equally each quarter, included in the total is depreciation of R20 000 for the year. 6. Sales commission is 10% of total sales and is paid in the quarter in which they are incurred. 7. Administrative expenses are paid for only in the first and third quarter and are estimated at a total of R30 000 per quarter 8. An investment of R100 000 matures on 31 May 2020, and interest of R8 000 will also be received on this date, Required: 2.1. Prepare a Debtors schedule for the four quarters. (6) 2.2. Prepare a Cash budget for the four quarters ending 31 December 2020 (24)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