accounting excel practise

User Generated

94pu

Business Finance

Description

please following the instruction strict . don't Plagiarism !

let me know if you have any questions. thank you !

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project YO16_XL_CH01_GRADER_PS1_HW - TCO 1.1 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.000 2 Change the name of Sheet1 to Documentation. Change the name of Sheet2 to AutoTCO. 10.000 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.000 5 Copy cell range C16:C22 to cell range D16:F22. 10.000 6 Select cell range B15:C15 and use the AutoFill handle to fill through cell F15. 10.000 7 Select row 14, and then insert a new row. 10.000 8 Type 5-year Total Cost of Ownership Analysis in cell B15. Center the text in B15:F15 using Center Across Selection. 10.000 9 Add the file name Header & Footer Element to the left section of the footer on both worksheets. 5.000 Updated: 01/03/2017 Cell E4 E5 E6 Value 15000 3.00 26 10.000 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.000 11 Delete the Sheet3 worksheet. 5.000 12 Move the AutoTCO worksheet to the left of the Documentation worksheet. 5.000 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.000 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.000 Total Points Updated: 01/03/2017 2 100.000 Current_Instruction.docx 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 20180613075623huang_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%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached is the completed assignment. I will be glad to hear from you. Thank you

e01ch01TCO_LastFirst

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
D...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags