A Feasibility Study - Step by Step

Описание: *Source file included in the description.

This video shows you how to create a simple feasibility study. It is based on a 5-years forecast for an IT company that sells two products. The initial assumptions are given. We complete all the required and possible calculations as a first step, set up the financial statements side-by-side, construct investment cashflow statement, and compute the NPV and IRR to lookup the feasibility of the project.

The study follows a dynamic approach where the user only needs to change the assumptions later, and it will be reflected on the whole study. Minimal knowledge of MS Excel is sufficient to understand the tutorial.

You can find materials related to this video following the links below:

*Extension: we add a loan to the study. This affects the forecast, but also shows you how to adapt structural changes to the business plan. The loan concept, inclusive of interest payments as well as repayments of the principle amount, is also covered in details:
►    • A Feasibility Study: Loan Amortization  

*Correction: There was a minor error related to remaining inventory calculations in the study. Please find the fix on this link:
►    • Feasibility Study - Correction (1)  

*Source File: (please read the description)
⇩ https://goo.gl/ebcexg

*Additional Template: you can download and work with a more dynamic feasibility study following this link:
►    • Feasibility Study Template: Trading Company  

Please let me know if you have any questions.

Class: Spreadsheets for Financial Mathematics
Program: Bachelor in Management
University of Luxembourg - Spring 2015