| Fracking Oil Investment Decision |
| Constants | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Income Tax Rate | NA | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% |
| Cash Needed to Start Year | NA | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 | $ 1,000,000 |
| Decline Rate | NA | 0.70 | 0.30 | 0.25 | 0.25 | 0.20 | 0.20 | 0.20 | 0.15 |
| Initial Production Rate (IPR) | NA | 500 | NA | NA | NA | NA | NA | NA | NA |
| Interest on Junk Bonds | NA | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 | $ 500,000 |
| Inputs | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Price Per Barrel | | NA | NA | NA | NA | NA | NA | NA | NA |
| Interest Rate on New Debt | NA |
| Requested Investment | | NA | NA | NA | NA | NA | NA | NA | NA |
| Summary of Key Results | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Net Income After Taxes | NA |
| End-of-the-Year Cash On Hand | NA |
| End-of-the-Year Debt Owed | NA |
| Net Present Value of Investment | NA | NA | NA | NA | NA | NA | NA | NA |
| Calculations | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Initial Production Rate/Day (IPR) | NA | 500 |
| Average Production/Day in the Year | NA |
| Barrels of Oil Produced in the Year | NA |
| Income and Cash Flow Statement | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Beginning of-the-Year Cash On Hand | NA |
| Revenue | NA |
| Out of Pocket Costs and Expenses | NA |
| Oil Transport ($12/barrel) | NA |
| Well Operations ($3/barrel) | NA |
| General and Administrative | NA | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 | $ 200,000 |
| Royalties to Land Owners | NA |
| Severance Taxes | NA |
| Interest on Junk Bonds | NA |
| Interest on New Debt | NA |
| Total Out of Pocket Costs and Expenses | NA |
| Income Before Taxes | NA |
| Income Tax Expense | NA |
| Net Income After Income Tax Expense | NA |
| Net Cash Position (NCP) Before
Borrowing and Repayment of Debt | NA |
| Add: Increase in Borrowing | NA |
| Less: Repayment of Debt | NA |
| End-of-the-Year Cash On Hand | $ 1,000,000 |
| Debt Owed | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Beginning-of-the-Year Debt Owed | NA |
| Add: Increase in Borrowing | NA |
| Less: Repayment of Debt | NA |
| End-of-the-Year Debt Owed | $ 1,000,000 |
| Net Present Value Data |
| Net Present Value @ 15% | | NA | NA | NA | NA | NA | NA | NA | NA |