Tesla TCO Comparison

    A total cost of ownership (TCO) analysis comparing the Tesla Model S and BMW X5M over a five-year period, including purchase prices, financing details, and fuel costs.

    6/30/2025
    7 views
    automotive
    financial analysis
    cost comparison
    electric vehicles
    tco
    This spreadsheet is hosted on Google Sheets. Open in Google Sheets to edit directly.
    Content article

    The Tesla TCO Comparison analyzes the total cost of ownership over five years for the Tesla Model S and the BMW X5M, alongside a financial breakdown for each vehicle. The purchase price for the Tesla Model S is set at $80,750, while the BMW X5M is priced at $50,500, with a financing amount for the Tesla after a down payment of $7,500 being $73,250. The BMW X5M, however, has no down payment and thus the total amount financed remains at $50,500. The Tesla Model S benefits from a tax incentive of $7,500, which is not applicable to the BMW.

    Both vehicles are compared over a loan term of six years for the Tesla and five years for the BMW, with the Tesla accruing interest at an APR of 1.49% and the BMW at a higher rate of 7.99%. The sales tax rate applied to both vehicles is 7.75%. Over five years, the Tesla Model S is projected to pay approximately $3,935 in interest, while the BMW X5M will incur $10,923, showcasing a significant difference in financing costs.

    When considering depreciation, the Tesla Model S is expected to depreciate by 50%, resulting in a depreciation cost of $40,568, while the BMW X5M, with a higher depreciation rate of 56%, will depreciate by $28,093. After five years, the residual value of the Tesla Model S is estimated at $40,182, compared to $22,407 for the BMW X5M. Fuel costs also play a crucial role in ownership costs; by year five, the Tesla's fuel cost per unit is projected to be $0.22, leading to an average annual fuel cost of $672, while the BMW X5M, with a fuel cost of $3.83 per unit, will incur an average annual fuel cost of $1,947.

    In terms of overall costs, the average annual cost of ownership for the Tesla Model S is approximately $6,272, while the BMW X5M's average annual cost rises to $10,533. Over the five-year period, the total cost for the Tesla Model S amounts to $31,362, whereas the BMW X5M totals $52,663, indicating a substantial difference in ownership expenses.

    Dimensions The dimensions of the Tesla Model S compare favorably against BMW models, with a length of 196 inches, a width of 77 inches, and a height of 57 inches. In contrast, the BMW 3 Series measures 183 inches in length, 72 inches in width, and 56 inches in height, while the BMW 4 Series is slightly longer at 184 inches but maintains a width of 74 inches and a height of 64 inches.

    Energy Costs Energy costs for the Tesla Model S are significantly lower than those for the other car over a span of years. In the first year, the Tesla incurs a cost of $633.33, which increases gradually to $712.82 by year five. Meanwhile, the other car starts at $1,833.33 in year one and rises to $2,063.43 by year five, highlighting the cost efficiency of electric vehicles compared to traditional combustion engines.

    Residual Values The residual values for the Tesla Model S and the other car also show a notable difference over a fifteen-year period. Starting at $65,175 in the first year, the Tesla's value decreases to $40,182 by year five. The other car begins at $42,925 and drops to $22,407 in the same timeframe. As the years progress, the Tesla continues to retain more value compared to the other car, which sees a steeper decline in residual value.

    This detailed analysis of the Tesla Model S and BMW X5M provides a comprehensive view of the financial implications of ownership, emphasizing the Tesla's advantages in cost efficiency, depreciation, and energy expenses.

    Comments

    SpreadableSheet is a platform for sharing and discovering spreadsheets. We do not own, review, or control the content of any sheets shared by users. All content is the sole responsibility of the uploader. If you have concerns about a particular sheet, please contact us.