spreadsheet and influence chart question (Loan Calculator)

Sheet1

R. Saltzman		Health Care Premiums Model					2/1/18
Inputs	Salaried	Hourly		Annual_Employee_GR_Hourly				=Sheet1!$C$5
Current Number Employed	30	70		Annual_Employee_GR_Salaried				=Sheet1!$B$5
Annual Employee GR	15%	25%		Annual_Premium_GR				=Sheet1!$B$8
Average Annual Premium	$8,850	$5,310		Average_Annual_Premium_Hourly				=Sheet1!$C$6
				Average_Annual_Premium_Salaried				=Sheet1!$B$6
Annual Premium GR	4%
Projected Premiums	No. of Employees		Ave. Annual Premium		Total Costs ($1,000)
Years from Now	Salaried	Hourly	Salaried	Hourly	Salaried	Hourly	Combined
0	30	70	$8,850	$5,310	$266	$372	$637
1	35	88	$9,204	$5,522	$322	$486	$808
2	40	110	$9,572	$5,743	$383	$632	$1,015
3	46	138	$9,955	$5,973	$458	$824	$1,282
4	53	173	$10,353	$6,212	$549	$1,075	$1,623
5	61	216	$10,767	$6,460	$657	$1,395	$2,052
1-way Data Table
	Annual Premium	Total Costs in $1000s in Year 5
	GR	Salaried	Hourly	Combined		Ratio to
		$657	$1,395	$2,052		Year 0 Total
	2%	$596	$1,266	$1,862		2.923
	3%	$626	$1,330	$1,955		3.069
	4%	$657	$1,395	$2,052		3.221
	5%	$689	$1,464	$2,153		3.379
	6%	$722	$1,535	$2,257		3.543
	7%	$757	$1,609	$2,366		3.713
	8%	$793	$1,685	$2,478		3.890
	9%	$831	$1,765	$2,595		4.073
	10%	$869	$1,847	$2,717		4.263
2-way Data Table		Hourly Employee GR
	$2,052	15%	20%	25%	30%	35%
	5%	$1,342	$1,555	$1,826	$2,104	$2,472
Salaried Employee	10%	$1,428	$1,641	$1,912	$2,190	$2,558
GR	15%	$1,568	$1,781	$2,052	$2,330	$2,698
	20%	$1,708	$1,921	$2,192	$2,470	$2,838
	25%	$1,923	$2,136	$2,408	$2,685	$3,054

Projected HC Premiums

Salaried 0 1 2 3 4 5 265.5 322.14 382.88640000000004 457.93213440000005 548.72215756800006 656.81006936064 Hourly 0 1 2 3 4 5 371.7 485.97120000000007 631.76256000000012 824.27784192000024 1074.6671689728003 1395.4522129367044 Combined 0 1 2 3 4 5 637.20000000000005 808.11120000000005 1014.6489600000002 1282.2099763200004 1623.3893265408003 2052.2622822973444

Years From Now

Costs in $1,000s