Project Calculations with Carbon Prices

This section defines the functions that calculate the project economics and emissions, with the impact of internal carbon prices.

These calculations are completed after the update and review of queries related to project data.

Internal Carbon Price Interpolation

This section calculates the internal carbon prices by first generating the in-between fiscal years through a Join function. Next, the carbon prices are interpolated for these years using a linear approximation in a Calculation function.

It consists of the following functions:

Generate Fiscal Year Series for Interpolation

This Join function generates the fiscal year series from current year onwards, to interpolate the internal carbon prices for the intermittent years, in the next function.

Interpolate Internal Carbon Prices

This Calculation function interpolates the internal carbon prices for the in-between years using a linear approximation.

Calculate Discounted Cash Flow for All Projects with Carbon Prices

This Join function joins the carbon prices to all project data without the carbon prices, to calculate the financial KPIs with carbon prices. The KPIs being calculated are incremental cash flow, discounted cash flow, and the emission offset.