Question: How do I write the formula to add individual spark-lines to embed/show trends in each active field? I want one for each row of data
How do I write the formula to add individual spark-lines to embed/show trends in each active field? I want one for each row of data in columns I 'Trends'
I just want to know how to properly construct the formula to embed individual sparkline trends.
| 2012 | 2013 | 2014 | 2015 | 2016F | Benchmark1 | TREND | |
| Revenue growth | 2.9% | 2.4% | 12.5% | 15.5% | 30.0% | (1.8)% | =TREND(B7:G7,G7:G10,J7:J10,G7) |
| Gross margin (Gross profit / Revenue) | 48.9% | 46.9% | 51.8% | 52.0% | 49.9% | 48.9% | |
| Operating margin (Op. profit / Revenue) | 6.4% | 4.8% | 8.6% | 9.5% | 8.2% | 7.6% | |
| Net profit margin (Net profit / Revenue) | 4.1% | 3.1% | 5.7% | 5.8% | 5.0% | 2.8% | |
| Return on assets (Net profit / Total assets) | 3.2% | 2.4% | 4.7% | 5.1% | 4.4% | 2.9% | |
| Return on capital (Net profit / Total capital) | 3.3% | 2.5% | 4.8% | 5.4% | 5.7% | 4.0% | |
| Receivable days (AR / Revenue * 365) | 41.9 | 45.0 | 48.0 | 50.9 | 52.9 | 21.8 | |
| Inventory days (Inventory / COGS * 365) | 424.2 | 432.1 | 436.5 | 476.3 | 441.7 | 386.3 | |
| Payable days (AP / Purchases * 365) | 15.6 | 13.3 | 10.2 | 9.9 | 11.3 | 26.9 | |
| NFA turnover (Revenue / NFA) | 2.4 | 2.4 | 2.4 | 3.0 | 3.6 | 2.7 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
