Sales revenue forecast
DaleB91
Registered Posts: 3
Can somebody please clarify for me how to calculate the answer to the following question:
Year 1 Actual Year 2 Actual Year 3 Actual Year 4 Actual Year 5 Forecast
Sales Revenue: 12200 12474 13527 14091 ??
Sales price index: 110.0 114.0 120.0 124.0 130.0
Sales Revenue @ yr1 prices: ?? ?? ?? ??
1) Use sales price index to calculate sales revenue for years 1 to 4 at year 1 prices
2) Project the sales revenue at year 1 prices forward to year 5
3) Calculate the year 5 sales revenue forecast
Year 1 Actual Year 2 Actual Year 3 Actual Year 4 Actual Year 5 Forecast
Sales Revenue: 12200 12474 13527 14091 ??
Sales price index: 110.0 114.0 120.0 124.0 130.0
Sales Revenue @ yr1 prices: ?? ?? ?? ??
1) Use sales price index to calculate sales revenue for years 1 to 4 at year 1 prices
2) Project the sales revenue at year 1 prices forward to year 5
3) Calculate the year 5 sales revenue forecast
0
Comments

1. Take actual income, divide by sales price index for year, multiply by year 1 sales price index.
The other two parts look like they need more information, is that the full question? There's no obvious trend to calculate yr 5 revenues so assume you must be given more figures.0 
Thanks, I know how to answer this question now.0

Hi , I can't get my head around this. Can you help please? thanks0

EvaP
I think CeeJaySix has given a clear explanation. I'll use it but put the numbers from the task into an example. I hope this will help you.
I think the Sales Revenue for year 2 given by DaleB91should be £12,747 and not £12,474. This explanation is based on that assumption. In year 1 the Sales Revenue is £12,200. As all the sales revenue is required at year 1 prices, this value can be kept at £12,200.
 In year 2 the Sales Revenue is £12,747 but the sales price index in year 2 was 114.0 (because this is higher than the index of 110.0 in year 1 this means there has been inflation in year 2). To take out the effect of inflation in the sales revenue we divide the sales revenue by the year 2 index and then multiply by the year 1 index:
£12,747 divided by 114.0 = 111.82 and then multiply by 110.0 =£12,300  In year 3 Sales Revenue £13,527 index 120.0 = 112.725 x 110 = £12,400
 In year 4 Sales Revenue £14,091 index 124.0 =113.64 x 110 = £12,500
Year.................Sales Revenue ................£12,200
 ................£12,300
 ................£12,400
 ................£12,500
As we know the forecast sales price index for year is 130.0 we can use this to find the year 5 sales revenue [at year 5 prices] forecast.
Year 1index sales revenue divided by year 1 index x year 5 sales price index = year 5 sales revenue
for year 5
£12,600 .................divided by 110.0 ......................x..................... 130.0 ......................= £14,891
The bold calculation is intended to line up with the word based formula above
I hope this is a help for EvaP and any other reader
I don't look at the forum everyday, so if you would like any further assistance or clarification you can contact me by email or look at my website
Yours
Sandy
sandy@sandyhood.com
www.sandyhood.comSandy
sandy@sandyhood.com
www.sandyhood.com2  In year 1 the Sales Revenue is £12,200. As all the sales revenue is required at year 1 prices, this value can be kept at £12,200.
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 323 NEW! Qualifications 2022
 165 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 88 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 273 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 200 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