Work the following problems:
Exercise 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 die twice and add the total.
Model 2: Simulate a combined roll of two dice, giving a number from 2 through 12 with appropriate probabilities.
Exercise 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 down-payment. 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.
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:
• The mileage driven over the 24 months can be approximated by an exponential distribution with mean 25,000 miles.
• The best estimate of the interest rate over the next 24 months is a normal distribution with mean 8.5% and standard deviation 1%.
• 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).
Use your simulation model to assess the probability that the lease option results in a lower net present value than does the purchase option.
Once you have familiarized yourself with this week’s materials, please write an APA format paper to report your results and findings for the following problems. Use appropriate section headings to make sure you answer each question in a separate section. Be sure to attach your Excel Worksheet to illustrate how you constructed your simulation model.
A sample grading rubric is attached
Professional homework help features
Our Experience
However the complexity of your assignment, we have the right professionals to carry out your specific task. ACME homework is a company that does homework help writing services for students who need homework help. We only hire super-skilled academic experts to write your projects. Our years of experience allows us to provide students with homework writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How our professional homework help writing services work
You first have to fill in an order form. In case you need any clarifications regarding the form, feel free to reach out for further guidance. To fill in the form, include basic informaion regarding your order that is topic, subject, number of pages required as well as any other relevant information that will be of help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download