Question

Column Labels T 2016 2015 2013 2014 Sum of Sales Row Labels Sporting Goods Gander Mountain Eastbay Dick's Sporting Goods Academy Cabela's Bass Pro Shops Sport Chalet Big 5 Orvis Champs Camping World Sportsman's Warehouse Scheels The Sports Authority REI Sporting Goods Total Mass Retail Lowe's Target Home Depot Walmart Ace Hardware Mass Retail Total Grand Total 14,213,833 5,168,149 3,039,433 1,690,831 1,682,888 1,414,842 1,328,183 1,185,235 1,161,361 1,127,447 931,452 854,307 852,616 714,442 627,374 35,992,394 13,292,927 4,929,935 2,740,195 1,793,112 1,861,691 1,143,888 1,121,454 898,932 1,135,313 1,317,453 1,140,824 859,209 854,626 655,700 808,903 34,554,160 15,932,740 3,672,696 2,704,367 569,695 1,880,579 682,609 933,700 1,309,132 912,406 1,697,275 961,126 635,162 1,081,261 563,517 715,637 34,251,902 12,999,289 3,942,509 2,517,843 1,856,492 1,912,397 1,116,370 1,068,823 1,130,616 928,662 1,489,437 1,257,972 831,743 988,258 675,135 679,027 33,394,573 4,551,744 2,248,500 2,215,850 1,966,957 1,218,583 12,201,635 48,194,028 4,084,520 2,171,753 1,900,363 2,048,918 1,368,533 11,574,087 46,128,247 3,865,954 1,485,340 1,491,932 2,710,755 1,232,990 10,786,970 45,038,872 4,011,751 1,883,949 1,822,000 2,519,929 1,314,044 11,551,673 44,946,246 In 2016, how much larger are Sales from Sporting Goods versus Mass Retail in dollars and %? In 2016, how much have Sales in Sporting Goods grown since 2015 in dollars and % In 2016, how much have Sales in Mass Retail grown since 2015 in dollars and % In 2016, how much have Grand Total Sales for all Segments grown since 2015 in dollars and % In 2016, how much have Sales in Sporting Goods grown since 2013 in dollars and % In 2016, how much have Sales in Mass Retail grown since 2013 in dollars and % In 2016, how much have Grand Total Sales for all Segments grown since 2013 in dollars and % Bonus Point: What is the 2013-2016 CAGR% for the Total Sales from all Distribution Channels

Answer 1

Particulars	Compare 1	Amount (A)	Compare 2	Amount (B)	Diff in dollars C= A-B	Diff in %
In 2016, how much larger are sales from Sporting Goods versus Mass retail in dollars and %	2016 sales from Sporting Goods	35,992,394	2016 sales from Mass retail	12,201,635	23,790,759	194.98%
In 2016, how much have sales in Sporting Goods grown since 2015 in dollars and %	2016 sales from Sporting Goods	35,992,394	2015 sales from Sporting Goods	34,554,160	1,438,234	4.16%
In 2016, how much have sales in Mass Retailer grown since 2015 in dollars and %	2016 sales from Mass Retailer	12,201,635	2015 sales from Mass Retailer	11,574,087	627,548	5.42%
In 2016, how much have Grand total sales for all segments grown since 2015 in dollars and %	2016 total sales from all segments	48,194,028	2015 total sales from all segments	46,128,247	2,065,781	4.48%
In 2016, how much have sales in Sporting Goods grown since 2013 in dollars and %	2016 sales from Sporting Goods	35,992,394	2013 sales from Sporting Goods	34,251,902	1,740,492	5.08%
In 2016, how much have sales in Mass Retailer grown since 2013 in dollars and %	2016 sales from Mass Retailer	12,201,635	2013 sales from Mass Retailer	10,786,970	1,414,665	13.11%
In 2016, how much have Grand total sales for all segments grown since 2013 in dollars and %	2016 total sales from all segments	48,194,028	2013 total sales from all segments	45,038,872	3,155,156	7.01%
Bonus: What is the 2013-2016 CAGR% for the Total sales from all Distribution channels
Formula = ((FV/PV)^(1/years))-1
FV	48,194,028
PV	44,946,246
Years	4
CAGR%	-1.73%