Use appropriate section headings to make sure you answer each question in a separate section. Please
also attach your Excel Worksheet to illustrate how you constructed your simulation model.
Problem 1:
Develop two simulation models of tossing two six-sided dice (Numbered 1 Through 6 on the six faces).
Model 1: Simulate rolling a single dice twice and add the total.
Model 2: Simulate a combined roll of two dice, giving a number from 2 through 12 with appropriate
probabilities. Problem 2
An advertisement in the newspaper offers a new car for sale or lease. The purchase price of the car is
$43,240, or the car can be leased for 24 months for a monthly payment of $458, with a $7,500 downpayment. Under the lease option, there is a charge of 24 cents/mile for mileage above 30,000 miles for
the 24 months, and a $550 security deposit, which is refundable at the end of the lease, must be
deposited with the dealer. The car may be purchased at the end of the lease for $29,732. All other
charges (taxes, maintenance, plates, etc.) are the same under both options.
A. Develop a simulation model to compare the net present value of buying or leasing the car
for 24 months. To compare the two options a number of assumptions must be made.
Assume that:
a. The mileage driven over 24 months can be approximated by an exponential
distribution with mean 25,000 miles.
b. The best estimate of the interest rate over the next 24 months is a normal
distribution with mean 8.5% and standard deviation 1%.
c. The value of the car at the end of 24 months is the same under both options (that is,
if the car is purchased, the realizable value at the end of month 24 is $29,732 less 24
cents/mile for each mile over 30,000).
B. Use your simulation model to assess the probability that the lease option results in a lower
net present value that does the purchase option.
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
