assignment

NUR4327-Financial-Forecasting-Model.xlsx

Sheet1

Prior Year Revenue Budget			300 patient
Source of Payment	Percent	Number	Payment	Income
Medicare	34%	102	22,436	2,288,472
Medicaid	11%	33	18,400	607,200
Contracted Insurance	45%	135	29,540	3,987,900
Non-contracted Ins	3%	9	32,350	291,150
ACA Plans	5%	15	16,400	246,000
Self-pay	2%	6	17,400	104,400
Total		300		7,525,122
Next Year Revenue Projections			340 patient
Source of Payment	Percent	Number	Payment	Income
Medicare	42%	143	22,463
Medicaid	18%	61	18,400
Contracted Insurance	18%	61	29,549
Non-contracted Ins	1%	3	32,350
ACA Plans	18%	61	16,400
Self-pay	3%	11	16,400
Total	100%	340
					To be cut from the budget to serve same number of patients