Cash Management sample assessment Paper 1
Henson
Registered Posts: 1
I am struggling to understand the answer for Task 3 question c which asks to identify the value of trade payables at the end of period 3 that will be paid in periods 4 and 5.
Please help!
Please help!
0
Comments

Hi Henson,
The balances they give you aren't 100%, balance 1 is 35%, 2 is 75% and 3 is 100%.
Hope that helps.0 
A company has supplied information regarding its forecast sales, labour costs and purchases:
Purchases:
The company pays its suppliers on the basis of 25% one month after the date of purchase, 40% two months after the date of purchase and 35% three months after the date of purchase. At the end of period 3 the balance of trade payables is forecast to be:
Balance from period 1 =£30,135
Balance from period 2 =£66,900
Balance from period 3 =£92,400
Total payables at the end of period 3 =£189,435
Identify the value of trade payables at the end of period three that will be paid in period 4 and 5.

Solution: The question is actually asking to calculate payments that will be made in period 4 & 5.
To do this we need to find out the original purchase amount which is missing in the question.
So we will make a simple key of purchase payment as follows:
Purchase Payments Key:
one month after: 25%
two months after: 40%
three months after: 35%
So the payments schedule will follow the following pattern (we can do this in a two way table as well):
For purchases made in PR1: Payments will be 25% in period 2; 40% in period 3; 35% in period 4
For purchases made in PR2: Payments will be 25% in period 3; 40% in period 4; 35% in period 5
For purchases made in PR3: Payments will be 25% in period 4; 40% in period 5; 35% in period 6
Payment Schedule
The original purchase figure which is missing can now be calculated with the following formula:
Purchase = (100% / % of Bal left) × Bal left in £'s
Purchase in PR1: (100% / 35% Bal left) × £30135 Bal left = £86100
Purchase in PR2: (100% / 75% Bal left) × £66900 Bal left = £89200
Purchase in PR3: (100% / 100% Bal left) × £92400 Bal left = £92400
Now, look back at the purchase payment schedule done above.
So, we can see that in period 4 we will make the following payments:
From Purchase in PR1 0.35 × 86100 = £30,135
From Purchase in PR2 0.40 × 89200 = £35,680
From Purchase in PR3 0.25 × 92400 = £23,100
Total Payments in Period 4 = £88,915
And, In period 5 we will make the following payments:
From Purchase in PR2 0.35 × 89200 = £31,220
From Purchase in PR3 0.40 × 92400 = £36,960
Total Payments in Period 5 = £68,180
Also, Period 3 TAccounts will appear as shown under:
Please do correct me if I am wrong.
Thank you.
M.Goldwater0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 317 NEW! Qualifications 2022
 155 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 92 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.2K General accounting discussion
 201 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 582 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership