Suppose Jane Dough plans to work another 30 years, and she's interested in how much money...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose Jane Dough plans to work another 30 years, and she's interested in how much money she'll have amassed in her IRA plan when she retires. Assume • Jane currently makes $100,000 per year, and 5% of her income goes into her IRA, and her employer matches her contribution dollar for dollar • Jane gets salary raises of 3% a year • Stock market returns are normally distributed (in the future) • All of Jane's money goes into an S&P 500 fund with negligible annual management fees The mean stock market return in the future is 11.6% and the standard deviation is 16.9% (this matches historical returns, with all dividends reinvested, for the S&P 500 since it was created in 1957 until 2019) No annual caps limit contributions during Jane's 30-year horizon • Assume that current year contributions get % of the market return for that year! Build a "flexible" simulation model that allows you to change any of the input parameters above (salary, contribution %, employer match %, raise %, mean and standard deviation of future returns) to examine potential "what if" scenarios. Then answer a few questions for Jane. a) What is the probability she has more than one million dollars in her IRA? b) What is the average amount she is expected to have on her IRA? 2. Orko's Kopy Orko's Kopy has two service contract options for its photocopy machines: Option A: Pay $1,000 for each failure (repair visit) Option B: Pre-pay $1,500 for the first three failures (no refund) and pay $200 for each additional failure Which option should Orko's Kopy pick to minimize its maintenance cost per machine? The relative frequency for the number of times a Xerox photocopy machine fails per year is: ¹If contributions are made monthly, the average amount of "new money" invested for a whole year is roughly % of the full year's contribution. This means the annual contribution gets approximately % of the annual market return. Number of Failures Relative Frequency 0 22% 1 30% 2 25% 13% 9% 1% 3 4 5 3. Bank Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a normal distribution with means and standard deviation summarized as follows (in $1,000s): Mon Tue Wed Thu Fri Sat Sun Mean 175 120 90 60 120 140 65 St. Deviation 26 18 13 9 18 21 9 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any day of the week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. And keeping excessive cash reserves would guard against this happenstance. However, cash is a non-interest earning asset, so there is an opportunity cost for holding excess cash reserves. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $825,000. Create a spreadsheet model to track the daily cash balance throughout the week. 1) What is the probability that the bank will run out of money at some point during the week? 2) What amount of money is needed at the start at the each week to ensure there is at most a 0.10% chance of running out of money? Suppose Jane Dough plans to work another 30 years, and she's interested in how much money she'll have amassed in her IRA plan when she retires. Assume • Jane currently makes $100,000 per year, and 5% of her income goes into her IRA, and her employer matches her contribution dollar for dollar • Jane gets salary raises of 3% a year • Stock market returns are normally distributed (in the future) • All of Jane's money goes into an S&P 500 fund with negligible annual management fees The mean stock market return in the future is 11.6% and the standard deviation is 16.9% (this matches historical returns, with all dividends reinvested, for the S&P 500 since it was created in 1957 until 2019) No annual caps limit contributions during Jane's 30-year horizon • Assume that current year contributions get % of the market return for that year! Build a "flexible" simulation model that allows you to change any of the input parameters above (salary, contribution %, employer match %, raise %, mean and standard deviation of future returns) to examine potential "what if" scenarios. Then answer a few questions for Jane. a) What is the probability she has more than one million dollars in her IRA? b) What is the average amount she is expected to have on her IRA? 2. Orko's Kopy Orko's Kopy has two service contract options for its photocopy machines: Option A: Pay $1,000 for each failure (repair visit) Option B: Pre-pay $1,500 for the first three failures (no refund) and pay $200 for each additional failure Which option should Orko's Kopy pick to minimize its maintenance cost per machine? The relative frequency for the number of times a Xerox photocopy machine fails per year is: ¹If contributions are made monthly, the average amount of "new money" invested for a whole year is roughly % of the full year's contribution. This means the annual contribution gets approximately % of the annual market return. Number of Failures Relative Frequency 0 22% 1 30% 2 25% 13% 9% 1% 3 4 5 3. Bank Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a normal distribution with means and standard deviation summarized as follows (in $1,000s): Mon Tue Wed Thu Fri Sat Sun Mean 175 120 90 60 120 140 65 St. Deviation 26 18 13 9 18 21 9 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any day of the week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. And keeping excessive cash reserves would guard against this happenstance. However, cash is a non-interest earning asset, so there is an opportunity cost for holding excess cash reserves. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $825,000. Create a spreadsheet model to track the daily cash balance throughout the week. 1) What is the probability that the bank will run out of money at some point during the week? 2) What amount of money is needed at the start at the each week to ensure there is at most a 0.10% chance of running out of money?
Expert Answer:
Answer rating: 100% (QA)
1 a The probability that Jane has more than one million dollars in her IRA is approximately 095 b The average amount Jane is expected to have in her I... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Assume that monthly returns are normally distributed with a mean of 1 percent and a sample standard deviation of 4 percent. The population standard deviation is unknown. Construct a 95 percent...
-
Assume X is normally distributed with a mean of 5 and a standard deviation of 4. Determine the following: (a) P(X < 11) (b) P(X > 0) (c) P(3 < X < 7) (d) P(-2 < X < 9) (e) P(-2 < X < 8)
-
Assume that historical returns and future returns are independently and identically distributed and drawn from the same distribution. a. Calculate the 95% confidence intervals for the expected annual...
-
The English publisher of a book called Cambridge gave a New York publisher permission to sell that book any place in the world except in England. The New York publisher made several bulk sales of the...
-
1. Prepare a service blueprint for Commuter Cleaning. 2. What generic approach to service system design is illustrated by Commuter Cleaning, and what competitive advantages does this design offer? 3....
-
A total of 300-observations of Bob Ramos, an assembly-line worker, were made over a 40-hour work week. The sample also showed that Bob was busy working (assembling the parts) during 250 observations....
-
Nuts and Cholesterol Several studies have been performed to examine the relationship between nut consumption and cholesterol levels. Here we consider two such studies. In Study 1, participants were...
-
Mr. LN. Vestor is retired and slowly selling some of his assets to supplement his retirement income. He wants to have some idea of how much tax he is going to owe for 2020 on the asset sales that...
-
The expected yield on a 2 year security is 7.8%. If the yield on a t-bill maturing in 1 year is 7.2%, what is the yield on a 1 year t-bill maturing 1 year from now?
-
Can establishing a multinational corporation or a joint venture serve the principles of social entrepreneurship? Would some options lend themselves better to social entrepreneurship than others? What...
-
I believe customer service skills are important for me to have as an administrative professional for the following reasons, and here is how I can demonstrate this importance to customers. discussions
-
Evaluate the way how different generations are using technology. Between the old and new generation ? Phone usage computer usage TV usage
-
Kingsgrove Ltd sells 1,000 tonnes of soil each year and demand is constant over time. The purchase cost of each tonne is $1 and the cost of placing and handling an order is estimated to be $5. The...
-
Leverage is a way of looking at how a firm balances its capital. One example is a debt to equity ratio which puts debt in the numerator and equity in the denominator to see how highly "leveraged" a...
-
Using the website www.sec.gov. and the most recent 10K SEC filings made by Dell Computer( DELL), and looking at the balance sheet, what is the book value of debt and the book value of equity. Is this...
-
Shi Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $27,000 in free cash. The following debts, totaling $47,050, remain: Government...
-
Consider the trigonometric series a0 2 + X r=1 (ar cos rx + br sin rx) where a0, a1, a2, . . . and b1, b2, . . . are constants and suppose that f(x) is a periodic function of x with period 2. (a)...
-
Test whether the 5-year survival rate for breast cancer is significantly different between African American and Caucasian women who are younger than 50 years of age and have localized disease....
-
The current market interest rate on U-Store City Investment Building bonds is $10 \%$, compounded semiannually. The original bonds are sold as $\$ 1,000,12 \%$ interest rate notes. A batch of bonds...
-
An investor purchased $\$ 20,000$ of U.S. Treasury bonds at face value. These bonds have a 25 -year maturity period, and they pay $1.25 \%$ interest every three months. Unfortunately, interest rates...
-
A new high-definition television costing $\$ 2,999$ is on a rent-to-own plan and is to be paid in 18 end-of-month payments (starting one month from now). The monthly payments are determined as...
Study smarter with the SolutionInn App