You need to utilize Excel to work out the problems and turn in the solutions. Part 1 Solve each question in a separate sheet in Excel and label the sheet accordingly. Also, copy and paste the question into the sheet similar to the class example. Lastly, make sure and color code any solutions and provide a key for your color-coding scheme (right now you will probably only have two colors but moving forward we will add to that). Please note* Points will be deducted for not following the above directions! Example solutions are located in the weekly videos posted in Canvas 1. A project requires a current investment of $189.32 and yields future expected cash flows of $45.19, $73.11, $98,54, $72.83, and $58.21 in periods 1 through 5, respectively. All figures are in thousands of dollars (do not change the values to thousands, leave as they are). For these expected cash flows, the appropriate discount rate is 6.3%. What is the net present value of this project? 2. A project requires a current investment of $54.39 and yields future expected cash flows of $19.27, $27.33, $34.94, $41.76, and $32.49 in periods 1 through 5, respectively. All figures are in thousands of dollars (do not change the values to thousands, leave as they are). For these expected cash flows, the appropriate discount rate starts at 6.4% in period 1 and declines to 5.6% in period 5 (loses .2% per year). What is the net present value of this project (hint* you will need to use the general discount formula)?