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
Concept explainers
Videos
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
A store owner must decide whether to build a small or a large facility at a new location. Demand at a location can be either small or large, which probabilities estimated to be 0.4 and 0.6, respectively. If small facility is built and demand proves to be high, the manager may choose not to expand (payoff=P235,000) or to expand (payoff=P275,000). If a small facility is built and demand is low, there is no reason to expand and the payoff is P220,000. If a large facility is built and demand proves to be low, the choice is to do nothing (P60,000) or to stimulate demand through local advertising. The response to advertising may be either modest or sizable, with their probabilities estimated to be 0.3 and 0.7, respectively. If it is modest, the payoff grows to P230,000 if the response is sizable. Finally, if a large facility is built and demand turns out to be high, the payoff is P900,000.a.) Draw a decision tree.b.) Determine the expected payoff for each decision and event node.c.)…
The CEO of a company is considering submitting a bid to purchase property that will be sold by sealed bid. His initial judgment is to submit a bid of $5 million. Based on his experience, he estimates that a bid of $5 million will have a 0.2 of being the highest bid and securing the property for the company. The current date is June 1. Sealed bids must be submitted by August 15. The winning bid will be announced on September 1. If the company submits the highest bid and obtain the property, it plans to build and sell a complex of luxury condominiums. However, a complicating factor is that the property is currently zoned for single-family residences only. The CEO believes that a referendum could be placed on the voting ballot in time for the November elections. Passage of the referendum would change the zoning property and permit construction of luxury condominiums. The sealed bid procedure requires the bid to be submitted with a certified check for 10% of the amount bid. If the bid is…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 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.arrow_forwardA 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.)arrow_forwardAt age 25, Anthony establishes an Individual Retirement Account (IRA). If he invests P10,000 per year for 30 years in an ordinary annuity, the account earns 7.75% per year, how much will he have in the account at age 55?arrow_forward
- Lorna owns a home that is worth $385,000. She has a mortgage with a balance of $112,000. Calculate her equity in the home. $497,000 $76,000 $273,000 $245,000arrow_forwardLingenburger Cheese Corporation has 7.5 million shares of common stock outstanding, 275,000 shares of 4.7 percent preferred stock outstanding, and 160,000 bonds with a semiannual coupon rate of 5.6 percent outstanding, par value $2,000 each. The common stock currently sells for $62 per share and has a beta of 1.10, the preferred stock has a par value of $100 and currently sells for $94 per share, and the bonds have 18 years to maturity and sell for 108 percent of par. The market risk premium is 7.2 percent, T-bills are yielding 3.4 percent, and the company's tax rate is 24 percent. a. What is the firm's market value capital structure? (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., .1616.) b. If the company is evaluating a new investment project that has the same risk as the firm's typical project, what rate should the firm use to discount the project's cash flows? (Do not round intermediate calculations enter your answer as a percent rounded…arrow_forwardJenny Ruiz has an 82% ownership in a company called Jenny’s Cell Phones. If the company has a value of 98,400 and Ruiz receives an income of 45% of the value of her ownership. Calculate for her income.arrow_forward
- Consider the following information for the Alachua Retirement Fund, with a total investment of $4 million. [5] Stock Investment Beta A $ 400,000 1.2 B 600,000 -0.4 C 1,000,000 1.5 D 2,000,000 0.8 The market required rate of return is 12 percent, and the risk-free rate is 6 percent. What is its required rate of return? Stock A has the following probability distribution of expected returns: [5] Probability Rate of Return 0.1 -15% 0.2 0 0.4 5 0.2 10 25 What is Stock A’s coefficient of variation? What is Stock T’s coefficient of…arrow_forwardOn Monday, a certain stock closed at $10 per share. Before the stock market opens on Tuesday, you expect the stock to close at $9, $10, or $11 per share, with respective probabilities 0.3, 0.3, and 0.4. Looking ahead to Wednesday, you expect the stock to close 10 percent lower, unchanged, or 10 percent higher than Tuesday’s close, with the following probabilities. Tuesday's Close 10 Percent Lower Unchanged 10 Percent Higher $9 0.4 0.3 0.3 10 0.2 0.2 0.6 11 0.1 0.2 0.7 Early on Tuesday, you are directed to buy 100 shares of the stock before Thursday. All purchases are made at the end of the day, at the known closing price for that day, so your only options are to buy at the end of Tuesday or at the end of Wednesday. You wish to determine the optimal strategy for whether to buy on Tuesday or defer the purchase until Wednesday, given the Tuesday closing price, to minimize the expected purchase price. Develop and evaluate a decision tree. a-1. Determine the optimal…arrow_forwardJose wants to set up a 10 year GRAT and does not want to have a taxable gift. He wants to transfer $1,236,021 million to the GRAT on 9/31/2020 when the 7520 interest rate is .4%. What annuity payment does he need to receive for there to be no taxable gift?arrow_forward
- The CEO of Coral Gables Corp. was reviewing the returns of the company's sizeable investment portfolio in the last five years during a period of extreme volatility. He noted the 5 year sequence of investment returns as follows: +30%, -20%, +30%, -20%, +30%. He then calculated the arithmetic average return, but his CFO noted that since he had ignored the compounding effect he was wrong. By how much was he wrong? (Hint: Calculate the annual arithmetic average return over the five years less the average geometric (compounded) return.) (Round intermediate calculation to 2 decimal places, e.g. 52.75.) O 1.59% O 3.25% ○ 2.95% ○ 9.39%arrow_forwardStrassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property, it can then be sold for $155,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know what the competitors will bid, but he assumes for planning purposes that the amount bid by each competitor will be uniformly distributed between $100,000 and $145,000. (a) What is the estimate of the probability Strassel will be able to obtain the property using a bid of $125,000? (Use at least 5,000 trials. Round your answer three decimal places.) (b) How much does Strassel need to bid to be assured of obtaining the property? $125,000 $135,000 $145,000 (c) Use the simulation model to compute the profit for each trial of…arrow_forwardStrassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property, it can then be sold for $153,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know what the competitors will bid, but he assumes for planning purposes that the amount bid by each competitor will be uniformly distributed between $100,000 and $143,000. (a) What is the estimate of the probability Strassel will be able to obtain the property using a bid of $123,000? (Use at least 5,000 trials. Round your answer three decimal places.) (b) How much does Strassel need to bid to be assured of obtaining the property? $123,000 $133,000 $143,000 (c) Use the simulation model to compute the profit for each trial of…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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License