Business Analytics I
abparsley
Parsley_Excel_Ch01_Assessment_TCO1.xlsxSheet1
| 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! | |||
