Question

In: Finance

A potential buyer of a sportscar is interested in the costs of a vehicle per mile...

A potential buyer of a sportscar is interested in the costs of a vehicle per mile travelled at net present value. The buyer is planning to sell the car after three years of operation at residual value.

The car costs £35000.00 to purchase and the buyer incurs costs for insurance, fuel and mantenance of £1400.00 per year. The car is expected to depreciate in value by £4000.00 per year (straight line depreciation). The buyer is planning to travel 17000 miles per year.

What is the total cost of ownership per mile travelled at net present value, assuming that all payments arise annually and are subject to an annual discount rate of 3%. Note that the miles travelled are not subject to discounting.

Solutions

Expert Solution

Based on given data, pls find below workings:

Based on the below, the ownership cost per mile comes to $ 0.36.

YEAR
Sports Car ($) 0 1 2 3 Terminal
Initial Cost          -35,000
Depreciation         -4,000         -4,000         -4,000
Residual Value          23,000
No.of Miles         17,000         17,000         17,000
Maintenance Cost         -1,400         -1,400         -1,400
Net Cash Flows          -35,000         -1,400         -1,400         -1,400          23,000
Discount Factor @ 3%           1.0000        0.9709        0.9426        0.9151          0.8885
Discounted Cash Flows          -35,000         -1,359         -1,320         -1,281          20,435
Cumulative Discounted Cash Flows          -35,000       -36,359       -37,679       -38,960         -18,525
NPV          -18,525
Total No.of Miles            51,000
Ownership Cost Per mile $                0.36

Owner ship cost per mile = 18525 / 51000 (NPV / No.of Miles) = 0.36

The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) ; Year 2 = Year 1 factor/(1+discounting factor %) and so on;


Related Solutions

Solve using excel: A. Suppose a potential home buyer is interested in taking a $500,000 mortgage...
Solve using excel: A. Suppose a potential home buyer is interested in taking a $500,000 mortgage loan that has a term of 30 years and a fixed mortgage rate of 5.25%. What is the monthly mortgage payment that the homeowner would need to make if this loan is fully amortizing? 
 B. You have taken out a $350,000, 3/1 ARM. The initial rate of 6.0% (annual) is locked in for 3 years. Calculate the outstanding balance on the loan after 3...
The table below shows that costs per mile (in cents) for a sample of automobiles. Small...
The table below shows that costs per mile (in cents) for a sample of automobiles. Small sedan Medium sedan Large sedan SUV 4WD Minivan 43 67 64 87 66 41 49 73 66 76 49 63 83 75 59 54 59 75 78 51 46 64 80 70 52 72 Use the one-way ANOVA test in Excel to complete the following table (round decimals to three decimal places) ANOVA Source of Variation SS df MS F P-value F crit Between...
Using SPSS!!! ONY SPSS 13. The table shows the costs per mile (in cents) for a...
Using SPSS!!! ONY SPSS 13. The table shows the costs per mile (in cents) for a sample of automobiles. At α = 0.01, can you conclude that at least one mean cost per mile is different from the others? Small Sedan Medium Sedan Large Sedan SUV 4WD Minivan 41 65 60 79 64 39 47 69 58 74 47 61 79 67 57 52 57 71 70 49 44 62 76 68 50 68
You are the potential buyer of a business, a shoe store.
You are the potential buyer of a business, a shoe store. You are negotiating with the seller: The seller is offering a selling price of $500,000. The seller calculated the NVP (business value) of $500,000, by forecasting future cash flows and applying a discount rate of 12%. In your negotiations, you agree with the future cash flow projections, but you want to pay a lower price.What different discount rate will you suggest be used?Are you sure about that discount rate?...
A buyer group is powerful when , the buyer faces few switching costs, poses threat of...
A buyer group is powerful when , the buyer faces few switching costs, poses threat of backward integration, concentrated, products it purchases are undifferentiated and it earns low profits. In regards to it earns low profits what does this mean? what does it mean, when a buyer is powerful because it earns low profits? when the business earns low profits? please clarify
There is single object to be sold to one of the n potential buyers. Each buyer...
There is single object to be sold to one of the n potential buyers. Each buyer has a valuation of vi for the object. Consider the auction rule where the winner is the highest bidder, and pays the minimum of all the bids, i.e. min{bi : i ∈ N}. In this game, truthtelling is a dominant strategy equilibrium. Is it true or false ?
Q6). We are interested in exploring the relationship between the weight of a vehicle and its...
Q6). We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles. Weight Fuel Efficiency 2710 24 2550 24 2680 29 2720 38 3000 25 3410 22 3640 21 3700 27 3880 21 3900 19 4060 21 4710 16 Part (a) Graph a scatterplot of the data. Part...
We are interested in exploring the relationship between the weight of a vehicle and its fuel...
We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles. Weight Fuel Efficiency 2710 24 2570 27 2620 29 2750 38 3000 23 3410 24 3640 21 3700 27 3880 22 3900 19 4060 18 4710 15 e.) What percent of the variation in fuel efficiency is...
We are interested in exploring the relationship between the weight of a vehicle and its fuel...
We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles. Weight Fuel Efficiency 2715 26 2520 24 2630 29 2790 38 3000 23 3410 25 3640 21 3700 27 3880 21 3900 19 4060 21 4710 15 Part (b) r = -0.71 (correlation coefficient). Yes, it is...
We are interested in exploring the relationship between the weight of a vehicle and its fuel...
We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles. Weight Fuel Efficiency 2670 25 2570 24 2630 29 2760 38 3000 25 3410 24 3640 21 3700 26 3880 21 3900 18 4060 18 4710 17 Find the correlation coefficient. Find the equation of the best...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT