Strassel 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 $165000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. 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 $100000 and $150000. a. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130000 for the property. Using simulation of 1000 trials, what is the estimate of the probability Strassel will be able to obtain the property using a bid of $130000? Round your answer to 1 decimal place. Enter your answer as a percent. % b. How much does Strassel need to bid to be assured of obtaining the property? What is the profit associated with this bid? 24

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
Problem 12-15 (Algorithmic)
Strassel 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 $165000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. 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 $100000 and $150000.
a. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130000 for the property. Using a simulation of 1000 trials, what is the
estimate of the probability Strassel will be able to obtain the property using a bid of $130000? Round your answer to 1 decimal place. Enter your answer as a percent.
%
b. How much does Strassel need to bid to be assured of obtaining the property?
$
What is the profit associated with this bid?
$
c. Use the simulation model to compute the profit for each trial of the simulation run. With maximization of profit as Strassel's objective, use simulation to evaluate Strassel's bid alternatives of
$130000, $140000, or $150000. What is the recommended bid, and what is the expected profit?
A bid of
results in the largest mean profit of $
Transcribed Image Text:Problem 12-15 (Algorithmic) Strassel 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 $165000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. 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 $100000 and $150000. a. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130000 for the property. Using a simulation of 1000 trials, what is the estimate of the probability Strassel will be able to obtain the property using a bid of $130000? Round your answer to 1 decimal place. Enter your answer as a percent. % b. How much does Strassel need to bid to be assured of obtaining the property? $ What is the profit associated with this bid? $ c. Use the simulation model to compute the profit for each trial of the simulation run. With maximization of profit as Strassel's objective, use simulation to evaluate Strassel's bid alternatives of $130000, $140000, or $150000. What is the recommended bid, and what is the expected profit? A bid of results in the largest mean profit of $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Types of Property
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education