207x Filetype XLSX File size 0.38 MB Source: busfin.osu.edu
Sheet 1: Summary
10-YEAR PROJECTED DIFFERENTIAL FEE REVENUE FORECAST SUMMARY | ||||||||||||
FY 2019 | FY 2020 | FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | FY 2026 | FY 2027 | FY 2028 | |||
PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | PROJECTED REVENUE | |||
Rank 1 | Pharmacy - Rank 1 - Differential | 108,160 | 14,061 | 14,131 | 14,202 | 14,273 | 14,344 | 14,416 | 14,488 | 14,560 | 14,633 | |
Rank 2 | Pharmacy - Rank 2 - Differential | 109,025 | 14,173 | 14,244 | 14,315 | 14,387 | 14,459 | 14,531 | 14,604 | 14,677 | 14,750 | |
Rank 3 | Pharmacy - Rank 3 - Differential | 114,217 | 14,848 | 14,922 | 14,997 | 15,072 | 15,147 | 15,223 | 15,299 | 15,376 | 15,453 | |
Rank 4 | Pharmacy - Rank 4 - Differential | 162,537 | 21,130 | 21,236 | 21,342 | 21,448 | 21,556 | 21,663 | 21,772 | 21,881 | 21,990 | |
Total Projected Revenue | $493,940 | $64,212 | $64,533 | $64,856 | $65,180 | $65,506 | $65,834 | $66,163 | $66,494 | $66,826 | ||
INCREMENTAL DIFFERENTIAL FEE MARGIN | ||||||||||||
FY2019 | FY2020 | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 | FY2027 | FY2028 | |||
Pharmacy - Rank 1 - Margin | 433 | 56 | 57 | 57 | 57 | 57 | 58 | 58 | 58 | 59 | ||
Pharmacy - Rank 2 - Margin | 433 | 56 | 57 | 57 | 57 | 57 | 58 | 58 | 58 | 59 | ||
Pharmacy - Rank 3 - Margin | 433 | 56 | 57 | 57 | 57 | 57 | 58 | 58 | 58 | 59 | ||
Pharmacy - Rank 4 - Margin | 433 | 56 | 57 | 57 | 57 | 57 | 58 | 58 | 58 | 59 | ||
Total Base Margin: | $1,731 | $225 | $226 | $227 | $228 | $230 | $231 | $232 | $233 | $234 |
no reviews yet
Please Login to review.