Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Asset % 1 Name 2 EMERGING ECONOMIES FUND 3 FIXED ACCOUNT PLUS 4 FOREIGN VALUE 5 HEALTH SCIENCES LARGE CAPITAL GROWTH. MID CAP INDEX FUND
Asset % 1 Name 2 EMERGING ECONOMIES FUND 3 FIXED ACCOUNT PLUS 4 FOREIGN VALUE 5 HEALTH SCIENCES LARGE CAPITAL GROWTH. MID CAP INDEX FUND SMALL CAP SMALL CAP INDEX 10 STOCK INDEX 11 Totals 12 13 Price Quantity Value($) $0.98 2741.13 $2,686.31 $3.45| 4405.96 $15,200.57 $1.4939839.49| $59,360.84 $3.34 902.37 $3,013.91 $1.5956866.15 $90,417.17 $17.70|1919.32 $33,971.96 $4.29| 1595.99 $6,846.81 $5.65| 3896.39 $22,014.62 $8.09| 11629.95 $94,086.27 $327,598.45 9 0.00% 14 15 16 17 18 First, write a formula in cell E2 that will calculate the percent of the total value of each fund. Once you have a list of percentages, select the Asset % column without the 100% cell. 19 20 21 22 Click on "Insert" and then choosea Pie Chart. Make sure it has a legend that shows what the different colors are. This will make it a little easier to understand how the portfolio is distributed. 23 24 25 26 Also, Use the Value (in dollars) column ot create a bar chart that shows the amount that is invested in each fund. You may need to play around with the formatting on the x-axis to be able to read the amounts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started