Algorithm for Dairy Farm Financial Analysis based on an Existing Excel Model

Project Description

We have a well-defined Excel-based financial model that is used by by dairy producers, bankers and other industry professionals to complete financial analysis on dairy farms that includes Cash Flow Projections, Actual to Budget Comparisons and Balance Sheet and related financial measurements/reports. These are all intended to boost the business acumen of the user and provide them with improved insight into the financial health of a dairy operation. It can also be used as a tool to develop various “What If?” scenarios, guiding a milk producer or banker to make more informed financial decisions.

For example, “What if I obtained longer term (e.g. a 20 year Real Estate Loan) financing, supported by real estate collateral, versus using short term lines of credit to expand my business? What are the financial implications and potential impact of these various scenarios?” “Is my dairy business cash flowing? If not, what cost areas do I need to reduce? Are there other financial management items that need to be refined?”

Using our program, an individual can obtain a better grasp of the finances of any particular dairy operation. In the case of a banker, he or she will be better equipped to make financing decisions. For a producer, they can make better investment, expansion and financing decisions, as well as obtain a much clearer picture of their actual financial performance in comparison to their budget numbers.

Our goal is to take this Excel-based financial model and create a SaaS-based platform.  This project here is the first phase in which we develop an alogrithm that reflects our current model.

Project for Experfy Expert

You will take our existing Excel model and turn it into a Python-based algorithm.  You would need to understand all the calculations in Excel and then build a data model in a relational database. We would like the alogrithm to update the data entered by the user in the relational database and provide the outputs.

Since we will be building a front-end for the SaaS-platform later, we do not see the need to develop an extensive UI at this stage.  We would like to build a basic interface to input the data and then have the output either printed on the screen or downloaded in a CSV file.

We would test the validity of your alogorithm again the results in Excel and if the two match, then the project will be considered complete.

In your proposal, please be very specific about 1) your approach; 2) the technology stack that you would use; 3) whether you will deliver the results in a CSV or on an online dashboard; 4) how you see your alogrithm being consumed by our future SaaS platform; 5) milestones and dates.