It is necessary to make an investment of CZK 6000000 which will generate the EBITDA in the annual amount of CZK 1500000 during nex 5 years annually. The project will not hold an initial working capital but it is expected to keep 15% EBITDA in the NCWC capital, which will not be released in the end. Tax corporate 20%. Discount facor is 12%. Straght line depreciation method for 4 years is using.
Evaluate if is worth to accept it and calculate what is the maximum IRR for the project to be acceptable and will this project bring the EVA of the company? Please use excel.