Question

Use the data below to extrapolate figures for 2018. Also, provide graphs and step by step if possible.

	Fiscal year 2018 Projected	Fiscal year 2017	Fiscal year 2016	Fiscal year 2015	Fiscal year 2014	Fiscal year 2013
Total operating revenue		$ 2,234,552.00	$ 1,748,836.00	$ 1,514,836.00	$ 1,320,259.00	$ 1,163,337.00
Non-operating revenue		$       47,376.00	$       24,560.00	$         1,227.00	$       22,416.00	$      46,261.00
Facility costs		$       94,446.00	$       82,235.00	$       75,451.00	$       86,267.00	$      81,245.00
Personnel costs		$ 1,185,879.00	$     653,587.00	$     548,966.00	$     514,403.00	$    485,400.00
Future capital expenditures, debt retirement and additions to reserves		$    101,879.00	$     124,528.00	$     158,597.00	$       93,877.00	$      77,471.00
Medical and other expenses		$    889,724.00	$     843,549.00	$     733,049.00	$     648,128.00	$    565,482.00

Answer 1

	Fiscal year 2013	Fiscal year 2014	Fiscal year 2015	Fiscal year 2016	Fiscal year 2017	Av.Increase (Sum)/4	Fiscal year 2018 Projected(2017 figure*Av.Increase)
Total operating revenue	1163337	1320259	1514836	1748836	2234552		2633643
Horizontal Trend		13.49%	14.74%	15.45%	27.77%	17.86%
Non-operating revenue	46,261	22,416	1,227	24560	47,376		218931
Horizontal Trend		-51.54%	-94.53%	1901.63%	92.90%	462.11%
Facility costs	81,245	86,267	75,451	82,235	94,446		98573
Horizontal Trend		6.18%	-12.54%	8.99%	14.85%	4.37%
Personnel costs	485,400	514,403	548,966	653,587	1,185,879		1521483
Horizontal Trend		5.98%	6.72%	19.06%	81.44%	28.30%
Future capital expenditures, debt retirement and additions to reserves	77,471	93,877	158,597	124,528	101,879		114726
Horizontal Trend		21.18%	68.94%	-21.48%	-18.19%	12.61%
Medical and other expenses	565,482	648,128	733,049	843,549	889,724		997114
Horizontal Trend		14.62%	13.10%	15.07%	5.47%	12.07%