Using the interest rate data and financial statements for XYZ, Inc. posted below, answer the questions below using Microsoft Excel. You may want to refer to the footnotes to the financial statements online for additional clarification/information if necessary.

1. Review the interest rate data provided for 2017. Assume that the 10-year treasury rate is the applicable measure of return for excess cash balances. Do you agree with the average 2017 rate specified(note-you can disregard the slight time period difference between the calendar year and XYZ's fiscal year)? Perform a calculation of the rate you would use (referencing only the materials provided) that either confirms the rate given, or provides an alternative. Support your answer.