Below are four cases that you will have to solve using Excel spreadsheets. 1st case The...

Transcribed Image Text:

Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT Initial investment Cash flows Year 2 cash Year 3 cash year 1 flows flows A $25,000 $7,000 $15,000 $18,000 B $22,000 $12,000 $8,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. It is requested 1. Determine the internal rate of return. 2. Determine the present value. 3. Determine the recovery period. 4. Define which is the most viable project. Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT Initial investment Cash flows Year 2 cash Year 3 cash year 1 flows flows A $25,000 $7,000 $15,000 $18,000 B $22,000 $12,000 $8,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. It is requested 1. Determine the internal rate of return. 2. Determine the present value. 3. Determine the recovery period. 4. Define which is the most viable project.