Business Analytics I Excel Chapter 1 Assessment – TCO Sheet1 Kallio Auto Sales Create Date By Whom Description Workbook Name 5/18/22 Jan Bassy Autom

Business Analytics I Excel Chapter 1 Assessment – TCO Sheet1

Kallio Auto Sales

Create Date By Whom Description Workbook Name

5/18/22 Jan Bassy Autom

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Business Analytics I Excel Chapter 1 Assessment – TCO Sheet1

Kallio Auto Sales

Create Date By Whom Description Workbook Name

5/18/22 Jan Bassy Automobile TCO Analysis Excel_Ch01_Assessment_TCO.xlsx

Mod. Date By Whom Mod. Description Last Version Backup Name
Author: VERSION BACKUP NAME :
Before modifying any worksheet, save the original workbook with the following name format:

Original name_yyyymmdd

Create Date Sheet Name Creator Purpose

5/18/22 Sheet2 Jan Bassy 5-year TCO for an automobile

Sheet2

Automobile Total Cost of Ownership Calculator

Model: Impala LT

Purchase Price: $ 31,115 Miles Driven / year:

% Down Payment: 10% Fuel Cost / Gallon:

Annual Interest Rate: 4.75% MPG:

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%

Year 1 Year 2

Depreciation: $5,445.13 $3,111.50

Financing: $1,220.46 $973.71

Taxes & Fees: $1,675.18 $125.00

Fuel: ERROR:#DIV/0! ERROR:#DIV/0!

Insurance: $1,200.00 $1,224.00

Maintenance: $0.00 $0.00

TOTAL COST: ERROR:#DIV/0! ERROR:#DIV/0!

Sheet3

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality