EXCEL: TREND ANALYSIS
Description
Trend analysis is the practice of uncovering patterns in your data. In most
organisations, trend analysis is used to monitor metrics and their
development over time. As such, trend analysis relies on effective historical
analysis.
This Excel model is for educational purposes only. Strictly Confidential
All content is Copyright material of 365 Financial Analyst ®
© 2023, 365 Financial Analyst ®
TREND ANALYSIS
in $ Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19
Revenue 1941 1849 2175 2081 2249 2269 2498
Cogs 706 600 711 656 671 594 583
Revenue Trend Analysis 2019-2021
5000
4000
3000
2000
1000
0
6 4 5 5 6 6 7 8 8 9 9 0 1 0 1 1 2 2 3 4 4 5 5 6 7 5 6 6
349 352 355 358 361 364 367 370 373 376 379 383 386 389 392 395 398 401 404 407 410 413 416 419 422 425 428 431 4
4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4
Revenue Cogs
Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20
1463 2335 2640 2259 2448 2660 2302 2545 2850
474 640 677 571 423 597 504 596 727
65 96 7 5 6 6 7 7 8 9 9 0 0
22 425 428 431 434 437 440 443 446 450 453 456
1
41 441 44 4 4 4 4 4 4 4 4 4 4 4
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21
3038 3081 3239 1845 2927 3383 3103 2853 3363 2896
705 684 612 509 717 731 591 590 830 682
Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
3366 3715 4039 3972 4246 2486 3863 4289 4194 3799
881 963 984 893 849 651 970 912 886 800
