ouchscreen Excel Lab #2-Chapter 15 Investments(1) (1)- Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW x. Cat Cambria-110-3 KK -H9- pwrap Tent Accounting .r Format Partei B 1 u-1-1-A, nale e EdMerge & Center. $-% , ] Normal Cambria 10 A A Conditional format a Neutral- Formatting Table Copy i calculation Number Styles . Font Directions: Using table 15-4, find the beginning year NAV for the AACNX mutual fund. Enter the current NAV Enter the Year-to-date % return . Current NAV: Year-to date % return Beginning of year NAV This template can be used to find the beginning-of the year NAV for a mutual fund listing or any of the values using the rates in Table 154 )Chapter 15- Building Wealth Through Investments Page 581 Challenge Problem 2a Problem 2a Using this Excel template find the return on investment for 250 shares of a mutual fund purchased wi 4 Directions: 5 Enter the number of shares purchased 26 Enter the purchase price 27 Eater the earned dividends per share 20 Enter the number of shares sold 29 Enter the selling price per share Divideuds per share 1 Shares parchased 32 Shares sold: Cost per share Selling price per share 3 Total cost of investment 4 Total proceeds from sale 5Return on investment VALUE VALUE Chapter 15 Investments TABLE 15-4 Portion of Mutual Fund Listing Family/ Fund YTD %return 6.2 4.0 4.9 3-yr %chg Chg 0.08 0.02 0.05 AARP Funds Aggr Consrv Mod p Symbol AAGSX AACNX AAMDX NAV 10.25 10.55 10.50 4.0 1.3 AMF Funds IntMtg LgCpEq ShtUSGv UltraShrtp UltShrtMtg USGvMtg .SCPX IICAX ASITX AULTX ASARX ASMTX 4.81 8.16 9.36 5.45 7.39 8.64 0.01 0.08 -0.01 -0.02 7.5 0.2 3.2 2.4 0.2 14.3 2.1 0.7 -12.2 0.02 0.7 APIEffFrtGrPrim fp 8.13 10.98 5.82 0.10 9.0 APIEffFrtGrPrim fp APIMultldxPrim AVS LPE Ptf -6.5 -9.6 NS 0.7 P APITX APIMultIdxPrim 0.09 -0.01 0.05 AFMMX AVS LPE Ptf LPEVX 11.3 Aberdeen Fds EqLS A t MLSAX 11.16 1.5