YO19_Excel_Ch01_Assessment_TCO_Instructions

xlsx

School

Salt Lake Community College *

*We aren’t endorsed by this school

Course

2010

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

2

Uploaded by CountMagpiePerson722

Report
Kawakami_Excel_Ch01_Assessment_TCO.xlsx Auto TCO Model: Impala LT Purchase Price: $ 31,115 Miles Driven / year: 15,000 % Down Payment: 10% Fuel Cost / Gallon: $ 3.15 Annual Interest Rate: 4.75% MPG:Miles per gallon 29 Loan Term (months): 60 Oil Change Miles: 5,000 5-year Residual Value: 50% Oil Change Cost: $ 35 License Cost: $ 125 Purchase Tax Rate: 5% Ins. Increase / Year 2% Paperwork Fees: $ 150 Year 1 2 3 4 5 Depreciation Rate: 35% 20% 17% 15% 13% Maintenance: 0% 0% 0% 3% 4% 5-years Total Cost of Ownership Analysis Year 1 Year 2 Year 3 Year 4 Year 5 Depreciation: $5,445.13 $3,111.50 $2,644.78 $2,333.63 $2,022.48 Financing: $1,220.46 $973.71 $714.98 $443.68 $159.22 Taxes & Fees: $1,675.18 $125.00 $125.00 $125.00 $125.00 Fuel: $1,629.31 $1,629.31 $1,629.31 $1,629.31 $1,629.31 Insurance: $1,200.00 $1,224.00 $1,248.48 $1,273.45 $1,298.92 Maintenance: $105.00 $105.00 $105.00 $1,038.45 $1,349.60 TOTAL COST: $11,275.07 $7,168.52 $6,467.54 $6,843.52 $6,584.53
Kawakami_Excel_Ch01_Assessment_TCO.xlsx Documentation Create Date By Whom Description Workbook Name 5/18/2022 Jan Bassy Automobile TCO Analysis #VALUE! Mod. Date By Whom Mod. Description Last Version Backup Name Create Date Sheet Name Creator Purpose 5/18/2022 Auto TCO Jan Bassy 5-year TCO for an automobile Completed Ms. Bassy's AutomobileTotal Cost of Ownership worksheet
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help