top of page

Investment appraisal financial model with carbon pricing for up to 3 investment options to compute financial viability and compare metrics eg IRR, Payback, NPV

DOWNLOAD DETAILS:

Excel Models 

Populated & Unpopulated

€‎30.00

User-friendly Excel model intended for the preparation of investment appraisals, including the impact of carbon pricing, for up to 3 investment options. The model helps to determine the financial viability and compare financial metrics for each investment option side by side, to assist the decision-making process.

​

The model follows good practice financial modelling principles and includes instructions, checks and input validations.

KEY OUTPUTS

The model is generic and not industry-specific. It computes a number of key appraisal metrics for proposed project or investment including:

  • Total one-off costs

  • NPV

  • IRR

  • MIRR

  • Accounting Rate of Return

  • Payback

  • Profitability Index

  • Equivalent Annual Cost

​

Results also include tables showing the overall costs and benefits on a:

  • Cash View – presents actual cash impacts of each investment option

  • P&L View – presents P&L impacts of each investment option (eg depreciation for capitalizable investments rather than cash impact)

​

The Results tab also includes charts showing the cumulative net cash flow and net earnings over the investment period.

KEY INPUTS

General inputs are further split into:

  • Company Name

  • Currency

  • Fist Projection Year

  • Cost of Capital

  • Corporate tax rate and payment assumptions

  • Carbon tax details and payment assumptions

 

Investment Inputs for up to 3 separate investment options including:

  • Investment Name

  • Investment Starting period & Lifetime

  • Initial investment amount (split into Capitalisable and Non-capitalisable)

  • Impact of investment on Revenues

  • Impact of investment on Costs

  • Variable costs % of Revenues

  • Working capital % of Revenue

  • Carbon emissions and related details

MODEL STRUCTURE

The model contains, 5 tabs split into input ('i_'), calculation ('c_'), output ('o_’) and system tabs. The tabs to be populated by the user are the input tabs are the input tab ('i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in ‘o_Results’ tab.

​

System tabs include the following:

  • 'Front Sheet' containing a disclaimer, instructions and contents;

  • Checks dashboard containing a summary of checks by tab.

KEY FEATURES

  • The model follows best practice financial modelling guidelines and includes instructions, line item explanations, checks and input validations;

  • The model is not password protected and can be modified as required following download;

  • The model allows the user to model the cost and benefits for up to 3 investment options across a maximum of 15 years with annual inputs;

  • Business name, currency and starting projection period are customisable;

  • The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors;

  • The model includes checks and input validations to help ensure input fields are populated accurately.

bottom of page