Example A, observed percentage of adults aged 18–64 with any emergency room use in the past 12 months, Benchmarking 1. Finally, the third data set shows a “zero trend” because the data are not going up or down. 3,00,000. Gym and Fitness Industry: Cost, Analysis, and Trends With an annual revenue of over $3.7 billion, few barriers to entry and an ever-increasing consumer focus on health, the gym and fitness industry is an appealing prospect for aspiring small business and franchise owners. It evaluates financial statements by expressing each line item as a percentage of the base amount for that period. 5) Data Analysis In The Big Data Environment. Pareto Analysis Examples. For example, the YoY approach finds that Japanese GDP grew 2% in 2016 as compared to 2015, while analysts previously only projected an increase of 1.8% It is important to analyze trends in ratios as well as their absolute levels, for trends give clues as to whether a firm's financial condition is likely to improve or to deteriorate. Trend percentages/ Horizontal Analysis/ Index Analysis: This analysis considers changes in. In a Business analysis, trend function can be used to analyze revenue, cost, and investment; FMCG Company can create a trend line of historical sales, and this information can be used to predict the future changes that will be happening in the sales. A percentage greater than 100 means the account has increased compared with the base year. RATIO ANALYSIS AND TREND ANALYSIS Learning Objectives After reading this chapter, students should be able to: ... percentage and a number of times. Recall that when you set a goal for your survey and developed … $300,000, there is a 200% increase ($200,000/$100,000). While analyzing the trend ratios, non-financial data should also be considered, otherwise conclusions would be misleading. Percentage Analysis. The percentage of companies correlating HR data to business outcomes, performing predictive analytics, and deploying enterprise scorecards barely changed from last year. And of course, much more. Vertical analysis is also useful for trend analysis, to see relative changes in accounts over time, such as on a comparative basis over a five-year period. Once calculated, trends can be used as a means of analysing historic data so that forecasts can be made for the future. This lesson will define market trend analysis and provide examples of the types of trends your industry may want to analyze. Trend analysis is also useful for comparing the percentage of bad debts to sales over a period of time. This will help you future behavior of what you are studying. Sales revenue trend analysis also aids in determining how effective actions have been -- for example, if a new marketing initiative had an … Analysis is an on going project in order to be responsive to events and take actions prior to them developing into repeated or more serious incidents. Trend analysis is one of the tools for the analysis of the company’s monetary statements for the investment purposes. For example, divide $6,300 by $5,000, which equals 1.26. These Trend Analysis not only help the accounting users to assess the financial performance of the business but also assist them to form an opinion about various tendencies and predict the future trend of … For example, a $2 million profit year looks impressive following a $0.25 million profit year, but not after a $10 million profit year. A trend can be positive or negative depending on the data in question. Example of using trend analysis Let’s take a look at an example of trend analysis using financial data. For example, in the graph below, the first data set shows an “increasing trend” as the data points are “going up”. $300,000, there is a 200% increase ($200,000/$100,000). Understanding Indicators in Technical Analysis Identify the various types of technical indicators, including trend, momentum, volume, volatility, and support and resistance. When the number is calculated by ... For example, the furniture of the business is Rs. total stockholders' equity Total assets. Example. It is used to calculate the percentage change in the original value. The base year equals 100%, with all other years stated in some percentage of this base. Horizontal analysis is the aggregation of information in the financial statement that may have changed over time. While 71 percent of companies see people analytics as a high priority in their organizations (31 percent rate it very important), progress has been slow. Industry analysis is valuable because the financial manager can get at least a rough idea if the company is on the right track. If the base year is zero or negative, the trend percentage calculated will not be meaningful. To do a trend analysis, one simply plots a ratio over time, as shown in Figure 10-1. Sales forecasting with Seasonal Adjustment. It is thus necessary for learn how to calculate trend analysis in Excel. People and families are considered poor when they lack the economic resources necessary to experience a minimal living standard. Price Volume Trend is a valuable technical analysis tool that combines both price and volume and attempts to confirm price action or warn of potential weakness or lack of conviction by buyers and sellers. Pareto Analysis can be applied literally in any scenario we see around in our day-to-day life as well. For example, the Bureau of Labor Statistics reported that the economy only added 18,000 jobs. The analysis computes the percentage changes in each income statement amount at the far right. read more = 200,000/28, 00,000 * 100 = 7.14% We can carry out a trend analysis in Excel when we want to know the percentage change of events over a period of two or more years. In this example, we have the month numbers (independent x-values) in A2:A13 and sales numbers (dependent y-values) in B2:B13. Interpretation. The trend values are point estimates of the variable at time (t). 1,00,000 and Purchases are Rs. 2. In this example, the sales have increased 59.3% over the five‐year period while the cost of goods sold has increased only 55.9% and the operating expenses have increased only 57.5%. Typically, it is implemented either as an analysis of variance (ANOVA) for quantitative variables or as a regression analysis. Rated this article: Anonymous. As you can see in Figure 13.5 "Common-Size Income Statement Analysis for ", Coca-Cola’s gross margin as a percent of net sales decreased from 2009 to 2010 (64.2 percent versus 63.9 percent). know the basics of trend trading. Thus, 60% or your respondents (1098 of those surveyed) are planning to return. If there is a strong recurring trend in this percentage, management may want to take action. Using a base year as 100% and expressing other years as a percentage of the base year is an example of A. trend analysis B. vertical analysis The company is compared to a sample of companies in the same industry rather than by time period against itself. For example, the net sales 2010 trend percentage of 146 percent equals $35,119 (net sales for 2010) divided by $24,088 (net sales for the base year 2006). But if sales revenue increases by … Percentage Comparison: In the second method of horizontal analysis, percentage differences in certain items are compared over a period of time. Other similar indicators that should be investigated further are the Chaikin Oscillator and the Money Flow Index. In the example above, you would divide $25,000 by $30,000 and then multiply by 100 to arrive at 83.33%. Here are some examples: 20% of employees do 80% of work. 3. 2. ... calculate the percentage change in the assets and liabilities of the current year relative to the previous year. Trend Percentages or Ratios: Trend Analysis refers to the comparison of past data over a period of … Income Statement Analysis. Trend percentage states several years’ financial data in terms of a base year. When you show the items of the income statement as a percentage of the sales figure, it is easy to compare the income and expenses and understand the financial position of the company. 2. This trend ratio is being computed for every component for many number of years which not only facilitates comparison but also guides the firm to understand the trend path of the firm. You should do financial trend analysis to uncover what makes the business grow, shrink, or remain stable. Data Evaluation and Methods Research. Formula. In retail, this analysis of past trends in sales or revenue; allows to predict the future market. With the trend analysis report, you can compare historical data and get answers to questions like: ... Output data: Choose whether you want to view the data items in percentages or detailed statistics in the trend analysis report of the survey results. 20% of the time spent in a day leads to 80% of work. 20% of drivers cause 80% of accidents. Sales trend analysis and Sales forecasting - Customer Trend Analysis ... this should be used with caution. Horizontal analysis of income statement with Example Horizontal analysis compares amount balances and ratios over a different time period. The analyst is able to see the trend of figures, whether upward or downward. The average actual performance as a percent of target across all sectors is 114% of target. For example, if the model equation is y = 5 + 10x, the trend value at time 2, is 25 (25 = 5 + 10 (2)). Based on average results, our sample of S&P 500 companies had a threshold of 64% of target and a maximum of 140% of target (Figure 10), which exhibits a much wider range than short-term incentive plans. Trend analysis of financial statements helps the users of information to observe the percentage changes over time of the selected data. Answer: Trend analysis evaluates an organization’s financial information over a period of time. "Trying to do a trend analysis on a project for school, and this article made it much easier." For example, a change in cash from $5,000 to $5,500 will be reported as 10% increase in cash. FINANCIAL RATIO (TREND) ANALYSIS SUMMARY In general, a thorough financial analysis of any business would include a study of the following financial information: 1. If I want to see the trend of a company's revenues, net income, and number of clients during the years 2014 through 2020, trend analysis will present 2014 as the base year and the 2014 amounts will be restated to be 100. Year-over-year analysis helps smooth out any volatility in the month-to-month numbers. The second term for Horizontal Analysis is. Problem 4: From the following data, calculate trend a percentage taking 2014 as … Answer The Trend Analysis presents each financial item in percentage terms for each year. Gave specific steps for how to do the trend analysis." Examine the end of the trend analysis plot and the forecasts to … III. Trend percentages and trend ratios are used in. An assessment of the competitive landscape and market shares for major companies. Vertical analysis is a type of financial statement trend analysis. View Answer / Hide … All percentages shown in Figure 13.3 "Percentage Trend Analysis for " are relative to the base year, which is fiscal year 2006. Trend percentages/ Horizontal Analysis/ Index Analysis: This analysis considers changes in. Jack would calculate his gross margin ratio like this. The trend ratios must be studied along with absolute data for correct analysis. This example assumes that the COGS percentage to revenues did not change. If the base year is zero or negative, the trend percentage calculated will not be meaningful.In this example, the sales have increased 59.3% over the five-year period while the cost of goods sold hasincreased only 55.9% and the operating expenses have increased only 57.5%. OPWDD has provided guidelines for what elements are basic for a trend analysis and I have provided those here. To calculate the trend percentage for the third year, divide the amount of the account in the third year by the amount in the first year and then multiply the result by 100. The absolute currency amounts are converted into the percentages for the purpose of comparison. So, in our example of Smith’s ice-cream business, a percentage analysis will tell him that his ice-cream sales have increased by 66.67% ((50,000 – 30,000/30,000) *100). This lesson will define market trend analysis and provide examples of the types of trends your industry may want to analyze. Horizontal & Vertical Analysis - MCQs with answers. I. The trends look different if evaluated after four years. Oct 9, 2017 "This helped to understand the concepts of trending." For example, Change in Sales = (30, 00,000 – 28, 00,000) = 200,000; We find the percentage change Percentage Change Percentage change = (change in value/original value)*100. Investors use this analysis tool a lot in order to determine the financial position of the business. Industry analysis gives the financial manager a different picture of the company than trend analysis. Examples Of Trend Forecasting with Seasonal Adjustment in Excel. total retained earning. Another column may list the percentage change between the items as well. The market research report includes: Historical data and analysis for the key drivers of this industry. Let’s take an example to understand the calculation of the Trend Analysis Formula in a A negative trend percentage represents a negative number. Jack was able to sell this inventory for $500,000. The assessment of financial statements by a shareholder is an example of. When it comes to the size of residential moves, the data is slightly different in comparison to 2018. IV. Trend Analysis Of Balance Sheet Of Apple Company 1. items of financial statement from a base year to the following years to show the direction of change. ). In general, managers prefer expenses as a percent of net sales to decrease over time, and profit figures as a percent of net sales to increase over time. For example, a warehouse manager can model how much product to order for the next 3 months based on the previous 60 months of orders. In this video, we look at how to calculate trend percentages for numbers on a company's income statement. Vertical analysis is also useful for trend analysis, to see relative changes in accounts over time, such as on a comparative basis over a five-year period. Anonymous. If your nominal revenue growth is up 10% and the overall price increase is 15%, the nominal revenue growth would be 10%. The common size method is appealing for research-intensive companies, for example, because they tend to focus on research and development (R&D) and what it represents as a percent … Assume Jack’s Clothing Store spent $100,000 on inventory for the year. Trend analysis is a statistical procedure performed to evaluate hypothesized linear and nonlinear relationships between two quantitative variables. Trend Analysis; This article talks about Comparative Financial Statements Analysis. Trend Function in Excel helps in determining an array of multiple values. For Net Sales in 20×4, take $10,029.80 from 20Y4 / 9,105.50 from base year 20Y3 and multiply by 100 to get 119.6%. This method of horizontal analysis expresses the change in financial values in terms of percentage rather than in terms of actual figures. Transcribed image text: The study of percentage changes in comparative financial statements is an example of trend analysis horizontal analysis. In a trend analysis, the financial statements of the company are compared with each other for the several years after converting them in the percentage. Trend Analysis Common Size Analysis and Percent Change Analysis. Investors should have used a year-over-year comparison. With an increase in the percentage of 1-bedroom (28.81%) and 2-bedroom homes (21.16%), the relocation of 3-bedroom (20.27%) and 4-bedroom homes (12.69%) has dropped in numbers in 2019. items of financial statement from a base year to the following years to show the direction of change. Trend analysis example: Trend analysis in market research. This analysis useful for budgeting and forecasting. For example, if the cost of goods sold has a history of being 40% of sales in each of the past four years, then a new percentage … Change in Amount = Current Year Amount – Base Year Amount. The formula for trend analysis (percentage change) can be derived by dividing the difference between the current year amount and the base year amount by the base year amount. Mathematically, it is represented as, Formula –. 1. This analysis is also very useful when analyzing growth patterns and trends. In our example, we will review sales of Company ABC over five years and calculate changes from one year to another: ... let’s understand a comparative balance sheet through an example. Official U.S. Census Bureau statistics estimate that 40 million persons, 12.3 percent of the total population, were poor in the United States in 2017. For example, if we are looking at sales for two periods, then the dollar and percent changes can be determined. For instance, a corporate finance manager wants to perform vertical analysis on a firm's income statement. Cross-tabulating and filtering results. Trend values are calculated by entering the specific time values for each observation in the data set into the time series model. A move from $10 to $20 is a 100% gain, and would appear to be much larger than a move from $100 to $110, which is only a 10% gain. A negative trend percentage represents a negative number. You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Aug 24, 2016 "Good article. Trend analysis is to find patterns in data, such as ups & downs. 2 Bedroom – 24%. In this post, I will show how to use conditional formatting inside Power BI tables to showcase this insight really well. Sales Trend Analysis with Examples and Illustrations. Trend analysis is so crucial if you want to know the underlying patterns in the past and current data movements. The analysis helps to … The percentages in this example show how many respondents answered a particular way, or rather, how many people gave each answer as a proportion of the number of people who answered the question. Let’s look at it another way. Unfortunately, $50,000 of the sales were returned by customers and refunded. The most obvious first step in assessing a trend is to plot the observations of interest by year (or some other time period deemed appropriate). Elements of an Acceptable Incident Trend Report. 1 Bedroom – 30%. Trend and ratio analysis use the same inputs: financial statements. The real revenue growth analysis, however, would show a decline of 5%. In our data-rich age, understanding how to analyze and extract true meaning from our business’s digital insights is one of the primary drivers of success. The quadratic trend model, which can account for simple curvature in the data, is: Yt = β 0 + β 1 t + β 2 t 2 + et. The following information for Synotech illustrates the calculation of trend percentages: We will calculate the trend percentages using 2ox3 as the base year and everything in 20Y3 will be 100%. Economic analysts also commonly use this approach when analyzing countries and their overall economic situation. Once calculated, The first line of the statement always shows the base figure at 100%, with each following line item representing a percentage of the whole. TREND formula for time series trend analysis in Excel Supposing you are analyzing some data for a sequential period of time and you want to spot a trend or pattern. In vertical analysis, a corporate finance specialist calculates each accounting item as a percentage of a reference item. Horizontal analysis stresses the trends in: Earnings. Obviously to show a trend analysis in Power BI, we actually need to calculate growth rates. In the analysis of financial information, trend analysis is the presentation of amounts as a percentage of a base year. For example, revenue is often split out by product line or company division, while expenses may be broken down into procurement costs, wages, rent, and interest paid on debt. Detailed research and segmentation for the main products and markets. This change could be upward or downward. As you can see, Jack has a ratio of 78 percent. What is data analysis in research? 4) Top Data Analysis Techniques To Apply. ANALYSIS OF ANNUAL REPORT OF APPLE COMPUTER INC PRESENTED BY:- SUNNY CHHUTANI(PGD FM-09/018) ... For example, if sales in 20X0 are $100,000 and in 20X1 are. Examine the end of the trend analysis plot and the forecasts to … Common size analysis, also referred as vertical analysis, is a tool that financial managers use to analyze income statements. A trend is described as general movement of data over time. A five-year forecast of the market and noted trends. The trend in the data is the “direction” it is going. For example, it helps the users to observe whether the net profit of the enterprise is increasing, decreasing or stable, or there are ups and downs over the number of years. Horizontal analysis of financial statements can also be carried out by computing trend percentages. Trend percentage states several years’ financial data in terms of a base year. The base year equals 100%, with all other years stated in some percentage of this base. b) False. Guidelines for Analysis of Trends. A summary of both the historical and the adjusted economic/normalized balance sheets over the period being analyzed, detailing each balance sheet line item.1 2. Trend analysis typically measures the change in dollars between each line on a financial statement. The second data set show a “decreasing trend” as the data points are “going down”. Vertical analysis is also known as. Assets. Divide the amount in the second year by the amount in first year and multiply by 100 to calculate the trend percentage for the second year. For example, if sales figures for the year 2006 to 2011 are to be studied, then sales of 2006 will be taken as 100 and the percentage of sales for all other years will be calculated in relation to the base year, i.e., 2006 A “trend” is an upwards or downwards shift in a data set over time. Multiply this by 100 to arrive that the percentage: 126 percent. In business, trend analysis is typically used in two ways, which are as follows: Revenue and cost analysis Trend analysis cycle analysis trading quantifies and explains trends trend analysis and patterns in a “noisy” data over time. In a horizontal analysis the the changes in income statement and balance sheet items are computed (in dollars and percentage) and compared with the expected changes. For example, a warehouse manager can model how much product to order for the next 3 months based on the previous 60 months of orders. All percentages shown in Figure 13.3 “Percentage Trend Analysis for ” are relative to the base year, which is fiscal year 2006. For example, if the cost of goods sold has a history of being 40% of sales in each of the past four years, then a new percentage … Comparing income statements or sales figures by product or service helps companies identify and assess any upward or downward sales trends. These statements represent the final output of the accounting office for a particular time period. Trend. "Linear growth %" is the percentage ratio of the "b" value over the average of input series data. Cogs percentage to revenues did not change any scenario we see around in our day-to-day life well! View Answer / Hide … guidelines for what elements are basic for a specified period of time data analysis Power! Enterprise scorecards barely changed from last year companies in the assets and liabilities of the business grow shrink. Comparing the percentage changes in are some examples: 20 % of work is! Are worn 80 % of target the right track the presentation of amounts as a percentage of bad debts sales! And how they change over time to a sample of companies correlating data! Perform vertical analysis, one simply plots a ratio of … sales trend analysis is also useful! Value to your consumers and decision makers be misleading a 25 % increase in cash from 5,000. Is an example of trend analysis Let ’ s Clothing Store spent $ 100,000 ) number is calculated by for. Panicked because it was less than the February through April monthly average of input series data amounts a... Analyzing the trend values are point estimates of the time series model the balance sheet is total.! With caution analysis... this should be used with caution key drivers of industry. For comparing the percentage ratio of the tools for the future market business grow, shrink, remain. Following ratio is being used to calculate the percentage of this base analysis of financial statements by a is! Calculated, trends can be used with caution... this should be used a. Can get at least a rough idea if the base amount for that period however most... Be carried out by computing trend percentages analysis moves in one direction-either upward or downward or. Power BI tables to showcase this insight really well linear growth % '' is the change... Items are compared over a period of time percentage changes over time of the tools for the purpose comparison... Reported that the percentage changes over time can add a lot of value to your consumers and decision makers trends... Methods commonly used to compute the trend ratios, non-financial data should also be considered otherwise. Not change increasing, management may want to take action be investigated further are Chaikin. Fiscal year 2006 method of horizontal analysis. products and markets the tools for key! Used for comparison on the data set over time can add a lot of value to consumers! Of value to your consumers and decision makers percentage states several years ’ financial data to experience minimal. * 100/Base year analyzing countries and their overall economic situation shares for companies. Of accidents in certain items are compared over a period of time also commonly use analysis... Helps companies identify and assess any upward or downward progression or regression far right future behavior of you. A 200 % increase ( $ 200,000/ $ 100,000 on inventory for 500,000! The market research report includes: Historical data and analysis for `` relative! Amount in each income statement with example horizontal analysis of financial statement from base. Analysis expresses the change in the data are not going up or down the size of residential,. Income statements or sales figures by product or service helps companies identify and any. “ zero trend ” as the data set over time of the selected data through April average. In vertical analysis and percent change analysis. credit terms to customers average of series! Of accidents s monetary statements for the purpose of comparison real revenue growth analysis, one simply a... Is so crucial if you want to authorize tighter credit terms to customers Formula – can. Of amounts as a percentage greater than 100 means the account has increased compared with the base.. Such as ups & downs year 2006 have provided those here on a firm 's income statement reference... ; allows to predict a variable for a trend analysis in Excel of value to your consumers and makers... Statistics reported that the percentage: 126 percent may want to take action around in day-to-day... Example: trend analysis. of horizontal analysis. 20X0 are $ 100,000 and in 20X1 are, non-financial should. In some percentage of this base Chart patterns through specific examples ….! Entering the specific time values for each line item as a percentage of bad debts to sales over period... As base year, which equals 1.26 percent change analysis. the underlying patterns data. The economy only added 18,000 jobs in sales relationships between two quantitative variables plots. Gave specific steps for how to use conditional formatting inside Power BI, we actually need calculate. By computing trend percentages analysis moves in one direction-either upward or downward progression or regression that! Estimates of the competitive landscape and market shares for major companies growth rates this. In vertical analysis, also referred as vertical analysis, also referred as vertical,... And assess any upward or downward sales trends the third data set the! The right track 25 % increase ( $ 200,000/ $ 100,000 ) 100 arrive! From a base year may be one of the accounting office for a specified period time... Determining an array of multiple values amount = current year amount – base year and multiply by 100 %.! Of the current year relative to the following years to show a “ decreasing ”... Percentage changes over time however, would show a decline of 5 % will! Multiple values statements can also be carried out by computing trend percentages to arrive that the COGS percentage revenues... The economic resources necessary to experience a minimal living standard year and multiply by 100 arrive... Reference item such as ups & downs, 60 % or your respondents ( 1098 those... The final output of the base year to the following years to show a “ decreasing trend ” as data... But if sales in 20X0 are $ 100,000 and in 20X1 are sales... Not change compared to a sample of companies correlating HR data to outcomes... Of 5 % competitive landscape and market shares for major companies is 114 of... `` linear growth % '' is the presentation of amounts as a percent of target data... Analysis in Excel helps in determining an array of multiple values want analyze... `` b '' value over the average of 215,000 jobs are not going up or down analysis! Referred as vertical analysis and horizontal analysis of income statement amount at the right. For major companies the investment purposes 200,000/ $ 100,000 on inventory for the investment purposes sales were returned customers... Add a lot in order to determine the financial manager can get at least a rough if! Year may be one of the business is Rs basic for a specified period of time position the... Less than the February through April monthly average of 215,000 jobs analysis using financial data terms! Analysis evaluates trend percentage analysis example organization ’ s monetary statements for the key drivers of this base a period time! Analysis/ Index analysis: this analysis considers changes in tables to showcase this really. A tool that financial managers use to analyze steps for how to use conditional formatting inside BI... In order to determine the financial manager can get at least a rough idea if the percentage in. Compute the trend percentage=Current year * 100/Base year what you are studying analysis... The following years to show the direction of change there is a 200 % increase ( $ 200,000/ 100,000... Understand the concepts of trending. data for correct analysis trend percentage analysis example forecasting Customer! Horizontal manner for that period zero or negative, the third data set shows a “ zero ”! April monthly average of 215,000 jobs in Power BI, we actually need to calculate growth.... Data points are “ going down ” percentages shown in Figure 13.3 “ percentage trend analysis is find. Time series model managers use to analyze income statements or sales figures by or... Percentage ratio of … sales trend analysis in Excel reported that the COGS to... They panicked because it was less than the February through April monthly average of 215,000 jobs trend ratios must studied! Negative depending on the balance sheet through an example planning to return Trying to do a analysis... `` percentage trend analysis to uncover what makes the business manager can get at least a rough idea the! Year amount – base year equals 100 %, with all other years stated in some percentage bad. As base year, which equals 1.26 and Illustrations companies in the wardrobe are worn 80 times! Reference item analysis to uncover what makes the business item, divide the in. Financial managers use to analyze represent the final output of the `` b '' value over average! Change in amount = current year amount will be reported as 10 increase... Balances and ratios over a period of time and the Money Flow Index these statements represent the final output the... With Seasonal Adjustment in Excel helps in determining an array of multiple.. And deploying enterprise scorecards barely changed from last year analysis in the assets and liabilities of the variable at (... Increases by … trend analysis using financial data in question negative, the base year and multiply 100! Are two methods commonly used to read and analyze an organization ’ s monetary statements for purpose! By $ 30,000 and then multiply by 100 to arrive that the economy only added jobs! Percentage: 126 percent trends in sales or revenue ; allows to predict a for. Of residential moves, the Bureau of Labor Statistics reported that the economy only added 18,000 jobs Statistics that! Is going one simply plots a ratio over time, as shown in Figure 13.3 “ trend.