Assume you have $100,000 to invest. Using the EXCEL spreadsheet on Black Board; based on your...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Age 20 Risk Tolerance High Asset Allocation 30 US Large Cap VYM Vanguard High Dividend Yield ETF Fun... View the full answer
Related Book For
Fundamentals of Investments Valuation and Management
ISBN: 978-0077283292
5th edition
Authors: Bradford D. Jordan, Thomas W. Miller
Posted Date:
Students also viewed these accounting questions
-
a. Using the excel spreadsheet found on xxx, analyze the data to determine what type of person would be most likely to survive? Least likely to survive? b. Read about the Titanic and develop a CED to...
-
Repeat Example 16.3 using the Excel spreadsheet FV function to determine the cost of borrowing $3,000 on a credit card for 1 years at 28 percent compounded monthly.
-
Morningstar is a mutual fund rating agency. It ranks a fund's performance by using one to five stars. A one-star mutual fund is in the bottom 10% of its investment class; a five-star mutual fund is...
-
The insurance company Helmet is considering acquiring BeSafe, a life insurance company. According to BeSafes most recent financial statements, its loss ratio stands at 0.9, and its expense ratio...
-
A mining company conducted a safety analysis for workers at a Saskatchewan site. Of 450 sample records in January, 16 revealed undesirable safety conditions. Of 660 sample records in February/March,...
-
Construct function prototypes that match the following descriptions: a. igor() takes no arguments and has no return value. b. tofu() takes an int argument and returns a float. c. mpg() takes two type...
-
In Exercise 41, an error was made in grading your practical. Instead of getting 90, you scored 100. What is your new weighted mean? Data from Exercises 41 The scores and their percents of the final...
-
Radon Homes current EPS is $6.50. It was $4.42 five years ago. The company pays out 40% of its earnings as dividends, and the stock sells for $36. a. Calculate the historical growth rate in earnings....
-
Direct labor costs Family Model Deluxe Model $72,900 $145,800 Machine hours 2,000 2,000 Setup hours 200 800 Packaging hours 50 75 The estimated overhead of $437,400 is allocated as follows: machining...
-
1. The following information is available for the Albert and Allison Gaytor family in addition to that provided in Chapters 16. The Gaytors paid tuition and fees for both Crocker and Cayman to attend...
-
Prezas Company's balance sheet showed total current assets of $3,250, all of which were required in operations. Its current liabilities consisted of $975 of accounts payable, $600 of 6% short-term...
-
Tata Motors Limited (tatamotors.com) was formerly called TELCO, an abbreviation for Tata Engineering and Locomotive Company. Today, Tata Motors is an Indian multinational automotive company...
-
The Procter & Gamble Company (P&G) is a force in the global marketplace. It is the biggest U.S. advertiser at some $5 billion annually, and spends a staggering $9 billion annually worldwide on...
-
In 2015, the government of Saudi Arabia announced an ambitious plan, known as Vision 2030, to diversify the economy beyond oil. Saudis plans to modernize its economy will require copious funding,...
-
Reread the Management Focus AB InBev, Beer Globally, and Creating Value, and then answer the following questions: a. With more than 200 brands and strong coverage internationally of the different...
-
Alibaba Group Holding Limited (alibaba.com) was founded in 1999 by Jack Ma as an e-commerce company to facilitate sales among companies that provide consumer-to-consumer, business-to-consumer, and...
-
Consider a system composed of an ideal gas. (a) (2 points) Derive P(V), this is, pressure as a function of volume, for a reversible adiabatic process. State any assumptions. (b) (2 points) Consider...
-
Write the statement to store the contents of the txtAge control in an Integer variable named intAge.
-
Explain the meaning of a Value-at-Risk statistic in terms of a smallest expected loss and the probability of such a loss.
-
Consider the following spot interest rates for maturities of one, two, three, and four years. r1 = 5.1% r2 = 5.8% r3 = 6.3% r4 = 7.3% What are the following forward rates, where f1,k refers to a...
-
A 30-year mortgage has an annual interest rate of 6.84 percent and a loan amount of $250,000. What are the interest and principal for the 120th payment?
-
External auditors collect consulting fees from the same clients they perform independent audits for, which allows good and close relationship with the clients. True/false
-
To deal with the turmoil caused by the various accounting scandals, the SOX Act was passed in 1999. True/false
-
Auditors should not demand full access to the entire general ledger so that they can be more focused on the audit. True/false
Study smarter with the SolutionInn App