Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Short Answer Question: 30 Points Assume you have $100,000 to invest. Using the EXCEL spreadsheet on Black Board; based on your age and rick tolerance,

image text in transcribed

Short Answer Question: 30 Points

Assume you have $100,000 to invest. Using the EXCEL spreadsheet on Black Board; based on your age and rick tolerance, build a portfolio. Include its mutual fund symbol so I may look it up. Use Morningstar.com. or any other website for help. Use the EXCEL spreadsheet to populate each asset allocation categories listed. You must use the first four categories. DO NOT PUT 100% IN ANY ONE CATEGORY.Tell me why you chose each individual mutual fund. For each Mutual Fund, you must include:

Fund Fact Sheet, if available. If I can find it and you do not hand it in you will lose 10 points, thus starting off with 40 out of 50 points or 80%.

Investment Objective

Expense Ratio

BETA

Year to Date Performance/Return

5 and 10 year Performance/Return

Dividend Yield, if Applicable

Any other attributes you feel make it attractive to you. There is no right or wrong answer. ( this must be a long answer ) note: I am 25 years old and I like to take risks

I am attaching the excel sheet, that you will need.

If you have any questions feel free to ask me, just make sure u use no individuals stocks

image text in transcribed

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

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes

11th edition

9781259278617, 77861647, 1259278611, 978-0077861643

More Books

Students also viewed these Finance questions

Question

What is Internal Control? Who is responsible for this?

Answered: 1 week ago

Question

What is the role of theory in the scientific method?

Answered: 1 week ago

Question

What would social interaction be like without rules and roles?

Answered: 1 week ago