Oil & Gas Investment Cashflow Model
Budget: $250 – $750 USD
I need a flexible finance model that lets me evaluate an oil-and-gas asset strictly from an investment-analysis standpoint. The core deliverable is a medium-term (3-5 year) cash-flow forecast that I can update quickly as assumptions change.
Here is what matters most to me:
• All revenue, royalty, OPEX, CAPEX, tax and decline-curve assumptions sit in a clearly labelled input section.
• The model automatically rolls those inputs into monthly and annual cash-flow statements for the full 3–5 year horizon and then summarises free cash flow.
• Built-in sensitivities let me toggle prices, production profiles and cost inflation so I can see how they affect cash flow at a glance.
If you usually include ROI, NPV or risk-assessment modules, feel free to structure the sheet so they can be switched on later, but please keep the focus on clean, auditable cash-flow forecasting first.
I’m comfortable working in Excel and would like the file unlocked except for key formula sheets. A brief walkthrough (loom video or similar) showing how to update inputs and read outputs will complete the engagement.
Here is what matters most to me:
• All revenue, royalty, OPEX, CAPEX, tax and decline-curve assumptions sit in a clearly labelled input section.
• The model automatically rolls those inputs into monthly and annual cash-flow statements for the full 3–5 year horizon and then summarises free cash flow.
• Built-in sensitivities let me toggle prices, production profiles and cost inflation so I can see how they affect cash flow at a glance.
If you usually include ROI, NPV or risk-assessment modules, feel free to structure the sheet so they can be switched on later, but please keep the focus on clean, auditable cash-flow forecasting first.
I’m comfortable working in Excel and would like the file unlocked except for key formula sheets. A brief walkthrough (loom video or similar) showing how to update inputs and read outputs will complete the engagement.