Register to reply 
Weighted average question 
Share this thread: 
#1
Dec113, 10:21 AM

P: 27

Hi guys,
I am doing some research into McDonalds and it's international businesses. It's a small study for people who are interested in good company structures. I came across a section in their annual report where they give some weighted average figures but I don't know how they arrived at those figures and I'm not very good at maths, so I was hoping someone might know the answer to my question. $6,889.1 is the weighted average cash... how did they arrive at this figure using the numbers in the screen shot below? :S In the notes it says: " The denominator is the weighted average cash used for investing activities during the applicable one or three year period. The weighted average cash used for investing activities is based on a weighting applied on a quarterly basis. Here is a screenshot of what I am looking at: (if the screenshot isn't visible please see it as http://postimg.org/image/de0tttj71/) Thank you in advance, sorry if its a dumb question, 


#2
Dec113, 10:42 AM

Mentor
P: 11,631

There is no screenshot visible. If you see it: maybe you have to be registered there to see it.



#3
Dec113, 11:43 AM

P: 27




#4
Dec213, 12:28 PM

Mentor
P: 11,631

Weighted average question
The weighting could be related to the variable exchange rates. Instead of averaging the exchange rate over all quarters, the cash spent in that quarter is used as weight. That is a more complicated way to say "in each quarter, the money is converted according to the exchange rate at that point" (maybe even with smaller steps than quarters).



#5
Dec213, 01:07 PM

P: 27

I know this is going to be asking too much but any chance of providing a calculation? Is it possible to do the calculation using the information that's shown on that screenshot?



#6
Dec213, 01:24 PM

Mentor
P: 11,631

If my guess is right, the data there is not sufficient to check the numbers.



#7
Dec213, 01:40 PM

Emeritus
Sci Advisor
PF Gold
P: 4,500

Based on the footnote (3) and (4) it sounds like the weighted average is not related to currency changes, they just assumed a flat exchange rate by averaging the exchange rate over the whole period.
It sounds like the weights in the average are supposed to be the percents at the bottom of the page, but I don't understand how they are averaging the adjusted cash and coming up with a number larger than any of the individual adjusted cash numbers. If I didn't know this gave the wrong number I would think the calcuation they are doing is [tex] \frac{3167.3*(.875+.625+.375+.125) + 2570.9*4 + 2056*4 + 1655.3*(.875+.625+.375+.125) }{8+2*(.875+.625+.375+.125)} [/tex] 


#8
Dec313, 01:52 PM

P: 1,969

The problem is that the 3167.3 and so on seem to be amounts per year whereas the weights are per quarter. But they don't show how the money is split between quarters.



#9
Dec513, 01:58 PM

P: 27

Hi guys,
Thanks for actually giving this some thought. I just found this in the annual report and it has to do with the original question. RECONCILIATION OF RETURNS ON INCREMENTAL INVESTED CAPITAL ROIIC is a measure reviewed by management over oneyear and threeyear time periods to evaluate the overall profitability of the business units, the effectiveness of capital deployed and the future allocation of capital. This measure is calculated using operating income and constant foreign exchange rates to exclude the impact of foreign currency translation. The numerator is the Company’s incremental operating income plus depreciation and amortization from the base period. The denominator is the weightedaverage cash used for investing activities during the applicable oneor threeyear period. The weightedaverage cash used for investing activities is based on a weighting applied on a quarterly basis. These weightings are used to reflect the estimated contribution of each quarter’s investing activities to incremental operating income. For example, fourth quarter 2012 investing activities are weighted less because the assets purchased have only recently been deployed and would have generated little incremental operating income (12.5% of fourth quarter 2012 investing activities are included in the oneyear and threeyear calculations). In contrast, fourth quarter 2011 is heavily weighted because the assets purchased were deployed more than 12 months ago, and therefore have a fullyear impact on 2012 operating income, with little or no impact to the base period (87.5% and 100.0% of fourth quarter 2011 investing activities are included in the oneyear and threeyear calculations, respectively). Management believes that weighting cash used for investing activities provides a more accurate reflection of the relationship between its investments and returns than a simple average. The reconciliations to the most comparable measurements, in accordance with accounting principles generally accepted in the U.S.,for the numerator and denominator of the oneyear and threeyear ROIIC are as follows: 


Register to reply 
Related Discussions  
95% Confidence of weighted average  Set Theory, Logic, Probability, Statistics  7  
Why a weighted average?  General Math  2  
Calculating the Weighted Average of Two Graphs  General Math  5  
Weighted average of weights themselves  General Math  0  
Weighted average  Introductory Physics Homework  5 