Part of your responsibilities as a junior financial analyst is researching and identifying potential short-term liquid investment options for your...

i. Example: U.S. Treasury CUSIP

6. EAR for each investment

7. YTM for each investment a. If held to maturity b. If sold at the end of 12 months

8. Total return for investment portfolio if held to maturity

9. Spreadsheet model is to include all cell-based formulas for all calculations Your conclusion is to summarize the recommendation made in item #1 above Format for report. Your report must:

1. Be presented in Word file format

2. Analysis must be between 3 to 5 pages maximum, including spreadsheet analysis

3. Excel spreadsheet is embedded into the Word file

4. Submit Excel file separately