Investment A woman invests $360,000 in three different mutual funds. One averages 12% per year,and another averages 16% per year. A third fundaverages 8% per year, and because it has much lessrisk, she invests twice as much in it as in the sum ofthe other two funds. To realize an annual return of$35,200, how much should she invest in each fund?
Q: CA Corporate has an available funds of $200,000 is considering for new investment opportunities. The…
A: Investment portfolio of stocks is given as follows:
Q: Why does this formula not function?
A: THE ANSWER IS AS BELOW:
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $75 each and gadgets…
A: Given data:
Q: After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the…
A: Below is the solution:-
Q: 3. ND: Referring to the Z-Table, calculate the probability that each alternative will turn out at…
A: Find the Given details below: Given details: Alternatives States of Nature Recession…
Q: You are thinking of making your home more energy efficient by replacing some of the light bulbs with…
A: Below is the solution:-
Q: A specialized machine essential for a company's operations costs $5,000 and has operating costs of…
A: Calculations:
Q: Suppose you are an HR (human resources) manager at a big university, and you sense that the…
A: As an HR manager at a big university, it will create a great responsibility to cope up with the…
Q: he probability that a mobile phone is stolen in an electronic shop is 0.0008. If 8500 mobile phones…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: A firm uses a single input to produce a commodity according to its short-run production function,…
A: given, commodity sells =$100 per unit input cost =$50per unit
Q: My current income is $40,000. I believe that I owe$8,000 in taxes. For $500, I can hire a CPA to…
A:
Q: If a business has $1,000 Cash currently, $300 Revenue each month going forward, and negative $200…
A: Given cash = $1000 revenue = $300 negative = $200 profit
Q: The Schoch Museum (see Problem 30 in Chapter 11) is embarking on a five-year fundraising campaign.…
A: Donation refers to the instance of act concerning which a contribution, grant or gift is being…
Q: Set up the system fequations and then solve it by using an inverse matrix. One safe investment pays…
A: Given, Investment =$1,47,200 and income = $20,000 per year. Let us assume that, X= Amount invested…
Q: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
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: As the Quality Sweaters problem is now modeled, if all inputs remain fixed except for the number…
A: Here we consider the model of profit sensitivity to number of mailing, where profit increase…
Q: You own a coffee shop in a metro Toronto shopping mall. It is Friday evening and you are trying to…
A: We have to find the value of payoff for quality baked(Q)+demand(D) by using below formula
Q: A building contains 1000 lightbulbs. Each bulb lastsat most five months. The company maintaining…
A: In the above question, the company wants to decide whether the group replacement policy is…
Q: A salesperson in a large bicycle shop is paid a bonus ifhe sells more than 4 bicycles a day. The…
A: Our task is to simulate n number of days and find the bonus earned by the salesman each day using…
Q: Assets A and B are such that their returns are uncorrelated (zero correlation). The Sharpe ratios of…
A: Assets A and B are such that their returns are uncorrelated (zero correlation). The Sharpe ratios of…
Q: A manufacturer of two products (Widgets and Gadgets) makes a profit of $140 for each widget sold and…
A:
Q: You are planning to save for retirement over the next 30 years. To do this, you will invest $800 a…
A: Although the stock and bond accounts have different interest rates, we can draw one timeline, but we…
Q: Each rented car makes a $100 profit per day and each unrented car makes a loss of $30 per day. It is…
A:
Q: I own a single share of Wivco stock. I must sell myshare at the beginning of one of the next 30…
A:
Q: Write an equation giving profit as a function of the number of lightweight compasses produced. (ii)…
A: (i) p=30-3q
Q: You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it…
A:
Q: Appliances Unlimited (AU) sells refrigerators. Anyrefrigerator that fails before it is three years…
A: Warranty refers to a facility that is provided to consumers in case of any malfunctioning product…
Q: A newspaper has 500,000 subscribers who pay $4 per month for the paper. It costs the company…
A: Given data : Newspaper has subscribers - Demand D = 500,000 Ordering cost to bill the customers K…
Q: A company manufactures dog leashes that sell for $18.64, including shipping and handling. The…
A: Given, Total revenue = $18.64*Q Fixed cost = $24,131 Total variable cost = 9.18*Q Total cost =…
Q: Consider a consumer that lives only for two periods. He works in period 1 (and gets income Y1) and…
A: We can say that where current consumption is solely dependent on current income, according to…
Q: A company that manufactures air-operated drain valve assemblies currently has $110,000 available to…
A: given values, Rate = 10% (NPMT) no of periods =5 FV = 0
Q: The Smiths save £32,000 per year for retirement. They are now in their mid-thirties, and they expect…
A:
Q: You are thinking of starting Peaco, which will produce Peakbabies, a product that competes with Ty’s…
A:
Q: You have recently won the super jackpot in the Washington State Lottery. On reading the fine print,…
A: Here, we need to compare two options. In order to do so, we must get the value of the two cash flow…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets…
A: Converting last 2 constraints so that the variables stay on the LHS, 9999y1 - x1 >= 0 9999y2 - x2…
Q: Do the following problems using either TreePlan A student is deciding which scholarships (out of…
A: A decision tree identify the best decision from all possible alternative based on the consideration…
Q: A company handles an apartment building with 50 units. Experience has shown that if the rent for…
A: Given data Apartment building has 50 units Each unit rent =$640 per month 1 vacant for $20 increase…
Q: The total asset of a company is OMR320,000; its current liabilities are OMR30,000 and its revenue…
A: A cost is the resources value in monetary terms spent by the business to produce and deliver the…
Q: You are thinking of starting Peaco, which will produce Peakbabies, a product that competes with Ty's…
A:
Q: You are trying to create a budget to optimize the use of a portion of your disposable income. You…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash…
A: The question is related to Miller-Orr model of cash management. This model allows lower and upper…
Q: A manufacturer of two products (Widgets and Gadgets) makes a profit of $140 for each widget sold and…
A: The optimization model will be as follows: Max Z = overall net profit = 140W + 100G - 2W^2 - 2G^4W,…
Q: A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets…
A: Given, Profit Margin widgets-$45 Profit Margin gadgets-$55 Set-up cost Margin widgets-$300 Set-up…
Q: you are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it…
A: It is given that; the cost per copy is $0.03, variable cost (VC) = $0.03. Selling price per copy is…
Q: 1.) True or false? Briefly explain. _____ Your firm has the opportunity to invest $20 million in a…
A: 1.TrueThe cost of capital of a company depends upon the borrowings of a company. In thequestion, the…
Investment A woman invests $360,000 in three different mutual funds. One averages 12% per year,
and another averages 16% per year. A third fund
averages 8% per year, and because it has much less
risk, she invests twice as much in it as in the sum of
the other two funds. To realize an annual return of
$35,200, how much should she invest in each fund?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- 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?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.)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.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.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?
- 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.A 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.)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?
- Rerun 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%.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.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?