The company "The Twilight Company" generates with its current assets flows of USD2,250,000 in perpetuity (You must calculate the perpetuity). In year zero (0) he is presented with the opportunity to carry out the "Jacobo" project, which requires an investment in year one (1) of USD2,800,000 and which returns from year two (2) flows of USD600 ,000 a year for 5 years, then returns USD350,000 for 7 years, to subsequently have losses of USD700,000 in perpetuity (You must calculate the perpetuity). In case of taking the project, losses cannot be avoided. In year one (1), the possibility of carrying out the "Eduardo" project arises, with an investment of USD3,700,000 to be carried out in year two (2), which originates flows from year three (3) of USD1,100,000 during 9 years to then deliver flows of USD275,000 in perpetuity (You must calculate the perpetuity). Finally, in year two (2) there is the possibility of carrying out the "Bella" project whose investment is USD4,000,000 to be carried out in year three (3), which originates flows from year four (4) of USD900, 000 for 6 years, to then generate flows of USD550,000 in perpetuity (You must calculate the perpetuity).

Evaluate projects that generate value for the company Indications

Build the operating cash flow of the following projects

Calculate the NPV of each one with a discount rate of 15% (K)

Calculate the IRR of each Upload the Excel document with the format: