Chapter 8, Problem 13QP

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.)

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.

Eight years ago, Burt Brownlee purchased a government bond that pays 3.60 percent interest. The face value of the bond was $1,000. What is the dollar amount of annual interest that Burt received from his bond investment each year? Assuming that comparable bonds are now paying 2.40 percent, will Burt's bond increase or decrease in value? Why did the bond increase or decrease in value?

A bond has a face value of $1,000, an annual coupon rate of 3.70%, an yield to maturity of 7.4%, makes 2 (semi-annual) coupon payments per year, and 6 periods to maturity (or 3 years to maturity). Determine the duration of this bond. Notice that there is a function “Duration” in Excel, but you probably would like to check your answer with an analytical solution based on the specific duration formula. Note: This is an excel based assignment so please work it out on excel highlighting the formulas. thank you

A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the total annual return (before tax).   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 as least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free.   Suppose the decision variable  represents the amount of money invested in bond  for . Formulate a linear programming (LP) model to solve the optimal strategy.   1. Write down the constraint using the defined decision variables requiring “invest as least 50% of the money in short-term issues”.   2. Write down the constraint using the defined decision…

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. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Stock in Company A sells for $89 a share and has a 3-year average annual return of $24 a share. The beta value is 1.26. Stock in Company B sells for $83 a share and has a 3-year average annual return of $18 a share. The beta value is 1.13. Derek wants to spend no more than $19,000 investing in these two stocks, but he wants to earn at least $2100 in annual revenue. Derek also wants to minimize the risk. Determine the number of shares of each stock that Derek should buy. Set up the linear programming problem. Let a represent the number of shares of stock in Company A, b represent the number of shares of stock in Company B, and z represent the total beta value. Minimize z3 1.26а + 1.13b subject to 89а + 83b s 19000 24a + 18b > 2100 a 2 0, b20. (Use integers or decimals for any numbers in the expressions. Do not include the $ symbol in your answers.) Derek should buy 88 share(s) of stock in Company A and 0 share(s) of stock in Company B. (Round to the nearest integer as needed.)

Long-Life Insurance developed a linear model to determine the amount of term life insurance a family of four should have, based on the head of the household's current age. The equation is:   y = 163  -0.45xwherey = Insurance needed ($000)x = Current age of head of household Calculate the amount of term life insurance you would recommend for a family of four if the head of the household is 53 years old. (Round your answer to 2 decimal places.)

Solve in excel