# AAT Cash Management Sample Assessent 1 Task 3 c

ManiGoldwater
Registered Posts:

**11**
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 (wecan do this in a two way table as well):

For purchases made in PR-1: Payments will be 25% in period 2; 40% in period 3; 35% in period 4

For purchases made in PR-2: Payments will be 25% in period 3; 40% in period 4; 35% in period 5

For purchases made in PR-3: Payments will be 25% in period 4; 40% in period 5; 35% in period 6

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 PR-1: (100% / 35% Bal left) × £30135 Bal left = £86100

Purchase in PR-2: (100% / 75% Bal left) × £66900 Bal left = £89200

Purchase in PR-3: (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 PR-1 0.35 × 86100 = £30,135

From Purchase in PR-2 0.40 × 89200 = £35,680

From Purchase in PR-3 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 PR-2 0.35 × 89200 = £31,220

From Purchase in PR-3 0.40 × 92400 = £36,960

Total Payments in Period 5 = £68,180

Also, Period 3 T-Accounts will appear as shown under:

Please do correct me if I am wrong.

Thank you.

M.Goldwater

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 (wecan do this in a two way table as well):

For purchases made in PR-1: Payments will be 25% in period 2; 40% in period 3; 35% in period 4

For purchases made in PR-2: Payments will be 25% in period 3; 40% in period 4; 35% in period 5

For purchases made in PR-3: Payments will be 25% in period 4; 40% in period 5; 35% in period 6

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 PR-1: (100% / 35% Bal left) × £30135 Bal left = £86100

Purchase in PR-2: (100% / 75% Bal left) × £66900 Bal left = £89200

Purchase in PR-3: (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 PR-1 0.35 × 86100 = £30,135

From Purchase in PR-2 0.40 × 89200 = £35,680

From Purchase in PR-3 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 PR-2 0.35 × 89200 = £31,220

From Purchase in PR-3 0.40 × 92400 = £36,960

Total Payments in Period 5 = £68,180

Also, Period 3 T-Accounts will appear as shown under:

Please do correct me if I am wrong.

Thank you.

M.Goldwater

1

#### Categories

- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 18.9K For AAT students
- 265 NEW! Qualifications 2022
- 147 General Qualifications 2022 discussion
- 9 AAT Level 2 Certificate in Accounting
- 42 AAT Level 3 Diploma in Accounting
- 64 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 274 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.3K General accounting discussion
- 193 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 352 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 590 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