Does anyone know how to build a calculation that will trend a balance when you know the know the beginning balance (Mo1) and the ending balance (Mo13) and have a trend to track from prior years?
Any help is appreciated!
The overal growth for the year is 15% required, but this is not compounded.
Mo1 $2000.00 Mo13 $13,348.00; I know the companies over all trend is.....
[TABLE="width: 593"]
<colgroup><col style="width: 49pt;" span="11" width="66"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;" width="72"> <tbody>[TR]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo2[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo3[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo4[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo5[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo6[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo7[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo8[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo9[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo10[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo11[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo12[/TD]
[TD="class: xl68, width: 72, bgcolor: transparent"]Mo13[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]2.96%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.94%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8.81%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.05%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-12.77%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1.16%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.61%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12.26%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.39%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5.76%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2.47%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.62%[/TD]
[/TR]
</tbody>[/TABLE]
Any help is appreciated!
The overal growth for the year is 15% required, but this is not compounded.
Mo1 $2000.00 Mo13 $13,348.00; I know the companies over all trend is.....
[TABLE="width: 593"]
<colgroup><col style="width: 49pt;" span="11" width="66"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;" width="72"> <tbody>[TR]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo2[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo3[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo4[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo5[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo6[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo7[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo8[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo9[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo10[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo11[/TD]
[TD="class: xl68, width: 66, bgcolor: transparent"]Mo12[/TD]
[TD="class: xl68, width: 72, bgcolor: transparent"]Mo13[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]2.96%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.94%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8.81%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.05%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-12.77%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1.16%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.61%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12.26%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]9.39%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5.76%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2.47%[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]-0.62%[/TD]
[/TR]
</tbody>[/TABLE]
