IDEAS home Printed from https://ideas.repec.org/a/ags/jasfmr/161490.html
   My bibliography  Save this article

New Features Added to the Purdue Farm Financial Analysis Spreadsheet

Author

Listed:
  • Barnard, Freddie L.
  • Yeager, Elizabeth
  • Miller, Alan

Abstract

The Purdue Farm Financial Analysis Spreadsheet originally introduced in 1998 has been updated to include the additional financial measures recommended by the Farm Financial Standards Council; EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization), working capital to gross revenue ratio, capital debt repayment capacity and replacement margin, and the replacement margin coverage ratio. Also, an additional worksheet was added that calculates break-even at the farm level using the traditional fixed and variable classification of costs, as well as a second breakeven amount that includes principal payments on term loans, loss carryover amounts and replacement amounts for capital, such as machinery and equipment.

Suggested Citation

  • Barnard, Freddie L. & Yeager, Elizabeth & Miller, Alan, 2013. "New Features Added to the Purdue Farm Financial Analysis Spreadsheet," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2013, pages 1-14, June.
  • Handle: RePEc:ags:jasfmr:161490
    DOI: 10.22004/ag.econ.161490
    as

    Download full text from publisher

    File URL: https://ageconsearch.umn.edu/record/161490/files/382A%20Barnard.pdf
    Download Restriction: no

    File URL: https://libkey.io/10.22004/ag.econ.161490?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Barnard, Freddie & Boehlje, Michael, 2004. "Using Farm Financial Standards Council Recommendations in the Profitability Linkage Model: The ROA Dilemma," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2004, pages 1-5.
    2. Wilson, Christine & Bernard, Freddie & Boehlje, Michael, 2007. "A Financial Analysis Program That Will PASS the Farm Manager “Interest Test”," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2007, pages 1-10.
    3. Barnard, Freddie L. & Ellinger, Paul N. & Wilson, Christine A., 2010. "Measurement Issues in Assessing Farm Profitability through Cash Tax Returns," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2010, pages 1-11.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Barnard, Freddie L. & Yeager, Elizabeth A., 2017. "Evaluating Effectiveness of Operating Strategies and Loan Term Changes on Repayment Capacity," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2017.
    2. Yeager, Elizabeth A. & Banard, Freddie L., 2014. "Effectiveness of Increasing Liquidity as a Response to Increased Repayment Risk: A Case Study," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2014, pages 1-19.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Barnard, Freddie L. & Yeager, Elizabeth, 2013. "The Perfect Storm: A Case Study Illustrating How a Series of Events Led One Farm Operator to Develop a Risk Management Plan that Includes a Lender’s Perspective," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2013, pages 1-15, June.
    2. Wilson, Paul, 2014. "Farmer characteristics associated with improved and high farm business performance," International Journal of Agricultural Management, Institute of Agricultural Management, vol. 3(4), pages 1-9.
    3. Li, Ziran & Jacobs, Keri L. & Artz, Georgeanne M., 2012. "The Relative Capital Structure of U.S. Agricultural Grain and Supply Cooperatives and Investor Owned Firms," 2012 Annual Meeting, August 12-14, 2012, Seattle, Washington 124755, Agricultural and Applied Economics Association.
    4. Mahnken, Curtis & Nordquist, Dale, 2017. "Pr - Profitability Migration In Minnesota Farms," 21st Congress, Edinburgh, Scotland, July 2-7, 2017 345777, International Farm Management Association.
    5. Chong, Sze Chin, 2019. "An Analysis of the External and Internal Factors Affecting Honda Motor Company’s Performance," MPRA Paper 97206, University Library of Munich, Germany, revised 18 Nov 2019.
    6. Yeager, Elizabeth A. & Banard, Freddie L., 2014. "Effectiveness of Increasing Liquidity as a Response to Increased Repayment Risk: A Case Study," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2014, pages 1-19.
    7. Paul N. Ellinger & Bruce L. Ahrendsen & Charles B. Moss, 2012. "Balance sheet and income statement issues in ARMS," Agricultural Finance Review, Emerald Group Publishing Limited, vol. 72(2), pages 247-253, July.
    8. Mishra, Ashok K. & Harris, James Michael & Erickson, Kenneth W. & Hallahan, Charles B., 2008. "What Drives Agricultural Profitability in the U.S.: Application of the DuPont Expansion Model," 2008 Annual Meeting, July 27-29, 2008, Orlando, Florida 6413, American Agricultural Economics Association (New Name 2008: Agricultural and Applied Economics Association).
    9. Wilson, Christine & Bernard, Freddie & Boehlje, Michael, 2007. "A Financial Analysis Program That Will PASS the Farm Manager “Interest Test”," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2007, pages 1-10.
    10. Barnard, Freddie L. & Ellinger, Paul N. & Wilson, Christine A., 2010. "Measurement Issues in Assessing Farm Profitability through Cash Tax Returns," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2010, pages 1-11.
    11. Briggeman, Brian & Dikeman, Mark & Yeager, Elizabeth & Reid, Robin, 2019. "A ProfitLink Decision Tree for Farm Financial Managers," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2019.
    12. Banard, Freddie L. & Yeager, Elizabeth A., 2014. "Impact of Lower, More Volatile Net Farm Incomes, and Higher Interest Rates on Repayment Risk," Journal of the ASFMRA, American Society of Farm Managers and Rural Appraisers, vol. 2014, pages 1-20.

    More about this item

    Keywords

    Agricultural Finance;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ags:jasfmr:161490. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: AgEcon Search (email available below). General contact details of provider: https://edirc.repec.org/data/asfmrea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.