sp500 <- structure(list(stock = structure(c(39L, 33L, 29L, 10L, 48L, 49L, 21L, 40L, 24L, 27L, 26L, 43L, 35L, 12L, 19L, 28L, 50L, 11L, 20L, 1L, 32L, 18L, 41L, 4L, 15L, 23L, 6L, 17L, 47L, 5L, 2L, 9L, 37L, 42L, 25L, 31L, 38L, 13L, 30L, 7L, 45L, 14L, 3L, 8L, 44L, 34L, 46L, 16L, 22L, 36L), .Label = c("AAPL", "ACN", "BAX", "BFB", "BIIB", "BRCM", "BSX", "CA", "CAM", "CCL", "CL", "CNP", "DELL", "DO", "EFX", "EP", "EXPE", "FLR", "GD", "HCP", "HRB", "HUM", "IBM", "INTC", "IVZ", "LLTC", "LNC", "LUV", "MAT", "MSI", "MWV", "NEM", "PBCT", "PCL", "PGN", "PPL", "QEP", "ROP", "SCHW", "SJM", "SLE", "SRE", "STZ", "SYY", "TRIP", "TRV", "USB", "VIAB", "VZ", "WMT"), class = "factor"), market_cap = c(17700, 4340, 11210, 24050, 26110, 111210, 4680, 8570, 134090, 7050, 7580, 4430, 15830, 8270, 25690, 6570, 204770, 45050, 15990, 505330, 28190, 10160, 12860, 11320, 5100, 231510, 19540, 4320, 55720, 28750, 39010, 13260, 5740, 14020, 10980, 5270, 9130, 30600, 16460, 8610, 4170, 9720, 33060, 12990, 17390, 6420, 22430, 22210, 14400, 16260), ent_value = c(15760, 4550, 11210, 32550, 32290, 151410, 5180, 10230, 127020, 5570, 7260, 7450, 29200, 16800, 26700, 7170, 251960, 48570, 24130, 464640, 30520, 8230, 12310, 11740, 5900, 248500, 15830, 4310, 104930, 27300, 33490, 13440, 7360, 24580, 16230, 7050, 9760, 24660, 12860, 12310, 4390, 9760, 34490, 11920, 19780, 8900, 25220, 35490, 7030, 33540), trail_pe = c(19.890000000000001, 21.84, 15.16, 12.789999999999999, 16.18, 46.140000000000001, 14.75, 19.210000000000001, 11.23, 26.170000000000002, 15.539999999999999, 7.5300000000000002, 27.600000000000001, 6.1299999999999999, 10.48, 36.960000000000001, 13.220000000000001, 19.02, 30.27, 15.42, 78.010000000000005, 17.670000000000002, 25.219999999999999, 19.93, 22.600000000000001, 15.300000000000001, 21.719999999999999, 9.4800000000000004, 11.85, 23.890000000000001, 16.960000000000001, 25.77, 21.550000000000001, 10.4, 15.67, 21.699999999999999, 21.710000000000001, 9.1500000000000004, 15.18, 20.449999999999999, 23.68, 10.1, 15.210000000000001, 14.49, 15.26, 33.439999999999998, 16.969999999999999, 159.66999999999999, 10.380000000000001, 10.380000000000001), forward_pe = c(16.77, 13.24, 12.48, 11.949999999999999, 9.6400000000000006, 14.109999999999999, 9.6799999999999997, 14.42, 10.24, 5.54, 15.68, 10.050000000000001, 16.300000000000001, 15.789999999999999, 9.3499999999999996, 8.0999999999999996, 11.300000000000001, 15.92, 13.51, 11.390000000000001, 9.8499999999999996, 13.880000000000001, 20.510000000000002, 19.989999999999998, 13.539999999999999, 12.15, 11.06, 10.23, 9.9900000000000002, 17.199999999999999, 14.32, 12.32, 12.77, 12.76, 11.18, 14.619999999999999, 17.879999999999999, 7.8899999999999997, 15.640000000000001, 12.619999999999999, 18.829999999999998, 13.630000000000001, 11.94, 10.699999999999999, 14.300000000000001, 27.440000000000001, 9.4499999999999993, 20.530000000000001, 9.8699999999999992, 11.460000000000001), ev_over_rev = c(3.3599999999999999, 3.8999999999999999, 1.79, 2.0600000000000001, 2.1499999999999999, 1.3700000000000001, 1.4199999999999999, 1.9099999999999999, 2.3500000000000001, 0.52000000000000002, 5.4400000000000004, 2.7200000000000002, 3.2799999999999998, 1.99, 0.81999999999999995, 0.46000000000000002, 0.56000000000000005, 2.8999999999999999, 13.98, 3.6400000000000001, 2.9500000000000002, 0.34999999999999998, 1.3700000000000001, 4.29, 3.0099999999999998, 2.3199999999999998, 2.2000000000000002, 1.25, 6.3399999999999999, 5.4199999999999999, 1.1799999999999999, 1.9299999999999999, 2.3300000000000001, 2.4500000000000002, 3.9700000000000002, 1.1599999999999999, 3.4900000000000002, 0.40000000000000002, 1.5700000000000001, 1.6200000000000001, 6.8899999999999997, 3, 2.48, 2.5099999999999998, 0.47999999999999998, 7.6299999999999999, 0.98999999999999999, 7.2999999999999998, 0.19, 2.6299999999999999), profit_margin = c(18.420000000000002, 17.030000000000001, 12.27, 12.109999999999999, 11.56, 2.1699999999999999, 9.0099999999999998, 8.4100000000000001, 23.969999999999999, 2.7599999999999998, 37.130000000000003, 22.68, 6.46, 16.059999999999999, 7.7300000000000004, 1.1399999999999999, 3.5099999999999998, 14.529999999999999, 31.23, 25.800000000000001, 3.5299999999999998, 2.54, 5.71, 21.27, 11.880000000000001, 14.83, 12.91, 13.69, 29.460000000000001, 24.5, 8.3800000000000008, 7.5, 8.4600000000000009, 13.52, 17.829999999999998, 4.0599999999999996, 15.279999999999999, 5.6299999999999999, 14.119999999999999, 5.79, 27.890000000000001, 29.579999999999998, 16.010000000000002, 19.52, 2.7999999999999998, 16.539999999999999, 5.5999999999999996, 2.8999999999999999, 3.8500000000000001, 11.74), revenue = c(4690, 1170, 6270, 15790, 15040, 110880, 3650, 5360, 54000, 10640, 1340, 2740, 8910, 8450, 32680, 15660, 446950, 16730, 1730, 127840, 10360, 23380, 9020, 2740, 1960, 106920, 7180, 3450, 16540, 5040, 28460, 6960, 3160, 10040, 4090, 6060, 2800, 62070, 8200, 7620, 637.05999999999995, 3250, 13890, 4750, 41020, 1170, 25450, 4860, 36830, 12740), growth = c(1.2, 18.699999999999999, 1.3999999999999999, 5.7000000000000002, 3.2000000000000002, 7.7000000000000002, 9.3000000000000007, 11.800000000000001, 21.199999999999999, 3.3999999999999999, 23.300000000000001, 27.5, 25.199999999999999, 2.2000000000000002, 6.2999999999999998, 31.899999999999999, 5.9000000000000004, 4.9000000000000004, 35.899999999999999, 73.299999999999997, NA, 18.699999999999999, 6.2999999999999998, 11.800000000000001, 5.7000000000000002, 1.6000000000000001, 6.5999999999999996, NA, 22.399999999999999, 8.8000000000000007, 17.100000000000001, 12.300000000000001, 48, 11, 3.1000000000000001, 0.10000000000000001, 8.8000000000000007, 2.2000000000000002, 5.4000000000000004, 7.7000000000000002, 12.199999999999999, 10.9, 2.7000000000000002, 10.4, 9.1999999999999993, 11.5, 0.29999999999999999, 25.199999999999999, 9.4000000000000004, NA), earn_before = c(NA, NA, 1220, 3780, 4090, 35330, 754.22000000000003, 1090, 23540, 1640, 700.83000000000004, 634.29999999999995, 2490, 2180, 4530, 1540, 34690, 4280, 1420, 45450, 5250, 1190, 1160, 873.70000000000005, 635.89999999999998, 26670, 1100, 582.39999999999998, NA, 2120, 4230, 1120, 1490, 2760, 1050, 987, 800.67999999999995, 5420, 1570, 1740, 305.56999999999999, 1650, 3890, 1730, 2330, 370, 2540, 3000, 2650, 4350), cash = c(35310, 865.29999999999995, 1370, 450, 1150, 13950, 572.61000000000001, 370.43000000000001, 14840, 7180, 1040, 55.799999999999997, 230, 606, 2650, 3140, 6550, 952, 33.509999999999998, 30160, 1850, 2260, 2750, 381.39999999999998, 127.7, 11970, 4530, 1340, 13880, 1690, 5100, 1320, NA, 265, 1390, 656, 338.10000000000002, 14820, 5090, 267, 183.53, 1240, 2900, 2470, 336.52999999999997, 254, 3830, 194, 9120, 1220), debt = c(2000, 1080, 1560, 9350, 7790, 55150, 1100, 2070, 7420, 5690, 795.51999999999998, 3150, 13700, 9190, 3930, 3750, 53430, 4810, 7730, 0, 4310, 532.96000000000004, 2450, 760.20000000000005, 1010, 31320, 1200, 1250, 63090, 1060, 6.3799999999999999, 1580, 1680, 10860, 6800, 2470, 1090, 9250, 1540, 4260, 426.73000000000002, 1500, 5200, 1430, 2860, 2770, 6600, 12970, 1960, 18570)), row.names = c(NA, -50L), class = c("tbl_df", "tbl", "data.frame"))