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
 18.9K For AAT students
 248 NEW! Qualifications 2022
 138 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership