I have already answer of the following question that you had responded but not in a spreadsheet. can you please do it in a spreadsheet showing your work by formulas at arriving at your solutions. "Finance Working Capital Management 5 (Short-Term Investment and Financing) Chapter 15 problem 1 A company invests $1,000,000 at the beginning of the year. It adds another $250,000 at the end of the first quarter, withdraws $350,000 at the end of the second quarter, adds $145,000 at the end of the third quarter, and withdraws $450,000 of the remaining funds at end of the year. It earns $20,000 of interest in the first quarter, $17,000 in the second quarter, $12,000 in the third quarter, and $29,000 in the fourth quarter. a. What is the annual effective rate earned on the investment on the investments portfolio? b. What rate of return would have been calculated if one only looked at the ending portfolio value as compared with the beginning $1,000,000 investment?"