Only need excel spreadsheet with the answers and formulas! Please excel sheet make copy and paste.

You plan to start a cow-calf operation with the aspirations of increasing the herd at a steady rate over the next 10 years. You plan to begin your operation with 80 bred cows and 950 acres of grass. Your geographic area is well suited for 1 pair per 10 acres. Assume every animal every year will have an offspring. Every year, you plan to cull older cows and keep as many replacement animals as you can while still turning a profit. You plan to cull at an 8% rate and use a 14% replacement rate. We can expect a death rate of 2%. Create a spreadsheet that analyzes this data. Use formulas in all cells. You can round to whole numbers to make things easier. Calculate everything from the beginning of each year and answer the following questions in your spreadsheet.

1. At approximately what point in time will we exceed our stocking rate?

2. What will our herd size be at the end of year 10?

Say you wanted to be a little more aggressive in growth. Change your replacement rate to 16% and your cull rate to 6%. Keep the death rate at 2% and answer the following questions.

3. At approximately what point in time will we exceed our stocking rate?

4. What will our herd size be at the end of year 10?

5. How many acres of grass will we need by the end of year 10?