A recently hired chief executive officer wants to reduce future production costs to improve the company's earnings, thereby increasing the value of the company's stock. The plan is to invest $76,000 now and $58,000 in each of the next 6 years to improve productivity. By how much must annual costs decrease in years 7 through 12 to recover the investment plus a return of 13% per year? The annual cost decreases by $....

A recently hired chief executive officer wants to reduce future production costs to improve the company's earnings, thereby increasing the value of the company's stock. The plan is to invest $76,000 now and $58,000 in each of the next 6 years to improve productivity. By how much must annual costs decrease in years 7 through 12 to recover the investment plus a return of 13% per year? The annual cost decreases by $....

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 36P

See similar textbooks

Similar questions

Suppose you are going to receive $20,000 per year forfive years. The appropriate interest rate is 7 percent.a. What is the present value of the payments if they are in the form of an ordinaryannuity? What is the present value if the payments are an annuity due?b. Suppose you plan to invest the payments for five years. What is the future valueif the payments are an ordinary annuity? What if the payments are an annuitydue?c. Which has the highest present value, the ordinary annuity or annuity due? Whichhas the highest future value? Will this always be true?
If a company’s Board of Directors wants its management to maximize shareholder wealth, should the CEO’s compensation be set as a fixed dollar amount, or should the compensation depend on how well the firm performs? If it is to be based on performance, how should performance be measured? Would it be easier to measure performance by the growth rate in reported profits or the growth rate in the stock’s value? Which would be the better performance measure? Why?
You currently own 600 shares of JKL, Inc. JKL is an all-equity firm that has 75,000 shares of stock outstanding at a market price of $40 a share. The company’s earnings before interest and taxes are $140,000. JKL has decided to issue $1 million of debt at 8 percent interest. This debt will be used to repurchase shares of stock. If the cost of equity is 25%, the WACC is 16% and cost of debt is 10%, what will be the implied D/E ratio?
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
1. Suppose you are going on a weekend trip to a city that is d miles away. Develop a model that determines your round-trip gasoline costs. What assumptions or approximations are necessary to treat this model as a deterministic model? Are these assumptions or approximations acceptable to you? 2. Suppose that a manager has a choice between the following two mathematical models of a given situation: (a)a relatively simple model that is a reasonable approximation of the real situation, and (b)a thorough and complex model that is the most accurate mathematical representation of the real situation possible. Why might the model described in part (a) be preferred by the manager?
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
A person sells and installs A, B and C. The table shows, for example, that it takes 3 hours to sell a unit of B, it takes 4 hours to install it, and net profit per unit is $ 40. Product No. of Units Selling Hours per Unit Installation Hours per Unit Profit per Unit A x 1 1 $10 B y 3 4 40 C z 2 1 10 During a 38-hour week, the person allots no more than 18 hours to selling and no more than 20 hours to installation. Find the combination of number of units of A, B, C that would yield maximum profit.
Chris LeBlanc estimates that if he does five hours of research using datathat will cost $175, there is a good chance that he can improve hisexpected return on a $10,000, one-year investment from 6% to 9%. Chrisfeels that he must earn at least $30 per hour on the time he devotes to hisresearch.a. Find the cost of Chris’s research.b. By how much (in dollars) will Chris’s return increase as a result ofthe research?c. On a strict economic basis, should Chris perform the proposed reserach?
Answer the following questions. Make sure to number your answers when you upload your response. Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets? Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain. Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies. If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week? If the price of a pie is $12, what is the maximum number of pies she could buy in a…
BADLY NEED YOUR HELP PLEASE. 1.) True or false? Briefly explain. _____ Your firm has the opportunity to invest $20 million in a new project. The interest rate on the firm’s debt is 7% and the cost of equity is 14%. The cost of capital for the project depends on whether the firm finances the project with new debt or new equity. _____ You are thinking about investing in either stock A or stock B. Both stocks have an expected return of 12%, but stock A has a standard deviation of 25% annually and stock B has a standard deviation of 35% annually. You should invest in stock A since it is less risky. _____ Your firm currently has a debt-to-equity ratio of 10%: debt = $50 million and equity = $500 million (market values). The interest rate on the firm’s debt (rD) is 8% and the cost of equity (rE) is 13%. Since the cost of debt rD is lower than the cost of equity rE, the firm can lower its overall cost of capital by borrowing more. Ignore taxes.
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
If Amazon's board of directors wants management to maximize shareholder wealth, should the CEO's compensation be set as a fixed dollar amount, or should the compensation depend on how well the firm performs? If it is to be based on performance, how should performance be measured? Would it be easier to measure performance by the growth rate in reported profits or the growth rate in the stock's intrinsic value? Which would be the better performance measure? Why?