Suppose you are in the market for a new car. You identify two models that you...

Suppose you are in the market for a new car. You identify two models that you like and are considering a final purchase decision. The vehicle details are as follows:

One is a high fuel efficient vehicle with a fuel cost per mile of $0.10 and the other is a low fuel efficient vehicle with a fuel cost per mile of $0.15.
The high efficiency vehicle costs $47,500 in time period 0 (no discounting); the low efficiency vehicle costs $32,500
You plan to drive the car for five years (time periods 1 to 5)
In addition to the fuel costs in period 5, you also face depreciation costs of $17,500 for the low efficient vehicle and depreciation costs of $40,000 for the high efficient vehicle

1. Suppose you drive 10,000 miles per month and have an internal discount rate of 5%. Which car has the lower total cost of ownership? Show your work on a separate page or attach a printout of your excel model, clearly labeled.
1. Suppose you drive 17,000 miles per month and have an internal discount rate of 5%. Which car has the lower total cost of ownership? Show your work on a separate page or attach a printout of your excel model, clearly labeled.
1. Suppose you drive 7,500 miles per month and have an internal discount rate of 20%. Which car has the lower total cost of ownership? Show your work on a separate page or attach a printout of your excel model, clearly labeled.
1. In general, what characteristics (in terms of driving habits and discount rates) describe an individual that finds a lower total cost of ownership in high fuel efficient vehicles?

Solutions

Expert Solution

The high fuel efficient car has a cost of $47500 and fuel cost of $0.10 per mile.
The depreciation cost is $40000 which is assumed to be spread over 5 years.

The low fuel efficient car has a cost of $32500 and fuel cost of $0.15 per mile.
The depreciation cost is $17500.

The residual value is not categorized in the question but it should be either considered as salvage value or must be regarded as initial cost.

a) 10000 miles per month is equivalent to 120000 mile per year

High fuel efficient car
120000 * 0.10 = 12000

Total Cost = Fuel Cost + Depreciation Cost
12000 + (40000 / 5) = 20000

Low fuel efficient car
120000 * 0.15 = 18000
Total Cost = Fuel Cost + Depreciation Cost
18000 + (17500 / 5) = 21500

The PW of the cash flow can be calculated using the following formula
PW = Cash Flow * (1+Interest Rate) ^ Duration

High Efficiency Car Year 0
(42500 - 40000) = 2500

High Efficiency Car Year 1
20000 / 1.05 = 19047.62

We can create a table here
The residual value if assumed to be salvage value

Year		High Efficiency			Low Efficiency
	10000 miles	17000 miles	7500 miles	10000 miles	17000 miles	7500 miles
0
1	20000	28400	17000	21500	34100	17000
2	20000	28400	17000	21500	34100	17000
3	20000	28400	17000	21500	34100	17000
4	20000	28400	17000	21500	34100	17000
5	17500	25900	14500	6500	19100	2000

	PW @ 5%	PW @ 5%	PW @ 20%	PW @ 5%	PW @ 5%	PW @ 20%
1	19047.62	27047.62	14166.67	20476.19	32476.19	14166.67
2	18140.59	25759.64	11805.56	19501.13	30929.71	11805.56
3	17276.75	24532.99	9837.96	18572.51	29456.86	9837.96
4	16454.05	23364.75	8198.30	17688.10	28054.15	8198.30
5	13711.71	20293.33	5827.22	5092.92	14965.35	803.76

Total	84630.72	120998.32	49835.71	81330.86	135882.26	44812.24

If the residual amount is considered to be initial cost

Year		High Efficiency			Low Efficiency
	10000 miles	17000 miles	7500 miles	10000 miles	17000 miles	7500 miles
0	2500	2500	2500	15000	15000	15000
1	20000	28400	17000	21500	34100	17000
2	20000	28400	17000	21500	34100	17000
3	20000	28400	17000	21500	34100	17000
4	20000	28400	17000	21500	34100	17000
5	20000	28400	17000	21500	34100	17000

	PW @ 5%	PW @ 5%	PW @ 20%	PW @ 5%	PW @ 5%	PW @ 20%
0	2500	2500	2500	15000	15000	15000
1	19047.62	27047.62	14166.67	20476.19	32476.19	14166.67
2	18140.59	25759.64	11805.56	19501.13	30929.71	11805.56
3	17276.75	24532.99	9837.96	18572.51	29456.86	9837.96
4	16454.05	23364.75	8198.30	17688.10	28054.15	8198.30
5	15670.52	22252.14	6831.92	16845.81	26718.24	6831.92

Total	89089.53	125457.14	53340.41	108083.75	162635.15	65840.41

The cost of ownership is lower for high fuel efficient car when considered for 10k miles per month and 17k miles per month.
However, the ownership cost is lower for low fuel efficient car if we consider 7500 miles per month and 20% discount rate. The calculation are given in the table above.

d) The discount rate is different here for the 3rd option or 7500 miles per month. The calculation shows that cost is directly related to the miles driven and higher the miles driven the lower cost of ownership for the high fuel efficient car.

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

Suppose you want to buy a new car and trying to choose between two models: Model...

Suppose you want to buy a new car and trying to choose between two models: Model A: costs $17,000 and its gas mileage is 20 miles per gallon and its insurance is $200 per year. Model B: costs $25,000 and its gas mileage is 35 miles per gallon and its insurance is $400 per year. If you drive approximately 40,000 miles per year and the gas costs $3 per gallon: Find a formula for the total cost of owning Model...

You are in the market for a new car. After test driving several models, you have...

You are in the market for a new car. After test driving several models, you have decided to purchase the Tesla Model 3. Including all options and up-front costs, the car will cost you $70,000. You will sell your old hybrid car for $20,000, so you need to borrow $50,000 to purchase the car. As this is a long-term purchase, you will borrow the money for 5 years. You’ve identified the following four lenders: Explain how you would rank the...

You are on the market for a new car. You want to check whether there is...

You are on the market for a new car. You want to check whether there is a significant difference between the fuel economy of mid-size domestic cars and mid-size import cars. You sample 24 domestic car makes and find an average fuel economy of 30.169 MPG with a standard deviation of 4.9556 MPG. For imports, you sample 14 cars and find an average MPG of 36.638 MPG with a standard deviation of 7.6187. Construct a 90% confidence interval for the...

You are in the market for a new car. With gasoline prices rising, you are looking...

You are in the market for a new car. With gasoline prices rising, you are looking for a gas efficient car. You have narrowed down the choices to two cars. Prima, a gas efficient car, priced at $25,000, and Malibu, a standard car, which sells for $22,000. You are planning to keep your car for six years. The manufacturer sticker on Prima states that compared to a standard car, Prima will have annual savings of $600. Assuming your opportunity cost of...

How will you finance a car? First identify a sample of new or used cars you...

How will you finance a car? First identify a sample of new or used cars you would like to own, and for each choice calculate what your down payment, monthly loan payments, and term of payment would be. How much would you need to buy a car and where would that money come from? How much could you afford to pay each month and for how long? How could you modify your budget to accommodate car payments?

Suppose you are in the market to purchase a used car. To make an informed decision...

Suppose you are in the market to purchase a used car. To make an informed decision regarding your purchase, you would like to collect as much information as possible. Among the information you might consider are the typical price of the car, the typical number of miles the car should have, and its crash test results, insurance costs, and expected repair costs. Make a list of at least three cars that you would consider purchasing. To be fair, the cars...

Suppose you are thinking of buying a new car. One of the choices you are considering...

Suppose you are thinking of buying a new car. One of the choices you are considering is a hybrid car. This hybrid model car is $9,000 more expensive than a traditional model; however, the hybrid model will get 40 miles per gallon of gas as compared to 30 miles per gallon for the traditional model. You expect the cost of gas to hover around $3.60 in the foreseeable future. Given the information above and your knowledge of CVP, answer the...

Suppose you are thinking of buying a new car. One of the choices you are considering...

Suppose you are interested in buying a new Lincoln Navigator or Town Car. You are standing...

Suppose you are interested in buying a new Lincoln Navigator or Town Car. You are standing on the sales lot looking at a model with different options. The list price is on the vehicle. As a salesperson approaches, you wonder what the dealer invoice price is for this model with its options. The following data are based on a random selection of these cars of different models and options. Let y be the dealer invoice (in thousands of dollars) for...

Suppose that an engineer in charge of a car panel manufacturing process of 30 panels models...

Suppose that an engineer in charge of a car panel manufacturing process of 30 panels models the time to complete the manufacturing process to follow a gamma distribution with parameters α= 9 and β= 2. Let X represent the random variable that measures this time in minutes. a) What is the mean of this distribution? b) What is the standard deviation of this distribution? c) Calculate P (8≤X≤16) d) What is the 90th percentile of this distribution?

Subjects