When we consider the time value of money, a peso received in the future: is worth less than a peso received today is worth more than a peso received today is worth the same as a peso received today depends on the compounding used to determine the relationship to a peso received today
Q: A firm is currently taking on two projects with an individual cost of capital of 10 percent and 12…
A: Cost of capital can be defined as the rate of return which is expected by the firm from its…
Q: A company that produces fresh cakes daily throws out their unsold cakes at the end of the day. The…
A: A company that produces fresh cakes daily throws out their unsold cakes at the end of the day. The…
Q: In the PMT function, what is not true about the Num_periods argument? Group of answer choices It…
A: Option C is correct.
Q: Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return…
A:
Q: A company wants to plan production for the ensuing year to minimize the combined cost of production…
A: The production is scheduled to minimize the total cost as:
Q: Lina wants to take a nice vacation trip, so she begins setting aside P250 per month. If she deposits…
A: Given that: a1= 250 rate = 6% t =10 n= 12 ....compunded monthly
Q: For the products A, B, C, and D, which of the following could be a linear programming objective…
A: This is the one and only linear functions from all the options available.
Q: Use two phase method for solving Maximize: Z = 4X1 + 3X2 + 9X3 Subject to: 2X1 + 4X2 + 6X3 ≥ 15 6X1…
A: Given: Find solution using Two-Phase methodMAX z = 4x1 + 3x2 + 9x3subject to2x1 + 4x2 + 6x3 >=…
Q: Compared to high school, college students: a. have more free time between classes b. are…
A: Option D
Q: Which of the following is not one of the reasons an optimization model can become nonlinear? Group…
A: The optimization model has three elements which are decision variables, objective function, and…
Q: Suppose on a road trip to Texas you observe that three out of every four trucks on the road are…
A: There are several methods to solve the problem. I am using Markov chain method here. Hope you are…
Q: Determine the overhead application rates for the producing departments using each of the three…
A: THE OVERHEAD APPLICATION RATES UNDER THREE METHODS ARE AS BELOW:
Q: Which of the following statements is true regarding the advantages of using simulations? a. Its…
A: Option D is correct.
Q: Heller Manufacturing has two production facilities that manufacture baseball gloves. Production…
A: Given data: TCD(X) = X2-X+3 TCH(Y)=Y2+2Y+2 5000 gloves per week production
Q: A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the…
A: Let the amount invested in Bond A be Xa, Bond B be Xb, Bond C be Xc, Bond D be Xd, and Bond E be Xe…
Q: Suppose you want to have $800,000 for retirement in 35 years. Your account earns 8% interest. How…
A: Given that : i = 8% annual = 8/12= 0.6667% montly n= 35 years = 35*12 = 420 months Future value, FV…
Q: Solve for the future worth of each of the given series of payments: (a) $12,000 at the end of each…
A: Future value (FV) is the value of a current resource at a future date in view of an accepted pace of…
Q: Explain what is meant by a linear programming that has feasible region with infinite number of…
A: A feasible area is a solution space for an optimization problem that comprises all potential points.…
Q: A manufacturing company has an aggregate planning of selling its beds in the following sizes (the…
A: Given Information: Total Production Bed Sizes Production Proportion Colors Proportion…
Q: Solve the LP problem. If no optimal solution exists, indicate whether the feasible region is empty…
A: GIVEN
Q: Which of the following are the main parts of a linear programming? maximization and minimization…
A: Linear programming is a mathematical approach for determining the best feasible result or solution…
Q: A room measures 12 feet by 15 feet. How many 3-foot by 3-foot squares of carpet are needed to cover…
A: Given data is Room size = 12 by 15 feet Carpet size = 3 by 3 foot
Q: Sunday. Suppose that the production department wants to meet its daily requirements using only…
A: a) Min C1X1 + C2X2 + C3X3 + C4X4 + C5X5 + C6X6 + C7X7 Subject to 1X1 + 0X2 + 0X3 + 1X4 + 1X5 + 1X6 +…
Q: Which of the following is not involved in a linear programming problem? a. variable b. solution set…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: XYZ, Inc., is a small firm that produces a variety of chemical products. In a particular production…
A: “Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: An investment of $300,000 is expected to generate the following cash inflows in six years: Year 1:…
A: Find the Given Details below: Given Details: Total Investment 300000 $ Cash Inflows Year 1…
Q: Perth Mining Company operates two mines for the purpose of extracting gold and silver. The Saddle…
A: This question is related to the topic- decision making and this topic fall under the operations…
Q: A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the…
A: Given data: Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes…
Q: A company manufactures two products. If it charges price pi for product i, it can sell qi units of…
A: Non-linear programming (NLP) is used in complex optimization problems where the objectives or…
Q: Solve the LP problem. If no optimal solution exists, indicate whether the feasible region is empty…
A: Below is the solution:-
Q: The estimated selling price of a new mobile phone is RO 90. The company wants to earn a mark up of…
A: Small Introduction about Cost Gap A product design's projected costs can be compared against the…
Q: We have 60 meters of fence and want to fence a triangular shaped area. Please formulate an NLP (do…
A: Suppose the sides of the triangle as a, b and c. Parameter of the triangle = a +b + c
Q: • Formulate the problem of deciding how much of each product to make in the current week as a linear…
A: The linear programming method is a mathematical method by which the best outcome where profits are…
Q: During the year, Brownout Company experienced the following power outages: Number of Power Outages…
A: Given data
Q: The cost of producing a certain commodity consists of P45.00 per unit for labor and material cost…
A: Formula to be used; Break even quantity = Fixed cost / Contribution margin
Q: The colouring of fabrics can be effected through staining (painting), dyeing or printing. As an…
A: In piece coloring, which is utilized essentially for textures that are to be a strong shading, a…
Q: MacDonald opens an 800 acre farm to raise wheat, beef, and alfalfa. He is planning his activities…
A:
Q: If a convex function is multiplied by a negative constant, the result: A. is concave B. could be…
A: . when a convex formula is multiplied by a negative constant the result will be a concave formula…
Q: This condition arises when there is a tie in the values used to determine which variable will enter…
A: A solution can be termed as degenerate, when, If the value of at least one basic variable becomes…
Q: In a SGTA of 32, there are more students whose major is Marketing than any other majors, how many…
A: In a SGTA of 32, more students whose major is Marketing than any other majors,
Q: Cox Electric makes electronic components and has estimated the following for a new design of one of…
A: Given data: Fixed Cost = $7,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue…
Q: A one-day vaccination clinic has forecast the number of workers needed according to the table shown…
A: A worker in 10 hour shift can start from either 8 am or 10 am because after 10 am shift, the 10 hour…
Q: Which of the following is the optimal value of the objective function for the LP model in this…
A: Given data is Objective function: z=4x+8y Subject to x+1.6y≥452x+0.5y≥40x+y≤40x,y≥0
Q: It costs $300 to buy a lawn mower from a lawn supply store. Assume that you can keep a lawn mower…
A: Build up a bookkeeping page enhancement model for mower purchasing for the following 10 years that…
Q: Which of the following is not a continuous random variable? The possible amount of rain on a given…
A: A continuous random variable is a variable which can have infinite values since the values measured…
Q: You have a new job as a Financial Planning assistant. Your client wants to invest money in stocks,…
A: S = Total dollars invested in stocks B = Total dollars invested in Bonds T = Total dollars invested…
Q: In research, it is very important to identify the different types of variable. Variables may assume…
A: Below is the solution:-
Q: George Johnson recently inherited a large sum of money; he wants to use a portion of this money to…
A: Let bond fund = x1 stock fund = x2 Max Z = 6% x1 + 10% x2 or Max Z = 0.06 x1 + 0.1 x2…
When we consider the time value of money, a peso received in the future:
- is worth less than a peso received today
- is worth more than a peso received today
- is worth the same as a peso received today
- depends on the compounding used to determine the relationship to a peso received today
Step by step
Solved in 2 steps
- In 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?Based on Kelly (1956). You currently have 100. Each week you can invest any amount of money you currently have in a risky investment. With probability 0.4, the amount you invest is tripled (e.g., if you invest 100, you increase your asset position by 300), and, with probability 0.6, the amount you invest is lost. Consider the following investment strategies: Each week, invest 10% of your money. Each week, invest 30% of your money. Each week, invest 50% of your money. Use @RISK to simulate 100 weeks of each strategy 1000 times. Which strategy appears to be best in terms of the maximum growth rate? (In general, if you can multiply your investment by M with probability p and lose your investment with probability q = 1 p, you should invest a fraction [p(M 1) q]/(M 1) of your money each week. This strategy maximizes the expected growth rate of your fortune and is known as the Kelly criterion.) (Hint: If an initial wealth of I dollars grows to F dollars in 100 weeks, the weekly growth rate, labeled r, satisfies F = (I + r)100, so that r = (F/I)1/100 1.)If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.
- You 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.)The 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.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?
- Suppose that GLC earns a 2000 profit each time a person buys a car. We want to determine how the expected profit earned from a customer depends on the quality of GLCs cars. We assume a typical customer will purchase 10 cars during her lifetime. She will purchase a car now (year 1) and then purchase a car every five yearsduring year 6, year 11, and so on. For simplicity, we assume that Hundo is GLCs only competitor. We also assume that if the consumer is satisfied with the car she purchases, she will buy her next car from the same company, but if she is not satisfied, she will buy her next car from the other company. Hundo produces cars that satisfy 80% of its customers. Currently, GLC produces cars that also satisfy 80% of its customers. Consider a customer whose first car is a GLC car. If profits are discounted at 10% annually, use simulation to estimate the value of this customer to GLC. Also estimate the value of a customer to GLC if it can raise its customer satisfaction rating to 85%, to 90%, or to 95%. You can interpret the satisfaction value as the probability that a customer will not switch companies.You now have 10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the mean and median value of your investment after 50 years. Explain the large difference between the estimated mean and median.The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.
- Assume that all of a companys job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 25% means that the company will accept applicants for jobs who rank in the top 25% of all applicants. If the company chooses a selection ratio of 25%, the average test score of those selected will be 1.27 standard deviations above average. Use simulation to verify this fact, proceeding as follows. a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.) b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excels DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and 0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excels database D functions. c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)