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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!