You have to calculate the total cost of ownership (TCO) for a new car you plan to buy. Submit an excel sheet with the detailed TCO calculations. A sample TCO table is as below:

		Year 1	Year 2	Year 3	Year 4	Year 5
Purchase Price	Current
Basic purchase
Acquisition cost
Variable 1
Variable 2
(at least two variables)
Usage cost
Variable 1
Variable 2
Variable 3
(at least four variables)
Salvage
Resale value

You can use a 12% discount rate to calculate the NPV. Steps to complete this task:

1. Select a car you want to buy. Get the purchase price and acquisition cost for that car and provide a reference for that information

Car: 2022 Honda Civic Sedan Sport

Purchase Price: $25,440

Acquisition Cost: 27,200

2. Come up with specific variables for the usage cost. Provide the basis for the numbers that you input. For example, if you claim that fuel cost will be $800 per year, provide the calculation that you used to arrive at this number.

Fuel: $1,000 per year

Oil Change: $380 per year

Maintenance: $792

Car Insurance: $350

3. Similarly, provide a resale value at the end of the valuable life and support it with the basis for that value. (ideal basis can be a reference to a website).

You will have to plan to keep the car for at least 5 years.

Pictures (11.14 & 11.15) below for example. The numbers above are estimated numbers based off of average costs found on the internet.- Student