Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 43P
Summary Introduction
To show: The values in the cells of the excel and relevant formulas.
Monthly payment:
It is the payment made every month for a product or a service. The monthly payment might vary for the product or service price.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A local finance company quotes a 16 percent interest rate onone-year loans. So, if you borrow $26,000, the interest for the year will be $4,160. Because you must repay a total of $30,160 in one year, the finance company requiresyou to pay $30,160y12, or $2,513.33, per month over the next 12 months. Is this a15 percent loan? What rate would legally have to be quoted? What is the effectiveannual rate?
Assume “Jane” saves $10,000 per year for 10 years starting at age 25. At age 35 she no longer is able to save but leaves her accumulated savings invested until age 65 when she retires. Assume “John” does not begin saving until age 35, but then saves $10,000 per year until age 65 when he also retires. Assume John and Jane invest their entire wealth in the same mutual fund. Who accumulates a larger retirement nest egg? 1. Answer this question by building an Excel spreadsheet that allows you to show the difference in wealth at age 65 assuming an annual rate of return of 8%. Make sure your model allows you to change the assumed rate of return and automatically recalculate the difference in wealth at age 65. 2. At what assumed rate of return are John and Jane’s wealth at age 65 equal? Use “Goal Seek” in order to find this rate of return. 3. Create a graph to clearly show how final wealth for John and Jane depends on the rate of return. Start at 0% and increase the rate of return in…
Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet)
You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars.
Chapter 2 Solutions
Practical Management Science
Ch. 2.4 - Prob. 1PCh. 2.4 - Prob. 2PCh. 2.4 - Prob. 3PCh. 2.4 - Prob. 4PCh. 2.5 - Prob. 5PCh. 2.5 - Prob. 6PCh. 2.5 - Prob. 7PCh. 2.5 - Prob. 8PCh. 2.5 - Prob. 9PCh. 2.6 - Prob. 10P
Ch. 2.6 - Prob. 11PCh. 2.6 - Prob. 12PCh. 2.6 - Prob. 13PCh. 2.7 - Prob. 14PCh. 2.7 - Prob. 15PCh. 2.7 - Prob. 16PCh. 2.7 - Prob. 17PCh. 2.7 - Prob. 18PCh. 2.7 - Prob. 19PCh. 2 - Julie James is opening a lemonade stand. She...Ch. 2 - Prob. 21PCh. 2 - Prob. 22PCh. 2 - Prob. 23PCh. 2 - Prob. 24PCh. 2 - Prob. 25PCh. 2 - The file P02_26.xlsx lists sales (in millions of...Ch. 2 - Prob. 27PCh. 2 - The file P02_28.xlsx gives the annual sales for...Ch. 2 - Prob. 29PCh. 2 - A company manufacturers a product in the United...Ch. 2 - Prob. 31PCh. 2 - Prob. 32PCh. 2 - Assume the demand for a companys drug Wozac during...Ch. 2 - Prob. 34PCh. 2 - Prob. 35PCh. 2 - Prob. 36PCh. 2 - Prob. 37PCh. 2 - Suppose you are borrowing 25,000 and making...Ch. 2 - You are thinking of starting Peaco, which will...Ch. 2 - Prob. 40PCh. 2 - The file P02_41.xlsx contains the cumulative...Ch. 2 - Prob. 42PCh. 2 - Prob. 43PCh. 2 - The IRR is the discount rate r that makes a...Ch. 2 - A project does not necessarily have a unique IRR....Ch. 2 - Prob. 46PCh. 2 - Prob. 1CCh. 2 - The eTech Company is a fairly recent entry in the...
Knowledge Booster
Similar questions
- In the cash balance model from Example 11.5, the timing is such that some receipts are delayed by one or two months, and the payments for materials and labor must be made a month in advance. Change the model so that all receipts are received immediately, and payments made this month for materials and labor are 80% of sales this month (not next month). The period of interest is again January through June. Rerun the simulation, and comment on any differences between your outputs and those from the example.arrow_forwardThe IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.arrow_forwardIn 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?arrow_forward
- Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?arrow_forwardUse excel for this problem A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem.arrow_forwardThis section contains questions regarding the 2nd part of the Unit 1 with the following topics: 1. Financial Planning2. Savings and budgeting3. Investing 1.Mutual Fund is when an investor directly acquires a claim on a security or property True False 2. The "Rule of 75" is used to determine the number of yearss needed to double the value of your money * True Falsearrow_forward
- Suppose we are borrowing $1,000 at 12% annual interestwith 60 monthly payments. Assume equal payments aremade at the end of month 1, month 2, . . . month 60. Weknow that entering into Excel the functionPMT(.01, 60, 1,000)would yield the monthly payment ($22.24).It is instructive to use LP to determine the montly payment. Let p be the (unknown) monthly payment. Each monthwe owe .01 (our current unpaid balance) in interest. Theremainder of our monthly payment is used to reduce the unpaid balance. For example, suppose we paid $30 each month.At the beginning of month 1, our unpaid balance is $1,000.Of our month 1 payment, $10 goes to interest and $20 topaying off the unpaid balance. Then we would begin month2 with an unpaid balance of $980. The trick is to use LP todetermine the monthly payment that will pay off the loan atthe end of month 60.arrow_forwardPLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?arrow_forwardDataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price change on a software product. Currently, 40,000 units of the product are sold each week for $45 apiece. The variable cost of the product is $5. The most likely case appears to be that a $10 rebate will increase sales 30%, and half of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 20%.a. Given all other assumptions, what increase in sales from the rebate would make the rebate and price cut equally desirable?b. Dataware does not really know the increase in sales that will result from a rebate or price cut. However, the company is sure that the rebate will increase sales by between 15% and 40% and that the price cut will increase sales by between 10% and 30%. Perform a sensitivity analysis (two-way data table) that could be used to help determine Dataware’s best decision.arrow_forward
- A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the total annual return (before tax). Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest as least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free. Suppose the decision variable represents the amount of money invested in bond for . Formulate a linear programming (LP) model to solve the optimal strategy. 1. Write down the constraint using the defined decision variables requiring “invest as least 50% of the money in short-term issues”. 2. Write down the constraint using the defined decision…arrow_forwardMy current income is $40,000. I believe that I owe$8,000 in taxes. For $500, I can hire a CPA to review mytax return; there is a 20% chance that she will saveme $4,000 in taxes. My utility function for (disposableincome) (current income) (taxes) (payment toaccountant) is given by x where x is disposable income.Should I hire the CPA?arrow_forwardPlease no written by hand and no emage John is an investor. His portfolio primarily tracks the standard and poor 500 (S & P 500) and John wants to add the stock of ABC corp. Before adding the stock to his portfolio, he wants to assess the directional relationship between the stock and the S & P 500. John does not want to increase the unsystematic risk of his portfolio. Thus he is not interested in owning securities in the portfolio that tends to move in the same direction. The prices obtained are summarized in the table that follows:Required: Calculate the covariance of John’s stocks. State the implication of the outcome in project management decisionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,