please include any and all excel functiosn and steps taken to find answers.

Thank you!!

6. Below is NPV profiles of two alternative investment projects. What investment projects should the company choose if the company does not have any other information such as cost of capital? (12 Points) NPV Profile $800,000.00 $600,000.00 $400,000.00 $200,000.00 10% 20% 30% 40 SON 0% ${200,000.00) $(400,000.00) $(600,000.00) -A Year 0 1 Cash Flow A S (1,000,000.00) $ 650,000.00 $ 350,000.00 $ 300,000.00 $ 200,000.00 S 100,000.00 2 3 4 5 Cash Flow 8 $(800,000.00) $ 90,000.00 $ 110,000.00 $ 250,000.00 $ 350,000.00 $ 850,000.00 2