Excel work
Keer49
Sharma_e01ch01_grader_h1_TCO.xlsxSheet1
| Kallio Auto Sales | |||
| Create Date | By Whom | Description | Workbook Name |
| 5/18/18 | Jan Bossy | Automobile TCO Analysis | ERROR:#VALUE! |
| Mod. Date | By Whom | Mod. Description | Last Version Backup Name : VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd |
| 5/20/18 | Firstname Lastname | ||
| Create Date | Sheet Name | Creator | Purpose |
| 5/18/18 | Sheet2 | Jan Bossy | 5-year TCO for an automobile |
Sheet2
| Automobile Total Cost of Ownership Calculator | |||||
| Model: | Scion TC | ||||
| Purchase Price: | $ 21,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: | $3,695.13 | $2,111.50 | |||
| Financing: | $828.22 | $660.77 | |||
| Taxes & Fees: | $1,225.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! | |||
