Formulae needed to calculate cattle herd growth projection!

[Lady K]

Hello everyone! Help!

1. There are 61 cattle due to give birth in 2016 and then one calf per year thereafter.

2. There is a 45% chance of those calves being female.

3. Of those calves being female, they too would be in a position to reproduce once two years old, again having a 45% chance of giving birth to a female.

4. I'm trying to calculate how many cattle there would be in 2025.

How many columns, rows, calculations do I need and what would they be!

Is there a chance this could be easy for someone out there?

I've kind of made a start (can do Q1. and Q2).

......???

Thank you

<colgroup><col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:1718; width:35pt" span="8" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 120"][/TD]
[TD="class: xl71, width: 72"][/TD]
[TD="class: xl77, width: 47"]Actual[/TD]
[TD="class: xl81, width: 429, colspan: 9"]Projections[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl85"]Totals[/TD]
[TD="class: xl86"]61[/TD]
[TD="class: xl87"]122[/TD]
[TD="class: xl87"]244[/TD]
[TD="class: xl87"]305[/TD]
[TD="class: xl87"]366[/TD]
[TD="class: xl87"]427[/TD]
[TD="class: xl87"]488[/TD]
[TD="class: xl87"]549[/TD]
[TD="class: xl87"]610[/TD]
[TD="class: xl88"]671[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl89"]of which 55% = bulls[/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl79"]67[/TD]
[TD="class: xl79"]134[/TD]
[TD="class: xl79"]168[/TD]
[TD="class: xl79"]201[/TD]
[TD="class: xl79"]235[/TD]
[TD="class: xl79"]268[/TD]
[TD="class: xl79"]302[/TD]
[TD="class: xl79"]336[/TD]
[TD="class: xl84"]369[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl89"]of which 45% = heifers[/TD]
[TD="class: xl90"] [/TD]
[TD="class: xl79"]55[/TD]
[TD="class: xl79"]110[/TD]
[TD="class: xl79"]137[/TD]
[TD="class: xl79"]165[/TD]
[TD="class: xl79"]192[/TD]
[TD="class: xl79"]220[/TD]
[TD="class: xl79"]247[/TD]
[TD="class: xl79"]275[/TD]
[TD="class: xl84"]302[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl72, width: 72"][/TD]
[TD="class: xl83"] 2016 [/TD]
[TD="class: xl73"] 2017 [/TD]
[TD="class: xl73"] 2018 [/TD]
[TD="class: xl73"] 2019 [/TD]
[TD="class: xl73"] 2020 [/TD]
[TD="class: xl73"] 2021 [/TD]
[TD="class: xl73"] 2022 [/TD]
[TD="class: xl73"] 2023 [/TD]
[TD="class: xl73"] 2024 [/TD]
[TD="class: xl74"] 2025
[/TD]

</tbody>

 

[Lady K]

ps. actually i need to know growth year-on-year - not just by 2025....