Sample assessment query for budgeting, level 4
Jayney
AAT Student, AATQB Posts: 21 Regular contributor ⭐ ? ⭐
I'm sure I must have covered this but obviously missing the point  It is online assessment 2 for budgeting, Task 4.
I need to calculate the sales price index to calculate sales revenue for years 1 to 5 prices & need to project the sales revenue year 1 prices forward to year 5 & calculate the year 5 sales revenue forecast.
Yr 1 Yr 2 yr 3 yr 4 yr5
Sales Revenue 12,200 12,747 13527 14091 14891
Sales price index 110.0 114.0 120.0 124.0 130.0
Sales revenue at yr 1 price ? ?
If anyone could show me what to do please. Many thanks
I need to calculate the sales price index to calculate sales revenue for years 1 to 5 prices & need to project the sales revenue year 1 prices forward to year 5 & calculate the year 5 sales revenue forecast.
Yr 1 Yr 2 yr 3 yr 4 yr5
Sales Revenue 12,200 12,747 13527 14091 14891
Sales price index 110.0 114.0 120.0 124.0 130.0
Sales revenue at yr 1 price ? ?
If anyone could show me what to do please. Many thanks
0
Comments

Dear Jayney
Here is a word doc of a spreadsheet I produced using your figures
The general approach to removing inflation from a set of figures is to divide each sales revenue value by the price index for that year (e.g. year 2 £12,747/114)
If you have then been asked to put all of the values into the value at year 1 prices you multiply your answer by the year 1 index
So the year 2 sales revenue at year 1 prices is found by :
Year 2 Sales Revenue x Year 1 Sales price index =
Year 2 Sales price index
£12,747 x 110 = £12,299.74
im114
I didn't follow the year 5 forecast as you already have that value.
But I can see that the actual question does not give you the £14,891 value
The way to derive it is to use the values you have for the year 1 prices: Find the rate of growth on a yearly basis  here the annual increase (at year 1 prices is £100)
 Add £100 onto the year 4 sales revenue at year 1 prices  this gives you the year 5 sales revenue at year 1 prices
 Divide the sales revenue (yr 5 at yr 1 prices) by the index for year 1 , then multiply the answer by the index for year 5
Sandy
[email protected]1 
Thank you Sandy for your help  that has helped a lot
0 
Thanks Jayney and Sandy
Sandy you are awesome your explanation is so clear to understand and precise. You have saved me from going into bewilderment.
Kind regards to both
Shilpa
0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 251 NEW! Qualifications 2022
 139 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 35 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
 137 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