Use Excel to complete problem

5. Weighted Average Returns a. Sherman is a novice investor. The following table shows his portfolio holdings and market values for each holding. Calculate Sherman's weighted average return for his portfolio. Junk Bond Fund Gold Fund Small Cap Fund Index Fund CD Market Value $ 13,000.00 $ 19,500.00 $ 36,000.00 $ 9,800.00 $ 41,000.00 Rate of Return 7.50% 12.00% 3.40% 6.20% 1.00% b. Sheri and Jarius own several pieces of expensive jewelry. The following table summarizes their most important gem assets: vital t 11.00 Diamond Ring Sapphire Necklace Emerald Pendant Ruby Brooch TOTAL Market Value $ 12,000.00 $ 23,000.00 $ 19,500.00 $ 21,200.00 $ 75,700.00 Purchase Price $ 7,250.00 $ 18,875.00 $ 19,000.00 $ 23,000.00 $ 68,125.00 Use this information to calculate the holding period return