Automobile Total Cost of Ownership just follow the steps that the word document says. Kallio Auto Sales Create Date 5/18/2018 Mod. Date 5/20/2018 By Whom J
Automobile Total Cost of Ownership just follow the steps that the word document says. Kallio Auto Sales
Create Date
5/18/2018
Mod. Date
5/20/2018
By Whom
Jan Bossy
By Whom
Firstname Lastname
Create Date
Sheet Name
5/18/2018 Sheet2
Description
Automobile TCO Analysis
Mod. Description
Creator
Jan Bossy
Workbook Name
20190131031529wang_e01ch01_grader_h1_tco.xlsx
Last Version Backup Name
Purpose
5-year TCO for an automobile
Automobile Total Cost of Ownership Calculator
Model:
Purchase Price:
% Down Payment:
Annual Interest Rate:
Loan Term (months):
5-year Residual Value:
License Cost:
Ins. Increase / Year
Year
Depreciation Rate:
Maintenance:
Depreciation:
Financing:
Taxes & Fees:
Fuel:
Insurance:
Maintenance:
TOTAL COST:
Scion TC
$
$
21,115
10%
4.75%
60
50%
125
2%
1
2
35%
0%
Year 1
$3,695.13
$828.22
$1,225.18
#DIV/0!
$1,200.00
$0.00
#DIV/0!
Miles Driven / year:
Fuel Cost / Gallon:
MPG:
Oil Change Miles:
Oil Change Cost: $
Purchase Tax Rate:
Paperwork Fees: $
3
4
20%
17%
0%
0%
Year 2
$2,111.50
$660.77
$125.00
#DIV/0!
$1,224.00
$0.00
#DIV/0!
5,000
35
5%
150
15%
3%
5
13%
4%
Office 2016 – myitlab:grader – Instructions
Excel Project
YO_Excel16_Ch01_PS1_v3
Project Description:
Most people own, or will at some time own, an automobile. Few actually take the time to calculate what owning
an automobile actually costs—called “Total Cost of Ownership.” This is an important calculation for both
individuals and for businesses. In this project, you will complete the development of an automobile total cost of
ownership worksheet for your supervisor, Jan Bossy, CFO at your place of employment.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Start Excel. Open the downloaded file named e01ch01_grader_h1_TCO.xlsx. Save it as
e01ch01TCO_LastFirst using your last and first name.
0
2
Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO.
10
In the AutoTCO worksheet, enter the values as shown below into the specified cells:
3
Data Item
Miles Driven / year
Fuel Cost / Gallon
MPG
4
Apply Merge & Center to cell range A1:F1.
10
5
Copy cell range C16:C22 to cell range D16:F22.
10
6
Select cell range B15:C15 and use the AutoFill handle to fill through cell F15.
10
7
Select row 14, and then insert a new row.
10
8
Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:F15
using Center Across Selection.
10
9
Add the file name Header & Footer Element to the left section of the footer on both
worksheets.
5
Updated: 05/23/2018
Cell
E4
E5
E6
Value
15000
3.00
26
10
1
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
In the Documentation worksheet, enter the values as shown below into the specified cells:
10
C8
Completed Ms. Bossy’s Automobile Total Cost of Ownership worksheet
B20 AutoTCO
5
11
Delete the Sheet3 worksheet.
5
12
Move the AutoTCO worksheet to the left of the Documentation worksheet.
5
13
For the AutoTCO worksheet, set orientation to Landscape Orientation. For the Documentation
worksheet, set orientation to Landscape Orientation. On the Documentation worksheet, set
the page scaling to Fit All Columns to One Page.
10
14
Save the workbook and then exit Excel. Ensure that the worksheets are named in the
following order: AutoTCO; Documentation. Submit the workbook as directed.
0
Total Points
Updated: 05/23/2018
2
100
Current_Instruction.docx
Purchase answer to see full
attachment
