Purchase Solution

Simulation model to evaluate car purchase vs lease option

Not what you're looking for?

Ask Custom Question

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.

• 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.

1.Please construct a basic decision model (Excel) and

2.Write one paragraph for each exercise to report your results and findings for the attached problems.

Purchase this Solution
Solution Summary

The Solution simulates the decision between purchasing or leasing a car using an Excel decision model.

Solution Preview

Hi,

Please find attached detailed help on your posting. The file ...

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

View More Free Quizzes
Related BrainMass Solutions

  • Buy vs. lease

    We get lease amount X 3.605 = 22,163 lease amount = 22,163/3.605=6,147.85 The maximum amount of lease should be $6,147.85 The solution explains how to evaluate a buy vs. lease decision.

  • Lease vs. Buy Calculations

    130461 Lease vs. Buy Calculations 1) You want a new car. Price of car $40,000, you can purchase for $37 K. You can lease it for $5000 down, and payments of $650 per month for 60 months with the option to buy for $1000 at the end of the lease.

  • Buy vs. Lease: evaluate the options for a $25000 car; how much would you pay to buy

    Which option fo you prefer? b. What is the maximum amount you should be willing to pay to lease rather than buy the car? Please show all work.

  • Lease vs Buy, Present Value, Rate of Return, Annuity

    130201 Multiple Choice Questions: Lease vs Buy, Present Value, Rate of Return, Annuity 1) A company has an option to purchase equipment or $24,000 but can lease the identical equipment for $5,000 per month for the next 6 years.

  • Buy vs Lease

    Which option do you prefer? b. What is the maximum amount you should be willing to pay to lease rather than buy the car? Please see the attached file. This explains Buy vs Lease and compares numerically

  • Compare and Contrast Lease Versus Purchase Options

    An example of an operating lease would be if a company decides to lease a car.

  • Lease Vs Buy / Depreciation

    Instead of renewing a lease or walking away, a lessee may decide to exercise the option to purchase the equipment at the residual value. A purchase option is a standard feature of an operating lease.

  • Lease vs. purchase

    Changing the cell D39 to 14% changes the PV of costs in the purchase option to $1,050.91. This makes the lease still more attractive since the net advantage to lease increases. 8.

  • Buying vs. Renting or Leasing

    It makes a sense for a dealer to lease the car to the consumer in order to increase his revenue. There may be many customers who cannot pay whole amount or may take time to get the loan. Thus rent is a easy and convenient option to the consumer.

View More Related Solutions