IE9-1 Using Present Value Concepts for Decision Making Copoor, Incorporated is evaluating investment ideas. Required: Use appropriate TVM formulas to determine the values of each option to determine which Copoor, Incorporated should choose. Note: Be sure to make all TVM functions negative () to calculate the values properly. Hint: Remember to subtract the TVM amount from the initial invesment in the building for Case 1. Hint: Think about whether you are spending or receiving cash in each case to choose the appropriate option. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Please post with excel formulas Thank youl