Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Humor And Other Oxymorons

Authors: Mr Mike Jacka

1st Edition

0991280903, 978-0991280902

More Books

Students also viewed these Accounting questions

Question

Express the number in decimal notation. 2.3 10 3

Answered: 1 week ago