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 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Mr. Johnnie B. Good has a furniture business which he operates as a sole proprietor. The business has been doing well for several years and now he wants to finance the expansion of his business by way of a loan and he is thinking of approaching BCN Bank accordingly. He is also planning to buy a great deal of raw material on credit from Miller’s Hardware in support of the business expansion. Mr. Good in looking at the potential risks to his personal assets and in an effort to safeguard himself from losing his personal assets if the business failed and was not able to repay the loan or pay for the material he got on credit, filed the relevant documents with the companies office and incorporated a private company, Good Furniture Ltd, with him as the sole shareholder and director and then went ahead and obtained a loan in the company’s name from the bank and bought the raw material on credit on behalf of the company. The bank in providing the loan ensured that Mr. Good signed a personal…
John Johnson, one of your classmates, is preepairing to launch an e-commerce company to sell home repair guidebooks, tools and other related material for home repairs. He has just told you that he talked to his grandmother over the weekend and she has greed to lendd her 25000 thousand euros to launch the company. When you askedJohn what arrangements he has made with his grandmother to formalize the loan, he looked puzzled and said "She plans to send me a check in a week or so, she just needs to get them out of her savings account". Do you agree/disagree with John's actions? What would you advise him to do?
Discuss the Three main concepts of the time value of money : (1)The future value of the dollar. (2)The future value of an annuity. (3)The present value of an annuity, and give example of each of them,Thank you
Lorna owns a home that is worth $385,000. She has a mortgage with a balance of $112,000. Calculate her equity in the home. $497,000 $76,000 $273,000 $245,000
Which of the following refers to the rate that bond investors expect to get for investing in a bond?
In the prospectus for the Brazos Aggressive Growth fund, the fee table indicates that the fund has a 12b-1 fee of 0.35 percent and an expense ratio of 1.55 percent that is collected once a year on December 1. Joan and Don Norwood have shares valued at $114,500 on December 1. What is the amount of the 12b-1 fee this year? What is the amount they will pay for expenses this year?
Eight years ago, Burt Brownlee purchased a government bond that pays 3.60 percent interest. The face value of the bond was $1,000. What is the dollar amount of annual interest that Burt received from his bond investment each year? Assuming that comparable bonds are now paying 2.40 percent, will Burt's bond increase or decrease in value? Why did the bond increase or decrease in value?
The Free Cash Flow model has the following advantage over the Dividend Growth model: In the case of variable growth, it does not require the calculation of any horizon value. It can be applied even if growth rates are unknown. It can be applied to companies with variable growth in the initial years that eventually settle down to a fixed rate of growth for the long term. It can be applied to divisions of companies. O It does not require any forecasting.
Mary is trying to qualify for a home loan but her lender tells her that her debt-to-income ratio is too high for FHA standards. What can Mary do to qualify for an FHA loan? О Transfer some of her existing debt to one or more credit cards. О Take out an equity line of credit to pay for the down payment. О Pay off one or more of her existing loans, such as a car loan or credit card debt. Decrease her credit score.
Assume that one year ago, you bought 240 shares of a mutual fund for $24 per share and that you received an income dividend of $0.31 cents per share and a capital gain distribution of $1.04 per share during the past 12 months. Also assume the market value of the fund is now $26.50 a share. Calculate the total return for this investment if you were to sell it now.
Nippon Steel's expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $45,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 11% per year? The equivalent annual worth is determined to be $
Assume that you recently graduated and have just reported to work as an investment advisor at the brokerage firm of Balik and Kiefer Inc. One of the firm’s clients is Michelle DellaTorre, a professional tennis player who has just come to the United States from Chile. DellaTorre is a highly ranked tennis player who would like to start a company to produce and market apparel she designs. She also expects to invest substantial amounts of money through Balik and Kiefer. DellaTorre is very bright, and she would like to understand in general terms what will happen to her money. Your boss has developed the following set of questions you must answer to explain the U.S. financial system to DellaTorre. Why is corporate finance important to all managers? Describe the organizational forms a company might have as it evolves from a start-up to a major corporation. List the advantages and disadvantages of each form.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS