Investment Reports
There are several different reports available to be printed from the information given in the Investment Files of the Disbursement and JIB Manager Integrated Edition. These reports are accessible from the Reports menu under Investment Reports.
These reports correspond to the Investment Files found under the Maintain Menu.
Investment Reports:
The Well Pay Out reports show the initial investment in each well and then a year-by-year report of cash received from production from the well. The report projects the cash to be received for those years in the future. The cash is estimated based upon the decline percentages entered for the field. The estimate is made by averaging the last three years gross income and then declining the average by the decline percentage. Expenses are averaged for the last 3 years with the one-time expenses being dropped out. You can also choose to estimate with the change in price of gas and oil as a consideration.
A "field" must be associated with the well on the Meter/Misc tab of the well information screen in order for this report to display the information for any owners in that well.
Base Projections On
Choose how you want the estimate made. Net Revenue Received projects the cash forward using the decline percentages entered for the field. Oil and Gas Price Changes projects the cash forward by declining the BBL and MCF using the decline percentages entered for the field and then multiplying the resultant BBL or MCF by the price per BBL or MCF.
Beginning and Ending Well
Choose the first and last well IDs in the range of wells to include in the pay out report.
Beginning and Ending Owner
Choose the first and last owner IDs in the range of owners whose wells will be included in the report.
Group
Choose the group of wells to be displayed in the report.
First and Last Well
Choose the first and last well IDs in the range of wells to include in the pay out report.
Payout As of Date
Enter the date you wish to see payout information for.
The depletion report shows the allowable depletion calculated for each owner and well in the given year.
Year
Enter the year for the depletion report.
First and Last Owner
Choose the first and last owner IDs in the range of owners whose wells will be included in the report.
Include Amounts Still in Suspense
Balances that have not been allocated to an owner on a run closing will be included on this report if this option is marked.
Discounted Rate of Return Report
The Discounted Rate of Return report shows the initial investment in each well and then a year-by-year report of cash received from the well. An internal rate of return calculation is made based upon the initial investment and the amount of cash received each year. The report projects the cash to be received for those years in the future. The cash is estimated based upon the decline percentages entered for the field. The estimate is made by averaging the last three years gross income and then declining the average by the decline percentage. Expenses are averaged for the last 3 years with the one-time expenses being dropped out. You can also choose to estimate with the change in price of gas and oil as a consideration.
Base Projections On
Choose how you want the estimate made. Net Revenue Received projects the cash forward using the decline percentages entered for the field. Oil and Gas Price Changes projects the cash forward by declining the BBL and MCF using the decline percentages entered for the field and then multiplying the resultant BBL or MCF by the price per BBL or MCF.
Beginning and Ending Well
Choose the first and last well IDs in the range of wells to include in the payout report.
Beginning and Ending Owner
Choose the first and last owner IDs in the range of owners whose wells will be included in the report.
Comment or report problem with topic