Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 2, Problem 38P
Suppose you are borrowing $25,000 and making monthly payments with 1% interest. Show that the monthly payments should equal $556.11. The key relationships are that for any month t
(Ending month t balance) = (Ending month t − 1 balance) − ((Monthly payment) − (Month t interest))
(Month t interest) = (Beginning month t balance) × (Monthly interest rate)
Of course, the ending month 60 balance must equal 0.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
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?
Home mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on interest rates or to make their rates appear competitive with those of other lenders. As an example, with a two-point loan, the lender would loan only $98 for each $100 borrowed. The borrower would receive only $98 but would have to make payments just as if he or she had received $100. In this way, the lender can make more money while keeping his or her interest rate lower. Suppose that you receive a loan of $260,000 payable at the end each month for 30 years with an interest rate of 9% compounded monthly, but you have been charged three points. What is the effective interest rate on this home mortgage loan?
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- 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_forwardYou are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)arrow_forwardA European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)arrow_forward
- Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?arrow_forwardIn 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_forwardRerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.arrow_forward
- Use 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_forwardSuppose savers either buy bonds or make deposits in savings accounts at banks. Initially, the interest income earned on bonds or deposits is taxed at a rate of 20%. Now suppose there is a decrease in the tax rate on interest income, from 20% to 15%. Shift the appropriate curve on the graph to reflect this change. This change in the tax treatment of saving causes the equilibrium interest rate in the market for loanable funds to (fall,rise) and the level of investment spending to (decrease,increase). An investment tax credit effectively lowers the tax bill of any firm that purchases new capital in the relevant time period. Suppose the government repeals a previously existing investment tax credit. Shift the appropriate curve on the graph to reflect this change. The repeal of the previously existing tax credit causes the interest rate to (fall,rise) and the level of saving to (fall,rise). Initially, the government's budget is balanced, then the government responds…arrow_forwardAssume “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…arrow_forward
- A company has determined that its profit for a product can be described by a linear function.The profit from the production and sale of 150 units is $455, and the profit from250 units is $895.(b) You are the CEO for a lightweight compasses manufacturer. The demandfunction for the lightweight compasses is given by p = 40 − 4q2where qis the number of lightweight compasses produced in millions.It costs the company $15to make a lightweight compass.(i) Write an equation giving profit as a function of the number of lightweight compassesproduced.(ii) At the moment the company produces 2 million lightweight compasses and makes a profitof $18,000,000, but you would like to reduce production. What smaller number oflightweight compasses could the company produce to yield the same profit?arrow_forwardA 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.arrow_forwardCompany A's stock sells for $142 a share and has a 3-year average annual return of $27 per share. The beta value, a measure of risk, is 0.38. Company B sells for $149 a share and has a 3-year average annual return of $61 a share. The beta value is 1.23. Tori wants to spend no more than $12000 investing in these two stocks, but she wants to obtain at least $3000 in annual revenue. Tori also wants to minimize the risk, that is, the beta value. Determine how many shares of each stock Tori should buy.arrow_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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License