Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all excel formulas! Thank you! 3. Car Leases. Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers

image text in transcribed

Please show all excel formulas!

Thank you!

3. Car Leases. Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36-month lease with no down payment due at the time of signing. Each lease includes a monthly charge and a mileage allowance. Additional miles receive a surcharge on a per-mile basis. The monthly lease cost, the mileage allowance, and the cost for additional miles are as follows: Dealer Monthly Cost Mileage Cost per Allowance Additional Mile Hepburn Honda $299 36,000 $0.15 Midtown Motors $310 45,000 $0.20 Hopkins Automotive $325 54,000 $0.15 Amy decided to choose the lease option that will minimize her total 36-month cost. The difficulty is that Amy is not sure how many miles she will drive over the next three years. For purposes of this decision, she believes it is reasonable to assume that she will drive 12,000 miles per year, 15,000 miles per year, or 18,000 miles per year. With this assumption Amy estimated her total costs for the three lease options. For example, she figures that the Hepburn Honda lease will cost her 36(299) + $0.15(36,000 - 36,000) = $10,764 if she drives 12,000 miles per year, 36($299) + $0.15(45,000 - 36,000) = $12, 114 if she drives 15,000 miles per year, or 36(5299) + $0.15(54,000 - 36,000) = $13,464 if she drives 18,000 miles per year. a. What is the decision, and what is the chance event? b. Construct a payoff table for Amy's problem. c. If Amy has no idea which of the three mileage assumptions is most appropriate, what is the recommended decision (leasing option) using the optimistic, conservative, and minimax regret approaches? d. Suppose that the probabilities that Amy drives 12,000, 15,000, and 18,000 miles per year are 0.5, 0.4, and 0.1, respectively. What option should Amy choose using the expected value approach? e. Develop a risk profile for the decision selected in part (d). What is the most likely cost, and what is its probability? f. Suppose that, after further consideration, Amy concludes that the probabilities that she will drive 12,000, 15,000, and 18,000 miles per year are 0.3, 0.4, and 0.3, respectively. What decision should Amy make using the expected value approach? 3. Car Leases. Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36-month lease with no down payment due at the time of signing. Each lease includes a monthly charge and a mileage allowance. Additional miles receive a surcharge on a per-mile basis. The monthly lease cost, the mileage allowance, and the cost for additional miles are as follows: Dealer Monthly Cost Mileage Cost per Allowance Additional Mile Hepburn Honda $299 36,000 $0.15 Midtown Motors $310 45,000 $0.20 Hopkins Automotive $325 54,000 $0.15 Amy decided to choose the lease option that will minimize her total 36-month cost. The difficulty is that Amy is not sure how many miles she will drive over the next three years. For purposes of this decision, she believes it is reasonable to assume that she will drive 12,000 miles per year, 15,000 miles per year, or 18,000 miles per year. With this assumption Amy estimated her total costs for the three lease options. For example, she figures that the Hepburn Honda lease will cost her 36(299) + $0.15(36,000 - 36,000) = $10,764 if she drives 12,000 miles per year, 36($299) + $0.15(45,000 - 36,000) = $12, 114 if she drives 15,000 miles per year, or 36(5299) + $0.15(54,000 - 36,000) = $13,464 if she drives 18,000 miles per year. a. What is the decision, and what is the chance event? b. Construct a payoff table for Amy's problem. c. If Amy has no idea which of the three mileage assumptions is most appropriate, what is the recommended decision (leasing option) using the optimistic, conservative, and minimax regret approaches? d. Suppose that the probabilities that Amy drives 12,000, 15,000, and 18,000 miles per year are 0.5, 0.4, and 0.1, respectively. What option should Amy choose using the expected value approach? e. Develop a risk profile for the decision selected in part (d). What is the most likely cost, and what is its probability? f. Suppose that, after further consideration, Amy concludes that the probabilities that she will drive 12,000, 15,000, and 18,000 miles per year are 0.3, 0.4, and 0.3, respectively. What decision should Amy make using the expected value approach

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Mining Valuation Handbook Mining And Energy Valuation For Investors And Management

Authors: Victor Rudenno

4th Edition

0730377075, 978-0730377078

More Books

Students also viewed these Finance questions

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago