cis1020 proj3 car_payment

cis1020 proj3 car_payment - Original Cost $120,000 Useful...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 1020 Project 3 - Car Payment Created by: Josh Whitesell Lab Instructor - D. Miller
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Car Payment 2.75 percent Months 60 Down Payment $0.00 Options Selling Monthly Car Package Price Payment Hummer H1 $3,000 $120,000 $2,142.94 Arnold's $40,000 $714.31 Interest Rate
Background image of page 2
Car Payment 2.75 percent Months 60 Down Payment $1,000.00 Options Selling Monthly Car Package Price Payment Hyundai Sonata 0 17400 $292.87 Interest Rate
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Spinner Cell 275 Car Options Package Selling Price Audi RS 6 $1,500 $84,000 BMW 545 i $6,000 $61,680 Chevrolet Corvette $3,000 $54,000 Hummer H1 $3,000 $120,000 Hyundai Sonata $0 $17,400 Jaguar S type $3,000 $51,000 Lexus SC 430 $700 $61,000 Mercedes CL 55 $0 $118,000 Porsche 911 Carrera $16,000 $93,000 Volkswagen Passat GLS $1,500 $23,800
Background image of page 4
Hummer Depreciation
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Original Cost $120,000 Useful life, yrs 5 Salvage Value $40,000 Straight Line Year Amount Depreciation Book Value 1 $120,000 $16,000 $104,000 2 $104,000 $16,000 $88,000 3 $88,000 $16,000 $72,000 4 $72,000 $16,000 $56,000 5 $56,000 $16,000 $40,000 Double Declining Balance Year Amount Depreciation Check Value Book Value 1 $120,000 $48,000 $48,000 $72,000 2 $72,000 $28,800 $28,800 $43,200 3 $43,200 $17,280 $3,200 $40,000 4 $40,000 $16,000 $0 $40,000 5 $40,000 $16,000 $0 $40,000 Double Declining Balance Excel Formula DDB Year Depreciation 1 $48,000.00 2 $28,800.00 3 $3,200.00 4 $0.00 5 $0.00 Y2 DDB Depreciation: $28,800.00...
View Full Document

This note was uploaded on 04/02/2008 for the course CIS 1020 taught by Professor Miller during the Fall '06 term at Western Michigan.

Page1 / 5

cis1020 proj3 car_payment - Original Cost $120,000 Useful...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online