using the results prepare a spreadsheet modeling the initial investment & annual cash inflows and outflows for each of the next five years. please explain formulas with calculations too so i can post in my assignment

To determine the maximum number of jobs that McCoy may execute each year, it is important to secure a needed information or data regarding the standard operations such as the size of the land and its estimated forage rate as can be seen in Table 1.McCoy set the standard of one acre per job and with the foraging rate per goat, we can calculate the length of time needed to finish a certain job Therefore, based on these calculations, upgrading to the larger truck/trailer combination could potentially allow McCoy to accept more jobs per year, indicating increased efficiency and throughput in his goat rental operation. Using the results from Question 1, compute the incremental annual revenues (cash flows) if McCoy invests in the larger truck and trailer. Use the model in case Exhibit 1 to compute incremental annual expenses (cash outflows) if McCoy invests in the larger truck and trailer