User Account

All Pages

What is the probability that frank will have

Assignment Help Finance Basics
Reference no: EM132179155

Problem - How much will an employee's portfolio be worth after working for the company 30 years more? The Human Resource department at EcoCarnifex Corporation was asked to develop a financial planning model that would help employees address this question. Frank Joseph was asked to lead this effort, and he has decided to begin developing a financial plan for himself first. Frank has a degree in business and at the age of 30 in 2017. At the beginning of 2017, he is making the annual salary $35,000 and has accumulated a portfolio valued at $16,000.

Frank made the following assumptions:

a) 5% annual salary growth at the end of each year is reasonable.

b) He plans to contribute 5% of his monthly salary throughout each year.

c) 10% annual portfolio growth seems reasonable.

(1) Develop an Excel worksheet that calculates and shows the value at the end of each year of Frank's portfolio after he will work for the company 35 years more (i.e., at the end of 2051).

(2) If Frank plans to work for the company 30 years more instead and hopes to accumulate a portfolio valued at $1,000,000 for his retirement by the end of 2046. Can he do it? Why or why not. Please explain in detail. If not, what he should do?

Frank has presented his findings based upon the above assumptions to his boss, but his boss does not agree with it. Instead his boss made the following assumptions.

a) The annual salary growth should not be constant. It should vary from 0 to 9% following a uniform probability distribution.

b) The annual portfolio growth rate should be approximated by a normal probability distribution with a mean of 7% and a standard deviation of 5%.

(3) Develop an Excel worksheet with this new information and then use @Risk to perform this simulation (using 800 iterations) that calculates and shows the value at the end of each year of Frank's portfolio after he will work for the company 35 years more (i.e., at the end of 2051).

(4) Based on (3), can Frank accumulate a portfolio valued at $1,100,000 for his retirement by the end of 2046? Why or why not. Please explain in detail.

(5) Attach the simulation graph result at the end of 35 years more as an output.

(6) Based upon the graph result, what is the probability that Frank will have at least $900,000 of his portfolio value for his retirement at the end of 2051?

Reference no: EM132179155

Questions Cloud

Principles are beliefs that are universal in nature : Principles are beliefs that are universal in nature. What does that mean (in your own words not from the book or a source).
Why you have applied or expressed interest : We would like to know more about your interest in NYU. We are particularly interested in knowing what motivated you to apply to NYU and more specifically.
Which type of advertising gives you : Which type of advertising gives you the "biggest bang for your buck?"
Explain the events that cause her to stay in the marriage : For example, what kind of parent or wife will the mother in "Fiesta, 1980" be like in the future. Explain the events that cause her to stay in the marriage.
What is the probability that frank will have : Based upon the graph result, what is the probability that Frank will have at least $900,000 of his portfolio value for his retirement at the end of 2051
Why do you think that brand need to change its logo : Why do you think that brand need to change its logo? Is this change evolution or revolution from the company wise?
Identify the activities that make up the critical path : Determine the critical path and identify the activities that make up the critical path.
Have you hear about the phenomenon of amazonization : Have you hear about the phenomenon of "amazonization"? How do you feel about it?
What are some of restrictions on each protection : What are these protections? Since none of these protections are absolute, what are some of the restrictions on each protection?

Reviews

len2179155

11/28/2018 12:44:18 AM

Note that Part 1 and Part 3 solutions must be separated. Note: Each problem should be on a separate worksheet and the entire exam should be in one workbook. All the exam solutions must be typed and solved by the Excel and the DecisionSuite Tool. No handwritten and hand-drawn submissions are allowed. All the branches of the tree nodes, including decision nodes and chance nodes, must be labelled clearly.

Write a Review

Finance Basics Questions & Answers

  Patient you are treating does not have a strong

The patient you are treating does not have a strong science background; explain to them (using complete sentences) how stimulation of skeletal muscle.

  Calculate and interpret the volume and price variances

Calculate and interpret the volume and price variances on the revenue side.

  Business to influence certain factors

However, is it possible for a business to influence certain factors to build a favorable environment for itself? If so, which factors could be influenced

  Given the potential conflict of interest between security

given the potential conflict of interest between security analysts and investment bankers working for the same firm

  What would ending inventory have been at year 9 and year 8

excerpts from the annual report of lands end follow in thousandsnbspyear 9year 8inventory219686241154cost of

  Sanders prime time company has annual credit sales of

sanders prime time company has annual credit sales of 1800000 and accounts receivables of 210000. compute the value of

  Citigroup is currently audited by kpmg who pays kpmg for

citigroup is currently audited by kpmg. who pays kpmg for its audit of citigroup? to whom is kpmg providing assurance

  Why does an annuity due always have a higher future value

why does an annuity due always have a higher future value than an ordinary annuity?would you prefer to receive an

  Balance over the life of the loan

Create an amortization schedule, and graph the components over time: interest, principal, and balance. Discuss the distributions of principal, interest, and the balance over the life of the loan.

  Compute the expected rate of return for a stock

What is the expected rate of return for a stock that is expected to pay $1 dividend next year and is currently selling for $10.

  What is the firm payables deferral period

ABC, Inc. has been experiencing cash shortages due to its high growth rate. Using the following information, what is the firm's Payables Deferral Period?

  What would the cash flow diagram look like

If an alternative has monthly payments of $10,000 a month for three years with a purchase price of $75,000 at the end of year three, what would the cash flow diagram look like? Select the correct choice from each pair of answers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd