October 29, 2023
I am struggling with how to model and automate this revenue forecast.
I will apricate everyone's assistance.
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.
January 31, 2022