the file using he appr Iqvestment Yields-YIELD, YIELDISC Formulas 31. 2019, Anne Britton asked for advice on two different interest-bearing owns. Anne has decided to complete remodeling on her home. In ust securities that she order to pay for this, she needs to sell one of the two investments andl as requeste advice. Investment A 8/31/2018 9/1/2018 8/31/2019 2% $28,793 $32,000 Investment B 8/31/2015 9/1/2015 8/31/2019 2% $28,793 $32,000 4 Setlement date Issue Maturity (intended sale date) Rate Security original purchase price Redemption value Frequency (compound periods per year) Required 1. Create a working table with the investment information listed above. For dates, use the DATE function under the formula menu. See Illustrations 5-71 and 5-72 in the chapter for demonstration of this function. Using the YIELD function, calculate the return on both investments. Using the YIELDDISC function, calculate the return on both investments. 2. 3. CTION I: INTERMEDIATE EXCEL SKILLS APPLICATION 4. Compose a memorandum to Anne using proper business memorandum g. Explain any differences in yield results and recommend to keep and which to sell. In the memorandum, explain the concept ofc interest with the assumption the client has tin little accounting or finance knowledge. into the 5. Insert a screenshot of the memorandum created in the Word documenti Excel file. Save the file using the appropriate naming convention for the course