Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 13-15 Algo (Using Excel) Peter has $30,000 to invest in a mutual fund whose annual returns are normally distributed with a mean of 5.97%

image text in transcribed

Exercise 13-15 Algo (Using Excel) Peter has $30,000 to invest in a mutual fund whose annual returns are normally distributed with a mean of 5.97% and standard deviation of 4.85%. a. Use Excel's Analysis ToolPak, with a seed of 1, to simulate 5,000 trials to estimate the mean balance after one year. (Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places.) Average balance after one year 1.780.18 X b. What is the probability of a balance of $31,300 or more? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probability of having a balance of $31,300 or more 10.92 X % c. Compared to another investment option at a fixed annual return of 3% per year, what is the probability of getting at least the same balance from the mutual fund after one year? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probability of getting the same balance from the mutual fund after one year 1.00 % Exercise 13-15 Algo (Using Excel) Peter has $30,000 to invest in a mutual fund whose annual returns are normally distributed with a mean of 5.97% and standard deviation of 4.85%. a. Use Excel's Analysis ToolPak, with a seed of 1, to simulate 5,000 trials to estimate the mean balance after one year. (Round intermediate calculations to at least 4 decimal places and your final answer to 2 decimal places.) Average balance after one year 1.780.18 X b. What is the probability of a balance of $31,300 or more? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probability of having a balance of $31,300 or more 10.92 X % c. Compared to another investment option at a fixed annual return of 3% per year, what is the probability of getting at least the same balance from the mutual fund after one year? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probability of getting the same balance from the mutual fund after one year 1.00 %

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_2

Step: 3

blur-text-image_3

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

Financial And Managerial Accounting

Authors: Nonso E Okpala

1st Edition

1634873904, 9781634873901

More Books

Students also viewed these Finance questions

Question

=+5. How would you rewrite the copy to make it more effective?

Answered: 1 week ago