Question

In: Finance

In this assignment, you will use a simple version of a portfolio where your money is...

In this assignment, you will use a simple version of a portfolio where your money is distributed across three categories: stocks, bonds, and cash. Refer to this module’s readings to review historical return values.

Category

Average Annual Return

Stocks

6.0%

Bonds

2.1%

Cash

1.0%

Your portfolio will be diversified across these three different types of investments. The amount that you decide to put into each will greatly depend upon what stage of life you are in. If you are young and just starting out in your career, you may want to have a high-risk portfolio with the hope of high returns in the distant future. However, if you are near the end of your career, you may want to choose a less risky portfolio.

Create your own portfolio that addresses the following:

After retirement, how much will you like to have annually in order to maintain the standard of living that you expect to have?

How much annually do you plan to set aside for your retirement plan?

How much of this annual contribution will you want to invest in each of the investment categories?

How many years will you work from now until you retire?

Click here to download the retirement Excel spreadsheet you will need for this assignment.

Put the values that you decided on above into the retirement spreadsheet.

Respond to the following

What is your retirement goal? Can you realistically reach the goal that you have set? How long will it take to achieve this retirement goal?

How much money will you need to save in order to achieve your retirement goal?

This assignment assumes that the interest rates will remain constant for the entire life of the retirement plan. Is this a realistic situation?

Are you planning to have a high-risk or a low-risk portfolio? Explain.

What other factors related to contributing to the typical retirement plan must you consider when managing your portfolio?

What impact will inflation have on your calculations?

Years Until Retirement
Retirement Amount Goal
Total Future Value of Retirement Account
Difference
Amount Invested Monthly Annual investment Future Value
Stocks 6%
Bonds 2.10%
Cash 1%

Solutions

Expert Solution

Current age(year) 35 Retirement Age(year) 60
Years Until Retirement 25 Inflation rate (expection) 2%
Life expectency (post retirement) 30 years
Current annual cost for standard of living $12,000
future annual cost for standard of living $19,687 Rate of annuity on retirement fund (assumed) 4%
Required retirement Fund ( by present value of Annuity) $340,428
Annual Investment towards Retirement Corpus $6,500
Future Value
Asset Expected Return Portion of Investment Annual investment Total Principal Total Interest Total Amount
Stocks 6% 70% $4,550 $113,750 $150,862 $264,612
Bonds 2.10% 25% $1,625 $40,625 $13,201 $53,826
Cash 1% 5% $325 $8,125 $1,146 $9,271
Total Corpus $327,709

Short fall of fund = $12,719

Response :

What is your retirement goal? Can you realistically reach the goal that you have set? How long will it take to achieve this retirement goal?

Answer : Retirement goal is to create corpus to maintain the  standard of living. I have 25 years to achieve decided goal.

How much money will you need to save in order to achieve your retirement goal?

Answer : The annual saving should be more than $ 6600

This assignment assumes that the interest rates will remain constant for the entire life of the retirement plan. Is this a realistic situation?

Answer : the interest rates can not be remain constant for the entire life of the retirement plan in the real life situation.

Are you planning to have a high-risk or a low-risk portfolio? Explain.

Answer : At my current age , i would like to invest more than 70% of my total invesment in the risky portfolio

What other factors related to contributing to the typical retirement plan must you consider when managing your portfolio?

Answer : The inflation factor is one the most important factors to be consider

What impact will inflation have on your calculations?

Answer : The inflation rate helps in to decide the amount required to maintain the  cost for standard of living in future after retirement time.


Related Solutions

You put half of your money in a stock portfolio that has an expected return of...
You put half of your money in a stock portfolio that has an expected return of 14% and a standard deviation of 23%. You put the rest of your money in a risky bond portfolio that has an expected return of 6% and a standard deviation of 11.3%. The stock and bond portfolios have a correlation of 0.42. What is the standard deviation of the resulting portfolio?
You put 60% of your money in a stock portfolio that has an expected return of...
You put 60% of your money in a stock portfolio that has an expected return of 14% and a standard deviation of 26%. You put the rest of your money in a risky bond portfolio that has an expected return of 6% and a standard deviation of 11%. The stock and bond portfolios have a correlation of 0.36. The standard deviation of the resulting portfolio is  %. Please enter your answer with TWO decimal points.
You put 70% of your money in a stock portfolio that has an expected return of...
You put 70% of your money in a stock portfolio that has an expected return of 14.75% and a standard deviation of 28%. You put the rest of you money in a risky bond portfolio that has an expected return of 4.25% and a standard deviation of 15%. The stock and bond portfolio have a correlation 0.35. a. Assume the risk–free rate is 2.00%. What is the stock weight in the tangency portfolio formed by creating the optimal risky portfolio...
You invest your money in a portfolio that consists of 70% of Fund X and 30%...
You invest your money in a portfolio that consists of 70% of Fund X and 30% of Fund B. The annual return for X is 10% and the standard deviation is 15%. The annual return for Y is 9% and the standard deviation is 19%. The correlation between X and Y is 0.60. a. Compute the return and standard deviation of your portfolio invested? b. Assuming you hold this portfolio for over 20 years, what is the probability of return...
Suppose that you have built a simple portfolio based on allocating 70% of your funds in...
Suppose that you have built a simple portfolio based on allocating 70% of your funds in a mix of S&P 500 index shares and the remaining 30% of your funds in a mix of utility sector shares. If we denote the monthly return for S&P 500 index by X and the monthly return for utility index by Y , then the portfolio monthly return variable will be R = 0.7X + 0.3Y. (a) Knowing that ??= 0.298%, ??= 0.675%, ??=...
For this assignment, you will create a command-line version of the game ​Hangman. You should work...
For this assignment, you will create a command-line version of the game ​Hangman. You should work in a group of two on the project and not view Hangman code of other students or found on-line. Submit this project-- your .java file-- here on Canvas. For this assignment you will research on StringBuilder Class (​Use this link​) and use it in your code. Functional requirements (rubric) ● Your game should have a list of at least ten phrases of your choosing...
You are playing a version of the roulette game, where the pockets are from 0 to...
You are playing a version of the roulette game, where the pockets are from 0 to 10 and even numbers are red and odd numbers are black (0 is green). You spin 3 times and add up the values you see. What is the probability that you get a total of 15 given on the first spin you spin a 2? What about a 3? Solve by simulation and analytically.
You are to use your code from part A of this assignment and add to it....
You are to use your code from part A of this assignment and add to it. In this part of the project, you are to do the following: 1. In the count_voters function you are to add code to: • Count the number of votes for Trump • Count the number of votes for Biden • Count the number of females • Count the number of males • Count the number of Democrats • Count the number of Republicans •...
You decide to play a simplified version of blackjack where you are dealt two cards from...
You decide to play a simplified version of blackjack where you are dealt two cards from a well-shuffled deck of 52 cards. One of the cards is dealt face down and one of the cards is face up. Assume that all of the cards count for their face value (e.g., a 3 of hearts = 3), face cards (J, Q, K) count as 10, and aces [always] count for 11^(1) The value of a player’s hand is determined by the...
Your assignment is to develop an investment portfolio of common stocks and mutual funds for a...
Your assignment is to develop an investment portfolio of common stocks and mutual funds for a person of your age (32) and current life situation(unemployed student) You are required to select 5 individual stocks and 5 mutual funds. You must justify your selections by doing some research and indicating why you chose the stocks and mutual funds in your portfolio. You will need to put a hypothetical $10,000 into each stock and each mutual fund. You will be tracking the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT