Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It has to be done in excel, Choose 3 different funds (10 different assets per fund) to prepare 3 portfolios for 3 different types of

It has to be done in excel,

Choose 3 different funds (10 different assets per fund) to prepare 3 portfolios for 3 different types of investors: i. Aggressive ii. Moderate iii. Conservative

In half a page for each portfolio, explain:

i. The rationale behind choosing the given funds per each portfolio

ii. The criteria chosen to build each portfolio

iii. The total amount to invest in each portfolio is 1.000.000.

Follow up the prices for all 3 portfolios for a week. Calculate the return for each portfolio at the end of the week.

Explain your results and show them graphically.

Compare in the same graph the development of the three portfolios you have chosen and the development in the same period of the S&P500 index.

Explain your conclusions.

Explain how much is your return in this period, and compare it to an investment in the S&P 500 index.

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

Finance for Non Financial Managers

Authors: Pierre Bergeron

7th edition

176530835, 978-0176530839

More Books

Students also viewed these Finance questions