An investor has at most $10,000 to invest in government bonds, mutual funds, and money market funds. The average yields for the government bonds, mutual funds,and money market funds are 11%, 7%, and 14% respectively. The investor's policy requires that the total amount invested in mutual and money market funds notexceed the amount invested in government bonds. How much should be invested in each type of investment in order to maximize the return? What is the maximumreturn in the first year? SET UP on paper, then use EXCEL to solveHow much should be invested in government bonds?How much should be invested in mutual funds?How much should be invested in money market funds?What is the maximum return in the first year?

Let the amount invested in Government bonds be G, mutual funds be M and Money market funds be K. The…

Answered: An investor has at most $10,000 to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 37P

See similar textbooks

Similar questions

It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years. Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2. There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed. The cost of clinical trials is assumed to follow a triangular distribution with best case 100 million, most likely case 150 million, and worst case 250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed. If clinical trials succeed, the drug will be sold for five years, earning a profit of 6 per unit sold. If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case 1 billion, most likely case 1.5 billion, and worst case 2.5 billion. The plant cost will be depreciated on a straight-line basis during the five years of sales. Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales. During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units. Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less. Cash flows are discounted 15% per year, and the tax rate is 40%. Use simulation to model Mercks situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the projects NPV? (Hint: The way the uncertainty about the first year sales is stated suggests using the General distribution, implemented with the RISKGENERAL function. Similarly, the way the uncertainty about the annual growth rate is stated suggests using the Cumul distribution, implemented with the RISKCUMUL function. Look these functions up in @RISKs online help.)
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?
Why might a borrower prefer a fully amortizing loan over an adjustable-rate mortgage? О The monthly mortgage payment will remain constant throughout the term of the loan The principal and interest payment varies each month. The payment towards interest increases as the loan is amortized. The interest rate may increase over the term of the loan
You have your choice of two investment accounts.Investment A is a 15-year annuity that features end-of-month $1,500 paymentsand has an interest rate of 8.7 percent compounded monthly. Investment B is an8 percent continuously compounded lump-sum investment, also good for 15 years.How much money would you need to invest in B today for it to be worth as much asInvestment A 15 years from now?
Scenario Your corporation has just approved an 8-year expansion plan to grow its market share. The plan requires an influx of cash in each of the 8 years. Management wants to develop a financial plan to ensure the cash needed for the expansion will be available at the beginning of each of the 8 years. The corporation has the following investment options: Security Price per unit Return Rate (%) Years to Maturity 1 $1,200 10.255 5 2 $1,000 6.7550 6 3 $1,175 12.110 7 Savings Account 5.500 Each unit of security 1, 2, and 3 guarantees to pay $1,000 at maturity. Investments in these securities must take place only at the beginning of year 1 and will be held until maturity. Any funds not invested in securities will be invested in a savings account that pays the annual interest rates noted above. The following table summarizes the cash needs for the expansion plan for each of the 8 years: Year 1 = $250,000 Year 5 = $295,000…
Please answer along with the excel formulas - 1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53 $1,870.61 $1,964.14 $2,062.34 $2,165.46 3. Last year Rocco Corporation's sales were $225 million. If sales grow at 6% per year, how large (in millions) will they be 5 years later? $271.74 $286.05 $301.10 $316.16 $331.96
Which of the following statements describes the payment amounts over the life of an ARM? A) Payments will remain constant for the life of the loan. B) Payments may go up or down in relation to the index rate. C) Payments may go up or down in relation to the margin rate. D) Payments may go up or down in relation to the equity in the property.
All financial institutions provide different financial products and services that expose them to different types of risks that require different risk mitigating practices and techniques. These risks include; credit risk liquidity risk, interest rate risk, market risk, foreign exchange risk, solvency risks, operational risks and model risk. Which of the following is not true about credit risk? Select one: a. Performance risk is similar to credit risk. The borrower´s performance on an operation or specific project determines the degree of transaction risk. b. Measures based on the credit quality of the debt. As ratings are ordinal measures, they are sufficient to value credit risk. c. The risk of the issuers and borrowers are evaluated in prices in a capital market setting and can be seen visibly, or through credit spreads, or as add-ons to the risk-free rate. d. Credit risk is similar to country risk, which is essentially the risk crisis in a country. Examples of…
Determine a capital good (an item with a useful life in excess of 1 year) that you need to acquire for your business. How will this asset improve the efficiency or effectiveness of your business? How is the future benefit of the asset translated into the present and quantified for a profitable decision for your business? Which technique to evaluate the data best suits your business? Explain.
You have just received a business valuation report that is dated six months ago. Describe the factors that might have changed during the past six months and, therefore, caused the value of the business today to be different from the value six months ago. Which of these changes affect the expected cash flows, and which affect the discount rate that you would use in a discounted cash flow valuation of this company?
Consider two equity market investors. The first investor is a hedge fund manager that relies on very active trading, and borrows from investment banks in order to leverage their investment. Their remuneration depends on total base fee earned by their fund as a percentage of net assets under management, plus a yearly bonus based on returns generated above a hurdle rate. The second investor is a high net-worth individual who is investing for their own retirement, which they anticipate to occur in 10 years or more. Identify three dimensions of risk that are likely to have significantly different impact on thesetwo investors. Explain the nature of the difference. Suggest aspects that each investor might monitor in order to control the risks most relevant to them.
You have deposited $10,800 into an account that will earn an interest rate of 8% compounded semiannually. How much will you have in this account at the end of 10 years? $16,564.89 $27,213.75 $23,664.13 $28,396.96

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS