I have a shortfall in revenues that i want to cover with prior year funds.
I want to be able to split the shortfall over how many years i designate via drop down and be able to pick the certain years I want to use to cover the shortfall in revenues.
I want to be able to split the shortfall over how many years i designate via drop down and be able to pick the certain years I want to use to cover the shortfall in revenues.
Anticipated Shortfall | Accumulate funds for the shortfall | |||||||||
Also want to select what years to spread the shortfall over | ||||||||||
Revenues | for example pick | |||||||||
2019 | 6,767,799.00 | 2021 | ||||||||
2020 | 14,980,809.00 | 2023 | ||||||||
2021 | 12,391,588.00 | (217,700) | 2025 | |||||||
2022 | 11,493,132.00 | (217,700) | 2026 | |||||||
2023 | 7,211,146.00 | (217,700) | 2027 | |||||||
2024 | 14,612,871.00 | (217,700) | Want to customize the year selection based on revenues available. | |||||||
2025 | 11,384,160.00 | (217,700) | ||||||||
2026 | 8,338,210.00 | (217,700) | ||||||||
2027 | 11,092,400.00 | (217,700) | ||||||||
2028 | 6,096,343.00 | (217,700) | ||||||||
2029 | 7,368,983.00 | (217,700) | ||||||||
2030 | 13,634,153.00 | (217,700) | ||||||||
2031 | 9,838,128.00 | (2,177,000.00) | ||||||||
(2,177,000.00) | ||||||||||
Create a dropdown to select how many years to spread the shortfall evenly over with a maximum of ten years | ||||||||||
Dropdown | # of years | |||||||||
1 | ||||||||||
2 | ||||||||||
3 | ||||||||||
4 | ||||||||||
5 | ||||||||||
6 | ||||||||||
7 | ||||||||||
8 | ||||||||||
9 | ||||||||||
10 |