Please help me understand the formulas in excel to create the below:

Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing business, and this is accounted for as the selling expense. The tax rate is 50%. Develop an Excel worksheet to extract and summarize the data needed to develop the income statement for 2014 and implement an Excel model in the form of a pro forma income statement for the company.

Tractor Unit Sales
Month	NA	SA	Eur	Pac	China	World
10-Jan	570	250	560	212	0	1592
10-Feb	611	270	600	230	0	1711
10-Mar	630	260	680	240	0	1810
10-Apr	684	270	650	263	0	1867
10-May	650	280	580	269	0	1779
10-Jun	600	270	590	280	0	1740
10-Jul	512	264	760	290	0	1826
10-Aug	500	280	645	270	0	1695
10-Sep	478	290	650	263	0	1681
10-Oct	455	280	670	258	0	1663
10-Nov	407	290	888	240	0	1825
10-Dec	360	280	850	230	0	1720
11-Jan	571	320	620	250	0	1761
11-Feb	650	350	760	275	0	2035
11-Mar	740	390	742	270	0	2142
11-Apr	840	440	780	280	0	2340
11-May	830	470	690	290	0	2280
11-Jun	760	490	721	300	0	2271
11-Jul	681	481	680	312	0	2154
11-Aug	670	460	711	305	0	2146
11-Sep	640	460	695	290	0	2085
11-Oct	620	440	650	260	0	1970
11-Nov	570	436	680	250	0	1936
11-Dec	533	420	657	240	0	1850
12-Jan	620	510	610	250	10	2000
12-Feb	792	590	680	250	12	2324
12-Mar	890	610	730	260	20	2510
12-Apr	960	600	820	270	22	2672
12-May	1040	620	810	290	20	2780
12-Jun	1032	640	807	310	24	2813
12-Jul	1006	590	760	340	20	2716
12-Aug	910	600	720	320	31	2581
12-Sep	803	670	660	313	30	2476
12-Oct	730	630	630	290	37	2317
12-Nov	699	710	603	280	32	2324
12-Dec	647	570	570	260	33	2080
13-Jan	730	650	500	287	35	2202
13-Feb	930	680	590	290	50	2540
13-Mar	1160	724	620	300	63	2867
13-Apr	1510	730	730	310	68	3348
13-May	1650	760	740	330	70	3550
13-Jun	1490	800	720	340	82	3432
13-Jul	1460	840	670	350	80	3400
13-Aug	1390	830	610	341	90	3261
13-Sep	1360	820	599	330	100	3209
13-Oct	1340	810	560	320	102	3132
13-Nov	1240	827	550	300	110	3027
13-Dec	1103	750	520	290	114	2777
14-Jan	1250	780	480	200	111	2821
14-Feb	1550	805	523	210	121	3209
14-Mar	1820	830	560	220	123	3553
14-Apr	2010	890	570	230	120	3820
14-May	2230	930	590	253	130	4133
14-Jun	2490	980	600	270	136	4476
14-Jul	2440	1002	580	280	134	4436
14-Aug	2334	970	570	250	132	4256
14-Sep	2190	960	550	230	137	4067
14-Oct	2080	930	530	220	130	3890
14-Nov	2050	920	517	190	139	3816
14-Dec	2004	902	490	190	131	3717
Mower Unit Sales
Month	NA	SA	Europe	Pacific	China	World
10-Jan	6000	200	720	100	0	7020
10-Feb	7950	220	990	120	0	9280
10-Mar	8100	250	1320	110	0	9780
10-Apr	9050	280	1650	120	0	11100
10-May	9900	310	1590	130	0	11930
10-Jun	10200	300	1620	120	0	12240
10-Jul	8730	280	1590	140	0	10740
10-Aug	8140	250	1560	130	0	10080
10-Sep	6480	230	1590	130	0	8430
10-Oct	5990	220	1320	120	0	7650
10-Nov	5320	210	990	130	0	6650
10-Dec	4640	180	660	140	0	5620
11-Jan	5980	210	690	140	0	7020
11-Feb	7620	240	1020	150	0	9030
11-Mar	8370	250	1290	140	0	10050
11-Apr	8830	290	1620	150	0	10890
11-May	9310	330	1650	130	0	11420
11-Jun	10230	310	1590	140	0	12270
11-Jul	8720	290	1560	150	0	10720
11-Aug	7710	270	1530	140	0	9650
11-Sep	6320	250	1590	150	0	8310
11-Oct	5840	250	1260	160	0	7510
11-Nov	4960	240	900	150	0	6250
11-Dec	4350	210	660	150	0	5370
12-Jan	6020	220	570	160	0	6970
12-Feb	7920	250	840	150	0	9160
12-Mar	8430	270	1110	160	0	9970
12-Apr	9040	310	1500	170	0	11020
12-May	9820	360	1440	160	0	11780
12-Jun	10370	330	1410	170	0	12280
12-Jul	9050	310	1440	160	0	10960
12-Aug	7620	300	1410	170	0	9500
12-Sep	6420	280	1350	180	0	8230
12-Oct	5890	270	1080	180	0	7420
12-Nov	5340	260	840	190	0	6630
12-Dec	4430	230	510	180	0	5350
13-Jan	6100	250	480	200	0	7030
13-Feb	8010	270	750	190	0	9220
13-Mar	8430	280	1140	200	0	10050
13-Apr	9110	320	1410	210	0	11050
13-May	9730	380	1340	190	0	11640
13-Jun	10120	360	1360	200	0	12040
13-Jul	9080	320	1410	200	0	11010
13-Aug	7820	310	1490	210	0	9830
13-Sep	6540	300	1310	220	0	8370
13-Oct	6010	290	980	210	0	7490
13-Nov	5270	270	770	220	0	6530
13-Dec	5380	260	430	230	0	6300
14-Jan	6210	270	400	200	0	7080
14-Feb	8030	280	750	190	0	9250
14-Mar	8540	300	970	210	0	10020
14-Apr	9120	340	1310	220	5	10995
14-May	9570	390	1260	200	16	11436
14-Jun	10230	380	1240	210	22	12082
14-Jul	9580	350	1300	230	26	11486
14-Aug	7680	340	1250	220	14	9504
14-Sep	6870	320	1210	220	15	8635
14-Oct	5930	310	970	230	11	7451
14-Nov	5260	300	650	240	3	6453
14-Dec	4830	290	300	230	1	5651
Operating and Interest Expenses
Month	Administrative	Depreciation	Interest
10-Jan	$633,073	$140,467	$7,244
10-Feb	$607,904	$165,636	$7,679
10-Mar	$630,687	$142,853	$6,887
10-Apr	$613,401	$160,139	$6,917
10-May	$607,664	$165,876	$8,316
10-Jun	$632,967	$140,573	$7,428
10-Jul	$609,604	$163,936	$8,737
10-Aug	$607,749	$165,791	$7,054
10-Sep	$603,367	$170,173	$8,862
10-Oct	$629,083	$144,457	$8,488
10-Nov	$611,995	$161,545	$7,049
10-Dec	$625,712	$147,828	$8,807
11-Jan	$656,123	$175,447	$7,430
11-Feb	$652,679	$178,891	$6,791
11-Mar	$655,521	$176,049	$8,013
11-Apr	$676,581	$154,989	$8,979
11-May	$676,581	$154,989	$7,484
11-Jun	$656,440	$175,130	$7,858
11-Jul	$661,969	$169,601	$7,424
11-Aug	$677,212	$154,358	$6,848
11-Sep	$653,545	$178,025	$6,751
11-Oct	$657,388	$174,182	$8,160
11-Nov	$672,475	$159,095	$7,898
11-Dec	$656,325	$175,245	$8,953
12-Jan	$723,594	$226,526	$9,443
12-Feb	$759,042	$191,078	$8,464
12-Mar	$749,187	$200,933	$10,264
12-Apr	$751,499	$198,621	$8,547
12-May	$741,452	$208,668	$8,578
12-Jun	$729,122	$220,998	$9,519
12-Jul	$734,783	$215,337	$9,343
12-Aug	$748,208	$201,912	$8,448
12-Sep	$738,186	$211,934	$9,957
12-Oct	$759,403	$190,717	$9,738
12-Nov	$726,183	$223,937	$9,785
12-Dec	$757,037	$193,083	$8,191
13-Jan	$672,232	$179,138	$9,914
13-Feb	$665,023	$186,347	$9,954
13-Mar	$667,657	$183,713	$10,859
13-Apr	$654,198	$197,172	$9,730
13-May	$659,435	$191,935	$10,430
13-Jun	$661,190	$190,180	$10,222
13-Jul	$647,321	$204,049	$10,102
13-Aug	$666,743	$184,627	$10,610
13-Sep	$678,705	$172,665	$9,374
13-Oct	$658,990	$192,380	$10,830
13-Nov	$656,221	$195,149	$9,017
13-Dec	$676,934	$174,436	$10,423
14-Jan	$641,571	$210,589	$9,985
14-Feb	$634,973	$217,187	$9,766
14-Mar	$662,054	$190,106	$11,148
14-Apr	$654,962	$197,198	$9,339
14-May	$645,579	$206,581	$9,468
14-Jun	$658,112	$194,048	$10,324
14-Jul	$637,711	$214,449	$9,737
14-Aug	$638,317	$213,843	$9,290
14-Sep	$651,996	$200,164	$9,213
14-Oct	$630,766	$221,394	$10,143
14-Nov	$645,095	$207,065	$10,383
14-Dec	$637,807	$214,353	$9,059
Unit Production Costs
Month	Tractor	Mower
10-Jan	$1,750	$50
10-Feb	$1,755	$50
10-Mar	$1,763	$51
10-Apr	$1,770	$51
10-May	$1,778	$51
10-Jun	$1,785	$51
10-Jul	$1,792	$51
10-Aug	$1,795	$51
10-Sep	$1,801	$52
10-Oct	$1,804	$52
10-Nov	$1,810	$52
10-Dec	$1,813	$52
11-Jan	$1,835	$55
11-Feb	$1,841	$55
11-Mar	$1,848	$55
11-Apr	$1,854	$55
11-May	$1,860	$56
11-Jun	$1,866	$56
11-Jul	$1,872	$56
11-Aug	$1,878	$56
11-Sep	$1,885	$56
11-Oct	$1,892	$57
11-Nov	$1,897	$57
11-Dec	$1,903	$57
12-Jan	$1,925	$59
12-Feb	$1,931	$59
12-Mar	$1,938	$59
12-Apr	$1,944	$59
12-May	$1,950	$59
12-Jun	$1,956	$60
12-Jul	$1,963	$60
12-Aug	$1,969	$60
12-Sep	$1,976	$60
12-Oct	$1,983	$60
12-Nov	$1,990	$61
12-Dec	$1,996	$61
13-Jan	$1,940	$59
13-Feb	$1,946	$59
13-Mar	$1,952	$59
13-Apr	$1,958	$59
13-May	$1,964	$60
13-Jun	$1,970	$60
13-Jul	$1,976	$60
13-Aug	$1,983	$60
13-Sep	$1,990	$60
13-Oct	$1,996	$60
13-Nov	$2,012	$61
13-Dec	$2,008	$61
14-Jan	$2,073	$63
14-Feb	$2,077	$63
14-Mar	$2,081	$63
14-Apr	$2,086	$63
14-May	$2,092	$63
14-Jun	$2,098	$63
14-Jul	$2,104	$64
14-Aug	$2,110	$64
14-Sep	$2,116	$64
14-Oct	$2,122	$64
14-Nov	$2,129	$64
14-Dec	$2,135	$64
Industry Tractor Total Sales
Month	NA	SA	Eur	Pac	China	World
10-Jan	8143	984	5091	987	278	15483
10-Feb	8592	1051	5310	1090	283	16325
10-Mar	8630	1016	6071	1127	285	17129
10-Apr	8947	1027	5856	1209	288	17327
10-May	8442	1057	5273	1221	286	16278
10-Jun	7500	1019	5315	1327	287	15448
10-Jul	6145	977	7170	1324	289	15905
10-Aug	5882	1057	5926	1268	290	14422
10-Sep	5595	1086	6075	1209	293	14258
10-Oct	5233	1045	6321	1168	295	14061
10-Nov	4494	1078	8381	1127	298	15378
10-Dec	3913	1029	7944	1085	301	14272
11-Jan	5938	1172	5688	1185	306	14289
11-Feb	6633	1273	7037	1286	302	16530
11-Mar	7327	1423	6981	1286	303	17320
11-Apr	8077	1612	7500	1346	307	18842
11-May	7830	1728	6571	1388	309	17826
11-Jun	7103	1815	6990	1449	312	17669
11-Jul	6239	1776	6667	1490	315	16487
11-Aug	6036	1685	6762	1449	318	16250
11-Sep	5664	1679	6635	1394	321	15692
11-Oct	5345	1618	6311	1256	315	14844
11-Nov	4831	1564	6476	1214	318	14402
11-Dec	4454	1522	6250	1171	320	13716
12-Jan	5299	1835	5922	1208	333	14597
12-Feb	6529	2115	6667	1214	313	16836
12-Mar	7120	2202	7228	1256	606	18412
12-Apr	7619	2151	8200	1311	571	19852
12-May	8387	2214	7941	1415	556	20513
12-Jun	8110	2278	7921	1520	526	20355
12-Jul	7752	2100	7677	1675	513	19716
12-Aug	6894	2128	7200	1584	769	18575
12-Sep	6015	2367	6735	1527	750	17394
12-Oct	5368	2211	6495	1422	732	16226
12-Nov	4964	2483	6061	1366	714	15587
12-Dec	4444	1986	5816	1262	698	14207
13-Jan	5000	2257	5051	1373	714	14394
13-Feb	6284	2353	6082	1436	1063	17218
13-Mar	7785	2457	6327	1478	1264	19310
13-Apr	9934	2517	7604	1512	1333	22901
13-May	10645	2612	7789	1642	1556	24244
13-Jun	9491	2749	7347	1667	1739	22993
13-Jul	9182	2887	6979	1733	1702	22483
13-Aug	8528	2833	6489	1700	1915	21465
13-Sep	8293	2789	6316	1642	2083	21123
13-Oct	8221	2765	5833	1576	2128	20523
13-Nov	7470	2746	5789	1493	2292	19789
13-Dec	6509	2534	5591	1450	2245	18329
14-Jan	7267	2635	5106	1010	2292	18311
14-Feb	8807	2703	5474	1045	2449	20477
14-Mar	10168	2795	6022	1106	2400	22489
14-Apr	11044	2997	6064	1150	2353	23607
14-May	12120	3131	6344	1244	2600	25439
14-Jun	13459	3311	6593	1357	2653	27374
14-Jul	13048	3390	6304	1421	2600	26764
14-Aug	12275	3277	6064	1263	2549	25428
14-Sep	11347	3232	5789	1173	2453	23995
14-Oct	10667	3131	5699	1128	2517	23142
14-Nov	10459	3087	5604	974	2541	22666
14-Dec	10082	3030	5444	979	2453	21989
Industry Mower Total Sales
Month	NA	SA	Eur	Pac	World
10-Jan	60000	571	13091	1045	74662
10-Feb	77184	611	17679	1111	96585
10-Mar	77885	658	22759	1068	102369
10-Apr	86190	778	27966	1237	116171
10-May	96117	886	27895	1313	126210
10-Jun	97143	882	30566	1176	129768
10-Jul	84757	848	29444	1359	116409
10-Aug	79804	735	28364	1238	110141
10-Sep	64800	657	28393	1215	95065
10-Oct	59307	595	24444	1154	85500
10-Nov	52157	553	18000	1262	71972
10-Dec	45049	462	12453	1386	59349
11-Jan	58627	553	12778	1443	73401
11-Feb	76200	615	18214	1515	96545
11-Mar	82871	658	23889	1373	108791
11-Apr	84904	784	29455	1442	116584
11-May	93100	846	29464	1215	124625
11-Jun	93000	838	27414	1333	122585
11-Jul	83048	763	27368	1415	112594
11-Aug	74854	694	27321	1296	104164
11-Sep	60769	625	29444	1402	92241
11-Oct	55619	610	23774	1468	81470
11-Nov	48155	571	17308	1351	67386
11-Dec	42647	512	12941	1389	57489
12-Jan	57885	537	10962	1509	70892
12-Feb	77647	595	15273	1402	94917
12-Mar	81845	659	20556	1524	104583
12-Apr	86095	756	26786	1574	115211
12-May	91776	878	24828	1468	118949
12-Jun	100680	825	24737	1560	127801
12-Jul	86190	756	24828	1441	113216
12-Aug	71887	714	25179	1545	99325
12-Sep	60000	651	24545	1667	86863
12-Oct	55566	643	19286	1698	77193
12-Nov	50857	619	15273	1810	68558
12-Dec	42596	548	9107	1731	53982
13-Jan	58095	581	8571	1887	69135
13-Feb	75566	614	13158	1845	91182
13-Mar	80286	622	19655	1923	102486
13-Apr	85140	727	25179	1981	113027
13-May	90093	826	23103	1810	115832
13-Jun	95472	783	24286	1942	122482
13-Jul	87308	681	24737	1961	114686
13-Aug	74476	646	26607	2000	103729
13-Sep	61698	625	22982	2075	87381
13-Oct	57238	617	16897	2019	76771
13-Nov	50673	587	13750	2095	67105
13-Dec	51238	591	7818	2150	61797
14-Jan	59712	563	7547	1852	69673
14-Feb	77961	571	13889	1743	94165
14-Mar	83725	625	18302	1892	104544
14-Apr	90297	723	25192	2037	118250
14-May	91143	848	24706	1887	118583
14-Jun	99320	792	25306	1944	127363
14-Jul	93922	745	27083	2170	123919
14-Aug	73143	739	26042	2037	101961
14-Sep	66699	667	26304	2018	95688
14-Oct	56476	660	22558	2072	81766
14-Nov	51068	625	14773	2182	68648
14-Dec	46893	608	6977	2035	56510