# Chapter 12 - Chapter 12 Exercise 09 QUICK-WRAP PACKAGING...

This preview shows pages 1–2. Sign up to view the full content.

Chapter 12 Exercise 09 \$43,500 \$3,500 5 \$40,000 \$8,000 Year 1 \$8,000 \$8,000 \$35,500 2 \$8,000 \$16,000 \$27,500 3 \$8,000 \$24,000 \$19,500 4 \$8,000 \$32,000 \$11,500 5 \$8,000 \$40,000 \$3,500 Directions: a. Enter a formula in Cell C7 to calculate the Depreciable Base. b. Enter a formula in Cell C8 to calculate the Annual Depreciation. c. Copy the Annual Depreciation amount down Column B. d. Enter formulas in Column C to calculate the Accumulated Depreciation. f. Format answers for Currency, 0 Decimal places, and \$. QUICK-WRAP PACKAGING Converor Depreciation Schedule • Straight-line Method Cost of Asset: Residual (Salvage) Value: Length of Service (yrs): Depreciable Base: Annual Depreciation: Annual Depreciation Accumulated Depreciation End-of-Year Book Value e. Enter formulas in Column D to calculate the End-of-Year Book Value. Use an absolute cell reference for Cost of Asset. g. Save the file as ch12ex09a.xls.

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

View Full Document
Chapter 12 - Exercise 11 \$59,000 \$6,000 7 \$53,000 28 Year 1 \$53,000 1/4 \$13,250 13,250
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/13/2010 for the course BUSINESS 15643 taught by Professor Schilz during the Spring '10 term at École Normale Supérieure.

### Page1 / 2

Chapter 12 - Chapter 12 Exercise 09 QUICK-WRAP PACKAGING...

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

View Full Document
Ask a homework question - tutors are online