Project3 - $120,000 Useful life, yrs 5 Salvage Value...

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

View Full Document Right Arrow Icon
CIS 1020 Project 3-Car Payment Created by: Melissa Staub Lab Instructor: Nitin Bharvgava Contents: Documentation Payment PaymentFormula Data Depreciation Goal Seek
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 $3.00 Percent Months 60 Downpayment $0 Options Selling Monthly Car Package Price Payment Hummer H1 $3,000.00 $120,000.00 $2,156.24 Arnold's $40,000 $718.75 Interest Rate Choose a car from the drop-down list
Background image of page 2
Car Payment $3.00 Percent Months 60 Downpayment $- Options Selling Monthly Car Package Price Payment BMW 545 i $6,000.00 $61,680.00 $1,108.31 Arnold's $40,000 $718.75 Interest Rate Choose a car from the drop-down list
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 300 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 Original Cost
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $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 2 $28,800 3 $3,200 4 $0 5 $0 Y2 DDB Depreciation $28,800 Car Payment $3.00 Percent Months 60 Downpayment $62,348 Options Selling Monthly Car Package Price Payment Mercedes CL 55 $0.00 $118,000.00 $1,000.00 Arnold's $40,000 ($401.56) Interest Rate Choose a car from the drop-down list...
View Full Document

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

Page1 / 6

Project3 - $120,000 Useful life, yrs 5 Salvage Value...

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

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