Chat with us, powered by LiveChat How much will your portfolio be worth in 10 years? - Writemia

How much will your portfolio be worth in 10 years?

How much will your portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resource department at EcoCarnifex Corporation was asked to develop a financial planning model that would help employees address these questions. Frank Joseph was asked to lead this effort and decided to begin by developing a financial plan for himself. Frank has a degree in business and at the age of 25, is making $34,000 per year. After 2 years of contribution to the company retirement plan and receiving a small inheritance, Frank has accumulated a portfolio valued at $14,500. Frank plans to work for 30 more years and hopes to accumulate a portfolio valued at $1,000,000. Can he do it?Assumptions:1. 5% salary growth is reasonable.2. He plans to contribute 4% of his salary.3. 10% annual portfolio growth seems reasonable.4. Contributions occur monthly throughout the year.Develop an Excel worksheet and calculate the value at the end of 5 years.Frank projected he could save around $691,500 after 30 more years of service. What would Frank’s alternatives be if he wants to make $1,000,000? Frank showed this to his boss who made the following observations.1. Salary growth should not be constant. Should vary from 0 to 10 percent with a uniform probability distribution.2. Annual portfolio growth rate should be approximated by a normal probability distribution with a mean of 10% and a standard deviation of 5%Develop an Excel worksheet with this new information.Frank is willing to work 5 more years. What is the result of that decision?Use @Risk to perform these simulations.

Do you need an answer to this or any other questions?

About Writemia

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order