{"id":10345,"date":"2016-09-02T11:13:05","date_gmt":"2016-09-02T11:13:05","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=10345"},"modified":"2019-10-11T12:19:15","modified_gmt":"2019-10-11T12:19:15","slug":"5-powerful-tools-for-accurately-measuring-your-farm-business-health-hint-download-ms-excel-report-generation-template","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/5-powerful-tools-for-accurately-measuring-your-farm-business-health-hint-download-ms-excel-report-generation-template\/","title":{"rendered":"5 Powerful Tools for Accurately Measuring Your (Farm) Business' Health [Hint: Download MS Excel Report Generation Template]"},"content":{"rendered":"

I first published this article online in 2012 on a 3rd party website as a guest post.<\/a> It discusses five powerful financial performance indication tools YOU can quickly and easily compute to determine your farm\u2019s financial state of health.<\/p>\n

\"5<\/a><\/em><\/p>\n

Read the full piece below, and learn how to download a resource Excel Workbook that contains example report generation formats for ALL 5 performance indicator tools discussed in it.<\/em><\/p>\n

<\/em><\/p>\n

Sometimes you need to get a loan from a bank; win over equity investors or attract strategic partners. If you\u2019re a big thinker, you could even have a vision to sell your farm business\u2019 shares in the capital market. Or you might want to expand by buying another farm(s). And sometimes you may just want to ascertain that all is well with your farm. The requirements to be met for each of the foregoing will differ.<\/p>\n

But one thing is certain:<\/strong> To do any of the above, you need accurate production records to generate reliable financial performance indicators! As long as you keep good production records, don\u2019t be in a hurry to hire a potentially expensive expert.<\/p>\n

This article discusses five powerful financial performance indication tools<\/strong> YOU<\/strong> can quickly and easily compute to determine your farm\u2019s financial state of health. And what you learn can aid you in assessing a hired expert, if\/when you decide to engage one. Note also, that these tools can be used to evaluate any business type.<\/em><\/p>\n

\u00a0<\/p>\n

Click here<\/a> to download a spreadsheet containing easy to understand computation formats for the different financial tools discussed below. Figures used in the example calculations were obtained from it. You may therefore find it useful to study the different computation formats as you read through the explanations, for better comprehension.<\/p>\n

The 5 Key Financial Performance Indication Tools<\/h3>\n

\u00a0<\/p>\n

Group One: Aggregate Measures<\/h3>\n

This group comprises two financial statements that provide an overview of a farm business\u2019 performance in monetary terms (I.e. income earned vs. expenses incurred), as it relates to the business\u2019 bottom line.<\/p>\n

(a) Income<\/strong> (or Profit and Loss) Statement:<\/strong> is often used in combination with the Net worth statement (see b.<\/strong> below). It is a summary of expenditure and income, which can be prepared for a farm unit or for individual enterprises e.g. on a mixed farm, comprising livestock and crop ventures. The key value reported is known as Net Income.<\/strong><\/p>\n

\u00a0<\/p>\n

Net Income =<\/strong> Sum of Income minus Sum of Expenditure<\/p>\n

Most people know this value needs to stay positive, for the business to make a profit.<\/p>\n

(b) Net worth Statement (<\/strong>or Balance Sheet):<\/strong> is used to determine the overall performance of a farm within a period of time. It is computed as follows:<\/p>\n

Net worth =<\/strong> Assets minus Liabilities<\/p>\n

This shows the value of assets that would remain if the business were to fold up and all outside claims were paid off. Incidentally, the net worth statement is the source for all the values used to compute the three remaining financial ratios<\/strong> to be discussed.<\/p>\n

\u00a0<\/p>\n

Group Two: Performance Ratios<\/h3>\n

This group comprises three performance measures which - unlike the financial aggregates - do not have units. And this makes them very useful for comparing performances of different farm sizes.<\/p>\n

These ratios go deeper than the aggregate measures do, to uncover areas of possibly \"poor health\" in your (farm) business (or indeed in ANOTHER [farm] business that you wish to purchase or invest in) which the income statement or net worth may not reveal.<\/em><\/p>\n

For instance, the ratios<\/strong> indicate the degree of a (farm) business' \"financial safety\" by comparing the load of assets and liabilities carried by it at a point in time.<\/p>\n

As a business owner, THAT information alerts you to areas in the business that you may need to take decisive action to fortify in order to avert potential disaster etc. As a prospective buyer or investor, this ratio\u2019s reported value can help you assess how \"safe\" or \"risky' it would be to purchase - or invest in - another person\u2019s farm<\/em>. That will guide you to negotiate smarter,<\/strong> with the owner \u2013 IF you decide to go ahead.<\/p>\n

Computing the Ratios<\/h3>\n

For the purpose of the example calculations done for these ratios, dummy values from the net worth statement format for a fictitious XYZ farms were used. Download the MS Excel resource workbook mentioned earlier, to study the different computation formats.<\/p>\n

In our workbook dummy example, total assets were 75,900 and liabilities were 45,500 giving a net worth of 30,400. The farm\u2019s inventory, accounts receivable and cash in hand constituted the assets. So the figure 30,400 indicates that the total assets exceeded total liabilities, and this can be useful; when comparing farms over a period of time.<\/p>\n

Let\u2019s now see how each of our three performance ratios is computed(Remember you need to download the workbook to see the dummy net worth statement source<\/em>):<\/p>\n

a. Current Capital Ratio (CCR)<\/strong> - This is computed as follows:<\/p>\n

Sum of Current Assets divided by Sum of current liabilities<\/em><\/p>\n

I.e. 9,200\/2,500 = 3.68 (using our dummy data from the net worth statement)<\/p>\n

The CCR measures the degree of immediate safety or solvency<\/strong> of the farm i.e. its ability of the farm to meet its current obligations<\/strong>. The value obtained in our example indicates that the farm can meet its immediate current liabilities three times over.<\/p>\n

b. Working Capital Ratio (WCR)<\/strong> - This is computed as follows:<\/p>\n

Sum of Working and Current Assets divided by Sum of Medium Term and Current Liabilities.<\/em><\/p>\n

I.e. 24,900\/16,500 = 1.51 (using our dummy data from the net worth statement)<\/p>\n

The WCR measures the degree of financial safety in the medium term<\/strong>. The value obtained in our example indicates the farm is not very safe, in the medium term.<\/p>\n

c. Net Capital Ratio (NCR)<\/strong> - This is computed as follows:<\/p>\n

Sum of Assets divided by Sum of Debts<\/p>\n

i.e.75,900\/45,500 = 1.67 (using our dummy data from the net worth statement)<\/p>\n

The NCR value indicates the farm\u2019s degree of financial safety. This ratio is computed annually.<\/strong> The value obtained above indicates the farm has assets that amount to about one and a half times its liabilities.<\/p>\n

It goes without saying that in evaluating your farm and\/or<\/strong> one you wish to invest in, the reported values for each of the above ratios will guide your decision making better.<\/em><\/p>\n

Final Words: Minimize Errors by Using Spreadsheets (and Automation)<\/strong><\/p>\n

Calculating these performance measures manually can be cumbersome and risky. Use of spreadsheets would greatly help. You may need to do some learning. But if you\u2019d rather not, you could have a nifty little VBA driven workbook built to automate it for you.<\/p>\n

Download my MS Excel resource workbook (Click here<\/a> to request it) which contains the different computation formats (complete with formulas) used for this write-up. Adapt it for your use. Nothing stops you from requesting RAW production data and posting them into this tested<\/em><\/strong> workbook, to see if the values turned out agree with what you\u2019ve been given<\/em><\/strong> \u2013 say by your farm manager\u2026or the owner of a farm you\u2019re interested in<\/em><\/strong>.<\/p>\n

Good luck!<\/p>\n

Reference\/Further Reading:<\/strong> Essentials of Agricultural Economics by A.J. Adegeye and J.S. Dittoh, Impact Publishers Limited (1985)<\/p>\n

Click here<\/a> to find out how to download MY FREE FARM BIZ RESOURCE WORKBOOK<\/h3>\n

It contains the different computation formats (complete with formulas) used in the above article<\/p>\n","protected":false},"excerpt":{"rendered":"

I first published this article online in 2012 on a 3rd party website as a guest post. It discusses five powerful financial performance indication tools YOU can quickly and easily compute to determine your farm\u2019s financial state of health. Read the full piece below, and learn how to download a resource Excel Workbook that contains […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,1375,133,266,1440,1753],"tags":[1889,2483],"class_list":["post-10345","post","type-post","status-publish","format-standard","hentry","category-entrepreneurs","category-excel-vb-solutions","category-farm-biz","category-my-dn-travel-news","category-recommended-websites-articles","category-the-farm-ceo","tag-5-powerful-tools-for-accurately-measuring-your-farm-business-health","tag-download-ms-excel-report-generation-template"],"aioseo_notices":[],"views":1079,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=10345"}],"version-history":[{"count":5,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10345\/revisions"}],"predecessor-version":[{"id":14615,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10345\/revisions\/14615"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=10345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=10345"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=10345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}