Forum

Notifications
Clear all

Assitance with Revenue Forecast

2 Posts
2 Users
0 Reactions
64 Views
(@oluwabusayosalamigmail-com)
Posts: 1
New Member
Topic starter
 

I am struggling with how to model and automate this revenue forecast.

I will apricate everyone's assistance. 

Rule:

For each of the three scenarios, revenue will not be accrued until three months after energization date.

Single Point: 100% Revenue 3 months from energization date

<25 Points: Assume 25% of Points adopted every 3 months for 4times and revenue becomes flat for other periods

>=25 Points: Assume 25% of Points adopted every 6 months for 4times and revenue becomes flat for other periods

Simple term, if energisation date is 1st Nov 2023, Revenue won't start until Feb 2024. Depending on the number of points (for instance <25), revenue in Feb 2024 will be (0.25*expected revenue). march and April will be the same and when it comes to may, the revenue will be (25%+25% additional). June and July will have the same revenue as May.

The revenue will increase again by 25% of the expected revenue (25%+25%+25%) in August. The revenue for Sep and Oct will be the same as August. In November, the revenue will increase by additional 25% of the expected revenue (25%+25%+25%+25%), this means that the 100% is complete. After November, the revenue will be flat for  the rest of the forecast period.

I want excel to commence revenue three months after energization, and apply the above rule to each project site income.

I have attached the an excel file with data structure for assistance.

 
Posted : 30/10/2023 10:40 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Would be helpful if you could also include the expected results in your file. Calculated manually, that is. I find it hard to 'translate' the rules into a formula otherwise.

 
Posted : 31/10/2023 1:16 am
Share: