Budget Impact Analysis in Excel: A Beginner’s Guide

I explain how you can build a simple budget impact model (BIM) in Excel 💡📊
Want to learn about Markov Cohort Simulations for Cost-Effectiveness? Watch this 👉 https://www.youtube.com/watch?v=UWJ7kVZZcQA&list=UULFCWndUzziarMjA4pDG1ps2A
----------------------------------------
CONNECT WITH ME 📲
Twitter: https://x.com/vonHeinMirko
LinkedIn: https://www.linkedin.com/in/mirko-von-hein-b9885110b/
Instagram: https://www.instagram.com/mirkovonhein
Facebook: https://www.facebook.com/profile.php?id=61566466527249
----------------------------------------
TIMECODES ⏰
0:00 Intro
0:40 Scenario & Objective
1:34 Cost Inputs
6:21 Epidemiology Inputs
9:24 Eligible Patient Population
10:21 Market Shares / Uptake Assumptions
11:54 Building the Model Engine
15:49 Budget Impact Results & Visualisation
17:50 Other Aspects to Consider for Budget Impact Analysis
----------------------------------------
SUBSCRIBE TO MY CHANNEL 🔔
https://www.youtube.com/@MirkovonHein?sub_confirmation=1
----------------------------------------
REFERENCES 📚
Sullivan, S. D., Mauskopf, J. A., Augustovski, F., Caro, J. J., Lee, K. M., Minchin, M., ... & Shau, W. Y. (2014). Budget impact analysis—principles of good practice: report of the ISPOR 2012 Budget Impact Analysis Good Practice II Task Force. Value in health, 17(1), 5-14.
Mauskopf, J., Earnshaw, S. R., Brogan, A., Wolowacz, S., & Brodtkorb, T. H. (2017). Budget-impact analysis of health care interventions. Cham, Switzerland: Springer.
NICE Budget Impact Template:
https://www.nice.org.uk/corporate/ecd7/resources/budget-impact-template-excel-11189604349
The British National Formulary (Drug List Prices for England & More):
https://bnf.nice.org.uk/drugs/
Clinical Practice Research Datalink:
https://www.cprd.com/
Hospital Episode Statistics (HES):
https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics
----------------------------------------
TEMPLATES 🗂️
Download the Excel file I used for this Tutorial: https://github.com/MvonHein/Budget-Impact-Analysis/blob/main/BIM_Tutorial.xlsx
----------------------------------------
HASHTAGS 🏷️
#BudgetImpact #Excel #EconomicModelling

Видео Budget Impact Analysis in Excel: A Beginner’s Guide канала Mirko von Hein