jagomart
digital resources
picture1_Excel Sample Sheet 41094 | 24   10 Year Differential Fee Forecasting Model V3


 207x       Filetype XLSX       File size 0.38 MB       Source: busfin.osu.edu


File: Excel Sample Sheet 41094 | 24 10 Year Differential Fee Forecasting Model V3
sheet 1 summary 10year 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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
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

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet summary year projected differential fee revenue forecast fy rank pharmacy total incremental margin base...

no reviews yet
Please Login to review.