Your sister and her fiancé are planning on getting engaged (and later married) in the future. Wanting to start saving up for the wedding costs, they ask you to help them invest their money in the hopes of having $60,000 saved four years from now. They also would like to withdraw $15,000 in a year to pay for the engagement rings. Besides their initial deposit, they also plan to make another deposit in three years as they are expected to receive an $8,000 settlement from a class-action lawsuit by then. There are one-year and two-year investments available for each year as well as a special three-year investment that becomes available in a year, shown in the diagram below. One-year investments return 2.5%, two-year investments return 6%, and the three-year investment return 10%. Formulate as a linear program using the variables that are listed on the diagram and solve to minimize the initial deposit your sister and her fiancé must make. Deposit (Xo) Present Хо1 Withdrawal Xo2 ($15,000) Year 1 Х12 \X13 Year 2 X23 X14 Deposit ($8,000) \X24 Year 3 Х4 Withdrawal ($60,000) Year 4

Your sister and her fiancé are planning on getting engaged (and later married) in the future. Wanting to start saving up for the wedding costs, they ask you to help them invest their money in the hopes of having $60,000 saved four years from now. They also would like to withdraw $15,000 in a year to pay for the engagement rings. Besides their initial deposit, they also plan to make another deposit in three years as they are expected to receive an $8,000 settlement from a class-action lawsuit by then. There are one-year and two-year investments available for each year as well as a special three-year investment that becomes available in a year, shown in the diagram below. One-year investments return 2.5%, two-year investments return 6%, and the three-year investment return 10%. Formulate as a linear program using the variables that are listed on the diagram and solve to minimize the initial deposit your sister and her fiancé must make. Deposit (Xo) Present Хо1 Withdrawal Xo2 ($15,000) Year 1 Х12 \X13 Year 2 X23 X14 Deposit ($8,000) \X24 Year 3 Х4 Withdrawal ($60,000) Year 4

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section11.3: Financial Models

Problem 28P

See similar textbooks

Similar questions

A project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)
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.
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.)
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Explain in some detail how the PrecisionTree calculations in Figure 6.11 for the Acme problem are exactly the same as those for the hand-drawn decision tree in Figure 6.6. In other words, explain exactly how PrecisionTree gets the monetary values in the colored cells in Figure 6.11. If your answer is negative number, enter "minus" sign. Market EMV Great ( $18 × - $ ) = $ Fair ( $18 × - $ ) = $ Awful ( $18 × - $ ) = $ Total 0.45 × __ $ + 0.35 × ___$ + 0.20 × ___ $ = ___ $
I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…
Your job pays you only once a year for all the work you didover the previous 12 months. Today, December 31, you just received your salaryof $65,000, and you plan to spend all of it. However, you want to start saving forretirement beginning next year. You have decided that one year from today youwill begin depositing 5 percent of your annual salary in an account that will earn10 percent per year. Your salary will increase at 4 percent per year throughout yourcareer. How much money will you have on the date of your retirement 40 years fromtoday?
The purpose of liquidity analysis is to estimate if: A. the supply of labor will be sufficient to carry out the plan B. the supply of irrigation water will be sufficient C. cash inflows will be sufficient to meet expected cash outflows D. net farm income will be positive or negative
6) Some people have said that the Soviet Union saved too much. Explain the benefit of saving in the long run and how over-saving could be possible. 7) Give an example of a government policy that could change savings behavior and an example that could change the productivity in an economy. 8) Explain why the Federal Reserve’s goals of lowering inflation and unemployment creates a time consistency problem. Explain using the short and medium run Phillip’s curve. 9) Show a liquidity trap situation on an IS-LM graph. Explain the possible policy changes to end this situation. ************* SHOW WITH GRAPHS PLEASE*********************
I have a accounting firm and someone from real estate wants to invest and give my firm all her accounts but in return wants equal ownership of my firm, but i dont want to giver her equal ownership but wants her to invest in my firm , what are alternatives that i can offer her without giving her half ownership. Elaborate
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%
Retailer Budget D. Tomlinson Retail seeks your assistance in developing cash and other budgetinformation for May, June, and July. The store expects to have the following balances at the end ofApril:Cash $ 5,500Accounts receivable 437,000Inventories 309,400Accounts payable 133,055The firm follows these guidelines in preparing its budgets:∙ Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day ofeach month. The firm books receivables at gross amounts and collects 60% of the billings withinthe discount period, 25% by the end of the month, and 9% by the end of the second month. Thefirm’s experience suggests that 6% is likely to be uncollectible and is written off at the end of thethird month.∙ Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month’s units of endinginventory should equal 130% of the next month’s cost of sales. The…