Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.a. Find the project’s NPV if cash flows occur at the ends of the respective years.b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.c. Find the project’s NPV if cash flows occur at the middles of the respective years.
Q: I have a restaurant, but I don't know what demand will be next year. I need to decide whether to…
A: 1) Expected value of expanding if you expand EMV= sum of (probability of event) = (0.20 x…
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: The finance function is primarily interested in the relationship between the risks of investments…
A: It is a true statement.
Q: Bayan wants to buy a house in six years. She hopes to be able to put down OMR 25000 at that time.…
A: Answer: For solving the question, we will assume that the bank CD will pay the interest in simple…
Q: Determine the optimal action based on the maximax criterion ii. Determine the optimal action based…
A: The investor who has certain amount of money to be invested, has assigned probability based on his…
Q: Let Q be the number of pies they make and sell. The total cost, C(Q) in dollars, for making Q pies…
A: The question demands us to find the total cost which is incurred in making 20 pies Total cost =…
Q: Suppose you are going to receive $20,000 per year for five years. The appropriate interest rate is 7…
A: a) The timeline for the ordinary annuity is: If the payments are in the form of an ordinary…
Q: n a bad economy, a CEO has a 4% chance of meeting earnings estimates at regular effort, and a 5%…
A: Probability of making sale ids 4% = 0.04 ANSWER : The cost for regular effort are zero Thus the…
Q: CanaSystems is considering a project to build upscale condominiums. They are considering plans on a…
A: Opportunity loss is characterized as the contrast between the real result and the result that would…
Q: Brandon is considering expansion of a store. If he expands, the interest rate at which he borrows…
A: The decision tree has been represented as shown in the diagram.
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 are going on a weekend trip to a city that is d miles away. Develop a model that…
A: 1.Model development Determine the inputs The variable d' = the distance to the city Account for the…
Q: Private Insurance provides coverages that can be used to meet specific loss situations. For each of…
A: A. The type of insurance coverage will be "Payment Protection Insurance". This type of insurance…
Q: Suppose that $100 is invested at the beginning of a year. Which (if either) of the following methods…
A: Interest is the additional amount received over the basic principle. This amount is decided by the…
Q: Consider an investment project with the following cash flows: N Cash…
A: Substitute, 9% as interest rate, according to trial and error method,
Q: Your sister and her fiancé are planning on getting engaged (and later married) in the future.…
A: By looking at the above diagram we can pull out the below equation:
Q: From the given information below of a const. of commercial bank building a. Tabulate the results for…
A: WE ARE ALLOWED TO DO FIRST THREE SUB-PARTS ONLY. THE ANSWER IS AS BELOW:
Q: A person wants to invest in one of three alternative investment plans: stocks, bonds or a savings…
A: Following is the given information:
Q: 2. Cindy wants to buy a volleyball. Its original price is Php965.00 and is on sale at 25% discount.…
A: The above questions are from the topic: Profit and Loss The answer to the question is given below:
Q: A company has $10,000 to invest , to be divided into fixed interest, equities and property. For…
A: Here, the individual wants to make an investment decision. Let x = Amount invested in fixed interest…
Q: Forester and Cohen is a small accounting firm, managed by Joseph Cohen since the retirement in…
A: Aggregate plan refers to the planning to get output using different approaches. Here, the employees…
Q: Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment…
A: Given data, Economy Has Good Year Economy Has Bad Year Yield on Stocks 22% 10% Yield on…
Q: Where you invest your money? Construct a decision tree.
A:
Q: The purpose of liquidity analysis is to estimate if: A. the supply of labor will be sufficient to…
A: These ratios are an important class of financial works that are used to find the debtor's ability to…
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: Let Xi be the price (in dollars) of stock i one year fromnow. X1 is N(15, 100) and X2 is N(20,…
A: Let Xi be the price of stock i year from now. For all i = 1,2 As per the given information, X1 and…
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: Michelle owns a house in which she keeps valuables worth 100,000 which can get stolen with…
A: Given information, Michelle worth = 10, 000 Probability = 1% Puchasing Coverage = C ( 0; 100,000)…
Q: A start-up company, Macrotech, plans to produce a device to translate Morse codeto a written message…
A: Given that, Initial Cost = $30,000 Selling Price SP= $85 Cost Price = $20
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: EBIT of different Firms are as follows, Interest (I) at 10% and Equity Capitalization Rate (Ke)…
A: The question is related to Capital Structure. The total market value of firm is calculated with the…
Q: Consider an economy that lasts for two periods, period 1 and period 2. Let TBị denotes the trade…
A: SOLUTION:
Q: Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as…
A: The net present value shows the capital appreciation from a project. This means that the net present…
Q: The yield on 1-year Treasury securities is 6%, 2-year securitiesyield 6.2%, 3-year securities yield…
A:
Q: 5. If money can be invested at 5% compounded annually, A. Accumulate P1,000 for 15 years. B.…
A: Compound Interest in the simplest terms can be referred to as charging an interest over the simple…
Q: An investor has a certain amount of money available to invest now. Three alternative investments are…
A: Hello thank you for the question. As per guidelines, we would provide only first three sub-parts at…
Q: Suppose an investor has the opportunity to buy the followingcontract, a stock call option, on March…
A: The following decision tree shows the problem in the most illustrative manner. The optimal…
Q: Suppose that a dam was built at a very high cost. At the time of construction, the estimated cost…
A: Assume that a dam was constructed at a very high cost for stop at the time of construction.
Q: 1/ Explain why all investors should choose the same risky portfolio from the efficient set. 2/…
A: Investors prefer to invest where risk is low. But high return involves the high risk and vise versa.…
Q: Conoly Co. has identified an investment project with the following cash flows. If the discount rate…
A: The timeline is: To solve this problem, we must find the PV of each cash flow and add them. To…
Q: A salesperson for Fuller Brush has three options: quit,put forth a low-effort level, or put forth a…
A:
Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.
a. Find the project’s
b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.
c. Find the project’s NPV if cash flows occur at the middles of the respective years.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- 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?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.)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.)
- 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?In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?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?If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?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.)