Workbook · Financial Engineering & Grants

Financial model for a feasibility study

Financial model for a feasibility study

Download

Excel, PDF
Languages: French, English, Spanish, Arabic
Other languages: French, Spanish, Arabic

Purpose

Five-year financial model linking a project’s assumptions to the forecast accounts (investment, financing, operations, cash flow, profitability, sensitivity); it calculates the net present value, internal rate of return and payback period, and tests three variables.

File contents

Workbook with nine sheets: (1) Guide; (2) Parameters; (3) Assumptions (value, unit, source, reliability, comment); (4) Investment; (5) Financing; (6) Operations; (7) Cash flow; (8) Profitability (net present value, internal rate of return, payback period, break-even turnover in the first year of operation); (9) Sensitivity (selling price, volume sold, unit variable cost). Only cells with a light background are to be completed; calculated cells and the structure of the workbook are protected. Each assumption carries its source and reliability (“Observed”, “Estimated” or “Assumed”); the workbook is prefilled with a standard structure and indicative values marked “Assumed”, to be replaced with the project’s data. Five-year horizon, without residual value. Presentation note: description of the nine sheets and notes for use.

Format

Editable Excel workbook with nine sheets and a three-page presentation note in PDF, in the language of the page. Languages of the tool: French, English, Spanish, Arabic.

Access

Free and open access: the workbook and the note can be downloaded directly, without registration or order; by way of exception to the distribution of open-access tools in PDF format, the workbook is supplied as an editable Excel file, which its use requires.

Related service

Consulting firm not registered with any Bar; no representation before the courts and no act reserved to the regulated legal professions.

Workbook – Financial model for a feasibility study – Presentation

  • Prepared by ASKonsult
  • Languages: French, English, Spanish, Arabic

General information document; it constitutes neither legal advice nor an opinion on a particular situation. References to legal texts should be checked against the version in force on the date of use.

Consulting firm not registered with any Bar; no representation before the courts and no act reserved to the regulated legal professions.