Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A young computer engineer has $12,000 to invest and three different investment options (funds) to choose from. Type 1 guaranteed investment funds offer an expected rate of return of 7%, Type 2 mixed funds (part is guaranteed capital) have an expected rate of return of 8%, while an investment on the Stock Exchange involves an expected rate of return of 12%, but without guaranteed investment capital. Computer engineer has decided not to invest more than $2,000 on the Stock Exchange in order to minimize the risk. Moreover for tax reasons, she needs to invest at least three times more in guaranteed investment funds than in mixed funds.
Assume that at the end of the year the returns are those expected; she is trying to determine the optimum investment amounts.
(a) Express this problem as a linear programming model with two decision variables.(b) Solve the problem with the graphical solution procedure and define the optimum solution.
Bruin Properties is in escrow to buy a 175,000 square foot shopping center in Camarillo, California for $35,000,000. Bruin Properties can borrow $24,000,000 fixed rate fully amortizing over 30 years at a 6.0% annual interest rate with equal monthly payments of principal and interest or it can borrow $28,000,000 fixed rate fully amortizing over 30 years at a 7.0% annual interest rate with equal monthly payments of principal and interest. What is the incremental annual borrowing cost for the additional $4,000,000 loan amount if each loan would be outstanding for the full 30 year term?
a.13.0%
b.12.4%
c.11.5%
d. 7.0%
Assume that at the beginning of the year, you purchase an investment for $5,480 that pays $138 annual income. Also assume the investment’s value has decreased to $5,080 by the end of the year.
What is the rate of return for this investment?
Knowledge Booster
Similar questions
- A martingale betting strategy works as follows. You begin with a certain amount of money and repeatedly play a game in which you have a 40% chance of winning any bet. In the first game, you bet 1. From then on, every time you win a bet, you bet 1 the next time. Each time you lose, you double your previous bet. Currently you have 63. Assuming you have unlimited credit, so that you can bet more money than you have, use simulation to estimate the profit or loss you will have after playing the game 50 times.arrow_forwardYou 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.arrow_forwardIn 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?arrow_forward
- 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?arrow_forwardYou are attempting to establish the utility that your boss assigns to a payoff of $1,000. You have established that the utility for a payoff of $0 is zero and the utility for a payoff of $10,000 is one. Your boss has just told you that they would be indifferent between a payoff of $1,000 and a lottery which has a payoff of $10,000 where the probability of losing is 0.7. What is your boss' utility for $1,000? (Round your answer to 1 decimal place.) Utility of $1,000arrow_forwardYou are attempting to establish the utility that your boss assigns to a payoff of $1,200. You have established that the utility for a payoff of $0 is zero and the utility for a payoff of $10,000 is one. Your boss has just told you that they would be indifferent between a payoff of $1,200 and a lottery which has a payoff of $10,000 where the probability of losing is 0.9. What is your boss' utility for $1,200? (Round your answer to 1 decimal place.) Utility of $1,200arrow_forward
- Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25arrow_forwardWarren Buffy is an enormously wealthy investor who has built his fortune through his legendary busimen acumen. He currently has been offered three major investments and would like to choose one. The first one is a conservative investment that would perform well in an improving economy and only suffer a small loss in a worsening economy. The second is a speculative investment that would perform extremely well in an improving economy but would do very badly in a worsening economy. The third is a countercyclical investment that would lose some money in an improving economy but would perform well in a worsening economy. The respective payoffs (millions) and the associated probabilities as shown in the Table below. Decision alternatives Improving Stable Worsening Conservative 30.00 5.00 -8.00 Speculative 40.00 10.50 -30.00 Countercyclical -5.0…arrow_forwardAssume that you recently graduated and have just reported to work as an investment advisor at the brokerage firm of Balik and Kiefer Inc. One of the firm’s clients is Michelle DellaTorre, a professional tennis player who has just come to the United States from Chile. DellaTorre is a highly ranked tennis player who would like to start a company to produce and market apparel she designs. She also expects to invest substantial amounts of money through Balik and Kiefer. DellaTorre is very bright, and she would like to understand in general terms what will happen to her money. Your boss has developed the following set of questions you must answer to explain the U.S. financial system to DellaTorre. Why is corporate finance important to all managers? Describe the organizational forms a company might have as it evolves from a start-up to a major corporation. List the advantages and disadvantages of each form.arrow_forward
- Larry’s Bakery operates a chain of ten high-end bakeries. Larry, the owner of these amazing bakeries, is looking at two options to increase his revenues throughout his chain of bakeries. The first option is to launch a loyalty card. Doing this would cost Larry $500,000. The probability that this would result in high sales is 0.6, which means the probability it would result in low sales is 0.4. If high sales are generated from this option, Larry can expect to see additional revenues of $1,000,000. If low sales are generated from this option, Larry can expect to see additional revenues of only $750,000. The second option Larry has is to cut the prices throughout his bakeries. Doing so would cost him $300,000. The probability that this would result in high sales is 0.8. If doing this results in high sales, Larry can expect to see additional revenues of $800,000. If it results in low sales, he can expect to see additional revenues of only $500,000. Larry obviously has a tough decision…arrow_forwardWhich of the following gambles has the largest objective risk? 20% chance of winning $100 and 80% chance of losing $100 50% chance of winning $10,000 and 50% chance of losing $10,000 50% chance of winning nothing and 50% chance of losing $100 50% chance of winning $100 and 50% chance of winning nothingarrow_forwardYour answer is partially correct. An independent contractor for a transportation company needs to determine whether she should upgrade the vehicle she currently owns or trade her vehicle in to lease a new vehicle. If she keeps her vehicle, she will need to invest in immediate upgrades that cost $5,200 and it will cost $1,300 per year to operate at the end of year that follows. She will keep the vehicle for 5 years; at the end of this period, the upgraded vehicle will have a salvage value of $3,800. Alternatively, she could trade in her vehicle to lease a new vehicle. She estimates that her current vehicle has a trade-in value of $9,800 and that there will be $4,100 due at lease signing. She further estimates that it will cost $2,900 per year to lease and operate the vehicle. The independent contractor's MARR is 11%. Compute the EUAC of both the upgrade and lease alternatives using the insider perspective. Click here to access the TVM Factor Table Calculator. 1943.56 EUAC(keep): $…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,