Finding last value using only moving averages.

[gcefaloni]

Hi guys,

I'm trying to find the latest monthly value but I only have access to data that represents a moving average of the last 12 months. What operation should I do to extrapolate what the last monthly data point is?

Example:
[TABLE="width: 1536"]
<colgroup><col width="64" span="24" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-01[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-02[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-03[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-04[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-05[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-06[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-07[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-08[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-09[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-10[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-11[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2016-12[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-01[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-02[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-03[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-04[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-05[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-06[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-07[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-08[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-09[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-10[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-11[/TD]
[TD="class: xl64, width: 64"]12 Mo Yield 2017-12[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4.17[/TD]
[TD="class: xl63, align: right"]4.11[/TD]
[TD="class: xl63, align: right"]4.05[/TD]
[TD="class: xl63, align: right"]4.00[/TD]
[TD="class: xl63, align: right"]3.92[/TD]
[TD="class: xl63, align: right"]3.83[/TD]
[TD="class: xl63, align: right"]3.76[/TD]
[TD="class: xl63, align: right"]3.70[/TD]
[TD="class: xl63, align: right"]3.63[/TD]
[TD="class: xl63, align: right"]3.58[/TD]
[TD="class: xl63, align: right"]3.54[/TD]
[TD="class: xl63, align: right"]3.71[/TD]
[TD="class: xl63, align: right"]3.64[/TD]
[TD="class: xl63, align: right"]3.63[/TD]
[TD="class: xl63, align: right"]3.63[/TD]
[TD="class: xl63, align: right"]3.62[/TD]
[TD="class: xl63, align: right"]3.61[/TD]
[TD="class: xl63, align: right"]3.64[/TD]
[TD="class: xl63, align: right"]3.66[/TD]
[TD="class: xl63, align: right"]3.65[/TD]
[TD="class: xl63, align: right"]3.67[/TD]
[TD="class: xl63, align: right"]3.66[/TD]
[TD="class: xl63, align: right"]3.65[/TD]
[TD="class: xl63, align: right"]3.56
[/TD]
[/TR]
</tbody>[/TABLE]


I would like to be able to know what the actual yield for one specific month was by extrapolating it from the 12 months moving average of yields showing above.

What operation would I need to do to do that? Know the current yield for a specific month, not a moving average of 12 months at a specific month.

Thank you!

 

[offthelip]

To find the value for any specific month you subtract one 12 month average from the next and multiply by 12
so as an example 2016 -04 minus 2016 -03 =
4.00 - 4.05 = -0.05
-0.05 * 12= -0.6
so the formula is :
=12*(B4-B3)