Financial planning company.

by | Mar 3, 2022 | financial management

you started a new job with a financial planning company. You have been asked to present the risk/reward profile of your own recommended 5 stock portfolio for one of the clients at an upcoming meeting. Specifically, they would like you to present the monthly average returns and standard deviation for the last 5 years. Given you are a new employee, the firm has offered you the option to select the client you would like to present your suggested portfolio. You must select one of the following clients:

Brad Smith: Brad is a recent college graduate who just started his career. He considers himself to be a “risk-seeking” investor. He would like to get his retirement account going by seeking above average returns in the next five years. He is not concerned about risk as he has many years left in his career.

Andrew and Julia Peters: The Peters are newlyweds and would like to consider saving for a home. They have a five year horizon to save for a down payment on a house. They would like to invest in a portfolio that offers average growth and understand the risk of investing in stocks.

George and Mary Bell: The Bell’s are looking to retire in five years. They are on track given their savings, but would like you to invest in a portfolio of “conservative” stocks. This might include stocks paying dividends as it will allow them to receive income. They would like to see below average to average returns without a lot of risk.

The firm has suggested that you adhere to two rules:

Select five stocks that you believe as a portfolio represent the clients interest (risk/reward)

Always diversify!

After selecting your client and deciding on your portfolio:

1) Collect price information from the Yahoo! Finance website (finance.yahoo.com) as follows:

a. Enter the stock symbol. On that page click “Historical Data”

b. For time period, enter the “start date” as July 1, 2016 and the “end date” as July 26, 2021, to cover the period. Choose monthly frequency.

c. After hitting “Apply” click “Download Data”.

d. Open the downloaded data in an Excel spreadsheet. Delete all the columns except the date and the adjusted close. Label the adjusted close the name of the stock.

e. Enter the next stock symbol in the main search box and search for the next stock. Repeat the same steps above for each stock, maintaining the same time frame. Make sure the first and last prices are in the same rows and lined up correctly.

2) Convert these stock prices to percent change in monthly prices (hint: create a separate worksheet within the Excel file).

3) Compute the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the statistics to annual for easier interpretation (multiply the mean return by 12, and the standard deviation by square root of 12: √12).

4) Add a column in your Excel worksheet with the average return across stocks for each month. This is the monthly return of an equally weighted portfolio of these 10 stocks. Compute the mean and standard deviation of monthly returns for the equally weighted portfolio. Convert these monthly statistics to annual (see step 3).

5) Create an Excel plot with the annual standard deviation (volatility) on the x-axis and annual average return on the y-axis.

a. Create three columns on your spreadsheet with the statistics you solved. The first column will have the ticker (symbol) and “Portfolio”, the second will have annual standard deviation, and the third will have annual mean return.

b. Highlight the data in the last two columns (standard deviation and mean), choose: > Insert > Chart > XY Scatter Plot. Complete the chart wizard with labels, titles, and headings.

Deliverable: Write a 1-2 page paper with:

Introduction: Identify the client, their interests, and what portfolio you selected.

Body/Analysis: Compare and contrast the investments from a risk / reward perspective over the last five years. What do you notice about the average of the volatilities with the individual stocks compared to the volatility of the equally weighted portfolio? What is the advantage of owning the portfolio?

Sample solution

Dante Alighieri played a critical role in the literature world through his poem Divine Comedy that was written in the 14th century. The poem contains Inferno, Purgatorio, and Paradiso. The Inferno is a description of the nine circles of torment that are found on the earth. It depicts the realms of the people that have gone against the spiritual values and who, instead, have chosen bestial appetite, violence, or fraud and malice. The nine circles of hell are limbo, lust, gluttony, greed and wrath. Others are heresy, violence, fraud, and treachery. The purpose of this paper is to examine the Dante’s Inferno in the perspective of its portrayal of God’s image and the justification of hell. 

In this epic poem, God is portrayed as a super being guilty of multiple weaknesses including being egotistic, unjust, and hypocritical. Dante, in this poem, depicts God as being more human than divine by challenging God’s omnipotence. Additionally, the manner in which Dante describes Hell is in full contradiction to the morals of God as written in the Bible. When god arranges Hell to flatter Himself, He commits egotism, a sin that is common among human beings (Cheney, 2016). The weakness is depicted in Limbo and on the Gate of Hell where, for instance, God sends those who do not worship Him to Hell. This implies that failure to worship Him is a sin.


This question has been answered

God is also depicted as lacking justice in His actions thus removing the godly image. The injustice is portrayed by the manner in which the sodomites and opportunists are treated. The opportunists are subjected to banner chasing in their lives after death followed by being stung by insects and maggots. They are known to having done neither good nor bad during their lifetimes and, therefore, justice could have demanded that they be granted a neutral punishment having lived a neutral life. The sodomites are also punished unfairly by God when Brunetto Lattini is condemned to hell despite being a good leader (Babor, T. F., McGovern, T., & Robaina, K. (2017). While he commited sodomy, God chooses to ignore all the other good deeds that Brunetto did.

Finally, God is also portrayed as being hypocritical in His actions, a sin that further diminishes His godliness and makes Him more human. A case in point is when God condemns the sin of egotism and goes ahead to commit it repeatedly. Proverbs 29:23 states that “arrogance will bring your downfall, but if you are humble, you will be respected.” When Slattery condemns Dante’s human state as being weak, doubtful, and limited, he is proving God’s hypocrisy because He is also human (Verdicchio, 2015). The actions of God in Hell as portrayed by Dante are inconsistent with the Biblical literature. Both Dante and God are prone to making mistakes, something common among human beings thus making God more human.

To wrap it up, Dante portrays God is more human since He commits the same sins that humans commit: egotism, hypocrisy, and injustice. Hell is justified as being a destination for victims of the mistakes committed by God. The Hell is presented as being a totally different place as compared to what is written about it in the Bible. As a result, reading through the text gives an image of God who is prone to the very mistakes common to humans thus ripping Him off His lofty status of divine and, instead, making Him a mere human. Whether or not Dante did it intentionally is subject to debate but one thing is clear in the poem: the misconstrued notion of God is revealed to future generations.

 

References

Babor, T. F., McGovern, T., & Robaina, K. (2017). Dante’s inferno: Seven deadly sins in scientific publishing and how to avoid them. Addiction Science: A Guide for the Perplexed, 267.

Cheney, L. D. G. (2016). Illustrations for Dante’s Inferno: A Comparative Study of Sandro Botticelli, Giovanni Stradano, and Federico Zuccaro. Cultural and Religious Studies, 4(8), 487.

Verdicchio, M. (2015). Irony and Desire in Dante’s” Inferno” 27. Italica, 285-297.

This question has been answered.

Get Answer