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.....
<colgroup><col style="width: 49pt;" span="11" width="66"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;" width="72"> <tbody>
</tbody>
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.....
| Mo2 | Mo3 | Mo4 | Mo5 | Mo6 | Mo7 | Mo8 | Mo9 | Mo10 | Mo11 | Mo12 | Mo13 |
| 2.96% | -0.94% | 8.81% | 9.05% | -12.77% | 1.16% | 9.61% | 12.26% | 9.39% | 5.76% | 2.47% | -0.62% |
<colgroup><col style="width: 49pt;" span="11" width="66"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;" width="72"> <tbody>
</tbody>
