Worksheet for Testing Multiple Development Debit and Compensatory Mitigation Credit Transactions

Enter and select the information requested in each of the data entry boxes below and press the calculate buttons. Note: You are free to deviate from the drop-down options if you choose to. For a newly established mitigation bank, make sure to enter 0-acres into the development acres input boxes. For transactions that are not going to be used, enter 0 in their mitigation acres and 0 in their development acres input boxes. Note: All transaction buttons must be selected at least once to allow a calculation of the sum statistics. Credits to offset debits are withdrawn from the entire bank, not a specific acreage or mitigation type. The final responsibilities and authorities over mitigation bank credit allotment, tracking, and transparent reporting are relegated to the mitigation bank Chairs.

Compensatory Mitigation Action 1
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Compensatory Mitigation Action 2
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Compensatory Mitigation Action 3
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Compensatory Mitigation Action 4
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Compensatory Mitigation Action 5
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Compensatory Mitigation Action 6
Development Acres:
Mitigation Acres:
Development Multiplier:
Mitigation Divider:
Price Per Credit:
Number of Credits Required:
Total Credit Cost:
Remaining Credits Available:
Remaining Credit Value:
Sum Credits
Sum of Total Credits Required
Sum of Total Credits Cost
Total Remaining Credits Available:
Total Remaining Credit Value:

Author: John Marshall