Spreadsheet And Influence Chart Question (Loan Calculator)

Sheet1

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.0 1.0 2.0 3.0 4.0 5.0 265.5 322.14 382.8864 457.9321344000001 548.722157568 656.81006936064 Hourly 0.0 1.0 2.0 3.0 4.0 5.0 371.7 485.9712000000001 631.7625600000001 824.2778419200002 1074.6671689728 1395.452212936704 Combined 0.0 1.0 2.0 3.0 4.0 5.0 637.2 808.1112000000001 1014.64896 1282.20997632 1623.3893265408 2052.262282297344

Years From Now

Costs in $1,000s