Cost-Benefit Analysis with Applications to Animal Health Programmes: Spreadsheet Implementation of Discounted Cash Flow and Risk Analysis

Cost-benefit analysis on an animal health program involves considerable data collection and analysis. The analysis step involves expressing data in the form of cash flows, and then performing discounted cash flow (DCF) analysis. The output of DCF analysis consists of one of more of the various economic performance criteria - such as net present value, internal rate of return and benefit-to-cost ratios - which assist decision makers in judging whether to proceed with a project. This discussion paper examines the ‘hands-on’ side of cost-benefit analysis, viz. using a computer to carry out the analysis. Here, cash flow data are entered into electronic spreadsheet, and the various spreadsheet financial functions and presentation features are utilized to summarise estimated project performance.

Tisdell, Clem
Issue Date:
Publication Type:
Working or Discussion Paper
DOI and Other Identifiers:
ISSN: 1322-624X (Other)
Record Identifier:
PURL Identifier:
Total Pages:
JEL Codes:
Q16; E37
Series Statement:
Research Papers and Reports in Animal Health Economics

 Record created 2017-04-01, last modified 2018-01-22

Download fulltext

Rate this document:

Rate this document:
(Not yet reviewed)