University of Wyoming Extension
Wyoming Ranch Tools

Tools

Home

Partial Budget

NPV Tool

Aum Value Tool

Genetic Investment

Sprayer Calibration

Stocking Tool



Fact Sheets

Partial Bugdet

Pasture Leasing

Genetic Investment Sheet

Sprayer Calibration

Stocking Rate



External Links

Cattle Market Analysis
ranch tools NPV.xlsx
Please fill all required fields
Wyoming Master Stockman
Net Present Value Analysis
Investment
Interest Rate
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15
Annual Cost
Annual Revenue
User Notes:
Results
Please e-mail me at brfeuz@uintacounty.com with any questions or feedback 5 year NPV
10 year NPV
This is intended to be a decision support tool and is only as accurate
15 year NPV
as the information entered
Break Even Year
Detailed Results
Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Investment
Annual Cost
Total Cost
Revenue
Net Return
Discount Factor
NPV
Cumulative NPV
Wyoming Master Stockman  
Econo-Range  
Net Present Value Analysis  
Investment per acre investment cost
Interest Rate Hint: Use 5% for a low risk investment - 10% moderate risk - 15% high risk
AUM Price Cost to lease comparable pasture
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15
Annual Cost
Additional AUMs
(per acre)
User Notes:
Results
Please e-mail me at brfeuz@uintacounty.com with any questions or feedback 5 year NPV
10 year NPV
This is intended to be a decision support tool and is only as accurate
15 year NPV
as the information entered
Break Even Year
 
Detailed Results
Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Investment
Annual Cost
Total Cost
Revenue
Net Return
Discount Factor
NPV
Cumulative NPV
Instructions for Using the Standard Calculator    
User Entry  
Step 1 - Enter the amount of your investment in the highlighted cell.  
Step 2 - Enter the discount rate you wish to use.  
  5% - Low Risk Enterpise 10% - Moderate Risk 15% - High Risk  
  At a minimum you should use the interest rate from a loan, or savings rate.  
  Add to the interest rate a factor depending on how risky you percieve the investment.  
Step 3 - Enter your annual costs for the project.  
Step 5 - Enter the expected annual returns for the project.  
   
   
Results  
5, 10 and 15 year Net Present Value (NPV) is calculated.  
  NPV - is used to calculate the value of the improvement project while accounting for risk and opportunities of
  investing capital in other ventures.  
A break-even year for the investiment is calculated. This calcualtion also accounts for the NPV.  
   
Detailed Results  
Total Cost - Investment cost plus annual cost  
Revenue - AUM price multiplied by the number of additional AUMs as a result of the improvement project  
Net Return - The difference between Revenue and Total Cost.  
Discount Factor - This value is calculated based on the discount rate entered in the input section.  
NPV - The annual value of the net return after discounting for risk and opportunity costs.  
Cummulative NPV - Total value of the net return after discounting for risk and opportunity costs.  
Instructions for Using Econo Range  
User Entry    
Step 1 - Enter the amount of your per acre investment in the highlighted cell.    
  Resource - University of Wyoming Custom Rates    
Step 2 - Enter the discount rate you wish to use.    
  5% - Low Risk Enterpise 10% - Moderate Risk 15% - High Risk    
  At a minimum you should use the interest rate from a loan, or savings rate.    
  Add to the interest rate a factor depending on how risky you percieve the investment.  
Step 3 - Enter the amount it would cost to lease an AUM.    
Step 4 - Enter your annual costs for the improvement project.    
Step 5 - Enter the expected annual AUM improvement as a result of the project.    
  Resource - Chapter 5 of the Nation Range and Pasture Handbook (Developed by the NRCS)  
     
Results    
5, 10 and 15 year Net Present Value (NPV) is calculated.    
  NPV - is used to calculate the value of the improvement project while accounting for risk and opportunities of
  investing capital in other ventures.    
A break-even year for the investiment is calculated. This calcualtion also accounts for the NPV.  
     
Detailed Results    
Total Cost - Investment cost plus annual cost    
Revenue - AUM price multiplied by the number of additional AUMs as a result of the improvement project  
Net Return - The difference between Revenue and Total Cost.    
Discount Factor - This value is calculated based on the discount rate entered in the input section.  
NPV - The annual value of the net return after discounting for risk and opportunity costs.    
Cummulative NPV - Total value of the net return after discounting for risk and opportunity costs.  
Econo-Range
Information Links
To facilitate the calculation of the per acre investment cost it may be useful to utilize custom machinery rates. Your actual costs may differ from the custom rates, but they can serve as a good guideline. Click on the link below to view the Wyoming Custom Rates.
Chapter 5 of the National Range and Pasture Handbook outlines NRCS recommendations for management of grazing lands. Utilizing this resource can assist you in identifying potential range improvement strategies, as well as the potential per acre AUM improvement
+requiredvalue
   
Powered By SpreadsheetConverter