Peter has $30,000 to invest in a mutual fund whose annuai returns are normally distributed with a mean of 5.93% and standard deviation of 3.55%. a. Use Excel's Analysis ToolPak, with a seed of 1, to simulare 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.) Avorage balance ater one yoar b. What is the probability of a balance of $32.700 or more? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probubity of having a balance of 532.700 or more

Peter has $30,000 to invest in a mutual fund whose annuai returns are normally distributed with a mean of 5.93% and standard deviation of 3.55%. a. Use Excel's Analysis ToolPak, with a seed of 1, to simulare 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.) Avorage balance ater one yoar b. What is the probability of a balance of $32.700 or more? (Round intermediate calculations to at least 4 decimal places and show your final answer as a percentage point with 2 decimal places.) Probubity of having a balance of 532.700 or more

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter2: Descriptive Statistics

Section: Chapter Questions

Problem 17P: Suppose that you initially invested 10,000 in the Stivers mutual fund and 5,000 in the Trippi mutual...

See similar textbooks

Similar questions

G. Each column in the table below is labeled, complete the table by writing the given data (in figures), the word “unknown" for the unknown data, n/a if it is not applicable in the problem. 8. If you start investing Php 50,000 now in a trust fund that pays 8% compounded semi-annually, how much money will you have in 10 years? P A 9. How much must be invested today at 8.5% compounded quarterly to have Php3,000,000 in 30 years? P I n AMW PRC 10. Find the present value of Php 150,000, due at the end of 2 years, if money is worth 9% compounded annually. A
Model each investment as an equation, and then arrange the investments in ascending order (from least to greatest value) based on their values after three years. Put from least to greatest in value after three years.$2,100 in a money market account that yields 12% per year$2,800 in a term CD that yields interest of 4% per year$2,520 in a savings account that yields interest of 5% per year
a. If Daniella opens a mutual fund account with a deposit of $15,000 and it promises to pay an annual interest rate of r%, compounded on a monthly Derive a function B, which shows the balance on Daniella′s account the end of 6 Make a comparison of the rates of change in B with respect to the interest rate when r is 8% , 10% and 12%. b. A virus is believed to be spreading through a sheep farm according to that equation N = 450 ( 1 ) 1 + 249e−0.1t where N is the number of sheep infected and t is the number of days. How many sheep are infected at t = 0? Using a spreadsheet calculate the number of sheep infected after 0, 10, 30, 50, 70, 100 days) Will all the sheep become infected eventually? Give reasons to support your answer
solve You are on employee that earn Php. 20,000 per month. Assuming that you want to invest half of the amount to be invested at the end of each month in a mutual fund that would grow at a rate of 6% for five years. How much would be the future value of the investment.
An investor puts $2,000 into a deposit account with a fixed rate of return of 10% per year. A second sum of $1,000 is invested in a fund with an expected rate of return of 16% and a standard deviation of 8% per year. a. Find the expected value of the total amount of money this investor will have after a year. b. Find the standard deviation of the total amount after a year.
Use the five-step strategy for solving word problems: You invested $9000 in two funds paying 4% and 7% annual interest. At the end of the year, the total interest from these investments was $555. How much was invested at each rate?
Suppose that you initially invested 10,000 in the Stivers mutual fund and 5,000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table: Which of the two mutual funds performed better over this time period?
A financial adviser is reviewing one of her client's accounts. The client has been investing $1,000 at the end of every quarter for the past Il years in a fund that has averaged 7.3% compounded quarterly. How much money does the client have in his account? Construct a cash flow diagram and use a formula.
John began his investing program with a $5,500 initial investment. The table below recaps his returns each year as well as the amounts he added to his investment account. What is his dollar-weighted average return? Time 0 1 2 3 4 A) 1.5 percent B) 2.2 percent C) 2.0 percent D) 1.8 percent E) 2.6 percent Investment $ 5,500 $ 2,000 $ 2,600 $ 3,000 $ 900 Return 8.5 % 5.0 % 4.5% 9.0 % 2.5%
You are evaluating five different investments, all of which involve an upfront outlay of cash. Each investment will provide a single cash payment back to you in the future. Details of each investment appears here:. Calculate the IRR of each investment. State your answer to the nearest basis point (i.e., the nearest 1/100th of 1%, such as 3.76%). The yield for investment A is %. (Round to two decimal places.) Initial Future Investment Investment Value Im A $1,900 $4,029 B $9,600 $13,121 C $500 D $3,200 E $5,900 Data table $1,759 $4,139 $9,079 End of Year 11 9 18 3 12 I X
You decide to contribute to a mutual fund that averages 3.6% return per year. If you contribute $600 quarterly. Round all answers to the nearest cent as needed. a) How much will be in the account after 20 years? $ b) How much of this money did you deposit? $ c) How much of this money is interest earned? $ Submit Question Question 3
Suppose you invest $3200 in a mutual fund. Over 5 years, your investment grows in value to $8500. What is your total return? State your answer as a percentage rounded to 1 decimal place. [Only give the numerical answer. Do not enter a percentage sign (%) in the answer box] ◆ Previous hp Not saved Submit Our